Resume of Lead Oracle Applications DBA




Title
Lead Oracle Applications DBA

Primary Skills
Oracle DBA 9i,8i and 10g, Oracle Apps DBA 11i, 9i RAC, Performance Tuning

Location
US-MA-Boston (will consider relocating)

Posted
Apr-23-08

RESUME DETAILS
Mallik

Lead Oracle DBA/ Oracle Applications DBA
9 yrs work exp in gaints like ACI Worldwide, Fujitsu, Tcs.

9 years experience as Oracle DBA 8i,9i and 10g, Oracle Apps DBA 11i, installed E-Business Suite Release 12, 9i RAC, Performance Tuning, Unix Shell Scripting , Backup and Recovery, Data Guard, SQL and PLSQL, Oracle iAS 10g, iAS 9.0.4 and systems configuration expert that includes administering, modeling, performance tuning, supporting mission critical production databases, applications instances and developing state-of-the-art software used by millions of customers worldwide 24 * 7 on high end Sun Solaris, HP UX and Linux servers with dozens of CPUs, multi gig memory and terra byte disks. Have good knowledge of Fusion middleware components installation.

Educational Qualification: - Master of Computer Application

Certification: Oracle Certified Professional -8i

• DBA Experience on Oracle releases 9i, 8i, 8.x, and 10g.
• Production Experience in administering Oracle Apps 11i, 11.0.3, 10.7 instances and databases.
• Experience in installation, troubleshooting oracle iAS 10g (10.1.2.0.2)
• 9i RAC (Real Application Clusters) admin experience and DataGuard implementation experience.
• Experience on RAC Installation and Administration on Oracle Apps 11i environment.
• Well versed with 9i RMAN and its capabilities
• Production Experience in implementing and integrating 3rd party applications into Oracle Applications 11i
• Extensive experience on performance tuning of Database and Applications.
• Regular interaction with client and customer managers and system administrators in coordinating projects, their requirements and GOLIVE cutover schedules and project plannng and DBA resource allocation.
• Vast experience in Backup and Recovery and setting up Database clones
• Apps Upgrade experience 11.5.4 to 11.5.9 and 11.5.0 to 11.5.10 Solaris to linux migration.
• 24 * 7 Production Database Support and maintenance. Oracle Certified DBA.
• Expertise in upgrading and maintaining Oracle Applications 11i
• Pro-active Performance Tuning using statistics from Statspack, maintenance of 98%+ database hit ratios.
• Tuning TOP SQLs based on Buffer Gets, Physical Reads and Executions
• Very strong in AD utilities including ADPATCH, AD MERGE PATCH, AD ADMIN and Oracle Applications Manager (OAM) of Oracle Apps 11i
• Expertise in cloning and configuring Oracle Applications 11i
• Rich PLSQL, Shell Scripting development experience.
• Very strong in administering and troubleshooting Concurrent Managers, Applications sys admin tasks, Oracle Applications Manager (OAM)
• Ability to tune complex application queries vastly increasing response times. Efficient in TKPROF, OEM Performance Manager
• Very strong in handling pressure and system downtimes.
• Worked on Shareplex and Goldengate enviornments.






Database Upgrades Implemented

1. Production Upgrade Oracle 8.1.6.1 to 10.2.0.4
2. Production Upgrade Oracle 9.0.1.3 to 9.2.0.2
3. Production Upgrade Oracle 8.1.7.4 to 9.2.0.7

Applications
1. Applications 11.5.4 to 11.5.9
2. 11.5.0 to 11.5.10 from Solaris to Linux


Skill Set

Operating Systems: Sun Solaris 9/8/7, RH Linux Advanced Server 3,
RH Linux 9/8.x/7.x, HP UX, Win 2000
Programming Languages: PLSQL, Perl, SQL, UNIX Shell Scripting
Relational Database Systems: Oracle 10g/9i/8i/8.x/7.3.x
Oracle Utilities and Tools: Oracle Enterprise Manager, Oracle AD Utilities
TOAD, Oracle Discoverer 4.1.37, Discoverer Viewer, Discoverer plus,

Oracle Apps Modules: Oracle Financials (GL, AP, AR, FA),
Oracle Manufacturing (INV, OE, PO, BOM, MRP) Oracle HRMS, Payroll, Workflow, I-procurement

Oracle Specific Knowledge: Oracle Apps 11i, oracle apps 10.7, Oracle 11i upgrade,
StatsPack, Oracle Export and Import, SQL*Plus,
SQL Loader, Data Warehousing, Oracle iAS 10g

Project Management Tools: MS Project Central Server, MS Project 2000
Version Control Systems: PVCS 8.0, Kintana, ITG

Projects and Experience ACI Worldwide Consulting.

Project:
1. Database Auditing implementation -- PCI DSS Standards compliance
2. Data guard implementation
3. Database Vault Implementation and Upgradation of Databases.

Software : Oracle 10.2.0.4, Gridcontrol, Linux 3.0

Description: Every second of every day, ACI Worldwide solutions are at work processing electronic payments for financial institutions, retailers and payment processors in over 80 countries. ACI has 30-year track record of providing electronic payment solutions Top 24 US banks.


Projects and Experience in Fujitsu Consulting.

Project : RDBA
Client : QLogic, Compucom, Xeta Technologies, Yamaha, KOYO etc.
Duration : Sep 2005 -- Feb 2008

Software : Oracle 9.2.0.7 RAC, Oracle Applications 11.5.9, oracle 10G, oracle 10.7, HP UX 11, Linux, Sun Solaris, Perl, Kintana, ITG(Mercury), Oracle iAS 10g Single Sign-on (SSO),Oracle Data Guard, Oracle iAS 10g, Veritas Netbackup


Description : 24 * 7 Production Oracle Applications 11i DBA including maintenance and troubleshooting and projects.

• Backup and Recovery support and troubleshooting including Manual Physical Standby databases and DataGuard
• Installed E- Business suite Rel 12.
• 9.2.0.7 RAC (Real Application Clusters) database administration and configuration.
• Perl DBI/DBD scripting to automate daily and weekly DBA tasks and procedures.
• Development of Unix Shell Scripts for automating DBA tasks
• Apache Web Server and Jserv configuration and Troubleshooting
• Regular meetings and interactions with multiple client managers, project managers, system administrators and approve DBA change requests on behalf of the DBA team.
• Lead a group of DBAs including offshore DBAs on many projects and tasks and gained rich leadership and motivational skills and experience.
• Oracle iAS 10.1.2.0.2 installation, administration and troubleshooting
• Cloning Oracle Applications 11i with Rapid Clone.
• Configured SSO on oracle apps environment.
• Worked on many weekend implementations for critical projects and bug fixes
• Worked extensively with the development and user teams in solving performance problems including database wide performance, SQL query analysis and tuning.
• Performed multiple Oracle 8.1.7.4 to Oracle 9.2.0.x upgrades of various other databases as a Primary database administrator.
• Code migration using PVCS and ITG
• Oracle forms, reports and discoverer code migration to production instance.

Projects and Experience in Tcs.

Project : IR DB and Tools Admin
Client : Ingersol Rand International, Dublin
Duration : March 2003 -- Sep 2005
Software : Oracle 9.2.0.5, Oracle Applications 11.5.9, Sun Solaris 2.8,
PL/SQL, Kintana, ITG, EDW, Discoverer 4.1.37

Description : This is a maintenance Project involved in support of Oracle Applications 11.5.9 and various databases of IRI


• 24 * 7 Production DBA including maintenance and troubleshooting
• Tuning SGA, Initialization Parameters and Database size tuning
• Pro-active performance tuning using statistics from Statspack, maintenance of 98%+ database hit ratios
• Backup and Recovery support and troubleshooting
• Development of Unix Shell Scripts for automating DBA tasks
• Efficient use of AD Merge Patch to reduce patching downtime. Used Kintana tool for migrating code and applying patches to Oracle Applications.
• Apache Web Server SSL Configuration and Troubleshooting
• Stored Procedure development using PLSQL and data modelling
• Written Unix Shell Scripts for automating various DBA activities in the project.
• Cloning Oracle Applications 11i with Rapid Clone.
• Tuning TOP SQL's based on Buffer Gets, Physical Reads and Executions
• Worked extensively with the development and user teams in solving performance problems including database wide performance, SQL query analysis and tuning.
• Setting up of development databases and refreshing production to test databases for fixing issues and testing. Backup and Recovery support and troubleshooting
• PLSQL package and custom code design and development.
• Installed Polish Language and applied NLS patches

Projects and Experience in Ibilt technologies ltd, New Delhi.

Project : Oracle Applications 11.5.4 to 11.5.9 Upgrade and 8i to 9i db upgrade
Client : Tropicana Belgium, Pepsi Germany
Duration : Feb 2000 -- Feb 2003
Software : Oracle Applications 11.5.9, 11.0.3, Sun Solaris 2.8, Oracle 9.2.0.4,
Oracle 8.1.7.4, PL/SQL, Kintana.

Description :
This project aimed at a smooth production upgrade from Oracle 11.5.4 to Oracle 11.5.9. It had all the core modules like Financials Suite with MRC, HR Suite, Purchasing, Sales and Marketing, Self-Service Applications including Internet Expenses, Employee Self Service, Time Card and various custom modules.

• Production Implementation of the 11.5.4 to 11.5.9 Migration.
• 24 * 7 Production DBA experience with emphasis on general database administration, Backup and Recovery etc.
• Used AutoConfig and Cloned instances using Rapid Clone
• Tuned a lot of post upgrade scripts including the AP and AR MRC Drivers.
• 8.1.7.4 to 9.2.0.4 Database Migration including Oracle Spatial and Intermedia using a host of 9.2.0.4 features.
• Written a host of shell scripts to aid automatic applying of patches.
• Worked extensively with Oracle Support Services to resolve various critical issues in the upgrade.
• Vast experience in running 11.5.9 Maintenance pack unified driver, AutoUpgrade, CRM upgrade and tuning them.
• Implemented AutoConfig and Oracle Applications Manager, troubleshooting server processes, concurrent managers, setup new printers and new modules.
• Involved in preparing a detailed 11.5.9 build document with all the issues occurred during various UATs and development systems and steps taken to resolve them.


Projects and Experience in Kgisl

Duration: Mar 1999 -- Jan 2000

Role: Production Database Administrator

• Worked both as a 24 * 7 Production Oracle DBA and Oracle Applications DBA
• Administration, Maintenance, Upgradation and Support of mission critical Production Databases
• Rich experience in Database wise performance tuning and SQL query analysis and tuning
• Production 8.1.6.1 to 8i upgrade
• Involved in extensive testing of new database releases, patchsets, Applications maintenance packs

Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


View all resumes in US-MA-Boston »
View all resumes in US-MA »

View other Lead Oracle Applications DBA resumes, Database Administrator resumes