We provide IT Staff Augmentation Services!

Database Manager Resume

4.00/5 (Submit Your Rating)

US

Professional Summary

  • Oracle DBA and Oracle Application DBA, with over 7 years experience in Oracle E-business Suite installations and upgrade, System administration, Oracle Workflow and Oracle Discoverer installation and administration, Database installations, monitoring, capacity planning, performance tuning, backup and recovery, user data security, writing SQL codes, Disaster Recovery planning.
  • Experienced in E-Business Suite Release 12 upgrade.
  • Experienced in SQL server administration with advance Knowledge in Store Procedure.
  • Expertise in using Oracle application utilities such as adpatch, adclone, adctrl, adadmin etc.
  • Advance in PL/SQL, Shell Programming and software development.
  • Implemented Single Sign on (SSO) on Application server 10g with E-business suite (HR module).
  • Strong analytical skills with experience in problem-solving and implementing solutions.
  • Team player who is equally effective in a team environment or working independently.
  • Strong Data modeling skills.
  • Self-motivated, goal-oriented and results-driven, with the professional attitude, enthusiasm, commitment and capacity to succeed in a demanding and high-pressure work environment.
  • Punctual and confident with friendly disposition and strong interpersonal skills.
  • Excellent communication and people skills, as well as being articulate, presentable and perceptive.
  • Adaptive and flexible, adapting quickly to new environments and situations and able to readily learn new skills.
  • Experienced in Oracle Database installations, management and administration on VMware

Technical Skills

ERP Application: Oracle E-Business Suite, Oracle 11g, 10g, 9i, Oracle Application server 10g, Oracle Discoverer- BI
Operating Systems: Solaris, HP –UX, Linux, AIX, UNIX etc
Tools: PL/SQL Developer, Oracle Spotlight, Benthic, Toad, HP Data Protector OEM and Grid Control, ADI, Workflow Builder
Storage: NetApps and EVA (HP)

Education/Certification/Trainings
  • B.Eng.-Electrical/Electronics, Confidential,University,Nigeria, Sept ’95.
  • Oracle 10g Database Administrations (May, 2007)
  • Oracle Discoverer 10g - Reports and Views ( May 2007)
  • OCP - Oracle9i Database Administrator (March 2003)
  • Certificate in Information Technology ( February 2002)
  • Enhanced Language Trainings Program for Professionals in Energy Sector, CCIS, Calgary (On going)

Workshop and Seminars Attended

  • Career Bridge Workshop, CCIS, Calgary (October 2009)
  • Oracle Open World, San Francisco, California, USA (September 2008)
  • Enhancing Effectiveness of IT Specialists in the Business World, Digital Jewels, Nigeria (July 2008)
  • HP Nigeria Technology Refresh Session Q2, HP, Nigeria (April 2008)
  • Oracle Financials for Professionals, Data & Scientific Systems Limited, Toronto, Canada (October 2005)

Professional Experience

Confidential,Nigeria Aug ‘07 to Till Date
Team Lead/Database Manager

Oando Plc, Africa’s leading integrated energy solutions provider, comprises a group of companies operating within Nigeria and the African energy sector. Oando Plc implementation environment consist of Oracle RAC 10G database, Application Server 10g, Oracle Application E-Business Suite 11i (11.5.10.2) and R12 (12.0.4), Oracle Financial, Human Resources (Self Service), Human Resources, Purchasing, Asset management, Oracle Process Management, Oracle Projects Module, CRM, Enterprise Assets Management , Daily Business Intelligence etc.

Database Manager

  • Team leader of five members that comprises of Oracle DBA and Technical
  • Ensure prompt payment of Oracle Support license
  • Work closely with development team and provide both technical and functional support
  • Ensure Database security and control Users access
  • Perform regular maintenance, performance tuning, backup and recovery, Disaster Recovery on two nodes RAC environment and Application server 10g
  • Ensure both the Application and RDBMS patches are up to date on all instances.
  • Maintain Disaster Recovery Site.
  • Regular clone of the Production instances to Test, User Acceptance and Development instances
  • Plan and perform weekend maintenance for hardware and software.
  • Provide standby service by mobile phones, blackberry to support the users off office hours and weekends
  • Shell Programming/Unix Scripting
  • Maintain Oracle Workflow, Portal 10g and Discoverer 10g

Responsibilities

  • Configured, implemented, installed and administered two 10GR2 RAC on 2-nodes HP Itanium Clusters (CFS)
  • Installed and Maintained six Oracle databases 10gR2 and E-Business Suite Applications Release 10.5.10.2 on HP-UX
  • Installed and configured Application server 10g for Oracle Discoverer 10g and Oracle Portal 10g.
  • Designed and Implemented Disaster Recovery (Maximum Availability Architecture – MAA)
  • Maintained and administered several oracle databases ( Production 2-nodes RAC, Test 2-nodes RAC, UAT, Application server 10g etc)
  • Data Migration from ACPAC to Oracle E-Business Suite
  • Performed several database upgrades from Oracle 9i database to Oracle 10gR2. (10.2.0.4)
  • Upgraded Oracle Applications E-Business Suite from 11.5.10.2 to Release 12
  • Provided technical support to functional consultants and developers on bug fixes and deployment of solution from development through UAT to Production.
  • Proactively measure performance of systems and fine-tune to ensure optimization of performance by extracting traces on long running queries and running oracle utilities (such as tkprof, ADDM, AWR etc) to explain execution paths.
  • Performed several clones from RAC to RAC and RAC to single nodes.
  • Using Shell programming and Unix Scripting to automate some DBA and Application processes

Confidential,Nigeria Oct ‘06 – July ‘07
Senior Oracle Applications DBA

Guaranty Trust Bank is one of the leading Banks in Nigeria with over 300 branches. The Oracle environment consists of Oracle 10G database, Oracle Application E-Business suite 11i (11.5.10.2) and Customer Relationship Management Module.

Responsibilities

  • Installations, upgrades, cloning, Shell Scripting and patches,
  • Configured, implemented, administer 10GR21 RAC on 2-nodes on HP UX Pa-risc Raw Devices
  • Developed custom scripts, performed regular performance tuning and monitoring,
  • Database backup and recovery and archiving
  • Data modeling
  • Performing regular maintenance, performance tuning, backup and recovery on two nodes RAC environment
  • Implemented Single Sign on (SSO) on Oracle Application Server 10g and E-business suite for the client across the network, and across all the applications e.g. HR module.
  • Part of team that Consolidated several Oracle databases (over 100 oracle instances) to two nodes RAC Oracle Database ( BASIS banking software)
  • Provided technical support and maintained two nodes RAC of Oracle E-business suite (11.5.10.2), and Customer Relationship Management –CRM module.

Confidential,Toronto, Canada May ‘04 – Sept ‘06
Oracle Applications DBA

Team member with Oracle Corporation Egypt to Implement ERP-project (Oracle E-Business suite - i.e. Oracle financials11i) for Central Bank of Nigeria

Responsibilities

  • Implemented and supported General Ledger, Human Resources, Account Payables, Purchasing, Balance Score card and Enterprise Budgeting and Planning and many more.
  • Day to day management and administration of the Oracle Applications, and the database. Backup and Recovery, Performance Tuning
  • Performed Applications Maintenance, Patching, Cloning and Upgrade
  • Installed and upgraded Oracle database from 9.2.0.4 to 9.2.0.5 and 9.2.0.6 to 10.1.0.4 and Oracle Applications 11i (11.5.9 to 11.5.10 and 11.5.10.2)
  • Installed Application server 10g and Implemented single sign on (SSO) and Discoverer 10g.

Confidential,Nigeria Oct ‘98 – Apr ‘04
Team Lead – System Analyst

Responsibilities

  • Developed and Maintained Peers HR/Payroll systems running on Oracle9i database
  • Responsible for data processing, professional supported HR and Administrative departments including maintenance and enhancements to Peachtree Accounting software and other internally developed applications.
  • Project Planning and organization, day to day team direction, user management liaison, high level and detailed systems design and requirement definition
  • Hardware maintenance and Networking (LAN).
  • Software procurement and analysis
  • Staff’s Educational Trainings

Confidential,Nigeria Jan ‘97 – Sept ‘98

IT Support Officer

Responsibilities

    • Responsible for Technical Support and Help desk support
    • Configurations and Installations of new software and
    • General system administration and support.

We'd love your feedback!