SUMMARY:

• 9+ years of professional experience as an Oracle DBA. Worked extensively on Oracle 12c, 11g, 10g and 9i versions involving database administration, Installation, Configuration, Backup and Recovery, Migration, Upgrades, Patches, Cloning, Replication, Database Security, Memory Management, RAC, Data Guard, Performance Monitoring and Tuning, Grid Control, Oracle Streams, Golden Gate, Data Modeling, Exadata.
• Expertise experience in installation, administration and configuration of Oracle 12c, 11g, 10g, 9i on OEL, RHEL, SUN SOLARIS, IBM - AIX, WINDOWS, HP-UX in OLAP and OLTP environment.
• Experience in taking the logical backups of data using oracle DATAPUMP utilities EXPDP and IMPDP.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
• Utilize Oracle Automatic Storage Management (ASM), Oracle Managed Files (OMF) and Recovery Manager (RMAN) to improve I/O performance, reduce administration overhead and provide a comprehensive backup and recovery strategy.
• Upgrading databases by Applying patch set and interim patches whenever required to make the database software up to date.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES.
• Implementing and maintaining Oracle Identity and Access Management to maintain and provide user access, roles and privileges across Enterprise data environments.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Installation and configuration of Oracle Server 12c, 11g RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases (VLDB) to ensure High availability .
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Implementation of High Availability Solutions using Oracle 11g RAC, 10g RAC, Physical and logical Standby database (Data Guard).
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM, and ASH.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Building, Monitoring and Supporting Oracle databases on AWS Cloud Storage platforms.
• Developed custom utilities to automate manually intensive tasks including mass schema changes, recovering golden-gate corruptions and managing host/cluster maintenance mode blackouts.
• Installing, Configuring and maintaining Oracle Golden-gate replication software across heterogeneous, homogeneous environments and implementing one-directional and bi-directional replication.
• Worked on Various Data modeling tools to extract, transfer and load data across different environments for Master Data Management.
• Proficient in writing PL/SQL procedures, Triggers, Functions, Packages and Cursors and Exceptional handling.
• Excellent experience in project management methodologies Including Agile methodology.
• 24*7 on-call production database support and maintenance including remote database support.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i, Oracle EBS R12, SQL Server 2012/2016.

Operating Systems: Red Hat Linux, Sun Solaris, HP-UX, IBM-AIX, Windows, UNIX.

Languages: C, C++, SQL, PL/SQL, Unix Shell scripting, Perl.

Tools & Utilities: Oracle Grid, Oracle Fail safe, Oracle Audit Vault, OEM,TOAD, Putty, Erwin, SQL loader, ER Studio, Data-pump, Golden gate, Data Guard, VMware, Transparent Data Encryption (TDE), Fog light, Informatica, Tripwire, EMC, Netapp, SAN, RMAN, Security, Exadata, Oracle Streams, OID, OVD.

Protocols: HTTP, TCP/IP, FTP, SFTP, SSH, TELNET

PROFESSIONAL EXPERIENCE:

Confidential - Charlotte, NC

Database Administrator

Responsibilities:

• Involved in configuration and implementation of hardware and software installations for oracle 12c, 11g on different versions of Red Hat Linux.
• Engineering, implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC).
• Running compliance runs on hosts to find out the errors and work with the respective Line of Business DBAs to correct them and make the environment Version compliant.
• Planning and implementing the migrations of RHEL5 Linux servers to RHEL6 Linux servers by coordinating with respective application and LOB Teams.
• Working on Issues related on ASM, CRS, Performance and several cluster level issues.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Involved in Tuning the RAC interconnect Finding RAC wait events and tuning the Databases using the Enterprise Manager Grid Control 11g/12c.
• OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM & monitoring the databases using OEM 12c.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Up gradation and Migration of Grid Infrastructure and Oracle Databases from 11g to 12c on RAC and Exadata environments.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.
• Performance Tuning the Oracle Server for better Memory, I/O and Operating System Performance using Oracle Enterprise Manager (OEM) .
• Correcting problems caused by logical data corruptions or user errors through Flashback.
• Supporting Multi-tenant pluggable databases on 8-node super cluster Exadata environments.
• Implemented transparent data Encryption (TDE) and supported OID on Production databases.
• Installing, configuring, upgrading, patching of golden gate replication software to ensure data flow across various hosts with respect to application requirements.
• Implementing and maintaining Oracle Identity and Access Management to maintain and provide user access, roles and privileges across Enterprise data environments.
• Supported Security User Management, Privileges, Roles, Audit Vault, Profiling, Authentication.
• Involved in supporting the Oracle spatial schemas for applications loaded with high integrity spatial data.
• Performance Tuning for the SQL queries which are running slow and taking more CPU cost & Creating and managing the database objects such as tables, indexes and views.
• Involvement in day to day activities like Space management, rectification of Lock problems, managed quotas, Table partitioning to improve I/O access.
• 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.

Environment: Oracle 12c/11g/10g, RHEL 6.X/5.X, ASM, OEM 12C (Grid Control), RMAN, ADDM, ASH, Data pumps, Exports/Imports, Data guard, OID, OVD, Golden gate, Exadata.

Confidential - Plano, TX

Oracle DBA

Responsibilities:

• High Level Evaluation and Performance Tuning, Load Balance and Failover, RMAN, Dataguard DR Plan with Dataguard and different DB Performance Tuning with latest 11g/10g Grid Tools and Technologies for Production Full Life Cycle support.
• Configured Physical Standby for Production databases and converted Physical standby to Snap shot Standby and ACTIVE data-guard.
• Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS, AIX and HP-UX.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance & troubleshooting issues in RAC environment (11GR2).
• Configured disaster recovery databases using Data guard and perform switchover & failover & monitor using Data Guard manager command line.
• Applying Quarterly patches and CPU, PSU, One-Off Patches to update Oracle version and to fix the bugs using Opatch utility.
• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.3 to 11.2.0.4 on 3 node RAC environment.
• Migrating databases from 11g to 12c using export/import and data pump export/import utilities.
• Involved in Developing, Installation and configuration of Oracle Fail safe on windows operating system for Development and QA Environments.
• Supported and administered other database platforms like Microsoft SQL server and applications such as Oracle EBS R12.
• Building, Monitoring and Supporting Oracle databases on AWS Cloud Storage platforms.
• Utilize a variety of tools including EMC Time Finder, RMAN, Data Guard, Unix shell scripts and In depth for Oracle to backup, duplicate, refresh and tune databases across multiple servers
• Implementation and administration of Oracle Audit Vault, data encryption for sensitive data.
• Implementing and maintaining Oracle Identity and Access Management to maintain and provide user access, roles and privileges across Enterprise data environments.
• Implemented performance parameters in replicate process and also involved in Splitting replicates which improved performance of Golden Gate environment.
• Configuring Extract and Replicate pumps for Golden gate replication and troubleshooting issues in Golden gate Environment to prevent lags in data flow.
• Worked on Installing and Configuring Oracle WebLogic Middleware Instances across different operating systems and clustered environments to provide High availability and Fail Over.
• Implementing Data guard, created physical standby databases in 10g and 11g RAC environment for production database.
• Performing database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Performing Application Tuning by tuning queries, identifying problematic code, creation indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects.

Environment: Oracle 12c/11g/10g, SQL Server, Oracle EBS R12,RHEL, ASM, OEM, RAC, OID, RMAN and Data Guard, Explain Plan, SQL Developer, Toad, PL/SQL Tuning, Audit Vault, Data Pump, putty, Golden gate, SQL Loader.

Confidential - Chevy Chase, MD

Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.
• Installed DR for 8 databases using Data Guard for Single instance and also in RAC Environment and trouble shoot issues in Data Guard environment.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Migration of databases from 10g to 11g using export/import and Data pump export/import utilities.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Configured and Implemented Cold/Hot Backups, Incremental and cumulative backups.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Implement Golden gate replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments
• Done initial load test by configuring new tables in Golden gate for replication.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance & troubleshooting issues in RAC environment (11gr2).
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL TRACE and TKPROF.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Supported and administered other database platforms like Microsoft SQL server and applications such as Oracle EBS R12.
• Responsible for capacity planning, recovery planning and installing patches.

Environment: Linux, Oracle 11g/10g, SQL Server, Oracle EBS R12, ASM, Data Guard, Oracle Grid Control, OID, TOAD, RMAN, Oracle Enterprise Manager, Golden gate, RAC, Data pumps.

Confidential

Database Analyst

Responsibilities:

• Installed and Configured Oracle 10g, 11g databases on Linux and also Upgraded Oracle databases from 10g to 11gr2 version by applying Patches.
• Applying patches quarterly ( PSU, CPU, ONE-OFF) for security and to fix the bugs.
• Implemented Oracle Database 11gR2 Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Oracle Grid Control 11g Installation and Configuration and Configured Oracle Data guard for Oracle Disaster recovery.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases and performing Point in time recovery using RMAN.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic
• Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.