SUMMARY

• Oracle Certified DBA and having 12+ years of experience in IT industry as an Oracle DBA with strong database concepts.
• Strong experience in Exadata Installation, Patching, Administration and Monitoring. Worked along with Oracle in Converting two half rack Exadata machines into one Full rack Exadata, Instance caging on Exadata.
• Expertise in providing and implementing various Golden Gate Solutions like Active - Active Replication for Zero down time maintenance and Migrations using Conflict detection and Resolution (CDR). Performed hundreds of migrations with minimal or zero down time using Golden Gate. Provided Golden Gate Solutions for increased reads capacity.
• Expertise on Oracle 8i/9i/10g/11g databases on heterogeneous UNIX and windows platforms.
• Experience in implementation, administration of oracle high availability technologies viz. Active Dataguard, Real Application Clusters (RAC).
• Expertise on Cloning the Database with using Physical, logical backups and RMAN.
• Expertise in Installation, configuration, up gradation, design, planning, implementation, user management, troubleshooting, tuning, patching, automating, trouble shooting and administering oracle databases.
• Expertise in Consolidation of databases. Consolidated 100+ databases from Oracle on legacy environments into one Full Rack Exadata with just 4 databases.
• Expertise in design, Implementation Backup and Recovery strategies using RMAN.
• Experience in installation and Configuration of Oracle Database Vault product for implementing security.
• Very strong experience in installation and Configuration of Oracle Transparent data encryption (column level & Tablespace level) for implementing security.
• Expertise in Configuration and maintenance of Oracle 10g/11g ASM instances.
• Experienced working on Installation, configuration and administration of OEM Grid control 11g and 12c and monitoring database through centralized OEM Grid control.
• Expertise in Database and SQL performance Tuning. Coming up the tuning recommendations with using SQL tuning advisory and used to implement new SQL profiles to resolve Performance issues.
• Involving into performance issues and identify the bottlenecks using with Automatic Workload Repository (AWR), SQL access Advisor, SQL Planning Management (SPM), ASH samples the state of all active session every second and Automatic Database Diagnostic Monitor (ADDM).
• Experienced in applying patches, CPU/PSU/One-Off and Interim patches using Opatch utility
• Experience in managing SQL Server databases.
• Configured Active Dataguard (ADG) for RAC databases on Exadata environments.
• Have experience in migrating databases from DB2 to Oracle using Golden Gate Replication.
• Administration on OEM12c to configure new Database, Monitoring performance of Database, generates reports and schedule Blackouts for Database maintenance.
• Replicated data in distributed environments by configuring Materialized Views for frequently used data.
• Experience in providing the solutions for migrations, building Disaster Recovery and develop minimal/zero down time solution for application switch overs, improving database availability, optimizing day to day tasks.
• Strong experience in providing and presenting Root Cause Analysis (RCA’s) for critical productions issues.
• Designed and Implemented High availability solution for Golden Gate replication with DBFS and VIP’s.
• Performed POC on Golden Gate Veridata.
• Have Knowledge on MySQL databases and provided secondary Support.

TECHNICAL SKILLS

Operating Systems: Linux, HP-UNIX, Sun Solaris and Windows

Languages: C,SQL, PL/SQL, Shell scripting

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

High Availability: Oracle Data Guard, RAC and Oracle Golden Gate (Active - Active Replication), DBFSBack-up

Tools: Veritas Netbackup, Data Domain

Replication Tools: Golden GateGUI OEM,TOAD,SQL Developer

Tools: and Utilities: Export/Import, Datapump, Sql Loader, RMAN, Service-now, JIRA, Remedy, HP Open view and Control-M

Domain Knowledge: Telecom, Retail (Travel), Healthcare

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior Oracle Database Administrator

Responsibilities:

• Provide Exadata administration for Full, Half and Quarter Rack Systems. The version of the systems is X2-2 and X3-2.
• Build and administer RAC databases of up to 8 nodes on Exadata.
• Build and administer two node and one node RAC databases on ODA (Oracle Data Appliance) Versions X4-2 and X3-2.
• Build and administer single Instance and RAC databases on AIX and Solaris platforms.
• Perform Application Schema Design Review for new and existing applications.
• Design and Implementation of Centralized database and application instead of maintaining thousands of local in store databases and applications.
• Gather the requirements, define and build databases, Disaster Recovery and ODS Solutions.
• Define Data migration strategy and perform data migrations from Legacy to Newer database systems.
• Perform database/schema refreshes production to non-production environments.
• Tuning the SQL’s for better performance which involves reviewing explain plans, SQL tracing, SQLT reports and creation of SQL profiles, SQL base lines and work with application teams on changing the SQL’s or adding hints etc.
• Perform database tuning activities like SGA, PGA parameters, Huge Pages, CPU bottle necks and AWR reports review.
• Implement DR Solutions using Dataguard, Active Dataguard and Golden Gate Replication.
• Provide Golden Gate Solutions for Reporting Stuff and Increase in search capacity.
• Apply Quarterly patches on Exadata for databases, compute nodes and Cell nodes with rolling fashion without having any down time.
• Build RAC ADG (Active Data Guard) databases for RAC databases.
• Quarterly Database backup restore on Test servers for SOX Compliance.
• Plan and review the project plans for all major releases.
• Coordinate and work with System Engineer and Backup teams to keep the databases up and running and plan for projects / involves hardware or system level changes.
• Involved in solving day to day production issues as well as regular application release work
• Created and maintained Physical standby databases and Dataguard databases.
• Configured RMAN Backups to Tapes for all single instance and RAC databases.
• Configured RMAN Backups from OEM 12c.
• Upgrade databases from 11.2.0.2.0 to 12.1.0.2.0
• Applying Latest CPU patches.
• Supporting Large databases of Terabytes in size
• Provide Level 3 support and DBA on-call rotation for level 3 escalations.

Confidential, Chicago, IL

Lead Oracle Database Administrator

Responsibilities:

• Provide Exadata administration for Full, Half and Quarter Rack Systems. The version of the systems is X2-2 and X3-2.
• Migrated 100+ OLTP production databases from Exadata X2-2 to X3-2 with minimal down time Using Golden Gate Replication.
• Implemented Active - Active Replication for Zero down time maintenance and Migrations including CDR (Conflict Detection and Resolution).
• Provided Golden Gate Solutions for increased reads capacity.
• Performed Golden Gate upgrades from 10.4 to 11.1 and 11.2
• Implemented Golden Gate Integrated extract configuration.
• Configured Golden Gate Replication for Transparent data encryption (TDE) and Custom encryption methods for Golden Gate versions 9.5, 10.4, 11.1 and 11.2
• Worked on combining the two X2-2 half rack Exadata systems into one Full Rack Exadata.
• Apply Quarterly patches on Exadata for databases, compute nodes and Cell nodes with rolling fashion without having any down time.
• Replaced DR solution from ADG (Active Data Guard) with Active - Active Golden Gate replication.
• Designed and Implemented High availability solution for Golden Gate replication with DBFS and VIP’s
• Build RAC ADG (Active Data Guard) databases for 4 node RAC databases on Exadata.
• Migrated oracle database from legacy platforms to Exadata.
• Install and configure Oracle Database Vault product for implementing security.
• Installation and Configuration of Oracle Transparent data encryption (column level & Tablespace level) for implementing security.
• Performance challenges in Complexity of Applications and the Workloads.
• Involved in migrating databases from non-ASM to ASM.
• Continuously monitor the database performance using AWR/STATSPACK by comparing with a baseline during both peak and non-peak loads.
• Installed Oracle database services/products/tools on UNIX environments.
• Quarterly Database backup restore on Test servers for SOX Compliance.
• Developed migration plan for migrating databases from newly acquired company in Texas to Orbitz data center.
• Work closely with SOX and PCI Audit Teams and providing requested information.
• Plan and review the project plans for all major releases.
• Weekly review meetings with the team as well as with client supervisor.
• Coordinate and work with SA, BUR teams to keep the databases up and running and plan for projects which involves hardware or system level changes.
• Involved in solving day to day production issues as well as regular application release work
• Created and maintained Physical standby databases.
• Configured RMAN Backups to Tapes for all single instance and RAC databases.
• Upgraded databases from 11.2.0.2.0 to 11.2.0.3.0
• Upgraded databases from 9.2.0.6 to 10.2.0.3 and 10.2.0.4
• Applying Latest CPU patches.
• Written and implemented RMAN Backup scripts for offline and online backup.
• Taking The Hot Backups and RMAN Backups
• Recovered database after it has been crashed.
• Worked on transportable tablespaces.
• Worked on Veritas clustered databases.
• Supporting Large databases of Terabytes in size
• Solving the performance related issues like Tuning the queries
• Implementation of Oracle advanced replication by using materialized views
• Managing ASM and RAC databases
• Secondary Support for MySQL databases.
• Performed POC on Golden Gate Veridata.

Confidential, Overland Park, KS

Senior Oracle Database Administrator

Responsibilities:

• Plan and review the project plans for all major releases.
• Weekly review meetings with the team as well as with client supervisor.
• Coordinate and work with SA, BUR teams to keep the databases up and running and plan for Projects which involves hardware or system level changes.
• Involved in solving day to day production issues as well as regular application release work
• Created and maintained Physical standby databases.
• Configured Dataguard using RMAN Backup.
• Worked on replication tools like Golden Gate.
• Worked on BCV replication/cloning.
• Upgraded databases from 10.1.0.3.0 to 10.2.0.3.0
• Upgraded databases from 9.2.0.5.0 to 10.2.0.3.0
• Applying Latest CPU patches.
• Worked on database migration from one server to other.
• Written and implemented RMAN Backup scripts for offline and online backup.
• Taking The Hot Backups and RMAN Backups
• Recovered database after it has been crashed.
• Worked on transportable tablespaces.
• Worked on Veritas clustered databases.
• Supporting Large databases of Terabytes in size
• Solving the performance related issues like Tuning the queries
• Implementation of Oracle advanced replication by using materialized views
• Maintaining ASM instance databases
• Maintaining two node RAC database

Confidential

Oracle Database Administrator

Responsibilities:

• Implementation and maintenance of oracle 9i Dataguard physical standby database
• Taking backup of the database which involves daily logical backup (export), RMAN Backup and cold backup
• Refreshing the report server database using database cloning technique.
• The performance tuning of the database
• Recovery in the event of crash
• Creating and managing schema objects
• Creating stored procedures, functions and triggers as per the requirement
• Creating the users with appropriate roles and privileges
• Security administration of the database
• Applying oracle patches
• Purging of unwanted data at regular intervals
• Implementation of Oracle advanced replication by using materialized views
• Loading of the data into the database by using SQL*LOADER Utility for Telecom billing and processing detailed call records
• Uploading data from Confidential Nalgonda billing server to Confidential Portal server Hyderabad for enabling online portal payments by using oracle DB Link