SUMMARY

• Over 9 Years of experience in IT industry as an Oracle Database administrator, having exclusive experience in Golden Gate administration, production support, installation, configuration, upgrades, cloning, space management and database security wif Oracle Software 11g/10g/9i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Possess high competency in advanced DBA skills such as backup, recovery & performance tuning.
• Good exposure in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Experience in installing and patching Oracle RAC wif ASM on AIX, Solaris and Linux platforms.
• Expertise in setting up Data Guard Fail-Over/Switch-Over/Read-Only scenarios. Fabricated multiple CLONING databases using traditional method and RMAN utility for High availability configuration.
• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases and Grid Infrastructure.
• Extensive knowledge of database backup/recovery strategy using RMAN and configuration of Recovery catalog for multiple databases.
• Performed periodical backups of both full and incremental and restoration, recovery of database using RMAN utility.
• Experience wif logical backups of the database using Data Pump (Expdp and Impdp).
• Implemented Database security administration by creating new users, roles, profiles and providing required user privileges in development, test, training and production environments.
• Performed backups and tested crash recoveries using conventional Hot and Cold backups.
• Experience in working on various OLTP and OLAP databases both in clustered and non-clustered environment.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution wif strategic disaster recovery plans wif different recovery procedures and methods.
• Experience in using transportable tablespace, materialized view, RMAN incremental backup and bitmap indexes in data warehouse environment.
• Experience in Oracle Golden Gate 10.x/11.x installation, configuration, and troubleshooting Golden Gate issues.
• Zero downtime migration using oracle datapump and Golden Gate between Oracle 10g and 11g wif Linux, Solaris, and Windows platforms.
• Experience in configuring Golden Gate replicatin between OLTP to OLTP, and OLTP to datawarehousing environments.
• Experience in Oracle Database Tuning and Performance by using tools/utilities like Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Implementation of Enterprise wide Database Monitoring and enabling Oracle 11g Enterprise Manager Grid Control (OEM). One stop solution for monitoring of the system, network, database operations, application, and other system components in Grid environment wifin the global enterprise.
• Managing internal databases, from planning and testing stages through implementation and support.
• Experience in Managing Database Structures, Storage, Table/Index segments, Constraints, Database Access and Rollback segments.
• Experience in migration, database change management and data management through the various stages of the Software development life cycle.
• Experience in Deployment process in all phases from Development to production.
• Experience wif SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Strong working knowledge of development tools like TOAD, SQL Developer, and SQL Navigator.
• Provided 24/7 on-call DBA support for Production/Development databases, responding to troubleshooting calls from multiple database sites and offering solutions to database applications.
• Got appreciation from the management, other teams as well as clients for a quick turnaround time in solving the critical database issues.

PROFESSIONAL EXPERIENCE

Confidential, Fairfield, OH

Oracle App DBA Analyst (Data warehouse)

Responsibilities:

• Responsible for designing, developing, enhancing, and administering data structures and data processes required to meet data warehouse business objectives. Contributes considerable business and technical knowledge to complex IT projects.
• Transform business requirements into data warehouse solutions through the design, development, and maintenance of data warehouse data flows
• Proactively resolve application and database performance issues.
• Design / implement a revised statistics gathering process
• Resolve I/O wait time issues
• Resolve resource contention on long running queries
• Upgrading databases from 11.2.0.4 to 12c.
• Re-Building Databases according to the application requirement.
• Heading the problem management team.
• Plan and implement the backup/recovery on need basis
• Working on a POC for Hardware move (IBM power 8 to power 9 systems)
• Coordinate and work wif database vendors for resolution on major incidents
• Database refresh, re-org, backup using RMAN and 3rd party tools
• Maintain current standards in database, data management, data warehouse and industry trends through research/education/self-motivated training and personal development
• Update and communicate project status to management, team members, and other supporting vendors
• Design and maintain the APEX applications for data warehouse.
• Work on implementing OEM 12c and migrating from OEM 12c to OEM 13c
• Mentors and educate ETL team wif respect to database design and implementation practices
• Develop and monitor data warehouse batch schedules
• Enforce application coding standards
• Coordinate database development and maintenance activities wif project and client teams
• Support development, test, and production Oracle databases including concurrent development efforts
• Work wif the VOC system DBAs to implement changes and performance improvements

Confidential, West Chester, PA

Sr. Oracle Database Administrator/Golden Gate

Responsibilities:

• Design and implement the high availability solutions (RAC, Golden Gate and Dataguard)
• Install, configure and manage ASM instances
• Define and configure the disk and diskgroups in ASM
• Setup, administer and troubleshoot Golden Gate Replication issues across database environment.
• Manage and administer the databases on Exadata machine.
• Managing the top 20 business critical applications by generating a tableau report for multiple checks every hour.
• Plan the database upgrade, migration and patching
• Upgrading Grid Infrastructure and databases from 11.2.0.3 to 11.2.0.4.
• Upgrading Grid Infrastructure and databases from 11.2.0.4 to 12c.
• Re-Building Database clusters according to the application requirement.
• Used golden gate replication to migrate data from DB2 on Mainframe or DB2 on LUW/ZOS into oracle 12c databases on Oracle Exadata. Extensive knowledge of golden gate replication.
• Heading the problem management team.
• Plan and implement the backup/recovery on need basis
• Hardware tech refresh (host to host database move)
• Coordinate and work wif database vendors for resolution on major incidents
• Database refresh, re-org, backup using RMAN and 3rd party tools
• Install and configure grid control database monitoring tools
• Administer and manage Oracle grid control
• Define performance benchmarks and metrics
• Periodic database instance performance review and tuning recommendation
• Proactive database analysis and suggestion to application team / business
• Write and troubleshoot shell scripting, SQL and PL/SQL scripts
• Primarily role is supporting the production and non-prod database environments
• Provide 24x7 and on call support for critical application databases

Confidential, St Louis, MO

Sr. Oracle Database Administrator/Golden Gate Administrator/Exadata

Responsibilities:

• Oracle Database Administrator providing RDBMS support for MasterCard applications using Oracle databases on Solaris, AIX and Linux systems.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects.
• Writing PL/SQL triggers, procedures, and functions.
• Installation, Configuration and maintenance of Oracle 11gR1/11gR2 on AIX, Linux, Solaris and Exadata.
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
• Upgrading Grid Infrastructure and databases from 11.2.0.3 to 11.2.0.4.
• Upgrading Grid Infrastructure and databases from 11.2.0.4 to 12c.
• Configured and implemented Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GAURD broker (DGMDRL).
• Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines.
• Experience in performance tuning, troubleshooting on Exadata machines. Gained Working knowledge of Linux, storage and network administration in relation to Exadata machines
• Review new tools and products that assist Data Architecture in providing database support and services.
• Done performance tuning related jobs like general health checks and maintenance of databases using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports by finding wait events.
• Providing 24x7on call support for all the production and development databases
• Interact directly wif application and business owners to educate them on the direction of Data Architecture.
• Worked on database migration from DB2 to Oracle as a part of POC.
• Worked on Physical and logical database design, implemented DDL and DML changes.
• IdentifiedSQLstatements wif poor performance using Performance Tools andSQLTrace tools.
• Developed stored procedures, triggers, views and added/modified tables for data load, transformation and extraction.
• Worked on Client/Servertools likeSQLServerEnterprise Manager and Query Analyzer to administerSQLServer.
• Worked as a Production and Development Support DBA responsible for maintainingSQLDatabase Serversin Prod, Dev, UAT, SIT and QA Environments
• InstalledSQLServer2008 R2 andSQLServer2012 on windows 2008 R2 and 2012servers, applied service packs and security fixes for all theservers.
• Implemented Database Mirroring onSQLServer2008R2 in Prod environment
• Configured performance tuning and optimization inSQLServer2005.
• Partner wif Development and Business partners to assess database hardware, database design and configuration requirements and recommend solutions that conform to supported standards
• Provide escalation support for Level 1 DBA support staff
• Stay current on features and functionality of Oracle databases, focusing on technology to improve performance, availability, reliability and stability of the Oracle databases
• Mentor junior level DBA’s
• Provide leadership to various projects and initiatives

Environment: Oracle Exadata, Oracle golden gate, Oracle 11gR2 Real Application Clusters (RAC) on Oracle Database Appliance, Oracle Enterprise Manager, Oracle Dataguard, SQLServer 2012/ 2008/2005/2000 , Cognos Reporting, IBM WebSphere, Application Build(Maven), Apache tomcat servers, RHEL, AIX and Solaris platforms.

Confidential, Austin, TX 

Sr. Oracle Database Administrator/Golden Gate Administrator

Responsibilities:

• Installation, Configuration and maintenance of Oracle 11gR1/11gR2 on Linux, and Solaris.
• Configuration and maintenance of 11g RAC and Single Instance database environments.
• Installing ASM environment and migrating databases from NON-ASM to ASM.
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
• Experience of installing, configuring Golden Gate Replication from OLTP databases to Datawarehousing environments.
• Troubleshooting Golden Gate issues in both development and production environments.
• Performed Uni-directional and Bi-directional replication through Golden Gate for zero downtime Database migrations.
• Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using Datapump and Golden Gate replication.
• Upgrading Grid Infrastructure and databases from 11.2.0.1/11.2.0.2/11.2.0.3 to 11.2.0.4.
• Applied patches (Patch sets and CPU patches) and worked closely wif Oracle to make Application environment up to date.
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Troubleshooting and maintenance of RMAN backups and user managed backups.
• Implemented Backup-using RMAN (Recovery Manager) as media management layer
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (wif Exp/Imp) and Data Pump Database backup (Hot & cold).
• Extensive use of performance monitoring tools like STATSPACK and AWR, ADDM reports, Oracle Enterprise Manager, TOAD for the performance tuning at the SQL and database level.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines. Provided support for OS upgrades on Exadata running on Linux.
• Provided support for altering hardware on Exadata machines.
• Installation of Oracle Enterprise Manager (OEM) Grid Control for environment standardization
• Constantly monitoring the performance of the databases and viewing alert log files & trace files.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users.
• Worked on tools like SVN/GIT for revision control, and Maven for deployment in various environments.
• Created a process using Maven and Shell scripts to build new environments in less TEMPthan 30 min.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects.
• Writing PL/SQL triggers, procedures, and functions.
• Experience in Planning Database, Sizing table space, Create database, scripts, Interact wif developers.
• Involved in Install, configure, monitor, upgrade, patch and tuneSQLServer2000, 2005 and 2008servers.
• Configuring SSIS (SQLServerIntegration Services) for named instances, remote access enabling for Users and Migrating DTS packages to SSIS
• Involved in re-writing of all the functionality (which is not supported in 2005) ofSQLserver2000 to SQLserver2005
• Creating Maintenance Plans for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application and solving Database troubles
• Performed Performance Tuning of the database, Stored Procedures andSQLqueries.
• Strategic content infrastructure for managing documents, images, rich media files, and records in Management
• End-to-End content lifecycle management from creation to archiving
• Experience in Planning Database, Sizing table space, Create database, scripts, Interact wif developers.
• Co-coordinating wif on-site counterpart as well as Clients and understanding requirements and providing 24x7on call support for all the production and development databases.

Environment: Oracle 10gR1, 10gR2, 11gR1, 11gR2, 12c wif RAC, Data Guard, ASM, Golden Gate, SQLServer 2008/2005/2000 , PL/SQL, Erwin, SVN, GIT, Maven, HTTP, F-Secure SSH, F-Secure FTP, TOAD and Oracle Enterprise Manager.