SUMMARY

• Integrally involved into Relational Database Management Systems wif 9 years of seamless experience as an Oracle Database Administrator wif 24/7 production support in mission critical database environments wif oracle 10g,11g,12c, Data Guard, Golden Gate, Database Security, Development, Analysis, Design, Migrations, Capacity Planning, Data Modeling, Space Management, Auditing, RMAN Backup And Recovery, Disaster Recovery, Production Support, Cloning, Installation, Configuration, Upgrades And Patching, Performance Tuning, Query Tuning, SQL, PL/SQL, Troubleshooting, Documentation And Exadata X4, X5, X6.
• Hands on experience on various platforms like RHEL Linux 4, 5, 6, 7, IBM AIX, Solaris, Ubuntu and Windows environments.
• Experience on different variants of Oracle databases such as 9i, 10g, 11g, and 12c.
• Excellent experience in trouble shooting and fixing performance issues at session and system level using various reports like Explain plan, TKPROF, AWR and ADDM reports.
• Excellent experience in improving database performance by SQL tunings, SQL profiles and Baselines.
• Experienced in configuring and Installation of multiple node 11g and 12c RealApplicationClusters (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 Cloud Control (OEM 12c and 13c), Toad, Oracle SQL Developer.
• Experience in implementing cross platform Migration such as IBM AIX, Solaris and Windows to Linux.
• Good experience on Upgrades and Patches in various stand alone and RAC environments.
• Excellent noledge in Hot/Cold Backup and Recovery and Cloning of databases using Recovery Manager (RMAN).
• Excellent experience in installing and supporting oracle 12C multitenant databases and converted several regular 12c databases to Multitenant.
• Good working noledge in implementing EXADATA features like HCC, Flash cache and SMART SCAN features.
• Provided and implemented performance tuning recommendations of all components in teh Exadata machines.
• Supported in analysis and designing of OracleExadataServer for infrastructure and related projects, Integration ofExadatamonitoring into our existing IT monitoring framework.
• Implemented Standby Databases wif teh help of DataGuard for High Availability, Data Protection, and Disaster Recovery for enterprise data.
• Experience on Fast Start Failover(FSFO) implementation of Data Guard as per teh end user requirement.
• Configured Data Guard for more tan 50+ databases wif Data Guard Broker and FSFO
• Pioneer in Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Experience in replication of schemas using GoldenGate schema replication which includes online change synchronization and DDL synchronization.
• Golden Gate 11g and 12c installations and maintenance of unidirectional replication.
• Excellent experience in fixing lag and other issues related to Golden Gate replication.
• 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 wif Oracle enterprise manager (OEM), and utilities like AWR, ADDM, Flashback Technology, SQL tuning advisor.
• Expertise in configuration and maintenance of table partitions in oracle 11g and 12c.
• Performance Tuning experience in identified poor SQL statements using EXPLAINPLAN, STATSPACK, TKPROF, SQLTRACE.
• 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.
• Implemented transparent data Encryption (TDE). Used TDE wif Encrypted columns and Data Pump.
• Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good communication and coordination wif different departments for efficient problem escalation and deciding on optimal solution.
• Experience on performance optimization in private cloud models (IaaS/PaaS) wif enterprise standards, workflows and industry best practices using VMware products.
• Rendered performance tuning to VMware servers, Virtual sessions and management of server resources between virtual machines.
• StrongMySQLskills wif significant general system administration skills on UNIX/IBM AIX, Linux and Windows environment, Knowledge in general System Administration tasks.
• 24*7 production database support to developers & end-users.

TECHNICAL SKILLS

Operating Systems: RedHat Enterprise Linux, Sun Solaris, IBM AIX, Microsoft Windows Server, Oracle Enterprise Linux.

RDBMS: Oracle 12c, 11g, 10g, 9i and 8i, MySQL 5.1, 5.6, 5.7

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

Tools: and Utilities: RMAN, SQL Navigator, SQL*Loader, SQL Developer, ASMCMD, DataGuard Manager Utility(DGMGRL), Server Control Utility (SRVCTL), Traditional Data pump, EXPDP/IMPDP DataPump, Data Guard, VERITAS Net Backup, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Splunk, Putty, Oracle Data Integrator(ODI), and Oracle SQL Developer.

Languages: SQL, PL/SQL, Perl, Bash, Csh Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential, Collierville, TN

Sr. Database Advisor

Responsibilities:

• Involved in 24x7 on-call support for enterprise production databases.
• Installation and Configuration of 4 node RAC using oracle clusterware and ASM storage, Configured ACFS file system and administeredASM Instances and Disk Groups in RAC.
• Resolved several RAC related outages caused due to node evictions and resolved many performance issues in Oracle12c RAC databases.
• Provided support and recommendations for components in Exadata X6 machines and Implement performance tuning for all components in theExadatamachines.
• Actively participated in analysis and designing of OracleExadataServer for infrastructure and related projects. Monitored IT framework on machines integrated wif Exadata.
• Experience in cloning of databases using RMAN.
• Migrated over 200+ databases across data centers using various methodologies like DATAPUMP, Log shipping and RMAN XTTS.
• Configured RMAN backups (Full, incremental and cumulative) and performed recovery, incomplete recovery and disaster recovery.
• Install, configure and upgrade databases to Oracle12c, consolidate multiple databases into multi-tenant database containers, evaluate and implement latest database technology and new Oracle12c features.
• Installed Oracle 12c (cloud) and migrated all teh databases from Oracle11g to Oracle 12c.
• Performed RAC all nodepatching and Rollingpatching.
• Implemented Backup, Recovery procedures and Hot, Cold and Logical backup plans.
• Installed and upgraded Golden Gate to version 12c.
• Installed and managed GoldenGate using veridata.
• Successfully implemented Unidirectional Golden Gate replication for Oracle 12c databases on 2 node RAC Clusters.
• Implemented Oracle TimesTen(In memory Database) for Personalization and Recommendation project.
• Identified and fixed Golden Gate Replication issues using GGSEVT and log dump utilities.
• Performed database migrations from AIX Solaris to Linux using Oracle Golden gate and data guard
• Installation and configuration of Golden gate for replication and resolved issues to sync Databases.
• Implemented Golden Gate replication during database migration from AIX to Linux server.
• Installed, configured and supported Goldengate (11g)replication solutions to facilitate data flow between environments.
• Developed custom utilities to automate manually intensive tasks including mass schema changes, recovering GoldenGate corruptions.
• Implemented, configured and maintained dataguard for oracle 11g(primary and standby databases) to ensure disaster recovery, high availability and data protection
• Extensively worked in various areas of dataguard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Installed OEM 13C and configured agents on all our monitored database servers.
• Configured and setup of monitoring alerts and BI publisher reports in OEM 12c and 13C.
• Implemented teh resizing of online redo logs in production and standby databases
• Worked on AutomaticStorageManagement (ASM) wif EMC Storage for managing data in SAN.
• Expertise in teh creation of databases, tablespaces, tables, indexes and other database objects.
• Installed and configured relevant network components to ensure database access as well as database consistency and integrity.
• Experience in troubleshooting and resolving various Oracleconnectivity problems.
• Extensively used DATAPUMP and Export /Import utilities for logical backups.
• Implemented transparent data Encryption (TDE). Used TDE wif Encrypted columns and Data Pump.
• Performed various performance goal oriented database tuning using Explainplan, AWR, ADDM and variousOracle Advisors to tune teh database.
• Tuned various slow running queries to improve performance and decrease data fragmentation.
• Performed instance tuning, memory tuning query tuning and complete database tuning.
• Created and implemented various table partitions for large tables.
• Applied quarterly PSUpatches to different versions of databases.
• UpgradedOracle 10g database to 11g and 11g to 12c,Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set.

Environment: Oracle 12.2.0.1, 12.1.0.2, 11.2.0.4, Oracle Exadata, IBM AIX 6.3,7.1, Red Hat Linux 6.0, PL/SQL, SQL*PLUS, ORACLE ENTERPRISE MANAGER 12c/13c Cloud Control, Oracle 11g Grid Control, Oracle RAC, Data Guard, Toad 12/12.5, Server control utility(SRVCTL), ASM Command line (ASMCMD), DataGuard Manager Utility(DGMGRL), MySQL 5.5, 5.6.

Confidential, Dallas, TX

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 Real Application Clusters (RAC) environment wif 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
• Experience in performance tuning recommendations of all components in theExadatamachines and participated in analysis and designing of OracleExadataServer for infrastructure and related projects.
• Integration ofExadatamonitoring into our existing IT monitoring framework.
• Extensive noledge on Performance Tuning, Memory (SGA) Tuning, Net backup, RAW Devices.
• Increased availability of development instances wif reducing cloning time by implementing clone automation using Grid Control.
• Applying patch set and interim patches using OPATCH for upgrading teh binaries.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Installed Oracle 12c Enterprise Manager(Cloud Control) for diagnosing and monitoring performance related problems and configured wif Application servers on databases.
• Daily tasks include 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 which is controlled from Crontab for automation of job Scripts to Startup, Shutdown and Health Check of Databases.
• Used TOAD tool to access teh database and PL/SQL developer to create PL/SQL Procedures.
• Performed Daily Health Check Up of teh Database using STATSPACK, AWR, ASH, ADDM, TKPROFand EXPLAINPLAN.
• Configured, administered and monitored Streams to apply changes in multiple databases using tool Oracle Enterprise Manager (OEM) (Grid and Cloud Control) console and performed performance tuning activity.
• Test initial Data Load option of GoldenGate during environment build and migrated database from ASM to Non-ASM using RMAN.
• ConfiguredGoldenGatereplication between Production and Prime Production, Performance and Prime Performance environments.
• Assisted in integration ofExadataapplications 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 teh OEM 11g grid control like Scheduling Backups, Performance Monitoring, alerts setting, generating reports.
• Used DataGuard to configuration, Maintenance and support for Disaster Recovery activities.
• Duplicated all teh non-production databases onExadataserver according teh Data Warehouse development as per project's requirement, to help compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques
• Troubleshooting Datapump errors in a RAC environment, configuring storage accordingly.
• Cloning teh databases for development and testing purposes and experience in taking daily/weekly backups using RMAN.
• Implemented ASM on RAC and stand-alone databases Managing disks and disk groups wif ASM andconfigured error handling for restart, logging, production support and status reporting in Goldengate.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• ImplementedDataGuard (Standby) forhigh availability/disaster recovery purpose.
• Configured database entries and Monitoring of all teh 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.

Environment: Oracle 12.1.0.2, 11.2.0.4, 10.2.0.5, Oracle Exadata, IBM AIX 6.3, Red Hat Linux 6.5, PL/SQL, SQL*PLUS, ORACLE ENTERPRISE MANAGER 12c Cloud Control, Oracle 11g,10g Grid Control, Oracle RAC, Data Guard, Server control utility(SRVCTL), ASM Command line (ASMCMD), DataGuard Manager Utility(DGMGRL), MySQL 5.5, AWR, ADDM, Recovery Manager(RMAN), Service Now.

Confidential

Sr. Oracle Database Admin

Responsibilities:

• Installed, maintained new Oracle9i and8i instances. Upgraded several Oracle10g instances from Oracle9i,Connectivity wif different client programs using ODBC.
• Maintained backups for recovery using RMAN in tapes and disks.
• Planning and implementing Backup strategy for teh databases using RMAN, Scripting backups, once in two weeks on teh 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 teh database performance for data integrity and maintained teh databases for teh day-to-day DBA activities.
• Redesigned teh database backup/recovery scripts to log errors, and to be consistent/ robust.
• Modified and maintained database structures and views for teh core system.
• Performed work related to importing and exporting data using IMP and EXP tools inOracle, file structures.
• Setting up client/server Architecture and distributed processing.
• Reduced DBAoff-hours support needs by 60% through planning and proactive monitoring.
• Implemented automated backup strategy using teh UNIXshell 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 wifOracle Reports 9i.
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Creating users and database links, snapshots 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.

Environment: Oracle 9.2.0.8, 9.2.0.1, 8.1.7.4, Red Hat Linux 4/5, PL/SQL, SQL*PLUS, SQL* loader, Data Guard, Server control utility(SRVCTL), DataGuard Manager Utility(DGMGRL),Toad, AWR, ADDM, Recovery Manager(RMAN).

Confidential

Sr. Oracle Database Engineer

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 (DBUA).
• Loading data from flat files into database tables using SQL* loader.
• Creating and maintaining triggers, packages, functions and procedures.
• Created users and established teh application security by creating roles.
• Used Indexes and Hints to enhance teh performance wif teh help of Explainplan.
• 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 Datapump tool.
• Creating tables, indexes, views and synonyms depending upon teh 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 teh creation of Listeners.
• Involved in Query tuning of SQL Queries.

Environment: Oracle 9.2.0.8, 10.2.0.1, Red Hat Linux 5/5.5, PL/SQL, SQL*PLUS, SQL* loader, ORACLE ENTERPRISE MANAGER 10g Grid Control, Data Guard, Toad, AWR, ADDM, Recovery Manager(RMAN).