SUMMARY

• Database Administrator with 9+ years of experience in Installation, upgrade/migration, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle databases.
• Proficient in Oracle 12c, 11g R1, 11g R2, Oracle 10g R2, 10.1.0.x, Oracle 9.2.0.x
• Experience in supporting Oracle databases 9i/10g/11g/12c in variety of different environments including UNIX, Sun Solaris, IBM AIX Servers and Linux.
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.
• Installed and Administered Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
• Proficient with new 11g features such as Active Data guard and Snapshot standby database
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
• Strong experience in migrating database from Non - ASM to ASM and Non-RAC to RAC.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).
• Extensive expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance Tuning, Backups, Recovery, RMAN backups, Optimization, Networking, Troubleshooting.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN and Golden Gate.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and a bend.
• Participated in Migration of 30 Mission critical Oracle databasesfrom different platforms to Microsoft azure.
• Experienced in working with microsoft azure cloud servicesdeveloped VM with oracle linux 6.8 and 7.1 in Azure.
• Experienced in building vm's in azure with oracle enterprise edition 12.1.0.2 on azure.
• Db migration to other data center and Azure were done using various methodologies datapump dataguard and restore recovery options based on sceanories.
• Expert level skills in managing on both physical servers,vm and cloud based solutions like azure.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.
• Experience in installing Oracle patches, Migration of database across different platforms.
• Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.
• Implemented Data guard in the production environment.
• Experience in Disaster Recovery set-up using Data Guard for critical environments and Disaster Recovery exercises annually.
• Participated in database Migrations using Oracle Golden gate.
• Installed,configured and troubleshooting of Goldengate 12c for migrating production database to new hardware.
• Implemented uni directional and Bi-directional replication using various versions of Golden gate.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental).
• Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, and SQL TRACE.
• Experience on building and rolling out new 12c databases for test/dev/qa environments
• Experience in upgrading of oracle databases from 11g to 12c
• Proven ability of providing production support for 24X7 on multiple databases.
• Ability to work on own initiative and as a part of team. Excellent verbal and written communication skills.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 5/6/7, Windows 2003, Windows 2000/NT, Windows XP.

Databases: Oracle 12c,11g, 10g, 9i, 8i, Mysql, Microsoft Sql Server 2005, Oracle 12c/11g/10g Real Application Cluster (RAC), ASM

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch, TK Prof, Utlbstat,Utlestat,Statspack, AWR, ADDM, QOPATCH, NID, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, ADRCI and DBUA

Scripting: Shell Scripting Korn & Bourne, C Shell

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, SQL Developer, Putty, SQL*PLUS, MS Office.

Languages: SQL, PL/SQL for Oracle, C, Java, Php, XSLT.

DataModelingTools: Erwin 4.0, Sybase Power Developer

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Database Administrator

Environment: Red Hat Linux 6.0, OEL 6.8, AIX, Oracle 11g/12c, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER, Oracle 12c, Oracle RAC, Data guard,ASM

Responsibilities:

• Installed and configured OEM 13C on Oracle Enterprise Linux 6.8 in Microsoft Azure cloud.
• Migrated databases from on premises to Azure cloud using Datapump and Rman cross platform transportable tablespaces from AIX to OEL platform.
• Developed the strategy and Participated in Migration of 30 Mission critical Oracle production databases from different platforms like IBM AIX to Microsoft azure with databases intially on 11.2.0.2 and we migrated them to 11.2.0.4 on azure.
• Experienced in working with microsoft azure cloud servicesdeveloped VM with oracle linux 6.8 and 7.1 in Azure.
• Experienced in building vm's in azure with oracle enterprise edition 11.2.0.4 on azure.
• Deploying OEM agents on Microsoft Azure Cloud OEL 6.8 - Hosts for monitoring Databases.
• Duplication of production databases using Backups from IBM TSM sbt tape.
• Participated in database Migrations using Oracle Golden gate.
• Installed,configured and troubleshooting of Goldengate 12c for migrating production database to new hardware.
• Implemented uni directional and Bi-directional replication using various versions of Golden gate.
• Worked on oracle utility meter data management 2.5.2 and 2.6 versions.
• Migrated databases between datacenters using golden gate 12c.
• Applied patches for oracle golden gate 11g.
• Created physical standby - RAC database size of 8 TB with storage ASM by using RMAN duplication for standby.
• Installed and configured 11.2.0.4 oracle standalone databases in Azure cloud(OEL platform).
• Installed and configured 12C grid control on Aix on premises server.
• SQL tuning by using SQL/Optimizer hints to improve Query performance.
• Provided Rman backup scripts for incremental level 0 and level 1 backups.
• Provided archivelog gap detection script for Monitoring Physical standby databases.
• Installed sql developer and Oracle client on application servers (OEL and Windows server).
• Upgraded oracle databases from 11.2.0.2, 11.2.0.4 to 12.1.0.2 on AIX platform using dbua and datapump.
• Performed Cancel based recovery.
• Upgraded SAP Business objects oracle databases from 10.2.0.4 to 11.2.0.4 and 11.2.0.4 to 12.1.0.2 on AIX platform
• Migrated several schemas using datapump from production to test databases.
• Enabling Flashback with Guaranteed restore point for Oracle Fusion Middleware Application upgrades/schema creation using RCU.
• Worked with offshore team and co-ordinate with them always for any database changes by means of email/phone communication.
• Worked with projects/operations/professional services team and co-ordinate multiple tasks at hand with expertise and solid plan.

Confidential, St.Louis, MO

Sr. Oracle DBA

Environment: Red Hat Linux 6.0, Solaris, AIX, Oracle 11g/12c, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER, Oracle 12c GRID, Oracle RAC, Data guard

Responsibilities:

• Worked on upgrading of Oracle databases from 11g to 12c.
• Worked on building and rolling out new 12c databases for test/dev/qa environments.
• Implemented Oracle 12c active standby database for test database environment.
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
• Implemented uni directional replication using various versions of Golden gate.
• Utilized RMAN recover table functionality and created proof of concepts for our pre-prod environment.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager
• Installation and creation of 11g and 10g databases for Testing, Development and Production.
• Implemented 12c/11g Data guard with one physical database
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack
• OEM / GRID (OGC) installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Build and implement test, quality assurance, and production databases and environments.
• Coordinated strategies to move data between databases using expdp/impdp.
• Composed maintained and monitored compliance to standards and practices.
• Assisted IT Analysts on technical database issues and features.
• Resolved data integration issues.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Assisted in installation, assembly and patching of Exadata and Oracle applications.
• Disaster recovery of Exadata Dataguard Physical Standby.
• Dataguard and Provided Oracle database administrative support.
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.

Confidential, Kansas City, MO

Sr. Oracle DBA

Environment: IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 10g/11g/12c, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0, Oracle 12c GRID, QUEST SOFTWARE (5.0), Oracle RAC, Data guard, Toad 8.6, AD utilities, SQL server

Responsibilities:

• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Implemented Oracle 11g golden gate for replication project.
• Implemented Oracle 11g Active Data guard for Disaster Recovery Solution.
• Worked on Implementing Oracle OEM 11g Agent cloning tasks for hundreds of servers.
• Handled Vendor applications and interacted with vendors regularly to understand and ptimize the database operations.
• Actively participated on war room bridges during major releases and escalated to dba management as needed.
• Participated in database audits and following compliance rules and regulations always.
• Participated in internal db team meetings with peers and management for db work/project status update.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
• Production Support for Critical Application Databases, work closely with
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• GoldenGate installation, configuration for replication.
• Used normal import and export and also datapump import and export for exporting and importing schemas, tables etc from one database to another.
• Extensively worked with dba jobs, dba scheduler jobs, functions, procedures and packages.
• Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance.
• Focusing on Exadata administration.With nodes ranging from 2 to 8 and incorporating Dataguard Exadataclusters for maximum availability.
• Kept tracking the database performance using oracle enterprise manager and checking the users sessions which consuming more CPU and taken the necessary steps to reduce the CPU usage.
• Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
• Analyzed the tables and indexes manually whenever required. Manually refreshed the materialized views (used for replication) whenever the job fails to refresh them.
• Monitored and checked the invalid objects like jobs, procedures etc and recompiled manually after solving the problem for objects to become invalid.
• Troubleshooting application failures including performance and database connectivity problems and job failures.
• Administrated the automatic storage management (ASM) like adding the disk groups.

Confidential, Cary, NC

Sr. Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD(10.1), Recovery Manager (RMAN), Tivoli, Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts,Golden Gate, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, AIX-5.3.

Responsibilities:

• Plans, analyzes, design, implements, maintains, and controls the organization’s databases with a main focus on Oracle.
• Programming and development of SQL, PL/SQL and UNIX shell scripts.
• Registering Oracle 11gR1/11gR2/12c databases in Oracle Virtual Directory.
• Implementation and configuration of Centralized Database Authentication using Kerberos authentication.
• Consults with and provides guidance to database users and client groups.
• Collaborates and provides input with other database analysts, where applicable, including troubleshooting and escalated issues.
• Working with Oracle Support Team, creation of Service Requests for OVD registration, Global role mapping, and database related issues.
• Documenting the OVD procedure and implementation, issues, status and remediation of shared accounts.

Confidential, Seattle, WA

Oracle DBA

Environment: Oracle 9i/10g, Sun Solaris, Linux, HP-UX, Putty, OEM, TKPROF, Data Guard, Shell Scripts, RMAN, Golden Gate, Oracle RAC.

Responsibilities:

• Installation and Maintenance of Oracle Databases.
• Upgrade of Databasefrom 9i to 10g.
• Involved in configuration of Golden Gate for replication of database.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Cleaning up unwanted log files and Checking the Disk Space for potential problems.
• Performed number of schema refreshes from production to test and dev using expdp/impdp
• Applying CPU patches to Oracle Applications.
• Performed cloning/Refresh of Production Instance to Test, Development environments.
• Performance tuning - Tune SQL statements, I/O, Memory, latches etc. Worked extensively on SQL Profiler, Explain Plan and Stats Pack for tuning top wait events, high cost SQL’s.
• Monitoring the environments from OEM.
• Backup and Recovery using RMAN.
• Applied Oracle Security Patches for 9i and 10g databases.
• Rebuilding of Indexes.
• Providing Production support (24/7) and troubleshooting user issues.
• Weekly meetings with users to discuss about the issues related to various application modules & overall performance of the system.
• Interaction with Oracle support to work on Tars.
• Taking different types of logical, physical backups at database level.
• Identifying and troubleshooting long running queries, locked sesions to improve overall performance.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self tuning purposes.
• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.
• Bouncing of Database services.
• Documented various process & procedures.
• Support the UNIX and Linux Administration tasks.
• Established and wrote the Database Administrators Procedures document for the IT department.
• Interaction with various stakeholders for timely delivery of different tasks.

Confidential, Atlanta, GA

Oracle DBA

Environment: Oracle 9i/8i, Solaris, Linux, HP-UX, TKPROF, Data Guard, Shell Scripts,Golden Gate, AWR,RMAN, RAC

Responsibilities:

• Provided 24x7 Support of Critical Databases and worked on enhancing the Database Monitoring process.
• Troubleshooting issues during upgrade, applying patches to fix issues.
• Upgrade of database from 8i to 9i.
• Responsible for refreshing/cloning test instances with Production Instance periodically,
• Applying patches for fixing issues and adding functionality.
• Administration of databases- Physical and logical structures.
• Applied and provided feedback regarding in-house technical standards and processes.
• Creating and Managing users, Granting and Revoking privileges for the users in order to ensure the Database security.
• Creating and Maintenance of different types of Tablespaces.
• Automated jobs to run backups, disk cleanup for logs and archive logs, gather statistics.
• Identify and troubleshoot long running queries, locked sessions to improve overall performance.
• Established and wrote the Database Administrators Procedures document for the IT department.
• This document outlines all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.
• Provided production database support, including creating and maintaining databases, backup and recovery, security, upgrades.
• Supported development projects on database activities (Oracle, DB2, and MySQL).
• Managed and supported users by creating roles and privileges for database access and data manipulation.
• Reported the database storage capacities to Project Management.
• Organized the capacity planning of the production database.

Confidential

Jr. Oracle DBA

Environment: Oracle 10g/9i, Solaris, Linux.

Responsibilities:

• Providing Production support and troubleshooting user issues.
• Performing daily database operations, maintenance and support.
• Administration of databases- Physical and logical structures.
• Export/Import data to/from PROD and Non Production systems as required.
• Expertise in database backupand recovery management (Hot/Cold, Exp/Imp).
• Identifying and resolving resource contention issues and monitoring database performance.
• Troubleshooting based on Alert logs.
• Maintaining of Space requirements on the Tablespaces by adding/re-sizing data files based upon the space available on the file systems and existing volumes.
• Creating and Managing Users, Granting, Revoking privileges for the users in order to ensure the Database security.
• Responsible for refreshing/cloning test instances with Production Instance periodically.
• Creation of Database Links and Materialized Views between different databases.
• Coordinate with Oracle Support to resolve database performance issues.