SUMMARY:

• Having 6 years of experience as an Oracle Database Administrator with exposure on Production Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management Systems for Business Solutions.
• Experience in Administration activities such as Installation, Configuration Client/server connectivity Creating and managing repositories, users, user groups, Folders, user Roles, profiles and Privileges.
• Experience on creation and implementation of Backup and Recovery methods and disaster recovery methods using RMAN, logical, hot backups, Flashback Recovery and performed full, incremental and Cumulative backups using RMAN.
• Extensive experience in Application Development, Database development 24x7 production system support handling large databases using Oracle 12c, 11g, 10g, 9i on various platforms like AIX, Solaris, Red hat EL, UNIX and Windows.
• Installation, upgrading, configuration and troubleshooting Golden Gate 12c software
• Configure GoldenGate for Classic and Integrated capture components for replication
• Configured Golden Gate High availability using Oracle ACFS on Grid
• Experience in performance tuning of Oracle Golden Gate process to achieve zero lag time
• Experience with Oracle Golden Gate 11g/12c replication setup across heterogeneous database vendors
• Expertise in Oracle GoldenGate installation, configuration troubleshooting GoldenGate issues.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• Establishing standards, policies and procedures for GoldenGate replication administration.
• Implementation of High Availability solutions with Oracle RAC, Physical and Logical Standby Databases
• (Data Guard) and Replication using GoldenGate.
• Implemented High availability using Golden Gate Replication. Implanted Bi - directional replication using golden gate.
• Implemented Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Experienceindeployingnewapplicationandsettingupreplicationbetweenthedatabases using GoldenGate
• Implanted unidirectional and Bidirectional replication using various versions of GoldenGate
• Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using GoldenGate.
• Implemented classic Golden gate replication as well as integrated replication.
• Experience in implementing Oracle TDE to protect data Confidential the operating system level
• Experience on Performance Tuning - proactive and reactive for optimal performance to meet Business SLA*s. Database performance tuning (Oracle 9i, 10g, 11g), SQL tuning (using AWR report, SQL Turning Advisor, v$ tables, ASH, ADDM report, OEM).
• Export and Import of database objects using Data pump utilities EXPDP and IMPDP.
• Experience in partitioning the tables to improve the performance.
• ExperienceinconfiguringandperformingSwitchoverusingActiveData-guard.
• Experience in shell scripting and scheduling jobs using crontabutility.
• Configuration of TNSNAMES.ora, LISTENER.ora for SQL*NET connectivity and resolving connection problems.
• Strong skills in Database Management tools like Grid and OEM.
• Experience in cloning the databases on various platforms.
• Experience in creating the database using DBCA for Oracle 9i, Oracle 10g and Oracle 11g/12C.
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.
• A very good team player, self motivated, dedicated in any work environment with24x7 support.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• Excellent communication, documentation and coordination skills.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/12c RAC DataGuard ASM

Oracle Tools: SQL Plus Oracle Utilities RMAN, EXPDP/IMPDP, SQL*loader

Operating Systems: RHEL/OEL/Solaris/AIX/Windows

Languages: SQL, PL/SQL and Visual

PROFESSIONAL EXPERIENCE:

Confidential, Richardson Texas

Oracle Database Administrator

• Installed and configured 4 node Oracle 11g R2 RAC for production environment.
• Experience with Oracle Golden Gate 11g/12c replication setup across heterogeneous database vendors.
• Expertise in Oracle GoldenGate installation, configuration, troubleshooting GoldenGate issues.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• Establishing standards, policies and procedures for GoldenGate replication administration.
• Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
• Responsible in configuring, managing and monitoring Physical standby database using Data Guard and have hands on experience on Active Data guard.
• Performed planned switchover and failover to physical standby database with and without Data Guard
• Broker to verify availability status.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 12c) for migration and logical backup of database.
• Responsible in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump
• Export/Import allowing users to quickly move a user across Oracle databases.
• Responsible for Creating Users, Roles, Profiles and assigning the users to roles and grant necessary privileges to the relevant roles.
• Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
• Configured data replication over DB links for maintaining the data consistency across multiple databases using datapump.
• Performed Oracle database migrations, upgrades, applying patch sets, database releases and code deployments.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Performed RMAN database cloning with ACTIVE duplication.

Confidential

Oracle Database Administrator

• Responsible in providing 24*7 on call support for Production Databases.
• Responsible in managing large-scale OLTP databases 6+TB size in HA and DR setup.
• Installed and configured 4 node Oracle 11gR2 RAC for production environment
• Experience with Oracle Golden Gate 11g/12c replication setup across heterogeneous database vendors
• Expertise in Oracle GoldenGate installation, configuration, troubleshooting GoldenGate issues.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• Establishing standards, policies and procedures for GoldenGate replication administration.
• Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
• Responsible in configuring, managing and monitoring Physical standby database using Data Guard and have hands on experience on Active Dataguard.
• Performed planned switchover and failover to physical standby database with and without Data Guard
• Broker to verify availability status.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 12c) for migration and logical backup of database.
• Responsible in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump
• Export/Import allowing users to quickly move a user Tablespace across Oracle databases.
• Responsible for Creating Users, Roles, Profiles and assigning the users to roles and grant necessary privileges to the relevant roles.
• Managing Security Management, Schema Management, Instance Management, Storage/Space
• Management.
• Configured data replication over DB links for maintaining the data consistency across multiple databases using Datapump.
• Performed Oracle database migrations, upgrades, applying patch sets, database releases and code deployments.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Performed RMAN database cloning with ACTIVE duplication.
• Performed FLASHBACK features to handle efficient database recovery.
• Performed database monitoring activities using Oracle Enterprise Manager (OEM) and TOAD.
• Administrating RAC Databases using SRVCTL, CRSCTL.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD.
• Experienced in performance monitoring/tuning/troubleshooting
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, SQL TRACE, SQL Tuning
• Advisor.
• Experience in system Monitoring and Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
• Responsible in tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.
• Daily Health Check Up of the Databases and applications.
• Enforced corporate business rules through adequate user/resource/object management.
• Security implementation through basic and advanced security techniques like applying recent patches and upgrades, appropriate user grants, permissions and profile management.
• Detailed analysis of the business and users requirements by doing various information-gathering techniques.