SUMMARY

• Database Administrator with 9 plus years of experience in Planning, Installation, Configuration and Upgrading of Oracle 11GR1/R2, 10G, 9i, 8i 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)
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and documentation.
• 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 Database Replay, 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.
• Design, document, implement, and maintain all backup, recovery including disaster recovery Procedures using RMAN, VERITAS Net Backup.
• 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.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
• Performed complete multi-master replication with updateable Materialized views.
• Strong programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
• Worked on Informix Dynamic Server 9.40.UC6 database administration like daily backup & log maintenance.
• Strong knowledge and experience of managing Oracle 9i, 10g and 11g RAC environments using the OEM Grid Control tools.
• 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.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Expertise in Oracle Golden Gate software.
• Experience in using GoldenGate to support data replication in the Oracle database environment.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR and 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

Operating System: UNIX,LINUX,Solaris, AIX,HP-UX and WINDOWS NT/2000,XP,2003

RDBMS: ORACLE 11g/10.x/9.x/8.x/7.x, Informix Dynamic Server 9.40.UC6 (IDS) and SQL Server 2005.

Oracle Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * LoaderDBVERIFY, TKPROF and STATSPACKAWR, ADDM, OEM, ODM, ERWIN

Backup Tools: VERITAS Netback up 5.3/6.0, BCV Snapshots, Legato

Languages: SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE

Confidential, OH

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.
• Taking Periodic Backup of the databases and the software using RMAN.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Installed Goldengate as replication process for the Client’s Data Store method.
• Monitored Replication Issues using GoldenGate Director, Goldengate logs and Supplemental Logging.
• Expertise in configuring Goldengate Extract, Pump & Replicat.
• Performed initial load using exp/imp, Datapump, DBlinks and Goldengate proprietary initial load process.
• Used Goldenagate 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.
• Data modeling / Logical database design and implementation (including index design)

Confidential, OH

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)

Responsibilities:

• 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.
• Worked on using the Materialized views for large Data Replication between 2 production databases.
• 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.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues (created via IBM-CMR,IMR in-terms of incidents and work orders of different severity levels like Sev1, Sev2, Sev3, Sev4).Used IBM MangeNow.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup / recovery using RMAN. And legato TAPE backup management.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Implemented Transparent Data Encryption (TDE) for compliance related 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.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• 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.
• High level of tracing of Optimizer and SQL performance with events 10053, and 10046 etc, recommend any changes required,
• 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.
• Used DBMS * packages to schedule jobs, re-engineering, gathering statistics, mview refresh...so on.
• 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.
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.

Confidential, MA

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,Informatica Power center 8.1x and 8.6 (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.
• Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Statspack.
• 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.
• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
• Created physical standby database (for disaster recovery) from hot backup of primary database.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• 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.
• Proficiency using Oracle Golden Gate and csscan utility.
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Scripts for Health Check of Databases.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• OS level activities like space monitoring of Mount points.
• Taking periodic backup of the database and the software.
• Automation of Backups.
• Interfacing with Confidential for technical support.

Confidential, NC

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,ERWin4.0, Informatica Power Center, TOAD (Oracle 8i/9i/10g /DATA GUARD/RMAN/SQLTuning/Upgrade/Migration/Space Estimation/24*7 support)

Responsibilities:

• 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.
• Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change.
• 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.
• Functionality testing has been performed against the identified modules.
• Volume management using Verities Volume manager to configure Disk group.
• Configured Verities Net Backup R3.2 is to automate the physical Backup of the Database.
• 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.
• Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change controls
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• User names are changed to new names as per business requirement during migration time.
• Suggested for the Backup strategy as per affordable downtime of production system.
• Worked on Recovery manager to recover the Database.
• Also involved in SQL performance 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.
• Checking the Alert Logs of production Databases for any errors reported by Oracle.
• Export and Import of databases from one database to another databases.
• Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required.
• Writing the shell scripts to automate the Backup and copying the production copies to Test environment. (Scripts to copy from one test database to another database)
• Attending specific requests from online, bug fixing, Bulk rate, Data warehouse Teams.

Confidential, OR

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)

Responsibilities:

• 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, Performance Tuning, Remote sessions tracing.
• Recovery Manager (RMAN) Implementation and strategies, Various Database Recovery scenarios verification in advance.
• Altering the Database objects and files during maintenance.
• Implementation of RAC Technology.
• Database Maintenance, Data warehousing. Data Modeling using Erwin.
• Software design of medium/large business applications, Design methodologies.
• Database (SQL) design, E-R Modeling, Design and Development Of database design.
• 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.
• Troubleshooting and maintaining, Database Recovery, Automation of the Database Start up and Shut down. Database Migrations..
• Snapshots creations and Refreshing.
• Managing the network and service changes on the network of the databases.
• 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.
• Experience in writing Shell scripts to run various Cronjobs.
• Involved in maintenance tasks at sever level.
• Involved in contacting Oracle support about technical issues through Metalink.

Confidential

Oracle DBA/Developer

Environment: Oracle Server 8i, 9i,SQL Server 2000,, PL/SQL, Sun Solaris 2.5, 2.6, UNIX Shell scripting,OEM,SQL*PLUS

Responsibilities:

• Involved in 24x7 Oracle Production Database Administration.
• Installed Oracle 9i for Test and Development databases
• The work involved overall maintenance of Oracle database, backup, recovery and other database related activities.
• Upgraded from Oracle 8i to Oracle 9i and 7i to 9i.
• Performed cloning to create test and development databases.
• Performed backup and recovery including HOT and COLD backup and monitored scheduled backups.
• Diagnosed and troubleshoot databases problems and failures.
• Recovered database from media failures, accidentally dropped tables and data files.
• Constantly monitored performance of database and monitored alert log file and trace files.
• Studied TKPROF, Explain Plan and UTILBSTAT/UTILESTAT outputs to improve performance.
• Monitored growth of tables and undertook necessary re-organization of data as and when required.
• Performed database administration tasks like space management, users, roles, profiles, schema management.
• Configured listeners and created files such as tnsnames.ora and listener.ora and started the listener for making database available to users.
• Created databases manually and by using DBCA.
• Created table spaces, tables, indexes, triggers for custom applications.
• Wrote SQL scripts for daily maintenance activities.