SUMMARY:

• Highly accomplished Senior Oracle professional with a proven track record of managing and delivering complex IT projects and exceeding expectations. Over 15 years of IT experience, specializing in maximizing the functionality of Oracle Projects. Subject Matter Expert and Thought Leader possessing technical knowledge of complex Financial, Banking, Healthcare & Mobile/Cellular Systems. An astute leader who adds value through proactive decision - making and business process. Track record for defining, building and optimizing best-in-class Databases and operations. Define enterprise technology strategies/solutions that reduce costs, improve efficiencies, support organizational goals and maximize the technology investment.
• Database Strategy & Execution - Expert in devising Databases upgrades across platform, Best Practices strategy & implementation, Audit & Security Strategy & Implementation for Databases, and build cost-effective and scalable solutions that support business
• Global (Oracle) Operations - SLA escalation Management, RCA Management on database projects on follow-the-Sun-model approach (across the US, Europe, Asia-Pac and the Middle East)for Top 10 Fortune Financial Enterprise (JP Morgan Chase)
• Leadership & Talent Development - Leading a Team of 3 DBAs & ability to attract and lead top IT talent and create team cultures based on performance and innovation. My Team was ed “Best Performance Team of the Year” & I was ed “Excellence ” in BMC Software
• Recognition - Have been “Employee of the Quarter - BMC Inc. ” for consecutive 2 Quarters

TECHNICAL SKILLS:

Database: Oracle 10g (10.2.0.4), 11gR1 & 11gR2 (11.2.0.3, 11.1.0.6, 11.1.0.7, 11.2.0.2.7 ), SQL Server 2000/2008, DB2 UDB v8.2

Languages: Shell, Awk, Sed, SQL, PL/SQL

Systems: Exadata, Unix, Linux and Windows which include IBM AIX - P570/P590/P690 / Linux RHEL 5.5, Solaris 10, HP Tru64 server, VMS, Microsoft Windows 2008/XP client/ server

Tools: TOAD, BMC Patrol, BMC SmartDBA Suite, SQL*Loader, Precise i3, OEM (10g (10.2.0.4), 11g (11.1.0.7, 11gR2),Autosys, Geneos, Control-M, OS Watcher, IBM CDC, Golden Gate, Veridata, Oracle Streams (Transparent Gateway DRDA), ACFS, EMC BCV, SRDF, EMC Storage, etc.

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA

Confidential, NJ

Responsibilities:

• Managing Business Projects as Senior Oracle DBA SME Level-3 - Projects handles huge transaction over wire daily (CIB - Corporate Investment Bank)
• Priorities includes 24 x 7 Production Support 150 Databases (DB size upto 4 TB) - uptime of 99% - MAA architecture - handling P1/P2 issues, etc.
• Strategic planning, engineering & Implementation effort in devising migration of Complex Databases (around 100 small to medium size (<1 TB)) from AIX based machine to Linux based machines (involving Golden Gate-Veridata, Oracle Streams (Gateway DRDA)) & IBM CDC replication, etc.)
• Level-2 escalations, SLA & RCA Management (for outages,etc.)
• Part of the project to optimize data backups / storage enabling faster analytic reporting reducing project’s annual technological maintenance costs by $20 million, including cost savings by consolidating DB’s
• Devising Database Backups Plans, Disaster Recovery & Business Continuity Plans (MAA architecture) & coordination with Project Management, Change Management, AD Teams, QA/Testing Teams, etc (include liaising with Senior Stakeholders with regards to incident (Peregrine queues) and Change Management (ITSM) tasks, etc
• Solved critical issues through pro-active decisions on Oracle streams - ahead of Planned GO-LIVE date - saved the organization $$$
• Devised & implemented TTS (Transportable Tablespace) involving 1TB of PROD data on Linux
• Solved NetBackup Tapes Utilization for RMAN Backups - saved $$$ for CIB estate
• Hands on devising Backup and Disaster recovery (including RMAN) strategies - includes DR-Physical Standby (ADG - Active Data Guard) DB’s & interface with EMC BCV,SRDF (split mirror), EMC Recover Point, etc.
• Member of JP Morgan’s Golden Gate Best Practices Team
• Suggestion & implementation of Best Practices on 11gR2 RAC
• Audit setup, RMAN Backup setup, Data Pump, Data Refresh, etc. (followed Global Best Practices)
• Installation & configuration of Oracle RAC 11g R1, 11gR2 (3 nodes) with Active Data Guard (Physical Standby) & ASM
• Administration of 2 & 3 nodes RAC environments (including PSU upgrades, etc.), OEM Grid Control, etc.
• Performance Tuning of Oracle 11g RAC (Tuned the systems resulting in 20% overall performance increase)
• Involved with Best Practices, DB Standards, Capacity planning (trend analysis - monthly/quarterly growth)
• Worked closely with Oracle Support on critical issues on node reboots, RMAN backup failures, etc.
• Experienced with Table Partitioning, Load Balancing in Oracle RAC implementation
• SQL & DB Tuning - AWR, ADDM, ASH, SQL Profile, SQL Outlines, Index, HINTS, Wait events, Oracle Streams, etc.

Senior Oracle DBA SME Consultant

Confidential

Responsibilities:

• Priorities includes 24 x 7 Production Support Datawarehouse DBs (upto 40 TB) on Exadata
• Recovered 12 TB Database (data corruption issues, data block recover, etc.)
• Performance Tuning (VLDB) – upto 40 TB (SQL tuning, Profiles, Bind Peeking issues, Optimizer Tuning, etc)
• Install Oracle RAC 11gR2 (4 nodes) & create DB with Data Guard (Physical Standby) & ASM (Exadata machine)
• Best Practices implementation on PSU upgrades, RMAN Backups, Tuning, etc.
• Oracle Golden Gate monitoring
• Oracle PSU upgrade 11.2.0.2.7 (from 11.2.0.2) on 5 node Production (12 TB database size)
• RMAN Backup strategy, Data Pump, Data Refreshes, etc.
• Experienced with Table Partitioning, Load Balancing in Oracle RAC implementation

Oracle DBA Consultant

Confidential

Responsibilities:

• Priorities includes 24 x 7 Support of 100+ Live OLTP databases & 50+ Datawarehouse/QR DBs
• Patch Maintenance (CPU’s & PSU’s)
• SQL & DB Tuning – AWR, ADDM, SQL Profile, SQL Outlines, Index, stale Statistics, HINTS,etc.
• Audit & Security Implementation – CIS – 10g,11g
• Oracle 10g RAC (2 node) with physical standby
• Involved in setting up backups (including Logical Export /Import Data Pump, & physical RMAN)
• Oracle Streams (9i, 10g)
• DB Installation & Upgrades (9i – 9.2.0.8 to 10g release 2 – 10.2.0.4, 10g – 10.2.0.4 to 11g - 11.1.0.7))
• Monitoring of databases to identify performance issues – using Precise i3, OEM, TOAD, etc.
• Data Refresh from Production to Development, testing & production ready environments – written a shell script to automate the process of Data Refresh
• Created & Implemented Daily DBA Checklist
• Written shell scripts to purge tables, & perform Reorg (using shrink command etc.)
• Written Shell scripts for automating online backups (Export/Import, Data Pump, RMAN Backups etc.)
• Capacity Planning
• AWR, ADDM, SQL Profiler, SQL Advisor, Tracing, Hang analyze, etc.

Oracle DBA & Team Lead SQA Engineer

Confidential

Responsibilities:

• Oracle DBA & Lead QA/Testing (Led a Team of 8)
• Managed QA/Testing Process (QA Acceptance Testing, regression Testing, System Testing, Integration testing etc.) for Full SDLC Cycle for SmartDBA Product Line (Products Included Space Expert for Oracle, SQL Explorer for Oracle, Unload for Oracle & DBXray)
• Test Plan strategy(s) – part of Team which fetched $100 million Sales deal
• Tuned Databases
• Role of a DBA - Priorities included a 24 x 7 support of five OLTP databases. Involved in setting up backups, database reorganizations, upgrades and monitoring of databases to identify performance issues
• BMC Unload for Oracle product for unloading the data from databases
• Involved in Upgrading and migrating different databases versions from 8i (8.1.7) to 10gR1 (10.1.0)
• Involved in Supporting high potential Products (SmartDBA Performance & Administration Tools – Oracle & DB2 - Space Expert, Unload for Oracle, SQL*Explorer, DBXray) from DBA perspective
• Space Management using BMC Space Expert for Oracle tool
• Performing database re-organization to get rid of fragmentation
• Imparted to Customer support Teams on BMC Space Exert for Oracle product

Environment: Oracle 9i/10g, Sun Solaris 9.0, AIX 5.3, PL/SQL, Shell Scripting, RMAN

Analyst Programmer

Confidential

Responsibilities:

• The scope of the project was to handle multiple databases geographically separated. This is essentially a distributed database environment
• Planning the size of rollback segment, optimizing memory, sizing tables and indexes.
• Performance tuning of Oracle database by optimizing SQL, PL/SQL code database physical and logical design and database (SGA) parameters.
• Involved in Oracle Migration (from SQL server 2000 to Oracle 8i using Oracle Migration Workbench tool).
• Creation of Database, Tablespaces, Tables, Indexes, Views, Users,
• Deciding Naming Convention for the Tablespaces and rollback Segments Etc.
• Functional experience includes Payroll, Time Management, US benefits, HRMS modules, etc.
• Contribution towards quality by following standardization & methododology. Experience in Unit testing, Integration testing, System testing,etc. Preparation of Test cases, etc.
• PL/SQL coding as large as 6000 lines in SQL server.
• Study of SDLC cycle, and performs the Analysis of requirements of the Business Rules, and converts them to Design Business Rules.

System Officer

Confidential

Responsibilities:

• Creating & Managing users, roles, and their privileges, etc.
• Backup & Recovery - both logical & physical Backup
• Have knowledge of Dedicated, distributed & parallel servers. Maintenance of SWIFT system at the System Management level