SUMMARY:

• Accomplished Oracle DBA with expertise in Oracle Database Administration, High Availability to increase reliability and maximize productivity, Performance Tuning and Automation
• Over 11+ years of professional experience in Oracle Database Administration
• 1.5 years of experience working in AWS environment
• 1.5 years of experience working in MongoDB Administration
• Worked in 24/7 production environment and provided on - call and day-to-day support
• Experience in installation, configuration and managing Oracle’s Real Application Cluster, Data Guard, Automatic Storage Management and Golden Gate
• Provisioning Oracle Database in AWS EC2 & RDS instance, Configure Multi-AZ Deployment, Setup User/Role/Tablespace and Performance tuning
• Installation and configuration of MongoDB, Replication & Sharded Cluster
• Implemented backup strategy for MongoDB and support DBA activities like Backup/Restoration, Query construction, Log rotations, Export/Import, User management, CRUD operations, Optimizing database/query performance and Add/Remove nodes
• Experience in migrating On-premise database to AWS RDS instance
• Experience in various flavors of UNIX/Linux like HP-Unix, IBM - AIX, Oracle Enterprise Linux & RedHat Linux
• Created Disaster Recovery environment (Physical Standby) for company’s critical and essential Databases
• Participated in Data Center Migration waves and supported migration activities
• Worked on Upgrade projects with multiple DB versions and the latest upgrade performed from Oracle 11g to 12c
• Experience in Upgrade, Patching and managing Oracle Exadata machine
• Experience in migrating databases from classic server to Exadata machine
• Database refresh using RMAN duplication and Datapump backups
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, Explain Plan, SQL Monitoring, SQL Tuning Advisor, SQL Access Advisor and SQLT
• Experience in developing Automation scripts using Shell script

TECHNICAL SKILLS:

Database: Oracle9i, 10g, 11g, 12c standalone and RAC with ASM, MongoDB

Operating System: Red hat Linux, Oracle Enterprise Linux, IBM-AIX, HP-UX

Tools: Toad, SQL*PLUS, SQL Developer, Putty, VNC server, Erwin, Ops Manager

Languages/Script: PL/SQL, SQL, Shell Scripting, JSON, Node.js

Application: Oracle Enterprise Manager, Oracle Internet Directory, Oracle Identity/Access Management

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Oracle DBA

Responsibilities:

• Provisioning Database (Real Application Cluster or Standalone), Roles, Schemas, Tablespaces and Performance parameters based on Application requirement
• Installation and configuration of MongoDB, Replication and Sharded Cluster
• Implemented backup strategy for MongoDB and support DBA activities like Backup/Restoration, Query construction, Log rotations, Export/Import, User management, CRUD operations, Optimizing database/query performance and Add/Remove nodes
• Perform Refresh/Cloning of database from production to lower environments
• Coordinate with Application team in planning, testing and execution of Application releases
• Perform Database upgrade and patching activities
• Troubleshoot database related issues and perform root cause analysis
• AWR, ADDM and Query/SQL analysis and performance analysis
• Configure and maintain Physical standby database for critical production databases
• Coordinate with Application team to configure Flyway tool to automate deployment process and troubleshoot in-case of any issues
• Coordinate with Informatica/Application team to configure Informatica PowerCenter Change Data Capture for Oracle databases
• Provide On-call support on rotational basis

Confidential, Henrico, VA

Responsibilities:

• Provisioning RDS instance - Gather Application requirement, Choose appropriate RDS instance type, Configure performance related parameters, Setup S3 bucket, Configure Multi-AZ deployment, Assign Security groups and Setup User/Role/Tablespace
• Migrate On-premise database to AWS RDS instance using Datapump and Database Migration service
• Installation and configuration of Oracle Database on AWS EC2 instance
• Implemented backup strategy for MongoDB and support DBA activities like Backup/Restoration, Query construction, Log rotations, Export/Import, User management, CRUD operations, Optimizing database/query performance and Add/Remove nodes
• Data Center Migration Project - Initial data gathering, Deep dive analysis, Prepare migration method, Automate migration tasks and participate in migration waves
• Migration method used for Data Center migration are Datapump, EMC SRDF/OR replication, Golden Gate Replication, Dataguard switchover and RMAN backup/restore
• Migrate Oracle10g database from HP-UX to AIX (Cross Platform) using RMAN utility and Oracle Golden Gate tool as part of Data Center Migration
• Migrate highly complicated Oracle Golden Gate DB’s configured with Bi-Directional replication to new Data Center as part of Data Center Migration
• Defining and setting backup and recovery procedures
• Application Tuning - Identify the SQL’s causing I/O bottlenecks, SQL’s of high cost and give recommendations to the team accordingly
• Implemented Materialized views as per Application requirements
• Perform new build validations for Standalone, RAC and Dataguard database and also automated the task using Shell script
• Attend LOB, Standup and Work status meetings related to Datacenter Migration
• Create change normal/Urgent/Emergency based on the request using HPSM

Confidential

Responsibilities:

• Implemented physical standby database for High Availability solutions using manual process and also using Oracle Enterprise Manager
• Configured physical standby database with Maximum Availability/Maximum Performance mode for production DB’s
• Maintain and Administer up to 8 nodes RAC cluster
• Installation, Configuration and Administration of Oracle10g/11g RAC, ASM and Dataguard
• Oracle Exadata Patching & Upgrade on Full/Half node RAC clusters
• Implement and administer ACFS & DBFS filesystem on database servers for storing non-database files
• Perform addition/removal of node from existing Oracle10g & 11g cluster
• ASM storage migration from DMX to VMX
• Implement RAC one node DB for non-critical applications
• Application tuning by tuning queries, identifying problematic code, creation of indexes, find better execution plan, creation of Materialized views and gathering necessary statistics on objects
• Configured OS Watcher for all classic RAC & Oracle Exadata servers
• Database refresh from Production to Development, Test, QA using RMAN & Datapump
• Recovered database using flashback database and RMAN backup
• Resolved huge gap in Oracle Data Guard environment using RMAN incremental backup
• Perform DBA tasks for any disk failures /disk replacement on Exadata storage cell node
• Implement and manage ASM filesystem on database servers for all environments
• Configure databases with RMAN level0 & level1 backup to recovery area and backup FRA to tape.
• Apply Quarterly patches and Version change patch bundles
• Good exposure to Oracle technologies like AWR, ADDM, SQL Tuning Advisor, SQL Access Advisor, SQL Monitoring, Flashback and Datapump
• Troubleshoot any ORA-600/7445 error message with Error look up tool and work closely with Oracle support to fix the issue
• Participate and present new topics in Oracle knowledge exchange meeting.

Confidential

Responsibilities:

• Install, Configure and Manage Oracle Standalone and RAC databases
• Implement RMAN Backups & Recovery strategy for new database installations
• Tune SQL queries for better performance by analyzing AWR/ADDM Reports, SQL Trace, TKPROF and Explain Plan
• Perform Partition table maintenance and Data Reorganization Activities
• Applying Patch Sets / Interim Patches
• Writing UNIX shell scripts to automate day-to-day database administration activities like Monitoring the database status, alert logs, and file systems
• Install and configure Oracle Identity/Access Manager and Oracle Internet Directory for development, staging and production environment
• Configure Oracle Internet Directory ASR Replication and Directory server Failover in Live and Staging environment
• Install Critical patches every quarter end for Oracle Access Manager and Oracle Internet Directory if applicable
• Implemented SSL in both Oracle Access Manager and Oracle Internet Directory
• Scheduling RMAN backup for OID database through Oracle Enterprise Manager
• Have experience in troubleshooting OAM and OID issues faced in all environments

Confidential

Responsibilities:

• Administration of Oracle Database running on RAC LINUX AS 2.1 Advanced Server with multiple instances
• Created standby database using Data Guard in Live environment
• Creating and maintaining all databases required for development, testing and production usage
• Importing and exporting dumps using EXP/IMP utility and Datapump
• Planning and implementing backup and recovery of the Oracle database with RMAN
• Manage objects, including tables, indexes, views, sequences, packages and procedures
• Create new database users as required and grant privileges to them
• Database monitoring and maintenance activities which includes checking alert log, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in cron, creation of users, schemas, tablespace and other objects
• Monitoring and Detecting Lock Contentions
• Analyzing the table weekly twice and performs health check