SUMMARY:

• 18 years of experience in Installing, Upgrading, Patching, Cloning, Migrating, Tuning, Troubleshooting, Maintaining and Production Support of single node and multi - node Oracle E-Business Suite environments
• Extensive experience with installing, upgrading, patching, migrating, troubleshooting, tuning and administering Core Oracle, Oracle RAC 10g, 11gR2, 12c and ASM
• Experience as DBA Manager managing a team of database administrators
• Experience in engaging DBAs in locations throughout the Confidential, PacRim, India and EMEA to provide support for 24/7 Global Oracle Applications environment using follow-the-sun model
• Disaster Recovery with Oracle Data Guard
• Experience with installing, administering, patching and supporting Oracle Weblogic Server 11g, SOA 11g and OBIEE 11g
• Experience with Root Cause Analysis and documenting solutions
• Experience with Technical Project Management
• Ensuring effective communication between DBA team, Infrastructure team, Development team, Application team and user community
• Able to manage multiple projects concurrently and meet deadlines
• Strong Problem Resolution Capabilities
• Works with minimal supervision and direction
• Strong verbal and written communication skills
• Oracle Database 12c Administrator Certified Professional (OCP)
• Oracle E-Business Suite R12 Applications Database Administrator Certified Professional

TECHNICAL SKILLS:

Applications: Oracle Applications 12.x, 11.x, Applications System Administration, GL, AP, FA, PO, PA, INV, HR, AR, OM, iStore, iProcurement, Self-service, Siebel 8.1, Siebel Call Center, SOA 11g, OBIEE 11g, Shared APPL TOP

Databases: Oracle 12c, Oracle 11g, Oracle 10g, Oracle 11g & 12c RAC & ASM, Grid Control 11g & 12c, SQL Server 2005/2008/2012, PostgreSQL 9.3

GUI: Discoverer 10g/11g, ADI, Noetix Views, Web ADI

Languages: SQL, PL/SQL

Oracle Tools: Oracle Application Server 11g, 10g, 9iAS, Oracle Weblogic Server 11g, Developer 2000, Developer 6i, SQL*Loader, SQL*Plus, Explain plan, Tkprof, AWR, ADDM, SQL*Trace, Import, Export, Data Pump, Oracle Streams, RMAN, Exadata, TDE

Operating System: IBM AIX 5.x, Sun Solaris 2.x, HP-UX 10.x, Red Hat Linux Enterprise 6.x, Windows 2003, Unix Shell Programming

Hardware: Sun Enterprise 10000, Sun Fire, Sun Enterprise 3000, HP 9000, Dell Linux Servers

Tools: Autotask, Quest Foglight, Quest STAT, Precise i3, Quest Spotlight, TOAD, BMC Patrol, Remedy, Borland Star Team, AppWorx, Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

• Installed, cloned, patched, maintained and tuned R12.1 and R12.2.x E-Business Suite environments
• Upgraded Oracle EBS 11.5.10.2 to 12.2.4
• Upgrade Oracle EBS from 12.2.4 to 12.2.6
• Installed, configured and integrated Oracle Access Manager 11g (OAM) with EBS for Single Sign-on (SSO)
• Installed and administered 11gR2 RAC clusters in 24/7 environments
• Created DR RAC environments using Oracle Data Guard for RAC Primary environments
• Performed database performance assessments and provided recommendations
• Configured Fast Start Failover (FSFO) and Client Failover using Data Guard
• Experience with configuring, supporting Active Dataguard, Snapshot Standby and Physical Standby databases.
• Performed Quarterly DR readiness exercises
• Installed, configured and administered Oracle Enterprise Manager Grid Control 12c
• Installed Oracle Applications Management Pack on top of OEM 12c
• Performed database refreshes
• Created SOPs and WIs on various topics including EBS Patching, RAC install, Backup & Recovery

Oracle DBA Consultant

Responsibilities:

• Installed and administered Oracle RAC 10g, RAC 11g, ASM and Core databases
• Upgraded Oracle RAC and Core Oracle databases from 10g to 11g
• Installed and administered Oracle Data Guard 11g including use of Data Guard Broker
• Automated creation of Standby RAC databases with scripts
• Implemented and supported Active Data Guard and Snapshot Standby Databases
• Performed Quarterly Disaster Recovery Testing including Switchover
• Migrated databases from Solaris to Linux
• Migrated databases from Windows to Linux
• Installed and supported OEM 11g and OEM 12c
• Migrated databases to Oracle Exadata
• Supported large Data Warehouse databases
• Performance tuning of databases hosting retail and institutional brokerage applications
• Supported SQL Server 2005/2008/2012

Senior Oracle Applications DBA and DBA Manager

Responsibilities:

• Led a team of Database Administrators in a large enterprise Oracle E-Business Suite environment and performed regular hands-on technical work
• Installing, configuring, cloning, patching, troubleshooting, tuning and maintaining multiple Oracle E-Business Suite environments
• Responsible for many 24x7 production EBS environments (11.5.10.2 and R12) supporting multiple business units
• Upgraded multiple 11.5.10.2 environments to 12.1.3
• Implemented Oracle EBS on RAC 11g
• Responsible for creating and providing support to Development, Test, QA, Reporting and Break Fix environments in addition to Production
• Migrated Oracle EBS environments from Solaris to Red Hat Linux
• Extensive experience with proactive patching of Oracle EBS and Databases including quarterly CPU/PSU patches, EBS RUP patches
• Proven skills to lead a team in the support of EBS including, planning, delegation, strong sense of ownership and responsibility, perform staff evaluations and mentoring skills
• Ensured that Performance patches were applied to the EBS environments
• Assessed whether the existing hardware is compatible with upgrade to R12
• Performed root cause analysis and documented solutions
• Responsible for troubleshooting EBS and databases via service requests, developing and documenting solutions
• Automated nightly cloning of a Reporting EBS environment from Production
• Performed Health check of EBS environments and created reports on performance from the previous day
• Performed assessments regarding current state of Patchsets and Family Packs in EBS compared to Patchsets released by Oracle Development, using Patchsets Comparison Utility
• Implemented Data Guard for Disaster Recovery in Oracle EBS environments
• Planned and executed quarterly DR switchover tests for Oracle EBS environments
• Ensured that database environment maintains a high level of uptime and performance
• Worked with Application team to run Purge jobs to delete obsolete data from Oracle EBS environments
• Published and maintained DBA calendar detailing timelines for DBA team’s activities
• Developed Oracle EBS maintenance procedures, schedules and notifications
• Created process for automated daily Audit Report and Backup Report for EBS databases
• Created Project Charter documents
• Installed Oracle Grid Control 11g and 12c and used Grid Control to monitor the databases
• Installed and maintained Oracle 11gR2 RAC, ASM, RAC DR
• Installed multiple Siebel 8.1 environments including one on Oracle RAC 11g
• Installed and supported Oracle Weblogic Server, SOA 11g and OBIEE 11g
• Ensured that DBA team delivered two Siebel CRM environments on-time and of high-quality
• Provided Support for PCI Compliance
• Experience working in an environment with formal change control and compliance processes
• Provided routine status reports to senior management
• Collaborated with IT Infrastructure team to procure new hardware and upgrade existing hardware
• Developed and maintained strong working relationships among various teams
• Ensured effective flow of communication between the DBA team, internal teams and management
• Interfaced with System Engineering/Admin teams, Applications group, Support Services (helpdesk) and the Project Management Organization (PMO)
• Responsible for developing, reviewing, revising, monitoring, archiving, approving, and controlling Standard Operating Procedures (SOPs) and Work Instructions (WIs)
• Interfaced with external auditors for annual database security and compliance audit.

Oracle Applications DBA Consultant

Responsibilities:

• Installed, upgraded, maintained, tuned multiple Oracle Applications databases
• Upgraded from 11.0.3 to 11.5.5
• Upgraded from 11.5.4 to 11.5.9
• Cloned Oracle Applications instances
• Performed database upgrades from 9i to 10g to 11g
• Migrated databases from AIX to Linux
• Responsible for engaging DBAs in PacRim, India and EMEA to provide support for 24/7 Global Oracle Applications environment using follow-the-sun model
• Created documents detailing DBA procedures to be used by offshore DBAs
• Ensured that the environment performs well, especially during financial close
• Led project to archive Oracle Applications data from many global applications environments into one environment
• Monitoring and Troubleshooting Oracle Applications environments
• Application of Oracle EBS Patches
• Installed, Set up and Customized Oracle Enterprise Manager and Quest Foglight
• Performed Applications System Administration duties
• Implemented 10 Rules of Oracle Database Security & Security Exception Policy
• Implemented Database Auditing Policy including Audit Requirements, Audit Maintenance and Audit Reporting
• Implemented procedures for SOX compliance
• Implemented Single Sign-on technology
• Created custom utility for Oracle account password management
• Managed Oracle's TAR escalation process
• Evaluated, tested, recommended and supported monitoring tools
• Provided Production DBA support to ensure 24/7 operation
• Very well versed in Rapid Install, adpatch, adadmin, adctrl utilities for Oracle Applications.
• Created a number of database instances for development, testing and production.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Applied Oracle Security patches
• Created shell scripts to monitor EBS databases
• Used Autosys for scheduling automated jobs
• Created documents detailing DBA procedures for offshore DBA personnel
• Created Performance Assessment and Capacity Review documents
• Extensive experience working with off-shore teams