We provide IT Staff Augmentation Services!

Oracle Apps Dba Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • Senior Oracle Applications DBA and Solution architect with over 16 years of combined experience in both production and development shops, with demonstrated ability to lead while performing well in a changing environment.
  • Lead multiple Technical implementations of Oracle ERP Systems with Oracle E - Business Suite Applications (R12, 11i).
  • Familiarity with High Availability platforms Data Guard and Golden Gate tool.
  • Proficient in understanding Project business objectives with the ability to articulate them in solutions.
  • Experienced as a technical manager, architect, applications DBA with excellent analytical and troubleshooting skills.
  • Strong analytical skills doubled with a broad knowledge of a multitude of platforms.
  • Experienced in maintaining large size databases in UNIX, LINUX, Windows.
  • Extensive use of SQL and PL/SQL programming. Experienced in both Federal and private sectors.
  • Possess strong knowledge of Oracle RDBMS administration.
  • Sound leadership, communication and language skills with a proven aptitude for learning new technologies.
  • I have been deeply involved in leading and participating in functional and technical reviews, preparing gap analysis and conducting risk analysis.
  • Throughout my career, I have tracked customer requirements and expectations by adhering to project management’s best practices. Proficient in French.

COMPUTER & TECHNICAL SKILLS:

Oracle E-Business Suite: R 12/11.5.10.2/11.5.9/11.5.8/11.5.7/11.5.5/11.0.3/10.7.

O/S, HARDWARE: LINUX, UNIX, Windows, Sun Solaris 7.0/8.0/9.0, Linux Server, HP-UX

RDBMS: Oracle 11g, 10g, 9.x, 8.x, 7.x under Sun Solaris, HPUX, Linux and Windows, Data Guard, Golden Gate

Programming language: Shell scripting, PL/SQL, SQL, Web design, OBIEE 11g

PROFESSIONAL EXPERIENCE:

Oracle Apps DBA

Confidential

Responsibilities:

  • Provide consulting services to clients on Oracle based systems including onsite or remotely.
  • Tasks include but are not limited to:
  • Troubleshoot and resolve production issues, Perform capacity planning for upcoming projects, provide added support to client’s DBA Team both in an advisory and hands on capacity. Clients include:

Confidential

Oracle Apps DBA

Responsibilities:

  • Acting as a returning resource to assist with temporary staff augmentation needs
  • Remotely provide technical support to the implementation of an Oracle EBS system (R12 12.1.3).
  • Handle Tier 3 level tickets and monitor Service Requests with Oracle Support.
  • Provide Database and Application administration support, Environment Capacity planning.
  • Database cloning, refreshes and patching. Provide support to developers

Confidential

Solutions Architect Consultant

Responsibilities:

  • Advised client in identifying bottlenecks and evaluate Solution Providers as client was reassessing its existing enterprise solutions.
  • Setup standard backup policies and initiated a disaster recovery process.
  • Designed an IT roadmap for mid to long term by incorporating SaaS and Could based solutions.
  • Analyze and evaluate client’s ERP and data management solutions.

Confidential

Principal Enterprise DBA Lead

Software & Tools: Oracle Database 11g, Oracle Applications 11i and R12 (12.1.3), Oracle Enterprise Manager, Data Guard, Golden Gate, TOAD, Oracle Database 10g, 11.2.0.4g Quest Foglight, Spotlight, ADI (Application Desktop Interface)

Hardware: DELL PowerEdge

OS, Linux RH5

Environment: Oracle EBS, Financial, HR, OTL, iRec, PA, Multi Environment PROD, TEST, DEV UAT

Responsibilities:

  • Responsible for leading the Oracle ERP Technical Practice and managed all aspects of SDLC by providing 24x7 support of Production, TEST and DEV environments to as well as identifying architecture and system requirements and resource staffing. Specific responsibilities and duties included:
  • Lead New Oracle EBS implementations (R12, 11.5.x), OBIEE, New Modules configuration (GL, AP, AR, PO, PA, iRec, OTL, PAY, HR…)
  • Installed and configured Oracle EBS 11.5.10 and 12.1.x.
  • Integrate Oracle Application with Custom Applications.
  • Performed daily System Administrations task (i.e. Concurrent Managers issues, Forms, Apache and Reports Server issues, Users, Roles and Responsibilities management and performance Tuning).
  • Applied Database and Applications patches; Manage Service Requests.
  • Performed scheduled and unplanned cloning of the ERP system.
  • Performed scheduled code migrations and releases in PROD and lower environments.
  • Performed weekly code reviews with developers prior to code migrations
  • Provide Database support to all efforts of application development.
  • Experience in replicating schemas using Golden Gate
  • Responsible for backup and security and regular of Oracle system
  • Lead Technical implementation of OBIEE
  • Evaluated new vendor products and solutions
  • Translated large and small scale IT applications strategies into deployable solutions.
  • Lead company’s annual COOP exercise for Disaster Recovery
  • Interfaced4 with Business Units, infrastructure teams for business requirements platforms/storage/network capacity/performance.
  • Lead the deployment of Oracle Applications fro a DBA standpoint by assisting with the development and implementation of new solutions.
  • Handle mission critical Tier-1,2 & 3 of Oracle ERP implementations

Confidential

Lead Oracle Applications DBA/Architect

Software: Oracle Database 10g, 11g, Oracle Applications 11i (11.5.10), Oracle Entreprise Manager TOAD, Oracle Database 10g, 11.2.0.4g Quest Foglight, Spotlight, ADI (Application Desktop Interface)

Environment: Oracle EBS Financials, HR, PAY, OTL, iRecruitment, PA Multi Environment PROD, TEST, DEV UAT

Responsibilities:

  • Lead and performed the technical implementation of an Oracle ERP system Version 11.5.10.
  • Installed Oracle EBS suite 11.5.10
  • Provide technical leadership in support of the Oracle ERP Applications and Database environment.
  • Performed application migration to production and performance tuning functionsProvide 24X7 global technical support, ongoing monitoring, performance planning and tuning.
  • Supported all change control processes and ensured proper compliance of standards.

Confidential

Senior Oracle Applications DBA

Software: Oracle Application 11i (11.5.10, 11.5.9, 11,5,8), CRM, Financials, Oracle (9i, 8i, 8.0.6), Unix Shell Scripting, Perl, SQL, PLSQL, Forms 6i, CRON jobs, TOAD, Quest Foglight, Spotlight, ADI (Application Desktop Interface), Visual Source Safe

Hardware: Sun 4800, Sun 3960

Environment: Sun Solaris 2.8, Windows NT/2000 16 Oracle E-Business Suite Instances (11.5.8 & 11.5.9) including development, test, patch and production, Enterprise manager servers on Windows 2000. Multi-nodes load balanced.

Responsibilities:

  • Responsible for Installing, cloning, patching and upgrading ORACLE E-Business Suite 11i (11.5.10, 11.5.9, 11.5.8).
  • Configured Webswitch on multiple middle tiers for Application LOAD BALANCING
  • Configuring Oracle Application Manager (OAM).
  • Installation and Configuration of Oracle Portal 3.0.9.x.
  • Enabled SSL in oracle applications including designing the logical access assignment flow to adhere to enterprise level Audit requirements.
  • Responsible for maintaining 16 Oracle E-Business Suite instances for various purposes.
  • Setup of Workflow mailer using Imap account.
  • Responsible for high availability, Implementing Failover, Performance strategy.
  • Responsible for migrating middle tier from Sun Solaris to Linux.
  • Configured Single Sign On (SSO) using OID for Oracle E-Business Suite 11.5.10.
  • Responsible for establishing database standards and policies.
  • Setup backup and refresh policies using RMAN.
  • Provide support to end users and technical expertise to other Teams involved in project.
  • Provide Tier 3 level support
  • Responsible for day-to-day tuning of Database and applications for better performance.
  • Provided management with semi-monthly status reports, as well as immediate reports incase of system emergencies.
  • Configured AUTOCONFIG for handling customizations.
  • Implemented customized AUTOCONFIG for custom variables and custom folders.
  • Created new password policies, enabled Application and table level auditing in Oracle applications.
  • Used AD Utility to register custom tables and objects in oracle applications.
  • Active member of PBGC Disaster Recovery Team. Conducted successful restore test at third party site for Disaster Recovery.

Confidential

Senior Oracle Applications DBA

Software: Oracle Application 11i (11.5.9, 11,5,8), Oracle (8.0.6/8i,9i), Unix Shell Scripting, Perl, SQL Scripting, Form 6i, CRON jobs, TOAD, Quest Foglight, Spotlight, ADI (Application Desktop Interface), Visual Source Safe

Hardware: Sun 15k, Sun 10K, Sun 4800

OS: Sun Solaris 2.8, Windows NT/2000

Environment: Oracle Financials, Project Accounting, Inventory, Kintana, 14 oracle Financial Instances including

Responsibilities:

  • Responsible for Installation of Oracle Application 11i (11.5.9).
  • Involved in Complete Life Cycle of implementing and setup of Oracle E-Business Suite 11i.
  • Patched Oracle applications including apply, maintain for different modules.
  • Created users, assigning responsibilities, Managing Concurrent processing, data auditing.
  • Used AD utilities viz. adadmin, adpatch, adctrl, adaimgr etc to manage Oracle Applications.
  • Used Version Control tool Kintana to migrate Code and apply Patches.
  • Setup and Installed Oracle Web Application Server, Self Service, Workflow.
  • Installed and configured Oracle Application Desktop Interface (ADI).

Confidential, Arlington, VA

Oracle Applications DBA

Software: Oracle Application 11i (11.5.8, 11.5.3,), Oracle (8.0.6/8i, 9i), Unix Shell Scripting, Perl, SQL Scripting, Form 6i, CRON jobs, TOAD, Quest Foglight, Spotlight, ADI (Application Desktop Interface)

Environment: Windows NT/2000, Sun Solaris 2.8, 16 oracle Financial Instances including development, test, patch and production, enterprise manager servers on Windows 2000.

Responsibilities:

  • Installed and configured Oracle Applications.
  • Responsible for upgrading 10.7 to 11.5.2 and 11.5.2 to 11.5.6.
  • Maintained several other environments (Test, Development, Integration).
  • Responsible for all DBA tasks on all Application Databases.
  • Oracle Database server installation, configuration, and Upgrade on Unix, Windows NT and 2000 platforms.
  • Installed and configured Oracle databases under VERITAS Cluster Server.
  • Provided 24x7 support to production systems.
  • Installed and supported Oracle Application Desktop Interface (ADI).
  • Applied patch sets as required by Application Life Cycle.
  • Built Responsibilities and customize multiple reports Compilation of objects in database tier, application setups, configuration of Oracle CRM application Setup Users, Menus, Responsibilities, Report Security Groups, Profiles, Concurrent Programs, Report Sets.
  • Customized Workflow for Oracle PO Applications.
  • Enforced version control during application releases.
  • Performed Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
  • Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.
  • Implemented automated Backup and Recovery procedures.
  • Provided direct support to Developers.

Confidential, Alexandria, VA

Oracle Applications DBA/Oracle DBA

Software: Oracle Applications 10.7 and 11.5.3), Oracle (7.3.48.0.6/8 i), Unix Shell Scripting, Perl, SQL Scripting, Form 6i, TOAD, SQLBacktrack

Environment: Windows NT/2000, Sun Solaris 2.6, oracle Financial Instances including development, test, patch and production, Datawarehouse

Responsibilities:

  • Install, Upgrade, Patch and Manage several versions of Oracle Applications (11.0.3, 11.0.5, 11.5.3)
  • Migration of Oracle Applications from Windows NT to Unix.
  • Extensive Performance Tuning of Concurrent Managers, Web Server and Jinitiator, Defining Work Shifts, etc.
  • Using utilities like adpatch, adadmin, adctrl, adaimgr, admerge, adsplice, License Manager, autoconfig, adclone etc.
  • Supported during Complete Life Cycle of implementing Oracle Applications.
  • Completed upgrade from 11.0.5 to 11.5.3
  • Installation and configuration of IAS 2000, 9iAS, Apache and Oracle Portal.
  • Involved in Integration of Oracle Financial with ADP payroll
  • Involved in Oracle Parallel Server, VERITAS Fail Over, Database High Availability Clustering,
  • Involved in setup of Net backup, Legato, EMC, RAID, RAW Devices
  • Applying various Patches both Server side and Client side.
  • Responsible for cloning various instances.
  • Wrote and analyzed queries on the production database for performance tuning.
  • Involved in the administration of two networks with multiple Oracle databases totaling up to 300 GB on Unix and Windows NT systems.
  • Supported OLTP and Data warehouse environment.
  • Responsible for Database layout design, capacity planning.
  • Maintained designing Enterprise Database Models using ERWIN.
  • Participated in client regular requirement meetings to determine impact on Business.
  • Experienced in installation of Oracle Databases on various platforms.
  • Responsible for creation of users, setting profiles and users quotas, granting privileges, scheduling Hot and Cold Backups as well as performing weekly maintenance jobs.
  • Responsible for database Performance Tuning, performance monitoring as well as crash recovery. Proficient with SQL Backtrack Tool and several other third party products.
  • Maintained Database scripts for all supported databases on various platforms.
  • Responsible for installing Oracle products, writing shell scripts to automate routine tasks.

We'd love your feedback!