Senior Database Administrator
Finance House
مجموع سنوات الخبرة :23 years, 10 أشهر
Performs relational database design, object, integrity, recoverability, & security implementation.
•Conduct performance tuning, application SQL performance tuning, standards enforcement, tools evaluation, capacity planning resource management and production system support.
•Identifies problems at the database and system level, and identifies and recommends solutions to problem.Monitors database growth and activities; determines performance bottlenecks & tunes application SQL statements.Administrator storage, system Linux& application.Works with Data Analysts to finalize and validate physical data model.
•Collaborate with enterprise data architect, internal developers and product managers regarding database requirements, data stability and other matters related to the databases
•Hands on to design and develop database enterprise infrastructure, along with traditional database best practices to ensure that all database systems are operating efficiently and optimally in platform Unix®, Linux Red Hat® IBM-AIX®, HP UX®, Oracle Solaris® Java™ J2ee® Enterprise Application Platform (EAP)
•Identifies and resolves inefficiencies in the database likes Oracle 12c, MS SQL-Server and determines and implements solutions for database operation problems
•Support T24 Temenos core banking system, webLogic J2ee, JBoss® web application server
•Supports IT in its use of database technology; assists with the development of database designs.
•Ensures compliance to standards, policies, procedures and documentation unique to each database design.Evaluates Service Level Agreements.Works with vendors on solutions and problem evaluations of HA Data Guard, Grid cluster RAC with ASM & migrating SAN storage on DR
•Ensure db, applications, system & storage availability & maintain house keeping
•Plays advisory role, working with System Analysts to consult on best practices and approaches for data movement, design & HA MAA architecture.
Key player in FlexCube Core banking project to build infra-structure of Oracle Database RAC, Oracle Middleware weblogic application server & Oracle Web-based Http server in heterogenous environment.
Key Accomplishments
• Experience of building infrastructure for Flexcube Core Banking.
• Active Key-member of DR-drill with DataGuard, Switchover, Switchback & failover scenario.
• Hands On experience of Robust database migration, upgrade, patching of multiple databases.
• Achieved Extra Mile Award for Core Banking Project of Mashreq Bank.
• Successful implementation of middleware weblogic web application server of Prod /DR.
Responsibilities:
- Installation Oracle database 10g, 11g RAC with ASM & GRID control EM on ibm-aix & RHEL.
- Configure and maintain highly optimized Oracle Databases for RAC and Standalone systems.
- Failure Recovery with RMAN & Flashback Recovery, Complete & Incomplete recovery.
- Performance Monitoring via ADDM, AWR, ASH, EM Grid control, ratio based metrics.
- SQL optimization using Segment advisor, tunning advisor, Query Plans, SQL trace & tkprof.
- Patch management Deploy PSU, CPU, Patch Set Bubdles, Rolling Upgrade on Oracle 11gR2Grid
- Optimize SQL, monitor bottleneck using diagnostics tunning packs.
- Security implementation Guardian, Proteus baselines security policy of databases.
- Migration & Upgrade Database 10g/11g DBCA, Datapump, Transportable-tablespace,
- Monitor, maintenance, administration of unix platform HPUX, RHEL, AIX, Linux, Solaris.
- High Availability RAC cluster, Advanced Replication, Oracle Golden-gate & Cloning.
- DR Setup and Testing of Physical, Logical Standby database & Oracle Data Guard 11gR2.
- Oracle patching of Clusterware, ASM, RAC database node through Rolling upgrade & Cloning.
- Shells scripting in AIX, Linux RHEL & HP-UX.
- Configure & Deploy Fussion Middleware, weblogic, obiee, J2EE web application in Unix OS.
- Install Web Logic & WebTier application server, patching, migration & upgrade.
- Performance & Tunning of Heap size, JVM, GC policy & connection Pool.
- Configure SSL KeyStore, CA certificate in weblogic, FMW 11g, OBIEE products.
- Infrastructure support for the Application teams on Middleware, WebLogic & Obiee.
- Maintains documentation of internal system standards, SOPs, security baseline and policy.
- Database design and implementation of production database in heterogenous environment.
- Ability to organize and manage multiple workloads and projects with minimal supervision.
NATIONAL CLEARING COMPANY PAKISTAN LIMITED:
(Sr.DatabaseAdministrator I.T ) Feb-2007 to Dec 2010 Deputy-Manager
NCCPL provides clearing and settlement system to all stock Exchanges of Pakistan.The National Clearing & Settlement System (NCSS) provides significant relief to the respective clearing houses of the three Stock Exchanges as well as Clearing Members (CMs)
•Provides Day-to-Day settlement of trades through three stock exchanges of Pakistan.
•Manage Database Disaster-Recovery and Business continuity site
•Implementation of Data-Guard for recovery purpose, in case of switch-over and Fail-over
•Tunning of different Database running on ibm-AIX Platform RISC/6000 550 SERVER 5.3 O/S
•Provides Data to “CDC for post verification Client/Broker member identity
•Fetched Data from Karachi stock exchange, Lahore stock exchange and Islamabad daily through shell-based process running on IBM-AIX platform 5.3 RISC-6000 p-series.
• Information will be given to SECP
• Administration & Maintenance of all databases.
• Performance tuning and Monitoring strategy
• Install new versions of the Oracle RDBMS and its tools
• Deploy patch set on all DBMS, integrated with the live & training environment.
• Failure Recovery setup
• Compilation/Promotion of changed program on live server: Provides technical support to application development teams. This is usually in the form of a help desk.
• Troubleshooting DBMS failures
• Design and implement new database structure
• High Availability in case of disaster or maintenance
• Optimize and tune Adhoc queries
• Document and train staff on Backup/Recovery, Disaster Recovery & Migration
Environment:
Oracle 10.2.0.4, IBM-AIX Server 5.2/5.3 RISC 6000 p-series power 6 550, 560, 510 SAN Box Hp EVA 4000, EM-10G dbcontrol, Grid-control, Weblogic 7, Oracle RAC 10g Test server
CRPL provides the customers with proactive services & solutions in the areas of remote database administration, storage management, performance tuning, capacity planning and disaster recovery. These services are provided for Oracle environments on Windows NT and UNIX platforms. Responsiblities include:
· 4.8 Years experience of working as a DBA in distributed environment of InstaPhone billing system.
· Ongoing improvement, development & enhancement of services for customers.
· New install, Apply patches, Version upgrade of databases on Multiple UNIX platform and Windows.
· Performance tuning of client / server application and OLTP in a 7x24 environment.
· Proactive monitoring and maintains of storage, redologs and DB objects.
· Backup logical, physical; implementing backup strategy plans and Tablespace Point-In-Time Recovery.
· Simulate recovery process during Hot Backup, using RMAN following Database corruption
· Performed Audit for client, DB installation, generated audit report & implemented advanced Replication.
· Implemented and documented policies and procedure for Database Administration, Data migration,
Standby Database & DB monitoring.
· Study & understand business requirement and translate into entity-relationship model. Develop logical
· & physical data models using Erwin.
· Implemented script for Advance warning for storage Management & tuning of Oracle databases.
· Used Oracle tools & utilities e.g. server Manager, OEM, Exp, Imp, SQL*Loader, Lsnrctl, Rman.
.
Ali Anwar
· Installed SCO-UNIX, LINUX and performed low-level system administration on UNIX.
· Implemented connectivity through TCP/IP client/server on sco-Unix platform.
·
PAKTEL / INSTAPHONE, LTD. ( CLIENT : CELLULAR BILLING SYSTEM )KARACHI, PK.
Database Administrator Support Team Lead:
Retained on Long-term contractual basis to serve as Oracle specialist throughout implementation of Cellular Billing System (ecbs). Performed daily DBA activities, including database backup and recovery initiatives, testing, troubleshooting, performance-monitoring & tuning.
Key Achievements:
• Selected as lead DBA for key database migrations to Oracle 8i and Oracle 9i in development and production environments, coordinating efforts of DBA, Systems Administration, and Application Development teams throughout project lifecycle.
• Successfully maintained day-to-day functionality and reliability of major database applications supporting core business activities, managing terabyte-sized production databases.
• Volunteered to participate in 24X7 on-call support rotation with staff DBAs, minimizing downtime of databases throughout Pakistan.
• Successfully designed, programmed, and implemented UNIX shell scripts to automate loading of generating reports, relating to performance and tuning data information from databases on Solaris servers to windows-based email browser.
• Apply patches, version upgrade of databases on Multiple UNIX platform and Windows
• Performance tuning of client / server application and OLTP in a 7x24 environment.
• Proactive monitoring and maintains of storage, redologs and DB objects.
• Implementing backup strategy plans and Tablespace Point-In-Time Recovery.
• Simulate recovery processes during Hot Backup, & incomplete recover via RMAN.
• Performed Audit for client, DB installation, generated audit report & implemented advanced security baseline and documented policies and procedure for Databases & DB monitoring.
• Automate script for Advance warning for storage Management & tuning of Oracle databases.
• Install, configure and maintains all Oracle Products like OEM, OID, SSO, Rman, Statpack.
• High-availability & proactive 24/7 support to client’s in production environment.
• Cron Jobs Monitoring database using written shell-scripts and Grid-control diagnostics tools.
LEARN PRINCIPAL CONCEPTS OF RAC INSTALL THE RAC COMPONENTS,ADMINISTRATOR DATABASE INSTANCES IN A RAC & ASM ENVIRONMENT,MANAGE SERVICES,BACKUP & RECOVER RAC DATABASES,MONITOR TUNE PERFORMANCE OF A RAC DATABASE. ADMINISTRATOR ORACLE CLUSTERWARE LECTURE MATERIAL IS SUPPLEMENTED WITH HANDS-ON PRACTICES. MOST OF THE LABS AND EXAMPLES IN THIS COURSE ARE LINUX BASED
1. A revolutionary platform requires a revolutionary curriculum. Our BEA WebLogic Server 10 curriculum employs state-of-the-art, solutions-oriented training that will increase your team’s productivity ten-fold. 2. This curriculum features BEA Ed.Lab, a revolutionary learning environment designed to eliminate the gap between technical training and real-world implementation. 3. Our solution maximizes your success during each phase of the project lifecycle. BEA Ed.Lab eliminates the gap by: • Incorporating hands-on lab exercises that simulate real-world problems • Incorporating hands-on lab exercises that simulate real-world problems • Accelerating knowledge transfer for immediate enterprise rollout • Providing continuity throughout the BEA curriculum • Refining knowledge in planning, designing, implementing, and running real Enterprise applications 2. BEA Ed.Lab replicates a theme park’s IT infrastructure. 3. This enterprise environment offers an immersive, hands-on experience to apply skills learned in a risk-free setting. 4. With BEA Ed.Lab, you plan, design, implement and run infrastructure for BEA’s theme park. 5. This includes developing enterprise portals, weaving complex integrations, and designing business processes that include rock-solid security, missioncritical Web services and other leading edge technologies.
COURSES/ TRAINING: Diploma in ORACLE, Institute of Computer Science (INFOTRAIN) Developer 2000 Form 6 Form 6i, & Forms 9i Database Administration Oracle 8/8i/9i/10g INTERNATIONAL CERTIFICATION: Oracle Certified Professional DBA, OCP. USA · SQL AND PL/SQL (IZO-001) JUNE 30, 2000 · DATABASE ADMINISTRATION (IZO-013) December 01,2000 · BACKUP AND RECOVERY (IZO-015) JUNE 01,2001 · NETWORK ADMINISTRATION (IZO-016) OCTOBER 17, 2001 · PERFORMANCE TUNING (IZO-014) FEBRUARY 15, 2002
Oracle SQL / PLSQL Oracle Networking Oracle Backup Recovery Oracle Database Oracle forms Oracle Reports Oracle iDS Oracle Developer Oracle Performance Tuning
Physics Chemistry Biology