Executive Summary

• Database Administrator with 9 plus years of experience in Planning, Installation, Configuration and Upgrading of Oracle 12c, 11GR1/R2, 10G, 9i, databases and applying patches under Linux, HP-Unix, Sun Solaris, IBM-AIX and Windows platforms.
• Experience of installation configuration, implementation of Oracle 10g/11g RAC two-node on Linux with ASM
• MIGRATING and Upgrading the DATABASES between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases.
• Experienced in using 11g features like DatabaseReplay, Partitioning, LogMiner, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security
• Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• Extensively worked on Oracle Utilities Data Guard, Data Pump, Flashback, SQL LOADER and RMAN.
• Worked with EXP/IMP,EXPDP/IMPDP to refresh the schemas and to restore the Dev,Test databases.
• Strong Exposure on High Availability Concepts RAC, Standby , Database Cloning, and Oracle Streams.
• Strong knowledge and experience of managing Oracle 9i, 10g and 11g RAC environments using the OEM Grid Control tools.
• Strong programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
• Performed complete multi-master replication with updateable Materialized views.
• Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE,AWR, ADDM, and 10g, 11g OEM Grid Monitoring.
• Good experience in applying Critical Patch Update CPU Patches on Databases.
• Expertise in Oracle Golden Gate software.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWRand ADDM reports.
• Experience in Oracle Enterprise Manager OEM Grid Control, TOAD, RMAN.
• Proven ability of providing production support for 24X7 on multiple databases.

Technical Skills

Professional Experience

Confidential

Sr. Oracle DBA

Environment: Oracle 12c, 11.2.0.2, 11.2.0.3, ASM, RMAN, RAC,OEM 12c, VERITAS netbackup,SQL Developer,Toad,Keepass.

Responsibilities:

• Worked on Planning Database, Sizing table space, Create database, scripts, Monitor databases, 24x7 production support.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Responsible for DBA functions and ETL development in Data ware housing.
• Managing Oracle instance, creating database and maintaining alert log files, AWR ADDM reports
• Deployed and Configured 12c OEM Agent .
• Responsibities in Monitoring 24/7 Production Support and Performed upgrades from Oracle 10g to 11g and applied patches.
• Supported team to ensure process compliance for Quality and timely updates of the ticket management system.
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager 12cOEM .
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Performed initial load using exp/imp, Data pump, DBlinks and Golden gate proprietary initial load process.
• Creating Tables, indexes, triggers to assist developers. Managing, troubleshooting and resolving oracle database, RAC and applications issues.

Confidential

Sr. Oracle DBA

Environment:Oracle 11.1, 11.2.0.2, 11.2.0.3, ASM, RMAN, OEM 11g, Golden Gate,SQL Developer, DataModeling.

Responsibilities:

• Worked on Planning Database, Sizing table space, Create database, scripts, Monitor databases, 24x7 production support.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Responsible for DBA functions and ETL development in Data ware housing.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Configured and Upgraded to Oracle 11gR2 from 10g and from 11.2.0.2 to 11.2.0.3
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager OEM .
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Installed Golden gateas replication process for the Client's Data Store method.
• Monitored Replication Issues using Golden Gate Director, Golden gate logs and Supplemental Logging.
• Expertise in configuring Golden gateExtract, Pump Replicate.
• Performed initial load using exp/imp, Data pump, DBlinks and Golden gate proprietary initial load process.
• Used Golden agate to achieve zero/minimal downtime migration for large databases.
• Created materialized views, table partition for Tuned databases.
• Written, tested and implemented various PL/SQL and SQL scripts to monitor the pulse of the database and system.

Confidential

Sr. Oracle DBA

Environment: Oracle 10g, 11.1, 11.2.0.2, 11.2.0.3, ASM, RMAN, OEM 11g, Golden Gate, IBM-AIX, RHEL, Shell scripting, TOAD, SQL Developer.

Responsibilities:

• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Involved performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 11g RAC on a test basis.
• Responsible for DBA functions and ETL development in Data ware housing.
• Configured, Implemented ESM tool for JPMC Audit and Security standards.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups with Export /Import , Database backup Hot cold .
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Configured and Upgraded to Oracle 11gR2 from 10g and from 11.2.0.2 to 11.2.0.3
• On-Call 24x7 DBA support for production databases.
• Implemented Guardium tool for audit database. Performed security remediation and auditing for the databases using ESM tool.
• Database Restore using RMAN, Cold Backup, Export and Flash Recovery.
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager OEM .
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Installed Golden gateas replication process for the Client's Data Store method.
• Used Golden agate to achieve zero/minimal downtime migration for large databases.
• Created materialized views, table partition for Tuned databases.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system.

Confidential

Sr.Oracle DBA,

Environment: Oracle 9i,10.2.0.4,11.1.0.6,IBM Manage NOW,Remedy,SQL Server 2000/2005, OEM 10g grid, SQL Loader, Windows XP, LINUX,WebSphere,Solaris5.9,TOAD,SQL Developer

Oracle 8i/9i/10g RAC/ASM/DATA GUARD/RMAN/SQLTuning/Upgrade/Migration/Space Estimation/24 7 support

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2 10.2.0.1, 10.2.0.2 and 10.2.0.4 11g Release 1 11.1.0.6,11.1.0.7 upgrades on all the environments in a procedural approach Dev, Test, Stage and Production also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Created routines for Daily, Weekly Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Worked on using the Materialized views for large Data Replication between 2 production databases.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time, ran SQL trace and generated TKPROF reports.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab UNIX , Scheduled Tasks Windows and Maestro 7.0 Job Scheduling Tool .
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used new oracle Metalink.

Confidential

Sr.Oracle DBA

Environment: Oracle 9i,10.2.0.2,11.1.0.7,Maestro 7.0,HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL Loader, Windows XP, IBM AIX 5.3,WebSphere,Solaris5.9.

Oracle 8i/9i/10g RAC/ASM/DATA GUARD/RMAN/SQLTuning/Upgrade/Migration/Space Estimation/24 7 support

Responsibilities:

• Involved in 24x7 Oracle Production Database Administration.
• Involved in installation, configuration and support of Oracle 10g RAC.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98 of the time.
• Resolved gaps between primary and standby databases Gap Resolution .
• Created physical standby database for disaster recovery from hot backup of primary database.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Creating Tables, indexes, triggers to assist developers.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Experience with Oracle Golden Gate software.Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Writing UNIX shell Scripts and Scheduling through crontab.

Confidential

Sr. Oracle DBA,

Environment: SQL Navigator, Oracle 8i, 9i, 10.0,WebSphere, data Stage, Remedy, clear quest, Sun Solaris, H.P, Windows2000, PL/SQL, Shell Scripts, Maestro Oracle 8i/9i/10g /DATA GUARD/RMAN/SQLTuning/Upgrade/Migration/Space Estimation/24 7 support

• Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site Disaster Recovery site at frequent intervals and apply to the Standby Database as per Business requirements.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning
• Performed Smoke testing during the installation of every full build for application to validate the fitness of the application for testing.
• Implementation of RAC, ASM, DATAPUMP,FLASH BACK Recovery
• Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site Disaster Recovery site at frequent intervals and apply to the Standby Database as per Business requirements.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• Migration of Oracle DB from 8.1.6.3 to Oracle 9.1.0.4/Upgraded the databases from 9.2.0.7 to 10.2.0.2
• Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
• Monitoring the performance of production database through Instance Monitor Quest Tool and growth of the database and suggesting for change in parameters if required.

Confidential

Oracle DBA,

Environment:Solaris 2.6/2.8,RHEL, HP-UX, AIX, Linux Red Hat, Windows 2000/2003 Oracle 8i 8.1.6/8.1.7 , Oracle 9i/10gR1, Oracle Enterprise Manager,SQL Plus, PL/SQL, SQL Loader, SQL Server 2000, Windows NT shell scripting,

• Oracle 8i/9i/10g /DATA GUARD/RMAN/SQLTuning/Upgrade/Migration/Space Estimation/24 7 support
• Database Design, Backup Recovery.Tuning the Database and Analyzing the Database.
• Coding PL/SQL Shell Scripts, Design/Code reviews.
• The activities included the database administration of the various databases assigned to the division for the internal as well as external clients.
• Installation of the Databases, Environment Building to OFA compliancy.
• Backup Cold, Hot, Online, Exports, Remote sessions tracing.
• Recovery Manager RMAN Implementation and strategies, Various Database Recovery scenarios verification in advance. Implementation of RAC Technology.
• Software design of medium/large business applications, Design methodologies.
• Jobs Scheduling, Exports/ Imports, Space Management.
• Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.
• SGA, I/O, OTIMIZATION, SQL- tuning, Security Management.
• Remote Database Access Security management 24 x 7 Monitoring.
• STANDBY Database implementation and Automation of the process KSH, LOADER, PL-SQL scripting combination of ftp download of files to proper load and update on tables.
• Writing shell scripts, Loading data into the database from the flat files with SQL Loader.