iftikhar_ahmed's_dba_resume

ResumeIFTIKHAR AHMED

416-302-4349(Cell)[email protected]

Professional Summary:

Oracle DBA with 15 years of experience in big financial firm Canadian Imperial Bank Of Commerce (CIBC) Proven experience in implementing and supporting 400 databases including Exadata , RAC, warehouse and I have successfully performed database recoveries and ensured that the business critical data is secure .Implemented and supported Oracle products on various UNIX and LINUX X86-64 based operating systems such as Sun Solaris, AIX, Linux, and HP UNIX. Implemented systems management tools such as Oracle grid control and. Throughout career held various roles as a team leader for offshore DBA teams, infrastructure specialist, Oracle 11gR1 and R2,. Excellent team player and possess a very strong work ethic.

Extensive experience with in all aspects Oracle database administration, 11gR1 and R2 4 nodes EXADATA, 4 nodes RAC, Data guard standby, Conventional Backup and Recovery, Logical Backup(Export and Import/ Data Pump) Rman Backup and Recovery , replication, installation, configuration, migration, sizing and space management, backup and recovery, Flashback, Active Data guard, performance tuning and troubleshooting using SQLT , AWR and OEM. Broad technical knowledge of infrastructure management ,Open group certified IT Architect

Technical Skill Set Summary:

15 years of experience as Oracle DBA implemented various database solutions such as 11gR1 and R2 , 4 nodes EXADATA, 10G RAC 4 nodes , 9i RAC, Data Guard, Oracle Grid Control and Oracle Streams areas of expertise include RAC installations, high availability, performance tuning, disaster recovery ,refresh 3.5 TB databases from active DB on the same node and across the nodes and backup and recovery strategy creation and implementation .

Assisted in management and database administration of Oracle database applications on Exadata Handled very large Exadata databases of more than 4 TB in production. System assessments for Oracle upgrades capacity planning and hardware layout. Enterprise systems management using Oracle Grid Control Extensive experience with 11gR1,R2, 10gR2 and R3 RAC, ASM, CRS, , using IBM hardware . System design and configuration of 11g instances on HA using 10g RAC & Data guard Extensive knowledge in Sun Solaris9 , 10 version 2.6, 2.8. HP-UNIX 10.7 and Linux x86_64

version2.6

Complex troubleshooting of hanging and looping issues, bugs and code performance fixes. Upgraded databases from 8.0.6 to 8i, 9i,10g & 11g

Used several advanced features such as names server and resource manager, data guard, streams, materialized views, advanced replication, Data encryption, log miner.

Handled offshore DBA teams and conducted several knowledge transfer workshops to transfer knowledge from the implementation team to the AMS support team.

Resume – Iftikhar Ahmed Database AdministratorPhone : ( 905 ) 812 - 2497 Ce l l ( 416 ) 302 -4349

E mai l : [email protected] Pa ge : 1 of 5

mailto:[email protected]?subject=Vacancy%20for%20oracle%20DBA

Employer History

03/2001 - Till date Oracle DBA Consultant, Canadian Imperial Bank Of Commerce (CIBC)01/1999- 06/1999 – Oracle DBA Neco System Toronto.

Courses Attended :

Oracle Database 11g R2- Performance and Tuning Release 2 Oracle Database 11g R2 – Introduction to system Administration Oracle Database 11g – Administer a Data Warehous.

Oracle Database 11g: Data Guard Administration Release 2 Oracle Grid Infrastructure 11g: Manage Clusterware and ASM - Release 2 Oracle Database 11g: RAC Administration Release 2

Education.

I have done MSc ( Master in Science )

Client Summary:

Assignment History 03/2001 - 10/2015 Canadian Imperial Bank Of Commerce (CIBC)

Accomplishments as Exadata Oracle DBA (Data Warehouse)

Production DBA responsible for maintaining Oracle 9i, 10g , 11g R1, R2 Exadata (RAC) database installation, configuration, performance tuning, upgrade troubleshooting, applying patches and database cloning.

Tested and real time applied DR on exadata, Standby DB converted to Prime DB Refresh done many times through duplicate method from active DB , production Rman backup

tape across the nodes and on the same node Implemented Oracle Grid Control to monitor database instances based on 9i, 10g, and Oracle 10g

RAC on AIX and Linux Developed backup and recovery strategy for production databases bases on Oracle RMAN Provided on call support handling critical Oracle database events during peak periods. Designed instance migration strategy, Exadata DB cloning (refreshing UAT , DEV from active

database in faster manner , from tape backed up through rman) , performance tuning and audit of Oracle Applications on the whole and the individual product families, products, and also analyzing and implementing End-to-End Performance Tuning

Implemented Oracle on RAC High Availability and Clustered environments. Working experience with Oracle and database tools, including TOAD, DB Artrisan, SQL,

PL/SQL and Unix/Korn Shell. Adhered to best practices for the solution stability and easier maintenance. Worked with Oracle support to resolve several SEV1 EXADATA DB’s issues affecting go live

dates




Configuring services for Load Balancing like ETL and Cognos and queries and utilizing all 4 nodes .

Converted single instance database to RAC. Installing and configuring stats pack package for Oracle Applications. Moved Oracle Exadata database between various UNIX platforms. Complete testing for Operational Readiness and Disaster Recovery through OCM . Used Flashback while release deployment Tested and Restore from Flashback point in case of issue occurred deployment without affecting

Standby DB Fixed the issue of LAPS redo between Prime Exadata to Standby (data gaurd ) Used export Data Pump utility to move the huge data from one environment to other. Used Rman for backup and restore through control file and catalog . Create custom requests to perform database maintenance. Write Korn shell scripts to monitor and maintain the Oracle database. Take care of users' questions on an ongoing basis Involved in Instance and database level Tuning. Monitored and optimized SGA components i.e.

shared pool, database buffer cache and redo log buffer for better performance. Tablespace stripping across different devices in order to distribute I/O. Helped the programmers to write efficient queries with the help of EXPLAIN PLAN.

rack space usage and forecast storage requirement. Apply Patches, Oracle installations, Perform database upgrades Prepare standard operating procedure(SOP) documents for frequently used databases tasks and

process Database refresh ,Schema refresh, Database Creation ,Implement table partitioning Implementing change controls in production environment Setup and manage standby databases Performance tuning of long running queries Perform deep dives on business critical database applications and submit report on current setup

along with recommendations to client Maintain accurate database, server information in Database Inventory. Keep technical documents

up to date. Provide training to junior team members and offer technical help when needed. Collaborate with team and generate ideas on initiatives like service improvement plans and

process automation. Represent Oracle team in Root cause analysis meetings related to severity-1 issues and (change

control board) meeting Handle Database Projects




Jan 1999-Jun1999

Necho System CorporationEmerald Business CenterMissisauga, ON Canada L5R 3K6

Responsibilities include technical support and development of software and include all the responsibilities of Oracle DBA like Tuning, Backup and Recovery under UNIX and Window NT for the travel and expense management procurement for large and medium-sized corporations. Continuing significant market development in North America.

Detail Description of Work Oracle RDBMS Versions 7 AND 8

ROLE 1: Database Administrator Customized Database

Implemented logical database design to physical database. Organized the contents of database through tablespaces. Designed the structure of the database to reduce the contention and fragmentation. Ensuring the safety of the database by creating multiplexed redo log files and control file. Managing databases structure and storage allocation and planned future requirement of the database. Created rollback segments as per activity level. By using Server Manager for Oracle 7.3.3 under Unix and Server Manager and Database Assistant for Oracle 8.0.3 under Unix and Windows NT.

Trouble ShootingTrouble shooting Oracle Errors with the help of Alert File and/or diagnosis. Have been in contact with Oracle Corp Support Services for different problem and bug fixing.

Database User/Security ManagementEnrolled new database users, altered or modified users as per business needs, monitored existing users, assigning default and temporary tablespace, assigning space to work in different tablespaces, assigning different roles. Created different roles as per organization setup to organize access to the database. Developed and implemented strategy for managing security roles and privileges. Using SQL*Plus and Server Manager for both Oracle 8.0.x ,8.1.x under Unix and Windows NT.

Optimized Resource UsageCreated profiles to control and optimize system resources such as Connect time, idle time etc. Using SQL*Plus and Server Manager for both Oracle 7.3.4 and Oracle 8 ,8i and 9i under Unix and Windows NT

Auditing a databaseAnalyzed the business process and defined value based and activity based auditing to investigate about the suspicious activities as per management needs. Using SQL*Plus and Server Manager for both Oracle 7.3.x 8.0.x ,8.1.x under Unix and Windows NT

Planned Backup and Recovery StrategyDesigned backup strategy in view of business requirement, activity level on the database, life of a database structure and above all the criticality of data. Implemented offline, online and HOT backup procedures. Complemented physical backup procedures with logical backup schedules. Before and after implementation, tested and verified the strategy. Using Import and Export, SQL*Plus and Server Manager for both Oracle 7.3.x 8.0.x ,8.1.x under Unix and Windows NT.

RMAN Backup and Recovery




Maintained logical backups data on the tape/deviceMaintained historical archive of database through export utility. These backups were used to move data from one machine to other, move from one version to other, move from one operating system to other and to reorganize table storage. Using Import and Export, Server Manager for both Oracle 7.3.3 under AIX and Oracle 8.0.3 under Windows NT

Monitored and optimized the performance of the database.Identification & solution for performance problems were developed for different clients. Involved in Instance and database level Tuning. Monitored and optimized SGA components i.e. shared pool, database buffer cache and redo log buffer for better performance. Tablespace stripping across different devices in order to distribute I/O. Helped the programmers to write efficient queries with the help of EXPLAIN PLAN. Monitoring & reorganization of tablespace fragmentation was done for different clients. Designed application specific rollback segments to manage bulk-loads. Balancing disk I/O to avoid contention problems. Using SQL*Plus and Server Manager for both Oracle 7.3.3 under AIX and Oracle 8.0.3 under Windows NT

PL/SQL, Triggers, Stored Procedure, Function and Shell Scripting Compile all above for the database

References Available on request.




iftikhar_ahmed's_dba_resume

Documents