SUMMARY

• More than 8+ 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/12c, Oracle 10g/11g/12c RAC and ASM, Data Guard,MySQL, Performance Tuning, Unix Shell Scripts, Unix (Sun Solaris, HP, AIX & Linux), Windows and Linux.
• Proven extensive working experience in database optimization and performance tuning.
• Experience in Oracle technologies like Real Application Clusters (RAC), Active Dataguard (ADG), Automatic Storage Management (ASM), Clusterware, RMAN,Grid Control and Oracle GoldenGate.
• Have both Production support experience and individual project experience where new environment is designed,built,configured,supported till the application goes live.
• Extensive knowledge in database administration of Oracle 9i, 10g, 11gR2 & 12c with experience in multi-platform mission critical large OLTP and OLAP systems.
• Lead engineering effort, implementation, tuning and support of Oracle 11g & 12c RAC/Dataguard upgrades.
• Performed capacity planning, application analysis and developed database solutions for database space consolidation.
• Experienced in proactive and reactive database performance tuning in all database environments.
• Involved in designing and implementing High availability and Disaster recovery solutions
• Involved in data center migration activities
• Experienced in Oracle Enterprise Manager OEM(12c) to manage databases and configuring database monitoring using templates.
• Experienced in Database Migrations and Upgrades as well as migrations of the Oracle database across platforms.
• Experience in DBA activities such as Patching, Cloning, Backups and Recovery, Performance Tuning, capacity planning, etc,.
• Monitoring and Performance tuning using Oracle 11g/12c OEM grid control and tools.
• Involved in setting up and supporting Goldengate replication on databases with RAC and dataguard on oracle EXADATA Database machines
• Successfully performed DBPITR (Database point in time recovery) and TSPITR (tablespace point in time recovery) on various situations.
• 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.
• Experienced in Installating and Upgrading MySQL databases.
• Experienced in MySQL Database Migrations on across the different servers.
• Monitoring and Performance tuning of MySQL database using MEM(MySQL Enterprise Monitoring) tool.
• Expertise in different platforms 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.

PROFESSIONAL EXPERIENCE

Confidential, ParkRidge, NJ

Lead Database Administrator

Responsibilities:

• Performed Installation, configuration, maintenance and tuning of Oracle 12c & 11gR2 RAC databases.
• Successfully upgraded the Oracle Grid infrastructure and databases from 11.2.0.2 to 11.2.0.4 & 11.2.0.4 to 12.1.0.2.
• Performed proactive and reactive database performance tuning in all oracle database environment.
• Successfully upgraded the 2 node standby databases(ADG) along with Grid infrastructure from 11.2.0.2 to 11.2.0.4.
• Setup and Managed Oracle Active DataGuard environment in Oracle 11gR2 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.
• 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 MySQL installation and upgradation
• Experienced in installing and configuring MySQL Enterprise Monitor(MEM)
• 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

Sr. DBA

Responsibilities:

• Worked for Open Systems DBA team which services Oracle, 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

ORACLE DBA

Responsibilities:

• 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

ORACLE DBA

Responsibilities:

• Worked as oracle database administrator in maintaining oracle 24* 7 database running in oracle 10g 3 Node Real Application Clusters (RAC’s).
• Maintained Production database EDC that is close to 900 GB and other production database for CRM, DMS, BSC etc. Managing over all around 70 instances which include Production, Test and Development.
• Installed, Administered and Troubleshooting issues related to Oracle Real Application Cluster Databases (RAC) and Non-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
• Applied patches on oracle 11i Application server (11.5.10.2).
• 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.
• Installing oracle patches for bugs identified and resolving the most critical issues by creating TAR’s to the oracle support services.
• Installing OEM agent on client servers to be monitored by OEM Server.
• Performed 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.
• Writing Basic Shell scripts for load monitoring and Housekeeping of Trace files.
• Planning and scheduling HOT Backups and COLD Backup using RMAN and Logical Backups (with Export/Import).
• Rebuilding index to rectify segment fragmentations and run analyze script at regular interval.
• Tuned the RAC database for performance issues using AWR / Statspack reports.
• AWR and ADDM report Generation and Implementing ADDM suggestion to a particular query which causes performance Issue.
• Monitoring Database performance using OEM for any locks, High CPU usage query, Instance activity,
• Crontab job scheduling based on end user request.
• End user review meeting, monthly report preparation and presentations.