We provide IT Staff Augmentation Services!

Lead Oracle Applications Database Administrator Resume

3.00/5 (Submit Your Rating)

EXECUTIVE SUMMARY:

Lead Oracle Applications Database Administrator with more than twenty years of experience in designing, implementing and managing oracle databases and application software projects. During this time I have extensively worked on Upgrades, Performance tuning, Backup and Recovery and Scripting for Oracle Applications as well as in - house developed systems. I have worked with complete software development lifecycle. I have Strong interpersonal, analytical and troubleshooting skills with superior verbal/written skills. I have earned OCP for 10g database administration,10g RAC administration and 11i Apps.

CAPABILITIES:

  • Methods & Techniques
  • Project Management
  • Technical Architecture
  • Database Administration
  • Performance Analysis
  • Capacity Planning
  • Database Installation and Tuning
  • Software Development Lifecycle
  • System Performance Management
  • Software Upgrades
  • Data Conversion
  • Technology

SOFTWARE, TOOLS & LANGUAGES:

Oracle DBMS: 7.x, 8.x, 9i,10g, 11g., MS Access, Ingress

ERP: Oracle Applications 11i,R12OEM, Oracle Management Packs, Enterprise Manager Grid Control, Statspack, AWR, ADDM, SQL*Plus, PLSQL, RMAN, Oracle SQL*Loader, Export, Import, Datapump, Dataguard, RAC, ASM, Discover

Oracle Application: Server, Oracle WebDB, Apache, Oracle ADIQuest Monitoring tools - I-watch, Foglight, Spotlight, Toad

Data modeling: Erwin

Languages: Turbo C, Microsoft C, C++, Java script, Unix Shell Script

Development tools: Cold Fusion 4.0, PowerBuilder 3.5, Microsoft Office 98,2003,2007,2010 170 systemsStarteam, Remedy, ClearQuest, Loadrunner, Sitescope, Introscope

Hardware & Operating Systems: Red Hat Linux 4.x,5.x, UNIX (Solaris 2.x, HPUX 9.0, 10.20 & 11.00,SCO Unix,SRV4 Unix), MS-Windows (3.1, 95, 98, NT, 2000,XP,Vista),MS-DOS,, Sun fire 6800,6500,3800,4810, E300 Sparc Servers, HP 900/T500

PROFESSIONAL EXPERIENCE:

Confidential

Lead Oracle Applications Database Administrator

Responsibilities:

  • Supporting multiple Oracle Applications 11i and R12 environments with user base more than 25K all over world, terabyte production database with three nodes RAC with ASM and nineteen application servers using shared application and Parallel Concurrent Manager, SSO, Discover, Grid Control.
  • Performed analysis of quarterly Critical Patch Updates (CPU) and application of the same.
  • Performance monitoring, tuning, reporting and backups using Oracle Grid Control.
  • Performed sql/plsql and shell scripting for performance monitoring, reporting, backup and other routine tasks.
  • Frequent cloning of multiple 11i and R12 environments. Automated major part of the cloning.
  • Supported multiple rollouts of application to new users
  • Created EBusiness Suite testing environments including installations of OID/OIM, Discover, Grid Control and other components.
  • Implemented Automated Health Check for multiple environments using Oracle Automated Testing Suite.

Confidential, NJ

Lead Oracle Applications Database Administrator(VP)

Responsibilities:

  • Managed multiple Oracle Applications 11i environments with more than terabyte database size, used by 46+ countries and business units with more than 10,000 users. The major modules implemented are General Ledger, Account Payables, Fixed Assets, iEexpense, iProcurement with Multiple Languages.
  • Managed team of offshore and onsite database administrators providing 24 x 7 supports.
  • Managed a complex upgrade/re-platform project which included Oracle Applications from 11.5.9 to 11.5.10.2, database upgrade from 9i to 10gR2, application server re-platform from Sun Solaris to Red Hat Linux, patching for ATG RUP6, JDK upgrade, localization of multiple countries and shared application tier architecture.
  • Worked closely with Infrastructure team, functional team and development team for the planning, implementation, testing, execution and post implementation support of the upgrade/re-platform project as well as other production change rollouts.
  • Managed Quarterly Production Releases and day to day production support activity.
  • Performed development environment refreshes from production using Rapid Clone.
  • Designed procedure to refresh production fix environment as requested.
  • Extensive experience with patch analysis for CPU (Critical Patch Analysis) and upgrades, ad utilities, concurrent manager tuning.
  • Performed Capacity Planning for hardware requirements and storage capacity planning for Development, Testing, QA, Staging, and Production for scalable database growth and performance.
  • Administered, maintained, developed and recommended policies and procedures for ensuring the SOX compliance for security and integrity of the company's databases and systems.
  • Implemented Performance Management tools and techniques to meet the performance SLA and monitoring long running and resource consuming programs along with associated sqls, server processes, end-user details and any locking issues. Helped developers tuning programs, worked with oracle support for performance patches, creating weekly performance reports, presented to management during weekly performance meetings. Implemented Quest performance management and diagnostic tools IWatch and Foglight. Authored Unix/Linux shell scripts and SQL/PLSql scripts for performance monitoring.
  • Implemented Data Guard and performed Disaster Recovery test using standby database.
  • Implemented and monitoring Backup and Recovery Using RMAN
  • Migrated Databases from 8i to 9i and 7.3.4 to 8i .and also migrated from HP to SUN hardware
  • Authored sql/plsql and UNIX shell scripts for performance monitoring, reporting, backup and other routine tasks.
  • Installed Oracle E-Business Suite 11i, Oracle databases 10g R2 (RAC and non RAC) and Oracle Application server 10g.
  • Hands on experience with upgrading Oracle Applications from 11.5.2 to 11.5.5 and 11.5.5 to 11.5.9.
  • Supported several Data center move activities.
  • Supporting Automated Invoice Processing from vendor kofax formally 170 systems.
  • Implemented Archiving solution from Applimation.
  • Recruited and trained onsite and offshore Database Administrators.
  • Implemented High availability using Veritas Clusters.
  • Implemented and tested Disaster recovery using EMC BCVs, SRDF and Recover point technology.
  • Extensive performance tuning of ETL.
  • Supported stress test activities performed before migrating changes to production environment as part of the release activity using tools Loadrunner, Sitescope, Introscope.

Confidential, New York

Senior Oracle Database Administrator

Responsibilities:

  • Supported 3 DSS and 3 OLTP databases using Oracle 7.x and 8.x for Intranet and Internet based applications.
  • Managed Database backup, Users Maintenance, Data load, Performance tuning, change management, database growth monitoring, identifying and resolving data quality issues, oracle client installation and documentation.
  • Developed scripts for uploading data into DSS databases and auto backup using Unix Shell scripts, PL/SQL and SQL*Loader.
  • Designed data model and database for various web-based in-house applications.
  • Migrated database from Oracle 7.3.2. to 8.0.5

Confidential, Florida

Senior Oracle DBA

Responsibilities:

  • Managed development and test oracle database for PeopleSoft.
  • Developed interface between PeopleSoft and J D Edwards for Order Management and Accounts Payable modules.
  • Mapped data between legacy system and PeopleSoft.
  • Developed interface programs using SQR.

Confidential

Oracle Database Administrator

Responsibilities:

  • Supported development and production environment onsite and offsite
  • Developed interface for Oracle Financials and Client’s in-house system.
  • Wrote Data upload script using UNIX shell programming and SQL*Loader to load data into Oracle Financials Tables.
  • Restructured programs to accommodate frequent changes in business rules (The programs were used by AVIS-UK, France, Germany, Belgium, Italy, Spain and Portugal offices.)

Confidential

Project Leader

Responsibilities:

  • Managed team of developers and DBA for development and implementation of software for Major Banks - State Bank of India and Canara Bank Investment Management, Bombay.
  • Installed Oracle software and created database for test and production instances.
  • Performed testing, bug fixing, enhancements and performance-related issues coming while user acceptance testing for the fund management software.
  • Migrated data from existing system to new system.

Confidential

Senior Developer

Responsibilities:

  • Conducted a requirement study and implemented full project life cycle of following systems.
  • Broker Management System(Ingress 6.4, SCO Unix)
  • Prepared process flow diagrams and data models, functional specifications, program specifications and test plans and authored various modules for the system.
  • Implemented the software at client sites.
  • Won company award ‘Top 10 Performers” for outstanding performance.

We'd love your feedback!