SUMMARY

• Confidential has total IT experience of 15 years and over 7+ years of experience in Production Support, Upgrading, Installing, Configuring and Maintaining VLDBs and Production databases.
• Oracle Certified Professional (OCP) Oracle Database Administration.
• Extensive experience on RAC Installation on windows/Linux, Backup & Recovery Setup, DataGuard Configuration, Replication using GOLDEN GATE, Database creation on EXADATA.
• Upgraded 11g databases to 12c on AIX/Linux/EXADATA on ASM/NON - ASM environments
• Performed replication on RAC/NON-RAC using Golden Gate
• Implemented Database replication using HITACHI storage replication
• Performed OS/DB/CPU/Application patching and any infrastructure changes including refreshes
• Peformed replication using MVs and Golden Gate to replicate data from PROD to NON-PROD
• Design, implement and test strategies for backup and recovery
• Manage End-to-End Integration process, Coordinate ITO vendor/hosting vendor/business
• Enhanced Security at Server level, Database level and Application level using - Roles & Privileges, Auditing, Fine-grained Auditing, Virtual Private Database (VPD) & Label Security
• Provided High Availability for 24*7 applications using - Perf & Diag Pack, AWR, ADDM
• Setup and Configured DATAGUARD on Test & PROD servers

TECHNICAL SKILLS

Oracle Database Administration: ORACLE 12.1.02/11.2.0.3/10.2.0.4

RAC: Clusterware: 11gR1/R2, ASM 11gR1/R2, DB 11gR1/R2

OS: Linux 5.0, HP-UX, WINDOWS 2008/2003 Server

Replication: Golden Gate

Oracle DBA Tools: OEM Grid Control (Performance Tuning + Diagnostic Pack) & StatPack, RMAN, Export/Import, TOAD

Oracl New Features: ASM, ADM, ADDM, Flash Recovery, Replication, Streams

Third Party Tools: Putty, VNC, FSecure, SM9, COSIMA, SOM@SAP

Development Tools: FORMS 10G, REPORTS 10g, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Sr. Oracle Database Administrator

Responsibilities:

• Implemented & Maintained Disaster Recovery for TEST/DEV/STAGE & PROD Environments
• Supported Critical Applications used by 1000+ users on 24*7 basis
• Implemented Backup & Recover strategy on Prod Environments using RMAN / FLASHBACK / SNAPSHOT / SHADOW-THIN IMAGE REFRESH technologies
• Provided Support during critical migrations - data migration / database migration / OS migration
• Performed CPU & one-off patches on Prod / Non-Prod environments new versions are released
• Trained Jnr. DBAs / End-users / Business Analyst regarding new database features
• Co-ordinated with Storage / Network / Unix / Application Teams across the globe during support
• Worked on EXADATA machines: create databases / performance tuning / setup backups
• Upgraded oracle databases from 11.2.0.4 to 12.1.0.2 and resolved post upgrade issues
• Written shell scripts for DB Adminstration, RMAN backups, Performance, Day-to-Day Checks
• Exibited excellent communication skills with end-users/technical teams/management

Environment: Data bases: Oracle 10g / 11g / 12c

Confidential, Ridgeland, MS

Database Administrator

Responsibilities:

• Supported production oracle DB 10.2.0.4 on Linux platforms
• Supported development team of size 20 in enhancing project of the existing prod system
• Used Sybase power designer for data modelling, applying db changes & reverse engineering existing systems for documentation
• Tuned resource consuming querires on prod and dev systems using performance tuning tools - SQLT, AWR, EXPLAIN PLAN, ASH & ADDM
• Monitored changes using DB ADMIN tools - EMBARCARDERO DB Artisan & DB Change
• Manager, SQL Server DB Admin
• Participated in Partitions decision making, capacity planning & development analysis meetings
• Raised SRs to Oracle Support as-and-when required for analysing prod issues
• Support monthly maintenance tasks and resolved/supported critical issues on PROD

Environment: Oracle DB: 10.2.0.4/11.2.0.1/11.2.0.3 SQL Server: 2005/2008/2012

Confidential, Colorado Springs, CO

Database Administrator / Technical Lead

Responsibilities:

• Supported production oracle DB 10.2.0.4 on Linux platforms
• Supported development team of size 20 in enhancing project of the existing prod system
• Used Sybase power designer for data modelling, applying db changes & reverse engineering existing systems for documentation
• Tuned resource consuming querires on prod and dev systems using performance tuning tools - SQLT, AWR, EXPLAIN PLAN, ASH & ADDM
• Monitored changes using DB ADMIN tools - EMBARCARDERO DB Artisan & DB Change
• Manager, SQL Server DB Admin
• Participated in Partitions decision making, capacity planning & development analysis meetings
• Raised SRs to Oracle Support as-and-when required for analysing prod issues
• Support monthly maintenance tasks and resolved/supported critical issues on PROD

Environment: Databases: Oracle 10.2.0.4/11.2.03 on Linux 5.0, Data Modelling: Sybase Power Designer 15.2.0, OS Tools: Putty, WinSCP, TELSA, Tight VNC2.0.4, Performance: SQLT, TRCA, EXPLAIN PLAN, SQL Profiling, Development: SQL developer 3.1.07, SQL, PL/SQLDB Admin: OEM Grid Control, EMBARCADERO-DB Artisan, DB Change Manager

Confidential, Chicago, IL

Production DBA

Responsibilities:

• Clearing tickets raised by HITACHI offshore team on PROD and SUPPORT instances
• Coordinating with onshore analysts and offshore development team
• Checking status of daily backup jobs for purging archivelogs (hourly), refreshing SUPP, DEV, TRAIN, TEST with PROD periodically
• Troubleshooting failed backups, slow-running queries, setting up new users and add/remove privileges on PROD for key development team
• Coordinated with Oracle Support to resolve issues on 24*7 basis

Environment: DBA team of size 4 - 2 onsite and 2 offshore, 16 Oracle Instances(10.2.0.4, 11.2.0.3), 40 Sql Server Instances (2005, 2007), Frontend applications are In-house .net applications & PeopleSoft (Financials on Oracle & HR running on SQL Server)

Confidential, NASHVILLE, TN

Oracle Production DBA

Responsibilities:

• Checked backup jobs using RMAN, Exp dump & check db health of PROD and TRAIN
• Refreshed TRAIN site for training county users as when request comes from DPA
• Monitoring and resolving slow running query issues on PROD and recommend dev team
• Applied Patches for Oracle Server and database tools as when new patches are released
• Coordinating with Oracle Support for troubleshooting issues on 24*7 basis
• Migrated environment from single-server to multi-server environment
• Moved environment from Non-RAC to 2 node RAC environment running on ASM
• Installed GIS environment (ArcGIS tools) on TEST and PROD to access data from oracle and SQL server and publish on website
• Played major role in integrating individual modules to IAS World Website accessed by more than 97 counties in the STATE
• Setup data guard on DR site to replicate data from PROD on regular basis

Environment: DBA Team of size 2, Development Team of size 12 (Applications running on .NET, JAVA, MS ACCESS & Oracle Forms & Reports), Oracle 10.2.0.x/11gR2 OS: Windows 2003/2008 Tools: TOAD8.6.0, SQL Developer Application Server: 10g AS OS: Windows Vista/2003R2/2008R2 RAC: 4-Node (4 processors, 32.0 GB RAM) 64-bit Application Server: Web Logic Server 11gR1 (10.3.5.0), Jdeveloper - 11g (11.1.1.5.0 )

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Installed and migrated databases from 10g to 11g using DBUA, Export/Import
• Discussed with QA Team before generating crystal reports as requested by end users.
• Creation of Application users and assigning the tablespaces, quotas, roles and profiles.
• Imported, created and edited the table definitions using Informatica Designer. Used repository manager to create folders and managed the user’s privileges.
• Written Shell scripts for day-to-day database activities for transfer files from dev server to PROD
• Database Planning, Designing and Setting up of storage parameters for segments.
• Setting up logical/physical backups for these databases. Depending on the nature of database, set up of either Full export, partial export, or export of just the structure of schema objects Using RMAN as well.
• Trained developers, management and end users regarding functionality of new products before implementation setting up Oracle disaster recovery sites using Data Guard
• Experience in writing, modifying and executing shell scripts for database mgmt tasks
• Configured and supported databases running on remote servers using OEM Grid Control

Environment: EBS: 11.5.9.0, 11.5.10.2 Languages: PL/SQL, Java Front End: Forms 6i/10g, Reports 6i/10g, JDeveloper Tools: TOAD8.6.0,SQL Developer Application Server: 10g AS OS: Windows XP, AIX 5.2, WRQ Reflection FTP Client Version Control: WinCVS 2.0.2.4

Confidential

Oracle DBA

Responsibilities:

• Experience in installing and configuring 10g RAC on Linux
• Migrated Oracle databases from 8i, 9i to 10g databases using DBUA, Export/Import
• Experience in implementing and supporting Oracle Streams for Replication
• Used 10g New Features like ADM, ADDM for producing database performance reports
• Creation of Application users and assigning the tablespaces, quotas, roles and profiles as per requirements.
• Experience in using RMAN utility for Hot Backups & Cold backups with various scenarios

Environment: Oracle Reports Builder 6i, Oracle Forms Builder 6i, XML publisher, Oracle 10g, SQL Loader, PL/SQL Developer, TOAD, UNIX

Confidential

Database Administrator

Responsibilities:

• Creating databases, Refreshing Testing/development databases from production.
• Implemented 10g New Features ASM, OCFS, ADM, ADDM for prod database performance
• Database Planning, Designing and Setting up of storage parameters for different segments.
• Tuning of rollback segments by estimating the transaction volume and transaction rates in 8i and later creating undo tablespaces in 9i and setting up undo retention parameter.
• Setting up logical/physical backups for these databases. Depending on the nature of database, set up of either full export, partial export, or export of just the structure of schema objects Using RMAN as well.
• Tuned the application for better performance by using explain plan and running the tkprof utility and Statspack.

Environment: Oracle Apps 11.5.10, GL, PO, AP, AR, Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, TOAD, Discoverer 10g, Windows XP, UNIX, XML Publisher

Confidential

Oracle DBA

Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products
• Establish and maintain sound backup and recovery policies and procedures
• Implemented and maintained database security (create and maintain users and roles, assign privileges)
• Directing & leading a backend team for ensuring seamless operations & services to clients. Heading database administration functions and complying with all rules & regulations pertaining to the same.
• Handled DB Operations and involved in creating / upgrading/ configuring Oracle DB
• Involved in code migration, database change management and data management through the various stages of the development life cycle

Environment: ORACLE 8i, 9i, SQL Server 2000/2005, Oracle Forms, Reports, SQL, PL/SQL, VB 6.0, Crystal Reports, Windows XP, Linux

Confidential, Sunnyvale, California

Database Analyst

Responsibilities:

• Directing & leading a backend team for ensuring seamless operations & services to clients.
• Handling Database Operations and creating / upgrading/ configuring databases 8.0 - 8.1.6 & Oracle Software.
• Perform application tuning and performance monitoring
• Involved in code migration, database change management and data management through the various stages of the development life cycle
• Setup and maintained documentation and standards