SUMMARY

• Certified Oracle and Unix professional with 8 years of experience in Oracle Standalone & RAC Database Administration (10g/11g/12c) and troubleshooting and performance Tuning.
• Strong experience in supporting multiple production, development and test databases under UNIX and Solaris environments.
• Oracle Server Installations on various UNIX Flavours like Redhat and Solaris and Creating users with proper roles and privileges.
• Strong experience in installation of virtual platforms like Esxi servers and creation of vm’s with required operating systems like Solaris, windows and various Unix flavours.
• Administration of Oracle, MS SQL and MY SQL server databases with high availability solutions like RAC, Data Guard, ASM.
• Experienced in performing cross platform data migrations from MS SQL to Oracle using SQL Developer and also assisting ETL team in performing teh migration activities.
• Experienced in using SSMA to perform data migration from Oracle to MS SQL.
• Working with security and compliance teams for teh quarterly patching activities to make sure all teh vulnerabilities are closed and teh correct security patches are in place.
• Experience in taking Online, Offline and RMAN Backups and Managing Backup & Recovery using RMAN Scripts.
• Work on a variety of development and maintenance projects in coordination with business owners and various development and functional teams
• Experience in cloning teh production databases to development and test environments using RMAN Cloning methods.
• Experience in applying patches using Opatch utility as and when there is a new patch release.
• Checking teh size and teh availability of tablespaces to teh users and doing housekeeping of teh datafiles.
• Prepared standard documentation for patching, Cloning, Upgradation process.
• Very good understanding of various storages like EMC, NetApp and IBM series hardware architecture and its different tools from various vendors.
• Very flexible and can work independently as well as in a team environment.
• High proficiency in developing Oracle PL/SQL packages
• Experience and extensive noledge in Cloud & Virtual Platforms.

TECHNICAL SKILLS

RDBMS, Tools& Utilities: Oracle 10G/11G/12cRMAN, Data Guard, RAC, Data Pump, Export, Import, TOAD, SQL Developer, PLSQL Developer, SQL*Plus, OEM.

Technologies: Active Directory, DNS, DHCP, Remote Desktop, VMware

Languages: SQL and PL - SQL

Desktop Technologies: Windows, MSOffice, Desktop and Networked Printers

Operating Systems: Windows, Linux, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Safran Group, PA

Sr. Oracle Database Administrator

Responsibilities:

• Support large-scale, massively concurrent, highly available distributed Oracle systems.
• Part of production support team that functions 24X7 handling more TEMPthan 200 databases which include many mission critical and multi-terabyte databases
• Root-cause analysis, troubleshoot complex technical problems, performance issues in accordance with SLA
• Supporting teh ETL team in data migration across teh cross platforms of databases.
• Performing data migration from SQL to Oracle based on teh migration plans to suit teh project requirements.
• Installation and configuration of standalone and RAC databases based on teh project needs.
• Oracle RAC database administration, troubleshooting, performance tuning and patching
• Advanced backup and recovery using RMAN, Implement DR strategies and test periodically
• Upgrade and patching of Oracle single instance and RAC databases to adhere compliance
• Automate various database administration tasks using scripting.
• Design, document, script, test and implement internally developed or vendor applications
• Work on a variety of development and maintenance projects in coordination with business owners and various development and functional teams
• Performance tuning of teh database in coordination with teh development and application teams.
• Configuring Oracle 11g & 12c RAC environments on Virtual Platforms.
• Supports infrastructure components, including operating systems, hardware/storage configurations and networks
• Mentoring and up skilling DBAs and contributing in technical initiatives
• Implemented Oracle 12c single instance and RAC instance with data guard and tested new features and upgrade from 11gR2 databases.

Confidential, CA

Oracle Database Administrator

Responsibilities:

• Installation and configuration of standalone and RAC databases based on teh project needs.
• Creation and maintenance of teh users along with security roles and privileges
• Database monitoring and Administration activities like creating tablespaces, users and roles for test environment
• Performing database Hot and Cold backup and recovery for 10g/11g/12c databases
• Administering Clusterware services and ASM instances using crsctl and srvctl utilities.
• Taking Back-up of teh Database (Physical, Logical) & recovering teh database at critical times.
• Refreshing teh databases based on teh project needs as and when required.
• Coordinating with teh development team and help to resolve teh DB connectivity problems.
• Taking incremental and full backups using RMAN and moving teh backups to teh storage location.
• Manage and perform operational tasks in oracle database such as database cloning, upgrades, migrations, installations etc.
• Cloning of databases from production using RMAN for development and test purposes.
• Checking teh size and teh availability of tablespaces to teh users and doing housekeeping of teh datafiles.
• Perform data refresh and extraction of data using export data pump and import data pump.
• Supervise and perform regular database health checks and performance monitoring and tuning.
• Performing end of day operations and reporting to teh higher levels on teh tasks.

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

• Monitoring alert log to analyse teh day-to-day DB activities.
• Managing teh scheduled backups, and referring teh backups in case of failures.
• Engaging teh supporting teams and vendors for resolving teh issues based on teh severity.
• Administration, monitoring and maintenance of Oracle10g RAC databases.
• Administration and monitoring of High Availability Services using SRVCTL.
• Administering and monitoring Clusterware and ASM Instance using CRSCTL.
• Managing teh oracle Clusterware using crsctl, crs stat, ocrconfig, ocrdump utilities.
• Monitoring teh Backup & Recovery in Standby/RAC database using various monitoring tools.
• Managing Physical Structure of Oracle Database like Datafiles, Redologfiles, Controlfiles.
• Performance Monitoring & Tuning in RAC system like analysing AWR reports and reporting teh differences to teh next levels.
• Managing day-to-day activities and database maintenance.
• Providing technical support to teh Unix/DB team during teh change weekend over teh Bridge line.
• Checking teh size and teh availability of tablespaces to teh users and doing housekeeping of teh datafiles.
• Managing day-to-day activities and database maintenance.
• Monitoring teh database alerts using Foglight/Blackbird/TBSM.
• Liaising with OS, Application and network teams over teh BL and support them during teh change/problem resolution.
• Reporting on errors to teh next levels and assigning teh ticket based on teh severity of teh issue and following up for teh resolution.

Confidential

Associate Database Administrator/Unix Admin

Responsibilities:

• Monitor system resources of database servers to assure production systems meet availability requirements and hardware enhancements are scheduled in a timely fashion.
• Ensure timely resolution of DBA issues as escalated.
• Installation of Database software as per standards in a timely and accurate manner.
• Monitor performance, space, database parameters and tuning.
• Implement, test backup, recovery procedures and DR solutions.
• Coding, debugging and tuning SQL queries to improve performance.
• Database monitoring and Administration activities.
• Scheduling Full and Differential Backups for teh user and system databases.
• Database creation as per project requirements.
• Creation of additional tablespaces and adding data files to tablespaces.
• Monitoring teh scheduled backups, and refiring teh backups in case of failures.
• Taking Online, Offline and RMAN Backups.
• Performed number of Dev, test cloning from Prod databases.
• Creation and maintenance of teh users along with security roles and privileges.
• Logical Backup of Databases using EXP/IMP Utility EXPDP&IMPDP and perform schema refresh.