SUMMARY:

• Oracle Certified Professional 9i, 10g, 11g and 12c, Oracle GoldenGate and Oracle RAC Certified Specialist and as well with 10+ years’ experience as an Oracle DBA in very large production environments on Red Hat Linux, AIX, Sun Solaris and Windows Platforms.
• Build and Configure Oracle 11g R2 RAC on multiple nodes.
• Hands on Experience in Performance tuning, analysis and optimization.
• Experience with SQL and PL/SQL code development and tuning
• Configuring and Managing Oracle 12c multitenant database.
• Working on setting up Physical and Logical standby Data Guard Environments.
• Applying CPU/PSU patches to oracle RDBMS including RAC and DataGuard Environment.
• Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non - traditional way (Transportable tablespaces) and using GoldenGate without downtime.
• Experience in GoldenGate 10x, 11.1, 12x implementation, Upgradation, Performance tuning GoldenGate extract and Replicats processes for real time database replication.
• Experience in Oracle Enterprise Manager (OEM) 11g and 12c.
• Hands on experience in Backup, Recovery & Cloning of databases using RMAN.
• Data movement (import/export, data pump, SQL*Loader), Transportable Tablespaces, Materialized Views.
• Experience to write Optimal SQL Query, T-SQL & PL/SQL (Package, Procedure, Function, Trigger, View) Scripting.
• Working on creating and Managing Users, Roles, Privileges, Profile and Virtual Private Database (VPD).
• Managing very large database (VLDB) with 20 TB.
• ETL, data warehousing dimensional modeling. cube, rollup Query.
• Experience in data modeling and database logical and physical design
• UNIX/LINUX installation and shell scripting.
• Responsible for managing a team of Production DBA’s in providing 24*7 productions support for mission critical corporate databases.
• Working on 24/7 high availability environment. Flexible and excellent team player. Ready to work in any time slot.
• Working with Oracle Global Customer Support Service Request (SR).
• Excellent troubleshooting skills and quick learner.

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g, 10g, 9i, SQL Server 2005/2008, MySQL 5.1

Database Administration: Oracle RAC and DataGuard with 9i/10g/11g/12c, Oracle GoldenGate, OEM 12c Cloud Control, Oracle Streaming, Oracle WebLogic, OID, LDAP, GG Monitor, SQL Server 2005, 2008, SQL Server HA (Replication, Log Shipping, Mirroring), MySQL 5.1.

Tools: Oracle VMBox, SQL*Loader, TOAD, Oracle SQL Developer, SSRS, ETL, Hadoop - MapReduce, MS Visual Studio, MS Visio, UML Design.

Languages: C#.NET, ASP.NET, Cristal Report 9, HTML, CSS, JavaScript, Java, Shell Scripting (Bash Shell)

Platforms: Red Hat Linux, Oracle Linux, AIX IBM, SUN Solaris, HP Unix and Windows Server.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Consultant - Senior Oracle Database and GoldenGate Administrator

RESPONSIBILITY:

• Managing more than 200 Oracle databases in all versions and OS platforms.
• Cross Platform migration of HP-Unix to AIX including database 9i to 12c upgrade using Oracle GoldenGate.
• Upgrade Oracle GRID and Database from 11g to 12c using GoldenGate without downtime/Logical DataGuard with minimal down time/RMAN with noopen option/ Data Pump.
• Migrated database on PostgraySQL to Oracle 12c multitenant database.
• Installing and configuring 12c with multitenant, 11gR2, 10g and 9i Oracle RDBMS databases on Linux, AIX.
• Installing and Managing Oracle RAC (11g, 12c) on AIX and Linux with 2 and 4 nodes
• Installing and Managing DataGuard Systems (Physical & Logical) Standby Databases of critical production databases.
• Configure RAC to RAC (2 & 4 nodes) DataGuard.
• Configure 12c Enterprise Manager Grid Control infrastructure in two nodes RAC.
• Install and configure OEM Grid Control agents across different platform.

Consultant - Senior Oracle Database and GoldenGate Administrator

Confidential

Responsibilities:

• Appling CPU/PSU patches to oracle RDBMS including RAC and DataGuard Environment using rolling patch for minimal downtime.
• Support multiple databases in a production environment, including both DSS and OLTP data services
• Implement and manage Oracle GoldenGate on Oracle, SQL Server and DB2 Appliance including unidirectional and bi-directional replication.
• Tuning and troubleshooting Oracle GoldenGate.
• Proactively monitor and performance tune databases, as well as troubleshoot problems in a timely manner.
• Performance monitoring and tuning up of the Database using STATSPACK, AWR, ADDM and Indexing, SQL Profiles, Table Partitioning.
• Ability to quickly identify bottlenecks, collaboratively develop solutions, test, and follow implementation standards in maximizing resource efficiency.
• Migrate Oracle GoldenGate from existing severs to new server for Target.
• Maintain daily operations, including backup and recovery, replication, and configuration processes and strategies
• Remain Involve in creation of users, managing their roles and privileges.
• Understanding the existing Database Structure and suggesting the database reorganization.
• Performed capacity planning and sizing of databases based on input from business
• WebLogic server 11g (10.3) configure, manage and troubleshooting.
• Install, Manage Oracle OID and Lightweight Directory Access Protocol (LDAP).
• Responsible for managing a team of 10 Production DBA’s in providing 24*7 productions support for mission critical corporate databases.
• Shell Scripting for Database Alert system and automation.
• Handling very large database (20 TB).

Technologies Used: Languages: SQL, PL/SQL; Databases: Oracle 9i, 10g, 11g, 12c Tools: TOAD, Oracle PL/SQL Developer, Oracle VMBox; Platforms: AIX IBM, SUN Solaris, Linux, Red Hat, Oracle Linux, HP.

Confidential

Oracle Database Administrator

RESPONSIBILITY:

• Installed and configured 3 node RAC environments on Oracle 11gR2 with ASM File system on Linux environments.
• Installed and configured RAC to RAC Data Guard on Oracle 11gR2 with ASM on Linux environments.
• Migrated Oracle 11g standalone to 2 node RAC environment with ASM File system on Linux environments.
• Implemented Physical standby for disaster recovery using Data Guard on Oracle 11g.
• Maintain physical standby databases utility named Data Guard Broker.
• Installed and configured OEM Grid Control agents 11g and 12c on Linux Server 5.7.
• Performance monitoring and tuning up of the Database using STATSPACK, AWR, ADDM.
• Performance tuning by using Indexing, SQL Profiles, Table Partitioning.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Worked actively in planning for storage space requirements and placing them for optimum I/O performance.
• Implemented Oracle Golden Gate unidirectional for real-time replication included Oracle, DB2, and SQL Server.
• Implemented of High Availability solutions with Oracle 11G RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate.
• Automated the process of analyzing tables, gather statistics and index rebuilding.
• Involved in database Export/Import and performing backups and recovery using RMAN.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Maintained all documents of Oracle database operations and database backup & recovery standards.
• Worked alongside the developer and contributing to the development process, enabling and analyzing trace files.
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents.
• Developed SQL and PL/SQL programs (Packages, Functions, Procedures, and Triggers).
• Created Users, Roles, Privileges, Profiles and managing security.
• Developed UNIX shell scripts for day-to-day database administration tasks that include various cron jobs, Backups, Restores and Recoverability.
• 24/7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution for multi-terabyte database issues.

Technologies Used: Languages: SQL, PL/SQL; Databases: Oracle 9i, 10g, 11g, MS SQL Server 2005, 2008, MySQL, DB2; Tools: TOAD, Oracle PL/SQL Developer, ERWin, MS Project Professional, MS Visio, UML Design, Oracle VMBox; Platforms: Windows, Windows Server, AIX IBM, SUN Solaris, Linux, Red Hat, Oracle Linux

Confidential

Oracle Database Administrator

RESPONSIBILITY:

• Implemented Oracle Best Practices in installing and maintaining Oracle Databases.
• Responsible for Installing, upgrading, Implementing and supporting oracle 10g R1/R2 and 11g R1/R2 databases.
• Administered 2 node RAC cluster. Maintenance and support for RAC and Grid components.
• Build and configure physical standby Data Guard as a high availability solution.
• Extensively worked on database cloning and refreshes.
• Implemented ADDM recommendations to optimize sizing of Instance memory pools like SGA, db buffers, shared SQL area, log buffer based on requirements.
• Involved in design and creation of different Database Objects like Tables, Views, Sequences and Database Triggers.
• Implemented and maintained full, incremental and cumulative backup by RMAN.
• Extensive knowledge of original export/import utility and data pump for schema and database refresh.
• Monitoring and troubleshooting space related issues implementing oracle security as per the standards.
• Provided tuning and health monitoring for all production databases.
• Worked extensively with Oracle support to resolve several show stopper issues.
• Documented procedures. Participated in knowledge transfer sessions.

Technologies Used: Languages: SQL, PL/SQL; Databases: Oracle 9i, 10g, 11g, MS SQL Server 2005, 2008, MySQL