SUMMARY:

• Around 9 years of experience as an Oracle Database Administrator in multi RAC environment, database security, RMAN for backup and recovery, disaster recovery, production support, cloning, installation, configuration, upgrades & patching, performance tuning, query tuning, space management, and Exadata X4, X5, X6.
• Hands on experience on various platforms like RHEL Linux 6, 7, HP AIX, Solaris, Ubuntu, Windows environments.
• Experience on different variants of Oracle databases such as 9i, 10g, 11g and 12c.
• Experienced in configuring and Installation of multiple node Real Application Clusters (RAC).
• Migrated NON - ASM databases to ASM using RMAN
• Expertise in installation, configuration, and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer.
• Experience in implementing cross platform Migration such as HP AIX, Solaris and Windows to Linux.
• Good experience in Upgrades, Patches in various environments.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
• Implemented Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
• Good exposure in Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Replicate schemas using Golden Gate schema replication which includes online change synchronization and DDL synchronization.
• Experience in Implementing and maintaining Database security.
• Experience in using PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance.
• Good experience with Oracle enterprise manager (OEM), AWR, ADDM, Flashback Technology, SQL tuning advisor.
• Expertise in loading data from Flat Files using SQL*LOADER and External Table.
• Performance Tuning experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, (OEM) Grid Monitoring.
• Provide and implement performance and tuning recommendations of all components in the   Exadata  machines.
• Participated in analysis and designing of Oracle   Exadata  Server for infrastructure and related projects.
• Integration of   Exadata  monitoring into our existing IT monitoring framework.
• Assisted in integration of   Exadata  applications into current IT actionable events and solutions.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Cloning and Refreshing databases from Production to Test and Development and from Development to Production.
• Good communication and coordination with different departments for efficient problem escalation and deciding on optimal solution.
• Successfully executed migrations from Oracle to Microsoft SQL server 2012 many a time.
• Pioneer in performance & query tuning to optimize the performance of the database and knowledge on index rebuilding, reorganization and query plan analysis to improve the overall execution time of complex queries.
• 24*7 production database support with support to developers & end-users.
• Strong MySQL skills but also significant general system administration skills on UNIX/HP AIX, Linux and Windows environment. Knowledge in general systems administration tasks.

TECHNICAL SKILLS:

Operating Systems: RedHat Enterprise Linux, Sun Solaris, HP AIX, Microsoft Windows

RDBMS: Oracle12c, 11g, 10g, 9i, MySQL 5.1, 5.6, 5.7, Microsoft SQL Server 2012, 2014, 2016.

Database Management tools: Oracle Enterprise Manager (OEM), Oracle Grid Control, TOAD, TIVOLI and ERWIN.

Tools and Utilities: RMAN, SQL Navigator, SQL*Loader, ASM, Export/Import, Patch Management, ODBC, Data pump, Data guard, VERITAS Net Backup, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Splunk, Putty and Hpovo.

Languages: SQL, PL/SQL, shell scripting, Perl and python

ETL: Oracle Data Integrator, Sunopsis, Ab Initio, Informatica Power Mart and Informatica Power Center.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• Installation and Configuration of RAC (4 node) using oracle Cluster ware and ASM, Configured ASM file system and administer ed ASM Instances and Disk Groups in RAC .
• Provide support and recommendations for components in Exadata machines like X6 and Implement performance tuning for all components in the   Exadata  machines.
• Participate in analysis and designing of Oracle   Exadata  Server for infrastructure and related projects.
• Assisted in integration of   Exadata  applications into current IT actionable events and solutions.
• Monitor IT framework on machines integrated with Exadata.
• Install and configure database cloning using RMAN.
• Configure RMAN backups (Full, incremental and cumulative) and performed recovery, incomplete recovery and disaster recovery.
• Install 12c cloud and migrated all the databases from 11g to 12c,
• Perform RAC all node patching and Rolling patching.
• Implement Backup, Recovery procedures and Hot, Cold and Logical backup plans.
• Install, configure and support Golden Gate (11g) replication solutions to facilitate data flow between environments.
• Develop custom utilities to automate manually intensive tasks including mass schema changes, recovering Golden Gate corruptions.
• Implement   Golden Gate  for data recovery and data migration for  Oracle  11gR1 RAC 2 nodes on IBM AIX and debugging   Golden Gate  issues such as extract or replicate and rebuild and perform DDL replication and director tracing using Golden Gate
• Set up, configured and maintained data guard for oracle 11g (primary and standby databases) to ensure disaster recovery, high availability and data protection
• Extensively worked in various areas of data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover
• Implemented the resizing the online redo logs in production and standby databases
• Work on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Expertise in the creation of databases, table spaces, tables, indexes and other database objects. 
• Install and configure relevant network components to ensure database access as well as database consistency and integrity. 
• Troubleshoot and resolve various Oracle connectivity problems.
• Extensively using DATAPUMP and Export / Import utilities for logical backups.
• Performed various performance goal oriented database tuning.
• Perl scripting, shell scripting and PL/SQL programming to resolve business problems of various nature.
• Developed PL/SQL stored procedures with the implementation of Oracle binding variables and dynamic SQLs to gain performance for PASS reporting system, designed the interface to Jasper Reports.
• Use explain plan , AWR , ADDM and various Oracle Advisors to tune the database.
• Created and tuned various materialized views 
• Tuned various slow running queries to improve performance and decrease data fragmentation.
• Performed instance tuning, memory tuning query tuning and complete database tuning.
• Creates and implemented various table partitions for large tables.
• Resolved various complex issues with the database. 
• Applied quarterly PSU patches to different versions of databases. 
• Upgrade  Oracle 10g database to 11g and 11g to 12c.
• Upgraded  Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set.
• Automated Database refresh from the Host system to Oracle using, PL/SQL procedures.
• Migrating database DB2 v8.2 to DB2 v9.2 version on AIX and ADDM.
• Involved in 24x7 supports for both production and development databases with on-call pager.  

Confidential, Phoenix, Arizona

Sr. Oracle DBA

Responsibilities:  

• Extensive knowledge on database administration for Oracle 10g, 11g and 12cwith experience within very large-scale database environment and mission critical large systems. 
• Excellent experience in installation, setup and configuration of Oracle 10g, 11g and 12c in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment. 
• Having hands on experience in management and database administration of Oracle applications on Exadata platforms. 
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c. 
• Expertise in Performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF . 
• Experience in a variety of hardware and software platforms including; MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL. 
• Extensively worked on Golden Gate implementation like installation, configuration GOLDENGATE unidirectional, Bi-directional and broadcast data distribution in classic capture mode on Oracle 11g LINUX.
• Installed Oracle Data Integrator(ODI), Set up the ODI connection with Oracle, MySQL Server and flat files.
• Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Created new models for the data sources - flat files, MySQL server, Oracle.
• Migrated Oracle databases using Oracle 11g GOLDENGATE . 
• Involved in configuring Exadata X2-2, X2-8 and have a good knowledge on smart flash cache, storage index, storage management and migration. 
• Installed Oracle 12c database and Cloud control (12.1.0.3) on Linux 64-bit server.
• Created Perl and UNIX shell script utilities for parsing or reformatting user data and compiling user information reports for various support purpose.
• Implemented OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM . 
• Monitoring all the databases using OEM 12c cloud control. 
• Worked in troubleshooting 2node and 4node RAC and implemented 11g New ASM features. 
• Extensively worked in setting up physical standby database using Data guard and implemented new 11g feature such as Active Data guard and Snapshot standby database. 
• Implemented switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases. 
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption. 
• Diagnosing and resolving most common errors from Oracle net services. 
• Troubleshooting suggestions for Oracle net services. 
• Logging and tracing error information for Oracle net services and contacting Oracle support Services. 
• Space management of disk space to avoid bottlenecks and database failures. 
• Applying patch set and interim patches using OPATCH for upgrading the binaries. 
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage. 
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF , SQL Tuning Advisory. 
• Installed SQLTXPLAIN (SQLT) Tool that helps to diagnose SQL statements performing poorly. 
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning. 
• Performed Range Partitioning as a cause to improve the performance of the database. 
• Performance tuning of the Oracle databases using the following tools/utilities: OEM , OEM 12C, AWR , ASH , Explain plan , ADDM , DBMS stats. 
• 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. 
• Extensive Experience with Change Control Management for all database changes. 
• Data Refresh from Production to Development and Test environments using Data Pump export / import  
• Involvement in space management, rectification of lock problems, user management. 
• Supporting Application developers with various performance, connectivity and security related issues on various projects. 
• Experience in backups and recovery using RMAN shell Scripts. 
• Involved in 24×7 Production Support. 

Confidential, Los Angeles, CA

Sr. Oracle DBA

Responsibilities:

• Upgraded Oracle RAC Database from 11.2.0.2 to 11.2.0.3
• Installed Oracle 11g using GUI on 3 nodes RAC environment with ASM.
• Managing, Troubleshooting and resolving oracle database, RAC and applications issues
• Administration of a 3 node RAC, configuring and monitoring daily backups, troubleshooting errors, to improve performance
• Provide and implement performance and tuning recommendations of all components in the   Exadata  machines and participated in analysis and designing of Oracle   Exadata  Server for infrastructure and related projects.
• Integration of   Exadata  monitoring into our existing IT monitoring framework.
• Extensively worked with import/export, data pumps, SQL *PLUS and SQL- loader
• Extensive knowledge on Performance Tuning, Memory (SGA) Tuning, Net backup, RAW Devices.
• Increased availability of development instances by reducing cloning time by implementing clone automation using Grid.
• Installed Oracle 12c Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases.
• Creating users, profiles and privileges, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Analyzing of Tables and Rebuilding of indexes, defragmentation data blocks of table spaces for optimized performance Also partitioned large tables to increase performance.
• Used shell scripting controlled from Crontab for automation of job Scripts to Startup, Shutdown and Health Check of Databases.
• Used TOAD tool to access the database and PL/SQL developer to create PL/SQL Procedures.
• Performed Daily Health Check Up of the Database using STATSPACK, AWR, ASH, ADDM, TKPROF and EXPLAIN PLAN.
• Applied patches whenever necessary by downloading them from Metal ink.
• Automated Database refresh from the Host system to Oracle using, PL/SQL procedures.
• Configured, administered and monitored Streams to apply changes in multiple databases using tool OEM console.
• On-Call 24x7 DBA support for very large databases.
• 24x7 production support for several mission critical systems which utilize multiple Oracle 10g 11g, 12c databases.
• Test initial Data Load option of Golden Gate during environment build.
• Migrated database from ASM to Non-ASM using RMAN.
• Oracle Golden Gate installation, configuration, troubleshooting related issues.
• Configured   Golden Gate  replication between Production and Prime Production, Performance and Prime Performance environments.
• Assisted in integration of   Exadata  applications into current IT actionable events and solutions.
• Upgrade and Migration of Databases from 11.2.0.1 to 11.2.0.3 and applying patches as per requirement.
• Managed databases using the OEM grid control like Scheduling Backups, Performance Monitoring, alerts setting, generating reports.
• Used Data Guard to configuration, Maintenance and support for DR activities.
• Handled Performance Tuning Activity using OEM (AWR/ADDM), Database space management.
• Duplicate all the non-production databases on   Exadata  server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques
• Troubleshooting Data pump errors in a RAC environment, configuring storage accordingly.
• Cloning the databases for development and testing purposes.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Experience in taking daily/weekly backups using RMAN.
• Implemented ASM on RAC and stand-alone databases Managing disks and disk groups with ASM.
• Configure error handling for restart, logging, production support and status reporting in Golden gate.
• Upgraded the data from Existing Oracle 9i to Oracle 10g to 11g & 12c.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Implemented data guard (Standby) for high availability/disaster recovery purpose.
• Assisted the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries
• Oracle Database Performance Tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc.
• Configured database entries and Monitoring of all the databases using Oracle Enterprise Manager (OEM) 10g/11g grid control and TOAD.
• Focused on separate Partitions like data loads, index creation and rebuilding, backup/recovery.
• Configured ASM and suggested feasible workarounds for ASM Metadata corruption and configured user log on load balancing and failover on RAC database.
• Preparing cluster, configuring and Installation of Cluster ware and Oracle RAC.

Confidential

Oracle DBA

Responsibilities:

• Worked as Support Database Administrator Responsibilities include creation & maintenance of table spaces, data files.
• Upgraded database from oracle 9.2.0.8 to 10.2.0.1 using database upgrade utility.
• Loading data from flat files into database tables using SQL* loader
• Creating and maintaining triggers, packages, functions and procedures
• Created users and established the application security by creating roles 
• Used Indexes and Hints to enhance the performance with the help of Explain plans.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader
• Used TOAD for faster application design and developments
• Implemented Hot, Cold and Logical backup plans using RMAN and Data pump tool.
• Creating tables, indexes, views and synonyms depending upon the need.
• Involved in Designing backup and recovery strategy for OLTP systems.
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
• Modified spfile parameters like DB block size, block buffers, shared pool
• Used netmgr and netca for the database communication.
• Involved in Query tuning of SQL Queries

Confidential

Jr. Oracle DBA

Responsibilities:  

• Installed, maintained new oracle 9i and 8i instances. Upgraded several Oracle 9i instances from 8i . Connectivity with different client programs using ODBC. 
• Maintained backups for recovery using RMAN in tapes and disks. 
• Planning and implementing Backup strategy for the databases using RMAN , Scripting backups, once in two weeks on the application database. 
• Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances. 
• Migration from SQL Backtrack to RMAN as backup utility. 
• Periodically fine-tuned and optimized the database performance for data integrity and maintained the databases for the day-to-day DBA activities. 
• Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust. 
• Modified and maintained database structures and views for the core system. 
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file structures. 
• Setting up client/server Architecture and distributed processing. 
• Reduced DBA off-hours support needs by 60% through planning and proactive monitoring. 
• Implemented automated backup strategy using the UNIX shell script and CRON Utility. 
• Wrote Shell scripts to automate DBA tasks such as monitoring tablespaces, health on daily basis. 
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i. 
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements. 
• Creating users and database links, snap shots on production and development servers. 
• Designed database tables as per technical specifications. 
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.