SUMMARY

• Over 9+ years of experience in System Analysis, Design, Development and Administration of Oracle 9i/10g/11g/12c Databases.
• Experience in Installation, Configuration, patching, upgrades and Maintenance of Oracle Databases.
• Expertise in AWS and Oracle Cloud Interface and integrate cloud with on premises applications.
• Designed GoldenGate Replication between different database engines.
• Involved in Installation, Maintenance, and Patching oracle Exadata servers.
• Experience with RMAN, OEM Grid Control, Oracle Automatic Storage Management (ASM), Data Warehousing, Oracle Data Guard, Informatica Data Replication, GoldenGate Replication, Oracle Data pump.
• Responsible for providing all aspects of Database Engineering and Administration support for multiple environments development, test, and production.
• Experience in Database Cloning from production to test and development databases.
• Experience in cross - platform database migrations from Sun Solaris to IBM AIX and Windows to Linux.
• Expertise in Configuring, managing, and troubleshooting data replication.
• Experience in Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH).
• Proficiency with Tuning the SGA, Monitoring and Detecting Locks.
• Experience in managing large Multi-terabyte Oracle databases.
• Applying PSU/CPU patches, Oracle patches, Release upgrades, ONE-OFF patches.
• Good experience in Capacity Planning and Bench Marking.
• Good experience in SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Experience in Partitioning (Range, List, Hash, Interval Partitioning).
• Experience in database security strategies. Creating database users, user roles, profiles, and audits.
• Experience in capacity planning for databases and server lifecycle.
• Goal Oriented, Good Co-ordination and Co-operation with the Team and Management. Adept at learning and adaptable to complex work environment.
• Managing projects ranging from simple implementation to heterogeneous setup for organizations of varying size and complexity in a 24/7 production environment.
• Maintained the Sybase and SQL server databases.

TECHNICAL SKILLS

RDBMS: Oracle 9i, 10g RAC, 11g RAC, 12c RAC, SQL Server, SybaseASE 12.5

CLOUD (AWS): EC2, S3, RDS, ELB, EBS, VPC, Auto Scaling, Cloud Formation, Cloud Watch

CLOUD (Oracle): Compute, DBS, VCN, ADW, ATP, DIPC, Management Cloud

Languages: SQL, PL/SQL, Unix Shell script, C, C++, JAVA, HTML.

Tools: RMAN, ASM, OEM/Grid Control, SQL*Plus, Export/Import, DataPump, SQL*Loader, Statspack, ASH, AWR, ADDM, IDR, GoldenGate, Toad, DBArtisan, SQL Developer, Informatica Data Replication, EMC, NetApp, Veritas NetBackup, TSM, HP Omni Back, Microsoft Office Tools.

PROFESSIONAL EXPERIENCE

Confidential, Rancho Cardova, CA

Senior Oracle DBA and Cloud Architect

Responsibilities:

• Design and implement migration of database from on premises to AWS.
• Installation, configuration and administration of Virtual Machines and Oracle databases on AWS.
• Managed network, database, migration, infrastructure services on AWS and Oracle Cloud like, virtual private network, Route 53, Data Migration Services, EC2 Instance etc.
• Identify and resolve network security issues.
• Design GoldenGate Architecture to replicate data from in house environment to 18 different clients.
• Install, maintain and design Oracle 12c databases on Oracle Exadata.
• Good understanding of Oracle Exadata Architecture.
• Experience in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Worked on Oracle Dataguard setup for all production databases.
• Performed upgrade, patching and configuration of RAC databases.
• Performed Schema Refreshes using export/import and Oracle Data Pump Export and Data Pump Import.
• Performed database and SQL tuning to mitigate performance impact after oracle 12c upgrade.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ADDM.
• Add tables to replication, resolve GoldenGate replication errors.
• Recommended architectural improvement, design solutions and integration solutions.
• Database Cloning from production to test and development databases
• Developed UNIX Shell scripts to backup Oracle databases.
• 24x7 Production on call Database support.

Environment: Oracle 11gR1/2, 12cR1/2, Grid Infrastructure 11gr2, 12cR1/2, MSSQL 2008/2012, OCI, Golden Gate, RAC, Exadata, Data Guard, RMAN, OMS 12c, OWB, Toad, SQL Developer, Erwin, Oracle on RHEL 5/6/7, HP-UX, Windows.

Confidential, Roseville, CA

Senior Oracle DBA and Cloud Architect

Responsibilities:

• Installation, Configure, Administrate and Maintained Oracle 11gr2/12c databases.
• Upgraded database from Oracle 11gr2 to 12c.
• Designing and deploying scalable, highly available, and fault tolerant systems onAWS.
• Work with application development teams to ensure that their applications are designed properly and verifying all external connections configure accurately with AWS infrastructure.
• Migrate databases from local datacenters to AWS RDS(cloud).
• Created documents for database design, installation, patching, upgrade and administration for Dev/SysTest/UAT/TRN/PROD Environments.
• Worked closely with project managers, middleware team, testers and developers to provide best application performance.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Performed installation and maintenance of ORACLE 10g/11gr2/12c on multi-node RAC.
• Worked on mapping and adding disks to ASM diskgroup on Exadata Platform.
• Configured and maintained Production database replication to client site using Golden Gate.
• Performed adding/removing a node on test server cluster for production POC and added node on Production Environment for high availability.
• Configure and administered the physical data guard for disaster recovery.
• Cloned active database, ASM Copy, RMAN and Data Pump to copy/create database for development/testing team.
• Involved in designing, assembly and tuning of database for development teams.
• Performed installation, upgrade, patching and configuration of OEM Cloud Control and Agents for database, RAC monitoring and data masking.
• Created auto maintenance and corrective actions jobs in OEM.
• Written Korn/Bash shell scripts for auto monitoring, backup validations and other corrective action tasks.
• 24x7 Production on call Database support.

Environment: Oracle 8i, 11gR1/2, 12cR1, Grid Infrastructure 11gr2, 12cR1, MSSQL 2k3/8, Golden Gate, RAC, Exadata, Data Guard, RMAN, OMS 12c, OWB, Toad, SQL Developer, Erwin, Oracle on RHEL 5/6, HP-UX, AIX, Windows.

Confidential, West Des Moines, IA

Senior Oracle DBA

Responsibilities:

• 24x7 Production on call Database support.
• Installation, Configuration and Administration of Oracle 10g, 11g and 12c databases.
• Converted Single Instance Database to Multi Node RAC.
• Added nodes to existing RAC.
• Upgraded database from Oracle 10g to 11g and 11g to 12c.
• Implemented replication using Informatica Data Replication.
• Installation, Configuration and Administration of Oracle 10g RAC, Oracle 11g RAC, Standby Database (Active Data Guard) for High Availability, Disaster Recovery and Reporting purpose.
• Migrated databases from Sun Solaris to HP-UX and Windows to Linux.
• Database cloning from production to test and development databases.
• Maintained backups for recovery using RMAN.
• Designed and implemented backup and recovery strategies.
• Performed Cold/Hot backups.
• Performed Schema Refreshes using export/import and oracle Data Pump.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Planned and designed databases, including designing local structures and forecasting further expansions.
• Database Design (Logical and Physical database design).
• Capacity Planning and Bench Marking.
• SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Written Shell Scripts for backups, cloning databases, monitoring.
• Partitioned large tables for better performance.
• Replication using Materialized Views, Oracle Streams and GoldenGate.
• Automated the regular jobs using crontab and dbms scheduler.
• Replicated tables of a Schema using Oracle Streams with two oracle databases in 10g.
• Extensively used Export/Import utilities for selective backup, transferred tables between oracle instances.
• Database security and auditing.
• Designed and conducted a data quality strategy plan to ensure no data was lost or corrupted during migration.
• Controlled and monitored user access to the database.
• Responsible for applying Oracle Patches and CPU patches.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Analyzed schemas on all the databases on a regular basis.
• Supported development, testing and production databases.

Environment: Oracle 12c RAC/11g RAC/10g RAC, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM Grid Control, SQL Plus, Sun Solaris, HP-UX, IBM AIX, RedHat Linux, Windows

Confidential, Miamisburg, OH

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i, 10g, 11g, 12c databases.
• Involved in Installation and configuration of Oracle 11g and 12c RAC.
• Upgraded database from Oracle 9i to 10g to Oracle 10g to 11gr2 and 12c.
• Built Physical standby databases.
• Designed and implemented backup and recovery strategies.
• Performed Full, Incremental backups using RMAN.
• Performed Cold/Hot backups.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Analyzed schemas on all the databases on a regular basis.
• Applied patches to fix the bugs.
• Involved in Database Design (Conceptual, Logical and Physical database design)
• Performed database and SQL tuning and troubleshooting including analyzing traces, reorganizing indexes.
• Used tools such as RMAN for backup and recovery.
• Designed new job process, and did performance tuning of the existing ones.
• Oracle Data Guard setup.
• Performed Database cloning for the Development environment.
• Interacted with the users and resolved the problems involved with the development of stored procedures, triggers and problems related to the privileges & resources.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Maintained the Sybase and SQL server databases.
• Used DBverify utility to check the data block corruptions.
• Created primary database storage structures like Tablespaces, tables, views, indexes etc.
• Performed Database cloning/refresh from production to the development database.

Environment: Oracle 11g /10g RAC/9i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM Grid Control, SQL Plus, MSDN2005, Sybase ASE 12.5, HP-UX, IBM AIX, RedHat Linux, Windows.

Confidential, Miamisburg, OH

Oracle DBA

Responsibilities:

• 24x7 Database administration support
• Installation, Configuration and Administration of Oracle 9i, 10g and 11g databases.
• Supported the Production, Development and Test databases.
• Installed and configured Oracle 11g RAC.
• Writing PL/SQL code.
• Performed Full, Incremental backups using RMAN.
• Performed Cold/Hot backups.
• Performed logical backups using DataPump.
• Performed Schema Refreshes using export/import and Oracle Data Pump Export and Data Pump Import.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Analyzed schemas on all the databases on a regular basis.
• Upgraded database from Oracle 8i to 9i and 9i to 10g.
• Applied patches to fix the bugs.
• Performed cross-platform database migrations from Sun Solaris to IBM AIX and Windows to Linux.
• Written PL/SQL Functions, Procedures, Packages and Triggers.
• Involved in Database Design (Conceptual, Logical and Physical database design)
• Performed database and SQL tuning and troubleshooting including analyzing traces, reorganizing indexes.
• Used tools such as RMAN for backup and recovery.
• Designed new job process, and did performance tuning of the existing ones.
• Oracle Data Guard setup.
• Performed Database cloning for the Development environment.

Environment: Oracle 10g RAC/9i/8i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM Grid Control, SQL Plus, RedHat Linux, Sun Solaris, IBM AIX, Windows

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 8i/9i/10g databases
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Cloned Production to QA, TEST and DEV environments.
• Performed Tuning by generation of STATSPACK reports and Tracing of Queries.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Monitoring the Database storage and day-to-day activities.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Experience in database security strategies by creating database users, user roles, profiles and audits.
• Performed RMAN backups and tested various recovery scenarios for production databases.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Reorganization of tables and rebuilding of indexes.
• Developed UNIX Shell scripts to backup Oracle databases.

Environment: Oracle 10g RAC/9i/8i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM Grid Control, SQL Plus, RedHat Linux, Sun Solaris, HP-UX, Windows

Confidential, Denton, TX

Oracle DBA

Responsibilities:

• Created Oracle Databases as per the requirements.
• Performed software installation and applying patches.
• Created the users and roles as per the business requirements.
• Performed Hot and Cold backups, Export/Import.
• Performed media recovery.
• Performed database administration tasks creating tablespaces, tables, indexes, synonyms, database links etc.
• Created Database links to connect different databases.
• Written Database stored Procedures, Functions, Packages & Triggers.
• Performed Unit, System and User Acceptance tests of different modules.
• Interaction with end user to solve their production related problems.
• PL/SQL programming and shell scripting.

Environment: Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM/Grid Control, SQL Plus, RedHat Linux, Sun Solaris, Windows