SUMMARY

• Oracle certified professional with 9 years of progressive hands - on technical experience in Oracle database versions 8i, 9i, 10g and 11g.
• Extensive experience in planning, installing, patching, configuring, upgrading and administering large size Oracle databases on various UNIX & Windows environments.
• Proficient in managing high availability solutions like Real Application Clusters, Dataguard, Goldengate Replication and Automatic Storage Management.
• Expertise in designing and implementing database backup & recovery plans using RMAN, and setting up secondary backups using Datapump.
• Good understanding and implementation experience in database performance monitoring, diagnostic and tuning.
• Highly focused in terms of preventive maintenance, managing incidents, change control processes, meeting P1/2 resolution SLA and process improvements.
• A good team-player with a proven ability to deliver high quality services and to mentor/train other DBAs and provide technical guidance

TECHNICAL SKILLS

Database: Oracle 8i, 9i, 10g and 11g Enterprise Edition

Operating System: Sun Solaris, HP-UX, IBM AIX, LINUX, Windows NT

Languages: C, SQL, PL/SQL, Basic UNIX Shell Programming

Database Tools & Utilities: Oracle Recovery Manager, Real Application Clusters, GoldenGate Replication, Data Guard, SQL* Loader, Datapump, Export/Import, TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Responsible for all end to end technical activities starting from day-to-day jobs monitoring, user management, space management, database creations, backup and recovery, migration, upgrade etc.
• Setting up and configuring Backup & Recovery solutions for the production databases, as per the defined standards and processes. Monitoring the successful completion of the backups on a daily basis.
• Performing monthly maintenance activities as analyzing data growth and setting up data archival, creating required partitions for the month, analyzing the performance and planning for the future improvements.
• Managing the RAC instances with ASM storage management.
• Managing and monitoring the Goldengate replication environment configured for real time replication of data.
• Review and manage changes to data and database structure via formal change control process. Managing the incidents, service requests and changes.
• Participate in weekly data meeting with the client for addressing the business data related issues raised by the client and business users.
• Frequently meet with the application teams to review the application requirements and changes.
• Apply PSU and one off patches as recommended by Oracle.
• As a member of the Oracle projects team responsible for all the major databases related projects.
• Monitoring the Data Warehouse load & reporting jobs. Troubleshooting and rectifying the issues in case of any failures or delays, to avoid SLA misses.
• Participate in the Audits and compliance activities

Environment: Oracle 11g/10g/9i, RAC, Goldengate, Sun Solaris, AIX, TOAD, RMAN

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Designing, Implementing and administering database High Availability solutions like Real Application Clusters and standby databases, as per defined standards. Maintaining the environment to ensure high availability and reliability.
• Setting up and configuring Backup and Recovery solutions for the production databases, as per the defined standards and processes. And monitoring the successful completion of the backups on a daily basis.
• Setting up Real Application Cluster databases, node additions, service configurations, load balancing set up, work on RCA for node eviction issues, managing resource failovers and clusterware resources.
• Automatic Storage Management (ASM) implementation & maintenance.
• Configuring and administration of the Golden Gate replication tool for real-time data replication. Managing the configuration changes in co-ordination with the third party vendor which manages the source databases.
• Perform Database Patch/Version upgrades and migrations to various platforms. And provide DBA support for OS Patching and Maintenance activities.
• Meeting the P1/2 tickets resolution SLA as defined, for the service tickets management. And focus on a complete and accurate RCA for P1/2/3 outages.
• Participate in team/customer meetings and workshops as required.
• Focus on preventive maintenance and database performance tuning. Ensuring that all the supported environments have correct monitoring in place for pro-active problem solving.
• Focus on quality of production changes. Making sure the change details are obtained on time, and performing a thorough review and test.
• As a part of the Oracle 10g Upgrade Technical SME and Quality Audit team, driven the Oracle 10g database upgradation efforts for the team and helped with the progress of the upgrades for all the Confidential databases.
• Contributed for the standardization of the upgrade procedures and guidelines.
• Perform database migrations/upgradation across platforms and versions
• Educating the team about the guidelines, procedures and Processes to be followed for any upgrades.
• Participate in weekly SME meetings to track the progress and effectiveness of the planned database upgrades, address any issues/concerns, and to discuss about the effective ways of improving the project planning
• Monitor/audit the upgrade process and ensure that the DBA teams are following established guidelines and procedures
• Participate in major release activities right from the initial plan reviews till the implementation. The major release activities include:
• Participating in Walk thru Meetings with all the application teams, and addressing the issues if any
• Provide the staffing plan for the release activities
• Perform database refreshes for the ORT/QA/Break Fix environments to sync to structure with production database.
• Receiving the script packages from Test DBA team and testing the packages in QA environment
• Sketch out all the necessary pre-works to be performed, and performing them prior to the release
• Coordinating with the third party vendor on the changes related to GoldenGate replicated tables and making appropriate changes at the target.
• Deployment of the planned changes in production database as per the project plan
• Performing post-release steps and assisting with the post-deployment testing.
• Providing on-call support for business critical applications on a 24x7 basis and Follow-The-Sun method.
• Participate in ERD Review meeting and address any of the known requirements, risks, and/or dependencies to the user community with all stake holders involved.
• Train and mentor the new joinees and junior DBAs, and providing technical assistance as and when required. Also conducted knowledge sharing session for the team on various topics.

Environment: Oracle 11g/10g/9i, RAC, ASM, GoldenGate, Data Guard, Sun Solaris, AIX, HP UNIX

Confidential

Database Administrator

Responsibilities:

• Installation and configuration of Oracle 9i products and its related tools on various OS platforms like Linux, Windows NT, 2000.
• Database creation and maintenance. Created databases for different applications keeping in view the space requirements for coming months.
• Creating users, profiles and granting roles/privileges to users. Managing database security by assigning appropriate roles and privileges to users depending on the user activity. Controlling and monitoring user access to the database
• Managing the Tablespaces for different user by granting quota on default and Temporary Tablespaces
• Creating primary database objects and day-to-day monitoring of the database.
• Designing and implementation of database backup and recovery procedures. Configuring and maintaining the Recovery Manager (RMAN) Repository
• Taking backup and performing recovery of database using Logical (Export & Import) and physical (Online & Offline) backups.
• Performing Oracle patches and Database Upgrades.
• Performing maintenance with Recovery Manager by configuring retention policies, crosschecking backups and copies, and deleting obsolete and expired backups.

Environment: Oracle 10g/9i, Windows NT, Sun Solaris, LINUX, SQL Developer