PROFESSIONAL SUMMARY:

More than 10 years of experience as an Oracle Database Administrator with extensive experience in the areas of installations, migration/upgrades, production support and on-time delivery of project deliverables. Certified oracle professional with expertise in various technologies, including Oracle 8i/9i/10g/11g, Oracle 10g/11g RAC and ASM, Data Guard, Performance Tuning, Ab Initio GDE, OWB, Unix Shell Scripts, Unix Sun Solaris, HP, AIX , Windows and Linux. Proven extensive working experience in database optimization and performance tuning.

STRENGTH

• Experience in Oracle Database Administration which includes features like Real Application Clusters RAC , Active Dataguard ADG , Automatic Storage Management ASM , Clusterware, RMAN,Grid Control, EXADATA and Oracle Golden Gate.
• Have both Production support experience and individual project experience where new enviroment is designed,built,configured,supported for an application till, it goes live.
• Extensive knowledge in database administration of Oracle 9i, 10g 11gR2 with experience in mission critical large OLTP and OLAP systems.
• Involved in setting up and supporting Goldengate replication on databases with RAC and dataguard on oracle EXADATA Database machines
• Worked on Golden gate to setup unidirectional replication on 4 node RAC database.
• Experienced in ETL tools like Ab Initio, involved in development of ETL Jobs for Extracting/Data cleansing/Transfroming/loading the data.
• Involved in designing and implementing High availability and Disaster recovery solutions.
• Experienced in Database Migrations and Upgrades as well as migrations of the Oracle database across platforms.
• Experienced in proactive and reactive database performance tuning in all database enviroments.
• Successfully performed DBPITR Database point in time recovery and TSPITR tablespace point in time recovery on various situations.
• Performed capacity planning, application analysis and developed database solutions for server, database and space consolidation
• Independently handled crisis situations like restoring table/schema/database from backup, switch over and failover, resolving range of perfromance issues,etc.
• Experienced in Planning and implementing Database Backup Strategy using RMAN.
• Experience in DBA activities such as Upgrades, Patches, Cloning, Backups and Recovery, Performance Tuning, capacity planning, etc,.
• Experienced at using Oracle Enterprise Manager OEM 12c to manage databases and configuring database monitoring using templates.
• Expertise in different environments like HP-UX, SUN SOLARIS, AIX, Linux and Windows.
• Demonstrated leadership, problem solving, research, inter-personal and good written and verbal skills.
• Able to work both independently and/or as part of a team, prioritize tasks and work on multiple assignments.

TECHNICAL SKILLS

WORK EXPERIENCE

Confidential

Role : Lead Database Administrator

• Performed Installation, configuration, maintenance and tuning of Oracle 11gr2 RAC databases.
• Successfully upgraded the Oracle Grid infrastructure and databases from 11.2.0.1 to 11.2.0.3.
• Created/managed application services on primary and standby databases and controlled the services via resource manager.
• Performed proactive and reactive database performance tuning in all oracle database environment.
• Created DataGuard Configurations including Active DataGuard managed using RMAN Duplicate as well as wiht BCV Split copy to create these Standby databases.
• Successfully upgraded the 2 node standby databases ADG along with Grid infrastructure from 11.2.0.1 to 11.2.0.3.
• Setup and Managed Oracle Active DataGuard environment in Oracle 11r2 and performed both planned and unplanned switchovers and failovers.
• Worked Troubleshooting and resolving the apply and transport ADG lag issues in standby databases.
• Involved in designing and implementing High availability and Disaster recovery solutions.
• Involved in installation Golden Gate server 11.2.1.0.6 and in implementation of GG initial-loads, Uni directional replication.
• Involved in setting up and supporting Goldengate replication on databases with RAC and dataguard on oracle EXADATA Database machines
• Worked on Golden gate to setup unidirectional replication on 4 node RAC database.
• Formulated Backup strategies and performed numerous Recovery operations. Methods include cold, hot, recovery manager RMAN and logical backups.
• Performed DBPITR Database point in time recovery and TSPITR tablespace point in time recovery on various situations.
• Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities .
• Independently delivered multiple Projects which involves tasks like design, build, configure, performance testing of database and providing support till they go live.
• Successfully built, configured and delivered multiple projects independently.
• Worked on query tuning on application SQLs that breached the SLA during the load testing in QP environment.
• Lead the Production support team and mentored the team members.
• 24x7 remote support and on call Database support for Database developers end users.
• Performed all aspects of database administration including installs, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Performed capacity planning, application analysis and developed database solutions for server, database and space consolidation
• Worked on setting up Monitoring of database and OS parameters using 12c Grid control.
• Performed SQL tuning and resolved performance issues in several environments.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Mentored other team members on RAC Cluster Builds and Clusterware Administration to bring them to speed on managing these Production Clusters.

Confidential

Role : Sr. DBA

• Worked for Open Systems DBA team which services Oracle, Oracle Apps, SQL Server databases
• Reporting to Client on a daily basis on the issues/challenges.
• Creating and maintaining all databases required for development, testing, staging and production usage.
• Installed, Administered and Troubleshooting issues related to Oracle Real Application Cluster Databases RAC for Oracle 9i and 10gR2.
• Installed, Administered and Upgraded the Oracle Clusterware CRS .
• Implemented Node Addition/Deletion and Instance Addition/Deletion procedures for the RAC Database.
• Migrated oracle 10g database from non-ASM to ASM .
• Performed conversion of Single Instance to Cluster databases using rconfig / Grid Control.
• Tuned the RAC database for performance issues using AWR / Statspack reports.
• Performing RMAN backup and Restore in different instances.
• Performing the capacity planning required to create and maintain the databases
• Performing ongoing tuning of the database instances.
• Planning and implementing backup and recovery of the Oracle, Oracle Apps, SQL Server and Sybase databases.
• Gathering schema Stats , rebuilding index , reorganizing table has done for improvement of running application queries .
• Perfromed switchover and failover of databases using DGMGRL and Rebuilt the physical standby database after fail over.
• Rolling out quarterly patches on RAC 10g, standby databases and single instance databases.
• Controlling migrations of programs, database changes, reference data changes and menu changes through the development life cycle
• Implementing and enforcing security for all of the databases
• Performing database reorganizations as required to assist performance and ensure maximum uptime of the database
• Putting standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Supporting issues as per SLA.
• Documentation of Implementation and Support activities
• Preparing Known Error Database KEDB for the team members' reference which consists of all the issues faced with the resolution steps
• Evaluating releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.
• Coordination with the Application developers, System administrators and Backup support team, to ensure the operations are smooth
• Administering all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
• Troubleshooting with problems regarding the databases, applications and development tools
• Automated jobs using UNIX shell script to perform backup, partition maintenance and schedule in control-m.

Confidential

Role : ORACLE DBA

• Worked on ORACLE DBA activities such as Database Creation, Database Maintenance, Database Backup and Recovery, Database Tuning, Application Tuning, Security, Migration.
• Performed database recovery using User-Managed, RMAN-Managed Recovery to handle efficient database recovery.
• Scheduled and upgraded the Production databases to the latest Oracle patchset with minimal downtime and migrated this database from a single instance to a RAC Cluster.
• Migrated the Production database from Oracle 9i to 10gR2 on development , test and Production environments.
• Successfully planned, executed and lead several disaster recovery tests.
• Implemented Security User Management, Privileges, Roles, Auditing, Profiling.
• Applying Oracle security patches.
• Involved in regular data monitoring, data backup/recovery processes.
• Worked in Oracle 10g, 11g Sun SOLARIS 5.8 RHEL5, HP UX 11.23
• Implemented Data Guard for Disaster recovery system using Oracle 10g
• Migrated upgraded databases from Oracle 10g to oracle 11g.
• Installation of Oracle 10.2.0.2, 10.2.0.3 and 10.2.0.4 binaries.
• Created new 10g Database and performed regular RMAN backups for all the databases.
• Patch Analysis, Patch Installation.
• Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
• Refreshing database using RMAN backups BCV split backups.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files.
• Setup database auditing, granted privileges to users through system/object roles.
• Created schema tables, Indexes, views, sequences, synonyms, packages .
• Automation of certain monitoring and scheduled activities through Shell Scripting
• Deleting data and arch file systems on legacy server after Database Migration to new server.
• Monitor and tune database performance using STATSPACK and AWR.
• Increased performance of sql queries by creating materialized views and by enabling query rewrite.
• Worked as part of a team and provide 24x7 supports when required.
• Documented instructions for migrating upgrading databases.
• Attended the key manager, team, change control, performance meetings and conducted weekly meetings for Infrastructure DBA Team

Confidential

Role: Oracle DBA

• Installed and configured Oracle databases version 9.x, 10g in Redhat AS 4 and Fedora 7 Linux. - Responsible for creating and maintaining the development and test database for DMF.
• Responsible for maintain different schemas and users with appropriate privileges.
• Installing and configuring the oracle client software in all machines and establish the connectivity.
• Preparing Data model and creating relevant tables and indexes.
• Involved in environment setup activities like installation of Ab Initio server co