SUMMARY

• 8+ years of experience as anOracleDatabase Administrator having hands on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Performed Migration and Upgrade of databases 11g to 12c.
• Upgrade of databases by applying patches, patch sets and critical patch updates.
• Installation and configuration ofOracleServer 11g RAC with ASM on multi node systems, Different operating systems.
• Extensive experience onOracle11g/12c/ASM/RAC and upgrade of standalone databases to 11g to 12c RAC environment
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean - up, data archiving.
• Developed RMAN scripts for database backup and recovery including- hot and cold backup
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Good exposure in Configuring Single instance,OracleReal Application Clusters (RAC) and Automatic Storage Management (ASM).
• Experience in installing and patchingOracleRAC with ASM on AIX, Solaris and Linux platforms.
• Good exposure ofOracleDBAtasks like Installation, Patching, Cloning and Upgrade ofOracle Databases and Grid Infrastructure.
• Knowledge of database backup/recovery strategy using RMAN and configuration of Recovery catalog for multiple databases.
• Performed periodical backups of both full and incremental and restoration, recovery of database using RMAN utility.
• Experience with logical backups of the database using Data Pump (Expdp and Impdp).
• Implemented Database security administration by creating new users, roles, profiles and providing required user privileges in development, test, training and production environments.
• Performed backups and tested crash recoveries using conventional Hot and Cold backups..
• Providing critical solution with strategic disaster recovery plans with different recovery procedures and methods and Involved in performance tuning and database reorganizations.
• Knowledge in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space
• Knowledgeable in using Grid Control and OEM Features and worked with databases which have critical data
• Monitored and managed various database components (logical & physical) like table- spaces, segments
• Worked on Shell scripting for backup, recovery and maintenance for databases

TECHNICAL SKILLS

RDMS: Oracle10g, 11g, 12c, SQL Server 2008

Languages: SQL, PL/SQL,C,Bashshell

Tools: RMAN, OEM,SQL*Loader,data pump, SQL Developer, TOAD, putty, Secure CRT

Tuning Tools: ASH,TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Operating Systems: AIX, Linux, Red HatEnterpriseLinux, HP-UX, SCO, Sun Solaris, Windows

Virtualization Technologies: VMware,OracleVirtual Machine

Utilities: SQL Loader, Exp/Imp, Data Pump, Expdp/Impdp, TKPROF,TRCAandStats pack, 10046 Trace, OradebugEducation: Bachelors of Computer Science from university of Karachi, Karachi, Pakistan in 2000

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

OracleDBA

Responsibilities:

• Installed, configured, and maintainedOracle10g and 11gR2 on Linux and also Upgraded from Oracle11g to 12c.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Data pump, conventional Export/Import (Oracle10g, 11g and 12c) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One - off Patch) using "run Installer" and based utility "OPatch".
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF EXPLAIN PLAN, AWR, and Tuning of SGA, distribution of disk I/O.
• Installation and configuration ofOracleclient products and Maintenance of Concurrent Programs
• Successfully upgraded 3 nodes RAC cluster from 10.2.0.4 non-ASM to 12c ASM.
• Upgraded standalone database from 11.2.0.4 to 12c..
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities.
• Installed and configure more than 11g Rac cluster on 11.2.0.3 with ASM, non-ASM.
• Installed and configure one nodeOracle11.2.0.3 rac cluster database with ASM on RHEL 6.
• ProvidingOracleDBArelated activities like patching, upgrade andOracleAdministration related activities like managing build for code migration for different releases, code migration, configuration management and other activities
• Planning, applying and monitoringOraclepatches on different instance and Applying patches, cloning and otherOracleDBAactivities and Controlling database and Security
• Coding Standards and configuration management through various development instances and also integrating the Custom developed components.
• Shell Scripting to resolve business problems of various natures.
• Rebuilding of Indexes and managing the table partitions for better performance, maintenance of OracleDatabase. Establish Backup policy using RMAN and also managed Backup, Restore using Data Pump, traditional Export and Import Utilities.
• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
• Used AWR, ADDM and statspack Reports for troubleshooting performance issues and Capacity Planning and extensively used Explain Plan, SQL Trace.
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• Worked with Partition Tables and partitioned the tables per the requirement of the Applications to improve performance and data management.
• Used Datapump export/ import to instantiate SCN to avoid conflict at destination, created different rule sets to propagate and apply process.
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance
• Expert in Space monitoring, Functions, Procedures, Triggers & Packages, and Object Management.
• Highly experienced inOracle11g, Automatic Storage Management (ASM) required fulfilling the storage needs.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Used hints for SQL tuning and optimization
• Performed Explain Plan analysis for Query Optimization and SQL tuning

Environment: Oracle11g,OracleRAC (11g),OracleGrid Control, RMAN, ASM, SQL Developer, TOAD, SQL*Plus.

Confidential, Raleigh, NC

Oracle DBA

Responsibilities:

• Performed Installation and configuration ofOracle10.2.0.1 database on HP - UX platform.
• Successfully performed migrations fromOracle11g to 11gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform.
• Successfully performed data replication using Materialized views andOracleStreams inOracle11gR2.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities inOracle11gR2.
• Install and configure block change tracking to work with RMAN Merged incremental backups.
• Applied patches 10.2.0.3, 10.2.0.4.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Extensively worked on Backup/Recovery using RMAN and Scripts based forOracle, 11.x with SAN and NAS File systems with and withoutOracleASM.
• Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oraclerelated issues.
• Worked exclusively for decommissioning of the databases for the applications has been migrated over to the new environment.
• Worked on Ticketing System with Remedy Service Desk for various Production Support Issues for 24X7X365 Days.
• Automated most of the House keeping jobs and alerts using shell/SED/AWK and Perl Script and configured in Tidal Enterprise Scheduler.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Provided 24X7 supports for all the production and development databases.

Environment: Oracle10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC,RMAN, Data Pump, SQL TRACE, EXPLAIN PLAN

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Create RAC clusters
• Migrate from standalone servers to RAC cluster...
• Develop RMAN scripts for backup and recovery of databases.
• Design, document, implement and maintain all work.
• Refreshes and restores on daily basis.
• Rebuilding of indexes on monthly basis..
• Created cron jobs for full and incremental backups, cold backups, purging, cleanup and refreshes.
• Provided user management support.
• Retrieved and analyzed database health check reports (ASH, AWR)
• Created company's data guard documentation
• Perform Backup and Recovery thru RMAN.
• Fulfill developers request to refresh schemas on a daily basis.
• Worked withOraclein troubleshooting issues.
• Configured and maintain Grid Control Repository.
• Troubleshoot network and performance issues
• provided on - call support on rotation basis.

Environment: Oracle10g, 11g on RAC,OracleEnterprise Manager,OracleGrid control, RHEL, HP UNIX.

Confidential, Warren, NJ

Oracle DBA

Responsibilities:

• Managed in - houseOracleDatabases running on various operating systems like Linux.
• Installation ofOracleDatabase andOracleproducts.
• Implementing Backup/Recovery.
• Using Enterprise Backup utilities for backup..
• System tuning for better performance.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Co-coordinated, and deliveredOraclecourses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
• Writing UNIX shell scripts for backup and recovery.
• Supervised the installation and configuration ofOracledatabases on Linux
• Writing SQL scripts to monitor database performance.
• Problem trouble shooting and resolution.
• Database installation and instance creation.
• Database tuning, backup and recovery and general day to day running of the system..
• Creating project plans and implementation schedules.

Environment: Oracle11g,Oracle10g, RMAN, ASM, SQL Developer, TOAD, SQL*Plus.