Professional Summary

• Result oriented, analytical and self-driven professional seasoned with 12 years of working in a dual role of design/architecture and production support.
• Experience in Installation/Administering Oracle 10g, 9i, 8i Databases of varying landscapes and sizes.­­­­­­­
• Excellent hands-on in database administration over Dedicated Servers, Parallel Servers, Data Guard Servers, Distributed Servers and Very Large Databases (VLDB) of sizes over 23 Terra Bytes on multiple instances which includes tuning, backup & recovery procedures.
• Extensive experience in data center configuration and migration.
• Extensive experience with Oracle patching/ cloning and configuration.
• Extensive experience with implementation of Oracle Advance security Wallet Manager.
• Experience with Oracle stream for the data replication for data mart.
• Experience of implementation of DR (Disaster Recovery) plan with different approach like Dataguard / Oracle streams.
• Experience with implementation of Audit and security implementation on oracle databases.
• Extensive experience in Database Upgrades & Migration from oracle 8i to oracle 9i, oracle 9i to 10g with cross-platform migrations.
• Experience using OEM, Grid control, Erwin, Toad for database administration, monitoring and design.
• Worked extensively on Backup & Recovery online/offline using RMAN, BCV technology & User-Managed physical/logical backups using Import/Export. Along with performing DR drills using BCV’s and Tape recoveries.
• Experience on Performance Tuning & Capacity Planning pro-active and re-active actions for optimal performance complying with business SLA’s.
• Excellent communication, interpersonal and leadership skills along with very good understanding and experience working in a highly qualified environment.

Technical Skills

Databases: Oracle 10g/9i/8i
Operating system: UNIX, HPUX, AIX, Linux, Solaris, Windows
Applications: SQL Navigator, SSH, Reflection X
Monitoring Tools: Oracle 10g Grid Control, OEM, Toad, Net IQ, Veritas
Backup & Disaster Recovery: RMAN, Dataguard
Performance & Tuning Tools: AWR/Statspack reports, ADDM, TKPRF/Trace Analyzer, Oracle 10g OEM Grid control, RDA
Certification:

Oracle9i and Oracle10g Certified Database Professional (OCP), ITIL V3

Professional Experience

Client : Confidential, CA Aug ‘10 Till date
Role : Lead Oracle DBA

Responsibilities

• Partner with architects of different other engineering / application teams to engineer complex technical product in order to provide palpable business solutions to various business divisions as a part of DBA Engineering project activities.
• Oracle streams implementation/administration for live reporting server, database consolidation, zero downtime migration.
• Architecting Oracle Fail safe environments for site critical databases, including configurations, failover testing, tuning, creating standards etc.
• Supervising application of One-Off, patchsets and PSU patches Oracle patches for 10g RDBMS and clusterwares.
• Designing processes and procedures, setting up standards, creation of scripts for installation of Oracle Server software, creation of databases, setup backup using RMAN, DR solutions using tape backup.
• Leading the efforts of performance tuning to scale up the test results in tune with the requirement of the application team.
• Optimizing the downtime for maintenance by coordinating with the different application teams involved in the maintenance activity.
• Strictly followed Change Control/Change management procedures as laid down by the organization in a highly qualified environment.

Environment : Solaris, Oracle 11.x/10.2.x/Cluster-ware, Oracle Grid control, Dataguard, Oracle streams, Toad

Client : Confidential,Pittsford, NY July ‘07 Aug ‘10
Role : Database Architect/ Sr. Oracle DBA

Responsibilities:

• Responsible for 24*7 supporting more than 30 Oracle databases (10g/9i) running on Aix 5.x, HP-UX 11i wherein the major chunk of the databases hold data of OLTP, DSS and other enterprise applications as a Database
• Implemented, administered, reorganized and subsequently tuned all Oracle databases (development production) databases with datacenter migration from Pittsford, NY (oracle 9i on HP UNIX) to Georgetown, TX (oracle 10g on AIX Unix) that save the company an estimated $3 million a year.
• By Implementing the Advance Security Wallet Manger on oracle 10g database, solve many audit and application connectivity issue.
• Successfully migrated Oracle 9i databases to Oracle 10g databases
• Responsible for analyzing and designing the process to implement the oracle patch sets available in Oracle.
• Responsible key member in designing/testing/implementing enterprise level move from user-managed backups to RMAN on Oracle 10g environments.
• Configured database cloning to copy production to other prod copy (for adoc report purpose) using Business Continuity Volumes (BCVs).
• Responsible for Validating Database integrity, security, auditing through SOX twice years to ensure the databases are FDA compliant.
• Involved in performing Disaster Recovery drills twice a year for all production systems using BCV splits of remote standby databases and tape recovery for non-BCV enabled systems.
• Maintaining strong working relationship with customers (UNIX, storage, developers and team leads).
• Prepare validation documents for database setup (installation, configuration, operation, etc.) in a FDA regulated environment.
• Strictly followed Change Control/Change management procedures as laid down by the organization in a highly qualified environment.

Environment : AIX/HP-UX/Windows, Oracle 11.x/10.2.x/9.8.x, SQL Server 2005, SQL, PL/SQL, Korn/C-Shell Script, Toad

Client : Confidential, Jan ‘07 Jul ‘07
Role : Oracle Database Administrator

Responsibilities

• An active member in upgrading & migrating 9i databases to 10g for both OLTP and data warehouses.
• For data-mart design, Implemented Oracle Stream (Advance replication) on oracle 10g.
• Involved in creating, maintaining and refreshing required Oracle instances/databases for development, test and production environments.
• Provided DBA support to the application development and acceptance team, both onsite and offshore for loading and testing data in 10g databases.
• Implemented Oracle\'s Advanced Features such as Partition table, Partition Index, Function Based Indexes
• Was responsible for setting up standards for database maintenance and monitoring.
• Responsible for Report generation, monitoring disk usage, keeping systems healthy for the production environment.
• Implemented changes into the existing cron jobs as per the business needs.
• In conjunction with the security administrator established and managed user access, along with designing and implementation of user environments, also establishing enterprise level security standards.
• Extensively used metalink for resolving technical issues, opening SR and use collaborative support for database related issues.
• Responsible for documenting important scripts and administration of server environment.
• Responsible for conducting weekly meeting, tele/video conference with clients, development teams both onsite as well as offshore.

Environment : AIX- Unix/ Oracle 10g, Sqlplus, PL­­/SQL, Sql Loader, TOAD, Erwin, Korn shell script, Perl Script

Client : Confidential, June ‘06 Jan ‘07
Role : Oracle Database Administrator

Responsibilities

• Responsible for providing on call production support for 24x7 databases running on oracle 9i.
• Performed day-to-day DBA activities like patching, performance tuning, space management, backup & recovery, query optimization, testing and implementation.
• Responsible for installation and configuration of oracle 9i over Aix and Windows platforms.
• Worked through all the stages of SDLC and was involved in requirement analysis.
• Responsible for doing the capacity planning.
• Implemented replication among the distributed sites using materialized views.
• Performed Database Cloning to create TEST and DEV instances
• Responsible for development of database schemas based on project requirement, database setup & configuration
• Responsible for optimizing instance performance and throughput so as to keep in pace with SLA.
• Implemented table and index partitioning for enhancing the query performance for demanding applications.
• Supporting development team with in SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.
• Involved in implementing and managing backup & recovery strategies using user managed process.
• Responsible for scheduling backup scripts in cron to run on timely basis according the strategy.

Environment : AIX/Windows, Oracle 9i, Crystal Reports, Erwin, TOAD

Education

• Bachelor of Engineering