SUMMARY

• A seasoned techno - functional Oracle Database Administrator looking forward to be a part of an organization which values for teamwork, initiatives and work ethics.
• Motivated and skilled Oracle Database Administrator (Architecture, Configuration, Security Management, Storage Management, Performance Troubleshooting, Backup & Recovery).
• Proficiency in Oracle Database (9i, 10g, 11g & 12c) Administration on RHEL4/6, SUN Solaris, AIX, SUSE and Windows Platforms and performing DBA duties like Installation, Cloning, Patching and Migration/Upgradation.
• Backup and Recovery of Oracle Databases using RMAN utility and Logical Backups using traditional Export/Import and Data Pump.
• Recovering Oracle Database to a previous point-in-time or SCN using RMAN.
• Creation and maintenance of Oracle Data Guard.
• A Good Knowledge on Real Application Cluster (RAC) and ASM (Automatic Storage Management) for RAC and Standalone databases.
• Analyzing STATSPACK, AWR, ADDM and Explain Plan Reports for performance tuning.
• Extensive use of Oracle Enterprise Manager Cloud Control 12c for database monitoring and tuning efforts.
• Recover tables using Flashback recovery techniques.
• Managing Data files, Control files, Online Redo Log files, Temp tablespace and Undo tablespace.
• Administration of Tables, Indexes, Extent and User management.
• Configuring LISTNER and TNSNAMES in network applications.
• Monitoring of File system, Tablespaces (datafiles) usage.
• Archival Space Monitoring and regulating Archival growth.
• Sound knowledge on SQL query and PL/SQL programs.
• Creating and managing DBLINKs and Materialized views.
• Proficiency in Oracle’s Edition Based Redefinition (EBR) feature and its usage while making both DDL and DML changes to the database schemas in multiple editions so as to minimize the downtime required for business critical (24*7) applications during the monthly releases.
• Expertise in Oracle 11g/12c RAC/ASM, Performance tuning/troubleshooting skills and experience with AWS Cloud database, PostgreSQL, Microsoft SQL Server, Data-replication tools - Shareplex & Golden Gate.

TECHNICAL SKILLS

Operating Systems: Linux (RHEL & SUSE), Sun OS, AIX

Languages & Scripting: SQL, PL/SQL, UNIX shell scripting

Databases (/RDBMS): Oracle 9i, 10g, 11g & 12c, Microsoft SQL Server, PostgreSQL

Cloud platform: Amazon Web Services (AWS)

Change Request Management: BMC Remedy, ManageNow, ServiceNow

Tools: and Utilities: Toad, Putty, PL/SQL Developer, Win SCP, OEM, Database Utilities (SQL Loader, RMAN, Data Pump etc.)

Data Replication: Oracle Data Guard, Oracle Golden Gate, Shareplex

Database Monitoring: Oracle Enterprise Manager Cloud Control 12c, APEX, AWS Console and New Relic INSIGHTS For AWS Cloud Databases

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Sr. Oracle Database Administrator

Responsibilities:

• Sr. Oracle database engineer with hands-on experience in administering and maintaining databases running on RDS and EC2 instances hosted on AWS Cloud platform.
• Experience in migrating Oracle databases from on-prem environments (Linux/Solaris) onto AWS cloud platform (RDS instance class:12x/48 vCPU/20k IOPS).
• Monitoring on-prem databases using APEX and OEM, cloud databases using AWS console and NewRelic INSIGHTS tool.
• Responsible for performance tuning requirements for the applications in my portfolio from the database stand-point and help resolve them and recommend the fixes in the best possible way using tools like Statspack, AWR, ADDM, ASH, Explain Plan, Oradebug, tkprof, Oracle Advisories and so on.
• Giving required Index recommendations, creating SQL profile to avoid SQL plan fluctuations for long running and resource intensive application/business critical SQL’s/queries to help improve the performance and reduce the execution time, CPU usage and I/O usage of the databases.
• Working with Data Modelers and Database Developers to deploy the database schema changes in QA and Pre-Prod environments and finally presiding the application releases for production deployment.
• Expertise in data replication across multiple Data Centers using Shareplex and Golden Gate.
• Managing standby databases running with Oracle Data Guard configuration.
• Using Oracle utilities like Data Pump for schema/table refresh activities from Prod to Dev upon app team request, RMAN to manage database backups/archives and so on.

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Responsibilities:

• To monitor database metrics, viz. Tablespace Usage, ASM Usage, Archival Usage, Database & Instance connectivity check, sessions & process counts and so on.
• AWR, ASH and ADDM report analysis for reported application job slowness and identifying the RCA and scope for performance improvements and thereby recommending parameter changes.
• Working on Standby database lag alerts, troubleshooting the issue and resolving the gaps and bringing both Primary and Standby copies in sync with each other.
• To carry out database upgrades from Oracle 12c Release 1(12.1.0.2) to Oracle 12c Release 2 (12.2.0.1)and to provide shadow support until all database/application functionalities are tested and validated to be successful and BAU.
• Installing Oracle PSU patches in Production and Development database environments as and when the request comes to assist other focal DBA’s.
• Working on Golden Gate alerts/incidents and taking first level action to resolve any golden gate process lag, process ABEND or parameter compatibility issues.
• Working on database failover/switchover requests as part of routine changes to ensure databases are in good shape and the switchover is happening smoothly without any deviation from the playbook.
• Working on ORA errors traced in the database alertlogs, finding the SQL causing it, investigating the problem with the argument data from the error message (trace file) to match up against the known bug and recommending/applying fixes/patches to resolve them.
• To design Oracle database backup and recovery strategies for different databases as per availability requirements from business standpoint. Also to work on different database backup & recovery scenarios using RMAN and Flashback utilities.
• Giving required Index recommendations, creating SQL profile to avoid SQL plan fluctuations for long running and resource intensive application/business critical SQL’s/queries to help improve the performance and reduce the execution time, CPU usage and I/O usage of the databases.
• To work on database backup and archive backup failures and investigating the cause and taking manual action as necessary to comply with the backup policy.
• To work on FRA usage monitoring, backup file system alerts, archiver hung alerts and changing the archive schedule as per requirement, space allocation and clearing the FRA location by deleting obsolete/old backups/archive logs to make room for new ones to keep the databases in good shape from connectivity standpoint.

Confidential, Minneapolis, MN

Sr. Oracle Database Administrator

Responsibilities:

• To comply with the PCI Audit requirements, migration of databases (v. Oracle 11g) hosted on the old servers running on either SUSE Linux or RHEL 4 to the new servers (some of them running on Virtual Machine boxes for less critical databases with very minimal activities) running on RHEL 6 platform with Oracle version 12c (12.1.0.2.0 ).
• To test the Migration and Upgrade approach on the lab server using the database backups and document the steps involved before the actual migration that includes OS install, user/group setup, ASM install and ASM disk creation, 12c GRID and database software installations with the latest PSU patch applied.
• Working with Data Modelers and Database Developers to deploy the database schema changes in QA, External (Functional/Regression test env.), Q1 (Load test env.) and finally into the Production environment during the monthly releases using Oracle’s Edition Based Redefinition (EBR) approach.
• Creating database editions, changing the database services to point to the correct editions with every release.
• Responsible for any production issues or performance issues for the application in my support bucket thereby analyzing and recommending fix for the issue in an attempt to improve the performance of the query/database from execution time, CPU usage and I/O usage perspective.
• Recommending indexes (mostly composite indexes) and deciding the column orders for the resource intensive queries with high no. of executions as and when a query is identified/alerted as the top query from either the execution time stand-point and/or resource usage stand-point.
• Creating SQL profiles for the reported queries with plan fluctuations picking the bad execution plans, to fix them to use the best available plan with the optimizer with every execution.
• To work with Oracle Support in case of a database incident requiring a one-off patch to be applied or database parameter/memory/OS parameter changes to be made to resolve the cause.

Confidential

Oracle Database Administrator

Responsibilities:

• Working as the Primary Development DBA for a set of applications/databases and carry out all database changes in the lower environments before the changes are deployed in the production environment.
• Experience on Installation and Configuration of Oracle 11gR2 databases with RAC setup (3 Node cluster) running on Red Hat Linux version 4 boxes with ASM storage.
• Review and Application of Oracle security (CPU and PSU) patches and bug fix patches.
• Implementing Database Backup strategies using RMAN and performing Database recovery.
• Implementing high availability solutions (DR) for business critical DBs using Oracle Data Guard and performing switchover scenarios with multiple standby locations.
• Performing database reorganization to assist performance and reclaim disk space.
• Creation of different database objects viz. tables, indexes, constraints, synonyms, views, packages, procedures, functions etc. as per application requirements.
• Monitoring tablespace usage, growth analysis and adding/resizing datafiles depending on the growth rate so as to avoid any application load Job failure due to insufficient space.
• Checking Alertlogs, ASM logs, contents of /var/log/messages when there is an incident generated due to any specific errors encountered in any of the above log locations.
• Working on ORA errors, finding the SQL causing the error, analyzing the cause and recommending/applying fixes to resolve them.
• Generating AWR, ADDM, ASH and Explain plan reports for incident durations and comparing it with the good run timelines to find out RCA of any application job slowness or if there is a need to change/increase any database parameters.
• Using Data Pump to export/import schemas/tables from one database (usually production) to another (usually development).
• Session tracing (ORADEBUG 10046/10053 ), formatting the trace file using tkprof and analyzing the trace file to find out RCA of an issue.
• Tracing long running application sessions with hanganalyze and systemstate and to upload the dumpfiles in SR for the Oracle Vendor(Support) to analyze.
• Setting up Resource Manager to limit the run duration, CPU and I/O usage of database sessions.

Confidential

Oracle Database Administrator

Responsibilities:

• Responsible for both manage and support all Production, Development and Test Databases.
• Frequent monitoring (every 4 hour) of tablespace Usage, ASM Usage, Archival Usage, Database & Instance connectivity check, sessions & process counts and so on.
• Checking Database Backup Report on Daily basis, checking error logs to know the reason of failure (if any) and trigger manual backup for failed backups.
• Applying database security patches (CPU & PSU) and Upgrading databases depending on application requirement & client’s database security policies.
• Monitoring the Log Shipping of physical standby databases configured via Oracle Data Guard and apply the archive gaps (if any).
• Installation/Upgradation of databases from Oracle 10g (10.2.0.4.0 ) to 11g (11.1.0.6.0).
• Maintaining partitioned tables/indexes and adding future partitions (Daily/Weekly/Monthly) beforehand.
• Checking the contents of database alertlogs when there is an incident generated due to any specific errors encountered in the alert log of the databases.
• Monitoring tablespace usage, growth analysis and adding/resizing datafiles depending on the growth rate so as to avoid any application load Job failure due to insufficient space.
• Generating AWR, ADDM, ASH and Explain plan reports for incident durations and comparing it with the good run timelines to find out RCA of any application job slowness or if there is a need to change/increase any database parameters.
• Working on application requests like password reset, account unlock, profile change, providing Explain Plan of the application queries.
• Working on ORA errors traced in the database alertlogs, finding the SQL causing it, investigating the problem with the argument data from the error message (trace file) to match up against the known bug and recommending/applying fixes/patches to resolve them.
• Manual Cloning of databases from the latest backup for test and development purposes.
• Analysis, design, coding and testing for the major enhancements with impact analysis.
• Root cause analysis (RCA) for the logged problems.
• Tracking the status of incidents being worked upon and meeting the SLA.