SUMMARY

• As an Oracle Certified DBA with nearly 10 years of IT experience including 7+ Years of Oracle DBA experience.
• As Senior Database Administrator responsible for installing, configuring, maintaining, and tuning Oracle software, database components, backup/recovery activities, create/modify shell scripts for automation.
• Extensive experience in Oracle RAC, ASM, Data guard, Golden Gate and Performance Tuning.
• Expert in Oracle 9i, 10g, 11g, 12c
• Extensive experience in upgrading around 40 Oracle databases from 11g to 12c.
• Expertise in RAC and ASM installation and administration.
• Expertise in Data guard configuration, maintenance and gap resolutions.
• Experience in Golden Gate configuration and administration.
• Experience in architecting multi - terabyte systems, including a proven track record of physical optimization, query optimization and capacity planning.
• Expertise in installing, upgrade, migration and patching standalone and RAC databases.
• Have completed successful migration of SQL server to Oracle databases.
• Have been part of storage migration from EMC to Oracle with size of 15TB / 20 TB
• Extensive experience with features such as Oracle Real Application Clusters (RAC), ASM and Active Data Guard for HA and DR solutions
• Have been part of AWS migration.
• Solid Experience with design, development, and implementation of database instances - schema, queries, pl/sql code, triggers, etc.
• Restoration and Recovery of databases. Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Experience in monitoring database performance statistics and recommending improvements.
• Experience in Backup and Restore strategies, modifying and creating RMAN backup scripts and database cloning using RMAN
• Maintenance and Support of multi-terabyte databases in production, testing and development environments hosted on Unix servers (HP, Linux) and Linux, Solaris servers
• Write UNIX shell scripts to automate database functions.
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
• Possesses strong coordination with global teams, planning, interpersonal, communication, presentation and decision making skills.
• Proven track record administering Oracle databases in a challenging environment
• Experience with upgrading OEM from 11G to 12C
• Recognized with Role Model Award in 2012.
• I am an OCA and ITIL Certified.
• Ability to work effectively in a team environment and able to stand alone in meetings and represent group with internal/external customers
• Ability to learn and adapt to new technologies and ability to collaborate with multiple teams and stakeholders
• Proven success in a fast-paced environment and highly demanding environment and capable of providing thought leadership and abstract thinking
• Have worked on Agile team and been scrum master for last one year and familiar with Version One.

TECHNICAL SKILLS

• SQL Plus
• Toad
• SQL Developer
• BMC Remedy
• HPSM
• Autosys
• Grid
• Putty
• SSH Client
• PVCS
• SVN
• Password safe sitescope and i3 tools
• Agile version One
• Citrix
• Commvault Simpana

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Oracle Lead Administrator

Responsibilities:

• Database refresh, creating duplicate database, schema refresh
• Taking the backup of database on scheduled basis and performing the recovery if required including user managed and RMAN method as per requirement. Data export and import using datapump. Restore using Commvault.
• Performing the upgrades and patching in standalone and RAC databases.
• Have been part of Database Migration from SQL Server to Oracle Database using Golden Gate.
• Datagaurd DR Setup and monitoring.
• Create/restore/refresh standalone and RAC databases as per business requirement.
• Have part of storage migration from EMC to Flash array.
• Migrated oracle databases to AWS. Experience in creating and administrating RDS and EC2 instance.
• 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.
• Troubleshoot and resolve database and/or application problems encountered by end users.
• Works directly with software developers to develop and enhance applications and data conversions.
• Support development teams with technical and physical design, development, and maintenance of Oracle Server databases; including data analysis and modeling, programming, implementation, performance monitoring, tuning, cloning/refreshing, planning, problem resolution, and data dictionary administration.
• As as Scrum master to create backlog templates, run the standup meetings, help the team to get the impediments resolved.
• Partitioned large tables for better performance and manageability.
• Experience on 24*7 environment including on call support as per requirement. Conversant in handling requests within SLA.
• Provide on-call support in adherence to specific business and customer Service Level Agreements
• Implementation of daily, weekly, and monthly DBA checklists for each environment.
• To work with the integration team to implement the data model in database.
• Cleaning database on regular basis to improve performance of database. Doing regular health check on the database to maintain the performance and to keep the Databases up and running fine, if any glitch then to bring up or to restore the database as soon as possible.
• Configuration of new listener and registering required database with listener.
• Working on the planned and unplanned outages.
• Managing disk space and CPU utilization on Linux/AIX based servers.
• To closely work with the integration team to maintain database as per the requirement of the client. Table partitioning
• Creating shell scripts as per the requirement from the customer.
• Creating & managing user account, granting & revoking privileges from users as per business requirements
• Managing table spaces & quotas and capacity planning.

Environment: AIX, Unix, Linux, Solaris, Windows, Oracle 9i, 10g, 11g, 12c

Confidential

Oracle Database Administrator

Responsibilities:

• Oracle RAC, ASM and Data guard administration
• Backup and Recovery using RMAN and datapump
• Oracle Installation, up gradation and patching
• 12c OEM installation and monitoring setup
• Capacity management and space forecasting
• Database and schema refresh.
• Job monitoring using Autosys
• Ticket resolution, Bug fixing and enhancements etc.
• General Performance - AWR/ADDM reports and checkouts DB health check
• Creating Primary Database storage structures (tablespace, data files) and objects like Tables, Indexes, and Profiles. Schema comparison and working on invalid objects.
• Co coordinating db down, listener no response, application down and managing unplanned outage.
• Accomplishing releases and data fixes
• Client coordination for the project, weekly status meetings and status reports.
• Monitoring performance of the Database.
• Auditing the newly added database for the support and Database retirement
• Studying the entire application management process, procedures, identifying the areas of improvement and implementing the same.
• Managing the physical & logical objects of the Databases. QA refresh with Prod, Migration, Data fix
• Creating & managing user account, granting & revoking privileges from users as per business requirements
• Managing tablespaces & quotas and capacity planning.
• Implemented backup and recovery using RMAN. Documented the process for implementation in production and staging environments
• Scheduling CRON Jobs based on the database and application requirement
• Played as a team lead for a 5 member team, since June 2012.

Confidential

Responsibilities:

• Creating & managing user account, granting & revoking privileges from users as per business requirements
• Managing tablespaces and quotas.
• Checking the listener status
• Monitoring the scheduled jobs
• Reading alert log file for performance point of view
• Monitoring the archive destination
• Working with the backup team in case of any backup job failure.
• Data export and import
• Loading the data through sql loader.

Confidential

Responsibilities:

• Read the document and fetch the appropriate key word and feed them into the tool
• To prepare production report on daily basis
• Coordinating with clients for project enhancements.
• Manual effort will be reduced and document search improves
• Studying the entire application management process, procedures, identifying the areas of improvement and implementing the same.
• Giving knowledge transfer to the new joiners
• Adhoc requests

Confidential

Quality Audit

Responsibilities:

• To monitor the calls on a regular basis
• Calls are monitored based on the given parameters
• Valuable feedback given to the executives to develop their call attending efficiency
• Allocating calls to the team members for audit
• To prepare EOD report for the whole team on daily basis
• Coordinating with on-site team for project enhancements.
• Training the new joiners on the project

Environment: BMC Remedy