PROFESSIONAL SUMMARY:

• 9 years of experience as an Oracle Database Administrator and 3+ years of experience of MYSQL having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 10g, 11g & 12C with experience within very large scale database environment .
• Excellent experience in installation, setup, migration and configuration of Oracle 10g 11g & 12C in Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Expertise in upgrading the databases from Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
• 24*7 production database support with Support to developers & end - users.
• Experience with 12c Cloud/11g grid/10g CRS Real Application Clusters ( RAC) and single instance environments on UNIX/Linux platforms using Automatic Storage Management ( ASM).
• Worked on ExadataX3-2 and X5-2 Half Rack Machines.
• Installing, configuring and Managing MySQL 5.0, 5.5, 5.6 on Linux RHEL Platform.
• Migrated database from standalone to Galera mysql cluster. Worked percona support system.
• Proficient in setting up Standby Database using RMAN utility tool, activating and Re-building Standby Databases Physical supported by DATAGUARD.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience on SAP system administration in Linux environment in DEV/INT/PRD system landscapes.
• Experience in installing/configuring Golden Gate, leading tool for data replication.
• Applied several patches like patch sets interim patches and one-off patches.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Experience in implementing Tablespace Point in time recovery(TPITR) and Point in time recovery(PITR) using RMAN.
• Implemented backups for MySQL database using mysqldump and innobackupex utility.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Database migrations using DATAPUMP between different wnvironments.
• Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables.
• Effective troubleshooting of database and Performance problems.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, IBM AIX, Linux(RHEL), Windows NT

RDBMS: Oracle 9i,Oracle 10g, Oracle 10g RAC, Oracle 11g RAC

Scripting: Cron scheduling, Vi Editor, Shell Programming

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: RMAN, OEM(GC), EXP, IMP, Datapump, TOAD, GoldenGate, DBVERIFY, Dataguard

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH,ASMM, Oracle Tuning Pack

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr Oracle DBA

Responsibilities:

• Installing,configuring, migration, maintenance of Oracle Database 12c on Red hat 6.6.
• Working on Oracle one node, 2node and 3 node RAC with Active DataGuard.
• Troubleshoot Oracle RAC issues like Node evictions and cluster waits.
• Backups and Recovery using RMAN.
• Working on Data Center Migrations Export and Import (Data Migrations) using expdp/impdp and Golden Gate replication.
• Successfully deployed Targets to 13c OEM for database and system monitoring everything from performance to Backups.
• Applied latest patches for Infra, Grid and database components.
• Implementation and configuration of Oracle Uni -directional and Bi-directional golden gate.
• Configured GoldenGate for database changes by defgen utility and maintained database replication 24x7.
• Install and migrate MySQL cluster databases 5.x from Dev to prod, create user accounts and grant permissions.
• Install and configuration of Galera cluster (3 nodes) and make all the nodes in sync. Implemented Adding Partitions to cluster database.
• Migrated databases from Non Galera to Galera cluster and upgraded Galera from 5.4 to 5.6.
• Working on Oracle Dataguard to maintain sync between primary and standby databases
• Working with developers and completing tickets.
• Worked on testing the Fail-over and Switch-over of standby Data guard using DG Broker.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace , TKPROF , STATSPACK, Explain Plan , AWR , ADDM and monitor the database performance on daily basis.
• Worked on Schema Refresh Requests using import/export, export data pump/import data pump .

Confidential, NY

Sr Oracle DBA

Responsibilities:

• 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, configuration, migration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0.
• Applied patches to Oracle Databases and Oracle Applications.
• Upgraded and Maintaining Exadata X3-2 and X5-2 Hardware Components.
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on physical standby databases in high availability mode.
• Installed and Configured Golden Gate which replicates data between platforms at high level of performance with guaranteed transaction reliability.
• Writing and modifying UNIX shell scripts to manage Oracle environments and for Backend Oracle Processes.
• Hands on experience working with perocna support, open tickets and troubleshoot issues.
• Worked on Oracle/MySQL databases and extensively on creating users, assigning roles, space management and moving code from development to production databases.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
• Upgrade and applied Latest Patch for SAP databases from 10g to 11g.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Cloning & duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Performed other DBA activities like including space management and performance monitoring.
• Performance tuning and diagnosing DBMS and individual Production databases. Organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.

Confidential, Minneapolis, Minnesota

Oracle DBA

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Linux SLES 9 and SLES 10.
• Implemented Data guard, creating Active Standby databases in 11g/10g RAC environment for the Production databases.
• Successfully implemented physical standby database in maximum performance mode using Oracle Data Guard feature for disaster recovery and high availability.
• Performed Upgrade/Migration of the oracle databases from Oracle 10.x to 11.2.0.2.
• Upgraded from 11.2.0.2 to 11.2.0.3 version of database on AIX -6.1 platforms.
• 24x7 remote support, working on incident tickets and on call Database support for Database developers & end-users.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
• Experience in handling tools such as Toad, Oracle Enterprise Manager (OEM) Grid Control to monitor databases.
• Successfully applied patchsets CPU/PSU as required, and also interim, oneoff patches using Opatch utility.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
• Reviewed and executed planned Change Request daily and also immediate/Incident Break fix related Change Requests.
• Worked on the shell script for monitoring database activities and implemented on the production environment.

Confidential, Minneapolis, Minnesota

Oracle DBA

Responsibilities:

• Recognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
• Performed application migrations to non-cluster databases to cluster databases.