SUMMARY

• I have over 6 years of interactive experience in Oracle Database Administration including Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Goldengate.
• I have worked on Oracle 10g, 11g, 12c versions. Support full SDLC environments.
• Experience in Performing database space management, monitoring, Tuning with Oracle 12c Cloud Control, custom automation scripts, etc.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch - over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
• Excellent experience in managing large-scale OLTP databases 150+TB size in HA and DR setup
• Performed Uni-directional and Bi-directional replication through Golden Gate for zero downtime Database migrations.
• Expertise in system Monitoring and Performing 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 (perfstat), SQL*Trace, TKPROF, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advisor, Undo Segment, MTTR, Memory.
• Experience migration/consolidation of databases using Oracle 12c multitenant.
• Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
• Performed an upgrade of Oracle Database from 11g to 12c.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database
• Monitoring the Database health check and growth with script.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues
• Implemented RMAN backup(Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Data Guard
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies
• System administration, Oracle Problem analysis and resolution and active cloning of databases from one server to another server

TECHNICAL SKILLS

Operating Systems: Sun Solaris 2.5, 2.6, 8, 9, 10. RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Tools: TKPROF, EXPLAIN PLAN, AWR, and ADDM.Toad, Putty, Winscp

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.
• Setup New databases on Clustered and Non clustered environment and Implemented Maximum Availability Architecture using RAC, DATAGUARD and Golden Gate
• Upgrade 11G Rac to 12c RAC and Administering the RAC Environment through SRVCTL and CRSCTL and applied patches in rolling fashion
• Worked on 12c RAC new builds and administering 12c RAC and managed ASM on RAC
• Creating Volume and Configured ACFS on ASM diskgroup and Extensively worked on creation oracle Databases with ASM filesystem
• Configured diskgroups with different redundancy levels and created fail groups and managing and tuning ASM parameters
• Configuration & Troubleshooting the Oracle DataGuard & GoldenGate environment in Oracle 11g & 12c versions.
• Configured Golden Gate 12c RAC, RAC Active configuration with 12c database
• Hands on experience in GGSCI utility for administering Extract, Pump, Replicate & reviewing the error logs and troubleshooting Abend scenarios.
• Configured GoldenGate BI-DIRECTIONAL replication and extensively used CDR parameters
• Full database, Schema refresh using RMAN, Datapump and Implemented the Backup strategies using RMAN catalog and nocatalog methods.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Handled High volume production databases around 25 TB size along with Physical standby databases
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
• Performed Data file recovery from logical and physical block corruptions
• Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
• Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability. Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkrpof, Explain plan.
• Experience working with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
• Partitioning strategies for very large tables. Implemented Range, List, Hash and various Sub Partitions, Create and schedule refresh for materialized views.
• Work with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.
• SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.
• Data Refresh of large production data warehouse environment to setup test, development environments using SAN level storage mirroring: Gold image copy and cloning.
• Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
• Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Worked on setting up Physical Standby Data Guard environment for Prod & non-prod databases.
• Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Confidential - Sunbury, PA

Oracle DBA

Responsibilities:

• Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
• Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms.
• Performed upgrade from 10g to 11g.
• Adding and removing nodes to existing Oracle database RAC configurations
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability

Environment: RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, Golden Gate