SUMMARY

• More than 12 years of Experience working as Oracle DBA for 12c/11g/10g/9i/8i/8.x/7.x on Unix/Windows environment.
• Strong expertise Backups and Recovery using RMAN or logical like Export and Import Datapump.
• Expertise in administration of Production Oracle databases in 24×7 availability.
• Performance and tuning using AWR reports, ADDM.
• Incidental Support and installation of Golden Gate Replications.
• Install/Support/Maintain on SQL Server databases.
• Worked on Oracle Big Data
• Extensive experience in all areas of Oracle database administration including Real Application Cluster (RAC).
• Worked on Grid Infrastructure 11g R2, with physical Dataguard.
• Have expertise on Oracle RMAN.
• Monitored and optimized the performance of the database through Tuning Applications, Tuning Database Memory, etc.
• Install, upgrade Oracle Enterprise Manager (OEM) for 10g/11g/12c.
• Experience in Modifying Storage for tablespaces in Capacity Planning, Space Management, Storage Allocation, segments, Undo Segments depending on application requirement.
• Extensively worked on Veritas Netbackup for backup and recovery solutions using Oracle RMAN (Recovery Manager).
• Worked on Oracle Access Manager and also installed on Oracle 11.2.0.
• Manage databases on Unix (all flavours), Windows.
• Good communication skills, proven teamwork qualities.

TECHNICAL SKILLS

Databases: OLAP, OLTP, Data warehousing, Data Mining, Oracle 32/64 - bit 12c/11g/10g/9i/ 8i/8.0/7.X

DBA Tools: Oracle Enterprise Manager (OEM) 12c/11g/10g Grid, RAC, Golden Gate, Active Data Guard, Putty, SQL*Plus, Toad, SQL Developer Recovery Manager (RMAN).

Operating Systems: Solaris 10/9/8/2.7/2.6 ; Red Hat Linux EL 4.0, Compaq Tru64 UNIX 5.1/5.1a/4.0, IBM AIX 4.3.2/4.3.3 , Windows XP/NT/2000, HP UX 11.00/ 10.20 , Veritas Clusters.

Languages: UNIX Shell Scripts, COBOL, SQL, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential, St. Paul, MN

Responsibilities:

• Design architecture for database.
• Install new Oracle 11g software onto Linux.
• Creation of new Oracle 11g R2 RAC(Real Application Cluster) database on Linux.
• The analysis of the current data warehouse environment. Evaluate the different options for setting up the warehouse environment in a RAC infrastructure.
• Designing the migration process for the existing Windows 2008R2 Oracle 11G warehouse to the new Linux Oracle RAC environment.
• Review clients existing migration tools and make recommendations for improving performance of the migration process.
• Analyze the method of transforming existing data into a format for the new environment, and the loading of this data into database structures.
• Setup/configure RMAN into databases.
• Install/configure Oracle 12c clouds on databases.
• Ensuring all interfaces that transfer data to and from the warehouse/RCA/SAAS are enabled.
• Ensuring the scheduled loading routines are converted/managed in the Linux environment.
• Testing the migration process.
• Validating the migration with business stewards.
• Support additional Operational and Maintenance and system enhancement requests as required.
• Mentor existing database staff on the administration, management, operation and maintenance of the new data warehouse environment.
• Perform schema/table refresh via EXPDP/IMPDP.

Confidential, Reston, VA

DBA (Enterprise Database Team)

Responsibilities:

• Provide support and maintain very large number of complex Oracle Database systems in a multi-platform 24x7 environment and supports Oracle Data Warehouse.
• Compare table structures between production and lower environment databases.
• Install and administer Oracle E Business Suite R12 on Oracle Enterprise Linux (OEL).
• Compare roles/privileges for various USERS/SCHEMAS on issues with the help of Toad.
• Perform Oracle database Upgrade/Migrate.
• Manage various Standby databases and monitor and troubleshoot 11g/10g databases.
• Perform schema/table refresh via EXPDP/IMPDP.
• Support application performance issues using 12c Cloud control / AWR / ASH / ADDM / Traces.
• Install, upgrade Oracle Enterprise Manager (OEM) for 11g/12c.
• Build Oracle 11g R2 database on Veritas Cluster with failover/failback testing.
• Managing Oracle Real Application Cluster (RAC) for Oracle 11g R2.
• Install and maintain Oracle Golden Gate replication feature for various databases including Oracle and My SQL server for Golden Gate 11.1.1.0.0.
• Worked on Oracle Access Manager and also installed on Oracle 11.2.0.
• Supported application in code baseline implementation across environments.
• Provide technical expertise in database area throughout the life cycle of the projects such as preparing database objects, refresh databases from production to lower environment, migrate database objects from one environment to the other.
• Apply Oracle Security Patches to adhere to the security policy.
• Maintain database operation environment with SOX compliance and adhere to corporate policy.
• Help to optimize the queries, tuning of SQL statements using tools like Explain plan, Auto trace, STATSPACK, DBMS PROFILER .
• Gathering statistic, analyzing tables and indexes.
• Creation of Service Request to Oracle.

Confidential, Richardson, TX

Lead Oracle DBA

Responsibilities:

• Provide support and maintain very large number of complex Oracle database systems in a multi-platform 24x7 environment.
• Performed database administration like User Management and implement Security using Roles, Privileges, Grants, applied patches, Database upgrades
• Build and maintain Golden Gate Processes for replicating purposes including Oracle Real Application Cluster (RAC) databases. Troubleshoot with Golden Gate ERRORS.
• Worked as Production DBA in 10g/11g.
• Install and administer Oracle E Business Suite R12 on Oracle Enterprise Linux (OEL).
• Install and upgrade Oracle Enterprise Manager (OEM) for 10g/11g/12c.
• Tablespace management and capacity planning.
• Build Oracle Real Application Cluster (RAC) systems over ASM for the clients. Maintained and enhanced the scripts used for Oracle RAC/non-RAC installation.
• Administer Oracle Real Application Cluster (RAC) databases and also managing various Oracle Services.
• Worked on Backups and Recovery policy Hot/Cold Backup using RMAN.
• Implementation and Setup of Physical Data Guard and provide support for Oracle Data guard and streams implementation for Disaster Recovery (DR) setup.
• Monitoring and optimizing the performance of the database through Tuning Applications query, Tuning Database Memory, and Tuning Disk Usage etc. Performance and tuning using AWR reports, ADDM, 10G Advisors.
• Experience in Creation and managing Table partitioning and Rebuilding, validating the Indexes.
• Help to optimize the queries, Tuning of SQL statements using tools like Explain plan, Auto trace, STATSPACK, DBMS PROFILER .
• Gather Statistic on table, analyzing tables and indexes.
• Creation of Service Request to Oracle.
• Worked on Oracle Access Manager and also installed on Oracle 11.2.0
• Mentoring new team members.

Confidential

Sr. Oracle DBA

Responsibilities:

• Provide support and maintain very large number of complex Oracle database systems in a multi-platform 24x7 environment.
• Performed database administration like User Management and implement Security using Roles, Privileges, Grants, applied patches, Database upgrades
• Build and maintain Golden Gate Processes for replicating purposes including Oracle Real Application Cluster (RAC) databases. Troubleshoot with Golden Gate ERRORS.
• Worked as Production DBA in 10g/11g.
• Install and administer Oracle E Business Suite R12 on Oracle Enterprise Linux (OEL).
• Install and upgrade Oracle Enterprise Manager (OEM) for 10g/11g/12c.
• Tablespace management and capacity planning.
• Build Oracle Real Application Cluster (RAC) systems over ASM for the clients. Maintained and enhanced the scripts used for Oracle RAC/non-RAC installation.
• Administer Oracle Real Application Cluster (RAC) databases and also managing various Oracle Services.
• Worked on Backups and Recovery policy Hot/Cold Backup using RMAN.
• Implementation and Setup of Physical Data Guard and provide support for Oracle Data guard and streams implementation for Disaster Recovery (DR) setup.
• Monitoring and optimizing the performance of the database through Tuning Applications query, Tuning Database Memory, and Tuning Disk Usage etc. Performance and tuning using AWR reports, ADDM, 10G Advisors.
• Experience in Creation and managing Table partitioning and Rebuilding, validating the Indexes.
• Help to optimize the queries, Tuning of SQL statements using tools like Explain plan, Auto trace, STATSPACK, DBMS PROFILER .
• Gather Statistic on table, analyzing tables and indexes.
• Creation of Service Request to Oracle.
• Mentored new team members.

Confidential

Oracle DBA

Responsibilities:

• Provide support and maintain very large number of complex Oracle database systems in a multi-platform 24x7 environment.
• Performed database administration like User Management and implement Security using Roles, Privileges, Grants, applied patches, Database upgrades
• Build and maintain Golden Gate Processes for replicating purposes including Oracle Real Application Cluster (RAC) databases. Troubleshoot with Golden Gate ERRORS.
• Worked as Production DBA in 10g/11g.
• Install and administer Oracle E Business Suite R12 on Oracle Enterprise Linux (OEL).
• Install and upgrade Oracle Enterprise Manager (OEM) for 10g/11g/12c.
• Tablespace management and capacity planning.
• Build Oracle Real Application Cluster (RAC) systems over ASM for the clients. Maintained and enhanced the scripts used for Oracle RAC/non-RAC installation.
• Administer Oracle Real Application Cluster (RAC) databases and also managing various Oracle Services.
• Worked on Backups and Recovery policy Hot/Cold Backup using RMAN.
• Implementation and Setup of Physical Data Guard and provide support for Oracle Data guard and streams implementation for Disaster Recovery (DR) setup.
• Monitoring and optimizing the performance of the database through Tuning Applications query, Tuning Database Memory, and Tuning Disk Usage etc. Performance and tuning using AWR reports, ADDM, 10G Advisors.
• Experience in Creation and managing Table partitioning and Rebuilding, validating the Indexes.
• Help to optimize the queries, Tuning of SQL statements using tools like Explain plan, Auto trace, STATSPACK, DBMS PROFILER.
• Gather Statistic on table, analyzing tables and indexes.
• Creation of Service Request to Oracle.
• Mentored new team members.

Confidential

Junior Oracle DBA

Responsibilities:

• Creation of users/tables as per requirements for application and grant roles/privileges as per requirements.
• Setup and recovery for Oracle RMAN for backup and recovery, cloning etc.
• Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN & TKPROF.
• Table space management and capacity planning for optimal space utilization. Evaluate and resize space usage on daily basis.
• Creating and maintaining Stored Procedure, PL/SQL Blocks, Functions, Trigger, Packages, etc.
• Load data into database using SQL Loader, ETL, etc.
• Help to optimize the queries, Tuning of SQL statements using tools like Explain plan, Auto trace, STATSPACK, DBMS PROFILER.
• Identified and analyzed user requirements and problems to improve the performance of database.
• Create Materialize Views for application requirements.
• Create Partition on Tables and Index according to the need of application.

Confidential

Computer Specialist

Responsibilities:

• To check the performances issue Confidential database level.
• Small shell scripting related to oracle.
• Creating and maintaining stored procedure, function, trigger, and packages etc.
• Identification of User Requirements.
• Finalization of User- Interfaces and Preparation of Reports.
• Create and maintain database operation to suit the applications like indexes, constraints.