SUMMARY:

• Senior Oracle Core DBA and Application DBA with more than 17 years of IT experience.
• Configured and deployed highly complex and high availability solutions in Oracle database, E - Business Suite and Application Server. Strong ability to multi-task and prioritize tasks.
• Strong experience in supporting OLTP, Data Wares house, Oracle Data guard, RMAN, Oracle ERP in single node / multi node (RAC) environments
• Oracle Database Administration: 12 Year
• Oracle Application DBA: 8 years
• Application Design: 5 years
• Software Development: 5 years
• A very good understanding of RMAN for database backup and recovery
• Configuration of Data guard for High availability and DR solution
• Experience in supporting 11g / 10g RAC production and development instances
• Experience in supporting Oracle Exadata
• Deep understanding of Oracle internals including wait events and optimizer.
• SQL and PL/SQL code review and tuning for identifying performance enhancements, ensuring best practices compliance, readability and ease of maintenance.
• Expert level understanding and experience in architecture, administration of all components of technology stack with in Oracle 11i and Release 12 E-Business Suite.
• Solid experience in cloning, patching, monitoring, performance tuning.
• Deployed Disaster recovery for E-Business suite
• Converted Database and Applications character set for Multi-lingual support
• Upgraded 11.5.9 to 12.0.6
• Solid experience in production support for mission critical 24X7 systems.
• Solid experience and understanding of Purchasing, Payables, General Ledger, Inventory modules. Strong ability to support business processes and users.
• Capacity planning, sizing, installation, configuration, tuning for major customers.
• Strong leader with ability to clearly define and structure projects for efficient, effective and on-time delivery
• Lead, coached and mentored DBA teams
• Experienced in setting up development and coding standards for Oracle 11i, R12

SKILLS SUMMARY:

Oracle DBA: Administration, Performance Tuning for memory, IO, SQL tuning, RMAN Backup & Recovery, Oracle Data Guard, Real Application Cluster, ASM, Oracle Golden Gate, VeridataOracle Advance Security

ERP Software: Oracle Applications R12,11i and 11.0.3 ( 11.5.10, 11.0.3)

Oracle Apps DBA: Installation, Patching, cloning, Concurrent Program Administration, Workflow administration, application and User Management Utilities adpatch, adadmin, adctrl, adsplice, admrgpch, rapid clone, adconfig

Backup tools and Hardware: IBM Tivoli Storage Manager, Netbackup, RMAN, Data Domain, ZFS

Oracle Development Tools: TOAD,SQL* Plus, Quest Central

Database Design: Oracle 11g,10g/9i/8i/7.x, Data design and data modeling

Data Migration Tools: SQL* Loader, Export /Import, data Pump

Applications Modules: Finance, HR,Order Management, I-expense, Manufacturing

Reporting and Data Warehouse Tool: Discoverer 4i/9i/10g, Oracle OFA 6.4 / OES 6.3.2 and DPA

Programming Languages: SQL, PL/SQL, Unix shell Scripting

Operating Systems: Linux (Red Hat), HP Unix, Sun Solaris, IBM Aix, Windows, Novell Netware

Support Tools: Kintana (For Patching and cloning ),Precise, Quest Central, Tkprof (SQL Tuning) Tracker, Remedy (Opening closing Tickets),Erwin (E/R Diagram), Markview (Invoice process)

Other Languages: dBase, Clipper, D2K, PowerBuilder, C

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Senior Oracle Database Administrator

Responsibilities:

• Support 24x7 mission critical PlayStation Gaming platform with databases version 11g
• Responsible to support Active / Passive seven node mission critical 20 TB RAC OLTP database with aggressive SLA
• Supported 300+ TB Data - warehouse on X2/X3 16 node Exadata machine
• Configured and supported Golden Gate for OLTP and Warehouse environment
• Upgraded CRS and RDBMS to 11.2.0.4
• Configured RMAN backup for mission critical databases
• Implemented TDE for PCI data
• Used Veridata to validate OLTP replication

Environment: Redhat EE 5.10, Oracle Linux 5, HP 3par storage, Oracle ZFS appliance, Data Domain, Oracle Exadata database machine X2 / X3

Confidential, San Diego, CA

Senior Oracle Database Administrator

Responsibilities:

• Support 24x7 mission critical production databases version 11g/ 10g and9i, and oracle R12 ERP instances
• Configured Oracle data guard for DR setup for all Tier 1 database
• Applied bundle patches to Oracle Exadata database machine
• Upgraded CRS and RDBMS to 11.2.0.2 in Oracle Exadata database machine
• Configured RMAN backup for mission critical databases
• Installed and configured 10g/ 11g multi node RAC environment
• Installed and configured OEM to monitor databases and hosts
• Design, Installation, Configure and upgrade of Databases
• Setup and managed custom application development environment to in corporate customizations into Oracle E - Business suite
• Cloning, Patching and other routine maintenance of applications
• Maintaining 12.0.6 oracle application on multi nodes and providing 24*7 support
• Upgrade of 11i (11.5.9) to R12 (12.0.6)

Environment: Sun Solaris 5.10, Oracle Linux 5, Oracle v 9i, 10g,11g Application 11.5.9, Release 12, Oracle Exadata database machine v2

Confidential, San Diego, CA

Senior Oracle Application Database Administrator

Responsibilities:

• As an Oracle DBA in a team size of 5 with the database size of 600GB on 6 nodes
• Design, Installation, Configure and upgrade of Databases
• Setup and managed custom application development environment to incorporate
• Maintaining stand - by databases and Single sign on instances
• Support production and application development and test instances and also supporting other 10g, 9i and 8i databases.
• Maintaining 11.5.10 oracle application on multi nodes and providing 24*7 support
• Cloning, Patching and other routine maintenance of databases and applications

Environment: Sun Solaris 5.9, Oracle v 9i, 10g, Application 11.5.10, Release 12

Confidential, San Diego, California

Senior Oracle Application Database Administrator

Responsibilities:

• As an Oracle Application DBA in a team size of 6, with a maximum database size of 1.2TB supporting 13 instances of different types like production, development and patch.
• Providing 24*7 support to users on 11.0.3 and 11.5.10 applications (2 Production, 11 Development instances)
• Apply Patches on Oracle Application using ADPATCH (11.0.3, 11i)
• Cloning Oracle application using Rapid clone (11i)
• MLS (Multilingual Support) conversion and configure PASTA printer configuration
• Installation and integration of discoverer 10g with 11i
• Workflow configuration (11i)
• Regenerate, relink application using adadmin (11.0.3, 11i)
• Evaluating performance on SQL queries, Database and application (11.0.3, 11i)
• Installing and supporting 10g iAS servers
• Providing support on Discoverer, OFA, Data where housing application, Markview ( 170 Systems), Precise, ADI
• Documentation as per SOX compliance

Environment: HP-UX 11i, Oracle v 10g,9i,8.0.6, Application 11.5.10, 11.0..3

Confidential

Oracle Application Database Administrator

Responsibilities:

• Support and monitoring of 11i (from 11.5.3 to 11.5.9) Production, test and development instances
• Cloning 11i instances and database using Adclone, Rapid clone, autoconfig
• Cloning and Patching using Kintana and Merant tracker tool
• Concurrent managers maintenance and administration
• Support and monitoring of RAC production and test instances
• Performing regular DBA activities like object monitoring, object space management, file system space management, alert logs and Backup and Recovery
• Taking online and offline backups using IBM Tivoli storage manager
• 24x7 mission critical database support
• Managing Oracle 11i using AD utilities
• Applying Patches

Environment: IBM AIX v5, Oracle 9i, Application 11.5.8,11.5.9

Confidential, Littleton, MA

Senior Oracle Database Administrator

Responsibilities:

• Provide production support to customers and work with developers.
• Oracle 8i/8.0.5 Installation and configuration on UNIX, Windows NT Servers
• Migration of various Oracle 8.0.5 databases to oracle 8i
• Provided JDBC, Web logic and Oracle XML support for the application
• Regular database administration of production and development database
• Developing Backup and recovery procedure and implementation
• Providing Application support in 24*7 environment on 3 - tier application
• Handling configuration and troubleshooting for Web logic and JDBC
• Writing extensive PL/SQL code including triggers, stored procedures and packages
• Tuning the application for better database performance
• Coordinated with development teams in developing Implementation and migration procedure
• Handling various adhoc tasks and writing PL/SQL,XML,Advance Queing procedures and shell scripts for customer specific request for ASP business
• Standby database implementation for Fault tolerance
• Implementation of Row level security using Oracle Fine grain access control
• Supporting developers to write SQL query and management and schema updating on test databases, staging database on NT and Unix.
• Database capacity Planning

Environment: Sun Solaris 2.5, Oracle v 8.0.6,8.1.7

Confidential

ORACLE Database Administrator

Responsibilities:

• Designing and Creating Production Database using ERWIN as a case tool
• Study the company hardware requirement: Calculate the growth of Database and its utilization in near future.
• Installation of Oracle Database 8.0, 8i on Windows NT 4.0, System Administration and Support.
• Creation of Table spaces based upon application and workload, Adding Data files and maintained documentation.
• Provide technical support to IT professionals and train them in tuning SQL.
• Frame the Logical and Physical archive log Backup policy and Frame the Documentation.
• Configuration of Space storage parameters for different types of segments

Environment: NT v4.0, Oracle v8.0, 8i, Developer 2000 (Forms v5.0, Reports v3.0)