PROFESSIONAL SUMMARY:

• Over 8 years’ experience of Oracle Database Administration, providing 24x7 support for both development and production databases on Unix/Linux/Windows Operating Systems. Extensive experience with Oracle Database 12C/11g/10g Administration including Database Backup & Recovery with RMAN , Database Monitoring, Performance Tuning & Troubleshooting, Replication & GoldenGate , Security, high availability including RAC and
• Excellent experience in Oracle database installation, configuration, upgrade/migration and applying patches.
• Expertise in Configuration, Implementation and Support of Oracle Real Application Cluster ( RAC ) with 12c,11gR2 and 11 gR1 on Red Hat Enterprise Linux 7/6/5 and Sun Solaris 10/11, including the Configuration & Maintenance of Automatic Storage Management ( ASM ) and Clusterware.
• Proficient experience in Installation, Implementation and Support Oracle Data Guard with both Physical & Logical standby databases.
• Experience in working with Configuring, and Supporting Oracle GoldenGate for Real - time Data Replication.
• Experience in evaluating disaster recovery options and planning sound RMAN Backup strategy to Disks.
• Experience in implementing Hot & Cold backup with Oracle Recovery Manager ( RMAN ) and Oracle Expdp/Impdp Utility using both Unix/Linux shell scripts and OEM . Managed the Flash Recovery Area .
• Experience in patching and upgrading database
• Experience with end-to-end support for advanced data replication & data transferring using Oracle Streams .
• Proficient in performance tuning of production and development databases using TOAD,SQL Trace , TKPROF , SQL Tuning Advisor , STACKPATCH , AWR , ADDM , and OEM Cloud/Grid Monitoring .
• Hand-on experience in Data Modeling, Logical & Physical database design, Data Warehousing, ETL, OLTP and OLAP. Management of Schemas, Objects and Partitioning the tables & indexes. Highly proficient in SQL , PL/SQL with Stored Procedure, Trigger, View and Function.
• Experience in implementing and managing Large Oracle databases, Exadata .
• Excellent problem solving skills with minimum supervision as a team player.

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Oracle DBA

Responsibilities:

• Database design, from logical design, like partitioning big tables, creating necessary index, using parallel technology and normalizing the tables, to physical design, such as, datafile layout, space capacity planning.
• Database development, including writing PL/SQL for stored procedures, packages, functions and triggers.
• Developed 12c migration documentation for 11g and 10g databases; upgraded databases from 11g/10g to 12c in Development, Test and Production environments; troubleshooting and documented database upgrading issues. Implemented Oracle Advanced Security with Oracle Key Vault, Audit Vault.
• Setup and maintained Oracle disaster recovery site using DataGuard, configured DataGuard broker;
• Maintained and administered Oracle ASM, RAC and Exadata.
• Performed database performance tuning by adjusting database parameters, changing join order, rewriting SQL statement, creating index and partitions, and adding enough filters to reduce high-volume transaction data processing.
• Configured Fast Recovery Area(FRA); setup database backup strategies; Wrote shell scripts for RMAN incremental backup; Cloned and refreshed production databases to other environments using RMAN.
• Imported and exported data from production databases to development databases and data warehouse. Used SQL*Loader to load data to database.
• Developed and maintained scripts to automate problem determination, change implementation, and monitoring activities.
• Developed, managed and tested recovery plans and procedures for Disaster Recovery
• Provided deployment, migration, patching, installation, and upgrading support in maintenance window. Worked with Oracle support for critical issues. Provided 24 x 7 oncall services.

Confidential, VA

Oracle DBA

Responsibilities:

• Expertise in Oracle 11g/10g database administration configuration, support and performance tuning
• Designed and implemented of high availability solutions with Oracle Database 11g RAC, Flashback, Golden Gate and Data Guard.
• Created and modified table partition, load balancing in Oracle RAC implementation and other Oracle specified duties.
• Production support for Oracle database 11g/10g ensuring flawless execution and continuous production.
• Implemented Oracle database backup using RMAN;
• Monitored database and applications, tuned SQL queries, indexes, Oracle initialization parameters and clustered application servers.
• Performed database upgrade and database migration from 10g to 11g.
• Generated and analyze AWR and ADDM reports and monitor statistics for performance tuning of the database.
• Developed and created the new database objects including tables, views, index, stored procedures and functions according to business requirements.
• Cloned database from production to non-production, reviewed database statistics, monitored replication, and performed space management.

Confidential, VA

Oracle DBA

Responsibilities:

• Configured and maintained Oracle 10g database.
• Performed database upgrade from Oracle 9i to 10g.
• Configured and monitored Oracle Streams.
• Performed, developed and maintained database backup and recovery procedures using RMAN script as well as import/export.
• Maintained Data Guard physical standby database.
• Monitored the various database activities by developing shell scripts and using various tools.
• Performed database tuning using various tools such as Statspack and Linux utilities.
• Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Developed stored procedures, packages, functions and triggers using PL/SQL.
• Implemented automated procedure to monitor archive log destination, database users, security and objects as well as storage and capacity planning.
• Ensured that the database systems are reliable, available and functioning at peak efficiency at all times
• Checked alert and log files on daily bases
• Managed and maintained multiple 24x7 production databases
• Developed the technical documentations to support the use and operation of the database system
• Provided suggestions to network team regarding disk configuration and RAID level according to database storage capacity planning
• Planned and co-coordinated database security measures. Administrated user accounts, user profiles and tablespaces etc.