SUMMARY

• Over TWELVE years of professional experience in teh IT industry, including NINE+ years as an Oracle Database Administrator working in Production Business critical environment with 24x7 support.
• Expertise in Oracle Database Administration (Oracle 11g/10g/9i/8i/8) on Solaris, HP - UX, AIX and Windows environments.
• Extensive Experience in managing technology projects. Strong skills in various phases of SDLC (me.e. reviews of Software Requirement Specifications, Software Design Document along with Unit Test cases, QA/Testing processes & methodologies, Release, General Availability, etc.).
• Exposure and good understanding of Project Management (Completed PMP Prep Course).
• Expertise in performance tuning in large OLTP (1.6 TB) and data warehouse environments.
• Experience in Database Security & Audit - Implemented CIS (Center for Internet Security) recommendations for Oracle 10g & 11g (One of teh independent Reviewers of CIS benchmark for Oracle 11g)
• Experienced in devising backup and disaster recovery (including RMAN) strategies - includes interface with EMC Time Finder BCV (split mirror), etc.
• Involved in data access rules and security (role based access).
• Experience in SQL & DB Tuning, Proficient in Application and Database Performance Tuning (SQL Profiles, AWR, ADDM, Tuning Memory, Tuning me/O, Wait Events, trending (time-based analysis), analyzed high CPU spikes, etc.).
• Experience in Configuration & implementation of ASM.
• Expertise in building Oracle RAC environments in mission critical large OLTP systems.
• Expertise in Oracle Enterprise Manager (10g, 11g) - upgraded 10g (10.2.0.4) to 11g (11.1) (including agents upgrades, etc.).
• Involved with Standards, Capacity planning (trend analysis - monthly/quarterly growth).
• Recommendations for Strategy for Patch Implementation (CPU’s & PSU’s) - including patch conflicts.
• Interacted closely with Change Management Team, Configuration Management Team, Development & Testing teams, etc. - Implementation of DB schema changes as per approved Work Request.
• Designed & written UNIX shell script to refresh Production data to non-Prod DB’s.
• Experience in creation, up gradation, & maintenance of Oracle databases on different flavors of UNIX & Windows environments.
• Experienced in cloning teh database using cold and hot backups (Net Backup BCV split mirror technology).
• Experience in Oracle Streams, Advance Queuing, etc.
• Co-ordination with other IT team managers and support teams to ensure teh Business Ops are not impacted.
• Knowledge of DB2, SQL Server, etc.
• Best Practices for Databases (Center Of Excellence).
• Mentoring and leading team of DBA’s.
• ITIL Foundation Certified. - 2007.

TECHNICAL SKILLS

Database: Oracle 10g (10.2.4), 11gR1 & R2 (11.1.0.6, 11.1.0.7, 11.2.0.2), Oracle 9i (9.2.0.8)SQL Server 2000/2008

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

Systems: Unix, Linux and Windows which include IBM AIX - P570/P590/P690 / Linux, Sun Ultraspac, Solaris v.2.6 - 10, HP Tru64 server, VMS, Microsoft Windows NT/2000/2008/XP client/ server.

Tools: TOAD, Confidential Patrol, Confidential SmartDBA Suite, SQL*Loader, Precise i3, OEM (10g (10.2.0.4), 11g (11.1.0.7, 11gR2), Control-M, OS Watcher

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr Oracle DBA SME Consultant

Responsibilities:

• Managing Business Projects as a Senior Oracle DBA SME (Subject Matter Expert)
• Managing High priority Business environments
• Priorities includes 24 x 7 Production Support OLTP databases & Data Warehouse DBs
• Audit setup, RMAN Backup setup, Data Pump, Data Refresh, etc.
• Configured Oracle RAC 11g R1, 11gR2 (2 & 3-nodes) with Data Guard (Physical Standby) & ASM
• Worked closely with Oracle Support on issues on node reboots, 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.
• Mentoring and leading a team of DBA Consultants

Environment: Oracle 10g, 11gR1 & 11gR2, AIX 6.1/7.0 (64 bit), Sun Solaris, Linux, SQL,PL/SQL, Shell Scripting, RMAN, Data Guard/Physical Standby, ASM, Veritas NetBackup, Control - M, BCVOEM, TOAD, SQL Developer, OS Watcher

Confidential, NYC

Oracle DBA

Responsibilities:

• Priorities include 24 x 7 Support of 100+ Live OLTP databases & 50+ Data warehouse / QR DBs.
• Mentoring and leading team of DBA’s Consultants.
• Audit & Security Implementation - CIS - 10g, 11g.
• Involved in setting up backups (including Logical Export /Import Data Pump, & physical RMAN).
• SQL & DB Tuning - SQL Profiler, Index, stale Statistics, HINTS, Flush Memory etc.
• 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).
• Patch Maintenance (CPU’s & PSU’s).
• 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 teh process of Data Refresh.
• Created & Implemented Daily DBA Checklist.
• Disaster Recovery Solutions.
• 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.
• Handling complete and incomplete recovery in case of database failure.
• AWR, ADDM, SQL Profiler, SQL Advisor, Tracing, Hang analyze, etc.

Environment: Oracle 9i/10g/11g, AIX 5.3 / 6.1 (64 bit), SQL, PL/SQL, Shell Scripting, RMAN, Veritas Net Backup, BCV, OEM, TOAD, Precise i3, Oracle Streams, Reorg, IBM Clear Quest Tool, etc.

Confidential, NY

Oracle DBA

Responsibilities:

• DB Installation & Upgrades (9i to 10g release 2 – 10.2.0.3).
• Change Management Tool – IBM’s Rational Clear Quest.
• Session tracing, TkProf etc.

Confidential, TX

Oracle DBA & Sr. SQA Engineer

Responsibilities:

• Oracle DBA & Lead QA/Testing.
• 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).
• 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.
• Installed and configured RAC with ASM on IBM-AIX 5.3 Servers.
• Worked with Defect Tracking tools – Vantive & Remedy.
• Extensively worked on SQL* Loader to load data from other databases and text files into Oracle Database.
• Confidential Unload for Oracle product for unloading teh data from databases.
• Involved in Upgrading and migrating different databases versions from 8i (8.1.7) to 10gR1 (10.1.0).
• Using export and Import utilities to take logical backups.
• 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 Confidential Space Expert for Oracle tool.
• Setting up Oracle 10g databases on Solaris.
• Performing database re-organization to get rid of fragmentation.
• Troubleshooting connectivity issues and network problems.
• DB Administration of databases up to size of around 600 GB.
• STATSPACK for performance tuning of databases.
• Imparted training to Customer support Teams on Confidential Space Exert for Oracle product.

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

Confidential

Analyst Programmer (Oracle DBA)

Responsibilities:

• Teh scope of teh project was to handle multiple databases geographically separated. dis is essentially a distributed database environment.
• Planning teh 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 teh 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 teh Analysis of requirements of teh Business Rules, and converts them to Design Business Rules.

Environment: Oracle 8.1.5, Sun Solaris 2.6, Windows NT 4, SQL Server 2000.

Confidential

System Officer (Oracle DBA)

Responsibilities:

• Creating /Adding table spaces, data files, rollback segments, etc. as per teh need.
• Creating & Managing users, roles, and their privileges, etc.
• Backup & Recovery - both logical & physical Backup.
• Recovery in case of crash. Performance & tuning of database - at both query & database level. Time-to-time planning for tuning of database.
• Have knowledge of Dedicated, distributed & parallel servers. Maintenance of SWIFT system at teh System Management level