Industry Experience

• Over 8 years of experience as an Oracle Database Administrator in providing 24X7 production and development support for 11g/10g/9i/8i/7.3 databases on different platforms like HP-UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.
• Proficient in database administration, installation, configuration, upgrades, patches performance tuning, backup and recovery, cloning, space management, troubleshooting, physical and logical database design.
• Experience in implementation of High Availability solutions with Oracle 10g/11g Real Application Clusters RAC with ASM, Physical and Logical Standby Databases Data Guard .
• Experience in active database cloning from non-RAC to RAC on ASM and vice versa using RMAN Duplicate.
• Experience in using GoldenGate to support data replication in oracle database environment. Proficiency using Oracle GoldenGate replication monitoring, tuning and capacity planning.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Experience in performing backups and recoveries using conventional hot cold backups and RMAN.
• Strong knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.
• Skilled in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, Recycle Bin, 10g/11g/12c Grid Monitoring.
• Good knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN, IBM Tivoli Storage Manager TSM , VERITAS Net Backup.
• Good experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Excellent Troubleshooting skills in OS level and Database level.
• Excellent experience in cloning oracle databases for development and testing.
• Expertise in SQL, PL/SQL, and developing various Data Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Expertise in Replication of Oracle Database using Logical Standby, Streams and Shareplex.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ADDM, Grid Monitoring.
• Has good experience in SQL Server Clustering and MSSQL Server 2000/2005 Log Shipping, Database Mirroring.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools
• Good experience in resolving the issues related to installation, upgrades and patches.
• Experience using Oracle 10g Flashback on Database, Drop Table features.
• Good Knowledge with databases running on UNIX /Linux using ASM.
• Working experience in both OLTP and Data warehousing environments.
• Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements, used cost based approach extensively and also used rule based methods to tune the SQL.
• Recovery of Databases Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc. .
• Good knowledge in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Expertise in creating and scheduling jobs through OEM.
• Proficient with 11g new features: Active Datagaurd, configuring Snapshot standby database.
• Knowledge of Data transfer between SQL Server and Oracle.
• Experience working with the client side, doing requirements gathering, providing innovative solutions, client interfacing and support for application and queries.
• Written KORN shell scripts in UNIX and scheduled the job using CRON and Tivoli scheduling.
• Expertise in cross platform data migrations using Transportable Table spaces.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
• Excellent interpersonal skills and analytical skills.

Skills

• Operating Systems ---> HP-UX 10.x/11.x, AIX 4.3x/5.1/5.2, WINDOWS NT/2000/2003 Server,
• Red HAT Linux 9/8/7.2/7.1/6.2, RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10
• DB Management ---> TOAD 7.6/7.5, OEM 9.2/10g 10.1/10.2 , Grid control RAC , RAT
• Programming ---> SQL, PL/SQL, C, C , UNIX shell scripting, PERL, Bourne, Korn,
• AWK-SED, PHP, JavaScript, HTML, Exposure to Java
• Tuning/Monitoring ---> RAC 11gR1/R2, RAC 10gR2, Data-Guard 9i/10g/11g, DB Cloning,
• Standby databases, RMAN, 9i/10g/11g/, TKPROF, EXPLAIN PLAN,
• STATSPACK.
• RDBMS ---> Oracle Server 8i/9i/10g/11gR2/12c, MySQL, SQL Server 200.2005

Work History

Confidential

Project work

• 24x7 Oracle Production Database Administration including Oracle 11g RAC.
• Used GoldenGate to move large volumes of data between oracle servers with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases.
• Implementation of High Availability solutions with Oracle 11g RAC, Physical and Logical Standby Databases Data Guard and Replication using GoldenGate.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Designing and implementation of database backup/restore methodologies troubleshooting performance and networking issues. Basic OS system administration.
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g and Sun Solaris to OEL Oracle Enterprise Linux .
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Implemented Real Application Clusters RAC setup, configuration and cluster interconnection of 5 instances with server side load balancing using Automatic Storage Management ASM .
• Applied critical patch updates CPU released by oracle quarterly.
• Maintain and periodically test backup and recovery process for Oracle databases for Disaster Recovery readiness.
• Setup and monitored multi node RAC to RAC Data guard with real time apply for Disaster recovery and offload backups.
• Configured and Administered Oracle 11g RAC high availability on ASM using EMC NETAPP as storage.
• Responsible for upgrading GoldenGate 9.5 to GoldenGate 10.0.
• Performed Import and Export using Oracle Data pump utilities Expdp and Impdp.
• Responsible for setting-up and managing Standby database using Data Guard for DR sites.
• Monitored/managed 2 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE.
• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.

Environment: ORACLE, SQL Plus, OEL 10g/11g, Data Guard, GoldenGate, ASM, PL/SQL, Toad, OEM, EMC.

Confidential

Project work

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution for multi-terabyte database issues during Pre Post GO-LIVE period. Daily Health Check Up of the Database.
• Intensively used latest 10g/11g Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM reports for the health check of the databases.
• Upgraded Prod, Dev and Test instances from 10g 10.2.0.2 to 11g 11.2.0.1/11.2.0.2 .
• Implemented oracle 11g RAC and 12c installations and new features R D.
• Logical backups were scheduled for Development, QA and UAT databases using export/import and Data Pump.
• Migrate 11g to 12c Database, Configure Containers, Implement Audit Vault and new database security features.
• Multi-node RAC configurations, database creations RAC database conversions.
• Involved in database installations/upgrades/patches/migration, space management, capacity planning, backup recovery, disaster recovery, database performance tuning, memory tuning, application tuning, security administration, Data Guard, real application clusters.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management ASM .
• Performance tuning for optimized results using tools like Explain Plan, SQL Trace, TKPROF and Statspack.
• Helped in Performing GoldenGate replication monitoring and tuning.
• Built Physical Standby Data Guard for production databases.
• Designed and implemented Oracle Real Application Clusters RAC on Solaris for an OLTP application with Transaction Application Failover and high transaction volume.
• Performed Initial load, extract, replicat, trial files and exporting data onto Repository Database using GoldenGate tool.
• Applied various GRID and Database Bug Patches for Oracle 11g R2 GRID/RDBMS.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.
• Responsible for installing and configuring GoldenGate 9.5 on Oracle Servers.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK etc.
• Implemented GoldenGate for Standby Configuration and developed procedures for Replication.

Environment: Sun Solaris 10, ORACLE, SQL Plus, OEL 10g/11g, Red Hat Linux 4.x, RAC, IBM AIX 5.3, Data Guard, GoldenGate, ASM, PL/SQL, RMAN, Toad, OEM GRID, EMC, NetApp.

Confidential

Project work

• Part of a 6 member DBA team which was involved in the maintenance of the Oracle 9i/10g/11g database for the Production as well as the development environments.
• Installing 10g and 11g databases on SUN SOLARIS/AIX/HP-UX.
• Performed documentation for Clusterware installation, RAC RDBMSinstallation, RACDatabase creation, Grid Control installation, Oracle 11g Standby Documentation.
• Implementation and Configuration of OEM Oracle Management Server for maintenance and monitoring.
• Migrated databases from one server to another server using Active Database Cloning, Data Pump, RMAN Duplicate database and Redirect restore.
• Setup and configured Oracle Physical Standby database Data Guard for disaster recovery as well as to offload the running of huge reports.
• Actively participated in installing of 11g RAC on Linux environment with two nodes and ASM as storage.
• Performed Roll Forward a Physical Standby database with RMAN incremental backup when Standby is out of Sync.
• Performance tuning and Monitoring using Grid Control database managing instances using OEM.
• Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing.
• OEM installation and configuration for monitoring and performance tuning.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Generated performance reports and Daily health checks of database using utilities like AWR, Statspack, ASH and ADDM to gather performance statistics.
• Implemented Backup and recovery strategies using export/import, RMAN and online backups.
• Used Oracle Streams for Basic and Advanced Data Replication between oracle database servers.
• Refresh databases from Prod to Test and Dev environments for Application testing using RMAN.

Environment: Sun STOREDGE 6140, 6130, 3500, Red Hat Linux x86, EMC Storage, ASM,VERITAS Net backup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, SUN SPARC, Dell Power edge , 11g OPS center.

Confidential

Sr. Oracle DBA

Responsibilities:

• Implemented Oracle RAC with Data Guard implementation for disaster recovery.
• Performed Oracle Database upgrades from 10.2.0.1.0 to 10.2.0.4.0 in AIX RAC environment.
• Restored recovered production reporting and SIT databases from hot backup using RMAN.
• Implemented centralized backup hot and recovery strategy for all the databases using shell scripts, SQL scripts and cron job.
• Used Oracle 10g AWR ADDM to monitor database activities and performance tuning.
• Planning and implementing Backup and Recovery procedures Hot Backups, and RMAN , scheduling daily backups and performed periodic recovery tests.
• Installed Oracle Cluster-ware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
• Implemented Data Guard, Standby, and Oracle Streams technologies in mission critical systems and configured Switch over and Failovers with Physical standby database on Windows and Linux environments.
• Developed shell scripts to monitor and maintain the Oracle database.
• Used Oracle 10g Data pump and export/import for data migration.
• Implemented Backup Recovery procedures using RMAN, Hot/Cold Backups
• Optimized data loading using SQL Loader to load different types of data from flat files to the Oracle server.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Involved in Capacity Planning, Hardware configuration for Oracle 10g RAC Environment.
• Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space and actively involved in Shell Scripting for various CRON jobs to be run.
• Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.
• Upgraded the database 10gR1 to 10gR2 and applied database patches using opatch utility.
• Experienced with SRVCTL for monitoring and configuring RAC Environment.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine-tuned for better performance.

Environment: HP Integrity Superdome Sx2000 chipset, 32 processor, 1TB, Solaris Fire 440,IBM z/OS 1.12, Fire 880, Oracle 9i/10g/11g, HP Integrity rx 8640, RHEL AS 5, SQL Plus, OEM, Erwin Data Modeler.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Involved in configuration and implementation of hardware and software installations for oracle 8i, 9i.
• Involved in upgrade of Oracle databases from 8.1.7 to 9.2.0.3
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Performed activities like applying RDBMS patches, security patches, proactive monitoring of databases.
• Knowledge of using EXP and IMP utilities.
• Troubleshooting DB related issues and providing scripts for taking regular backups

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, STATSPACK, TKPROF, UTL SMTP, EMC ERWIN, SQL LOADER.