Oracle Manager
Resume:
CHUKWUMA AUSTIN IMEGWU
Tel: 443-***-****
E-mail: *********@*****.***
Summary:
Oracle E-Business Suite Applications & Database Certified Professional with 5 years of extensive
experience as implementing & maintaining production e-business suite applications & databases, tuning,
cloning, patching, releases, upgrades, cross platform migration using Oracle Tools and technologies. Has
knowledge on Database 11g, 10g, and RAC multi terabyte, Applications R12,, RMAN/Data Guard
backup/recovery high availability, in different O/S like Windows, Linux, on SAN storage Familiar with
ITILv2 life cycle process and standards.
Education:
• Masters in Applied Computer Science (G.P.A of 3.8/4.0) - University of Maryland Eastern Shore
MD, 2011
• Bachelor degree in Petroleum Engineering - University of Port-Harcourt Nigeria, 2000
Professional Certificate:
• Oracle Certified Professional 11g (OCP)
• Oracle Certifies Associate 9i
• ITIL Foundation
• ITIL Practitioner Service
Personal Qualities:
• Transparent and engaging
• Very flexible and willing to learn and explore new challenges
• A responsible and reliable player with sound leadership and people skills
• Able to work in a fast paced and constantly changing technological environment
• Posses’ excellent written and oral communication skills
Technical Skills:
ERP Applications: Oracle E-Business suite 11i (11.5.10.2), R12
Databases: Oracle 11g, 10g RAC,MS Access 2007
Operating Systems: HP UNIX, RHEL, Win-NT
Oracle Tools: Oracle SQL Developer, OEM, AD Utilities, RMAN
Languages: SQL, Linux Shell Scripting
Hardware: HP Data Storage
Professional Experience:
Integral Life Science Plainsboro NJ (Project Delphi) July 2012 - Nov. 2012
Oracle Apps DBA / Oracle DBA
Environment: Oracle Applications 11.5.10 /R12.1.3 Financial Modules, HRMS, Payroll, GL, AP,
AR, Manufacturing, Marketing, Sales RDBMS 11gR2 Linux, Windows Server 2003, 2008
R2,Loftware 10.0.0.131,SOA,OBIEE,AGILE PLM,AGILE ProShip,SQL SERVER 2008
DATABASE SIZE 500 GB to 2 TB.
• Managing SIT, DEV, UAT and PROD Oracle applications R12.1.3 environments.
• Day-to-day issues and Hands-on Supports:
• Database: Adhoc requests, Monitoring table space size, long running jobs, research on Alert log
error, Space management for bulk load of data, Maintaining Archive logs and their spaces, Code
migration support, data block corruption, Database hang, Database crash, performance issues
(SQL and system), undo / rollback table space, temp table space issue, db link issues, privileges
issues, opatch issues etc.
• Made necessary changes/update/migrate or enhancement for menu, responsibilities,
functions, request groups and system profile using FNDLOAD utility.
• Installation and configuration of Loftware and Loftware Oracle Connector on Windows
Server 2008 R2, and oracle database 11gR2.
• Installation and configuration of OBIEE 11g
• Working with Oracle support: opening, managing, and resolving Oracle SR's
• Installation and configuration of printers in Oracle R12 application and Loftware 10.0.131.
• creating roles, role hierarchies and manage user registrations and approvals in oracle user
management/rbac
• Troubleshoot issues through discussion with process owners and technical lead, Includes
problem recognition, research, isolation and resolution steps.
• Define printers, printer types, and printer drives for user with the applications. Coordinate naming
of printers with the operating system administrator to ensure correct coupling between the
operating system print queue and applications printer.
• Provided on call 24 x 7 production support of business critical Web/Internet access databases.
• Involved with enterprise-wide database security implementation and enforced many checks and
balances to improve auditing, security and password protection
• Created/Alter Partitioned tables for large customer related data.
• Responsible for purging and archiving the production databases.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Performed database performance tuning, stats pack reports automation, stress test on production
copy for scalability, resolving production performance issues.
Sterling Bank Plc, Nigeria Jun.2006 – Jan.2010
• Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g
databases on Linux and Windows OS
• Installation of Oracle ERP 11i Application (11.5.10) with 9i Database and Application server
9iAS/10g AS.
• Installed and configured E-Business suite 11i & R12 on single node and multi-node.
• Patch analyzing and patching the different Application Tiers. Extensive Usage of AD utilities.
• Cloning of Oracle E-Business R12 using Rapid Clone.
• Upgrading Oracle Application 11.5.10 to R12 with 11g R2 Databases
• Managing and implementation of shared application Tops
• Performed Oracle database Upgrade and Migration from Oracle to 10g to 11g
• Installation and management of Oracle database using Grid and database control
• Installation and application of several Oracle critical patches to various database versions
• Monitor, optimize and allocate physical data storage for database systems.
• Install and configure relevant network components to ensure database access as well as database
consistency and integrity
• Establish, implement and maintain comprehensive Oracle database maintenance plans
• Developed, implemented and maintained an Enterprise Oracle backup, recovery and disaster
recovery strategy.
• Implemented the use of Oracle Recovery Manager (RMAN) to backup the databases.
• Troubleshoot and resolve various Oracle problems such as connectivity problems, backup and
performance issues.
• Perform maintenance and related preventative maintenance on databases
• Providing Oracle network troubleshooting, technical and administrative duties
• Create and manage documentation on the configuration and support of the Oracle databases
• Applied security features to 10g and 11g databases
• Tune the database and applications for faster and better performance; also performing goal-
oriented tuning as necessary.
• Supporting Oracle Apps and Databases in a RAC cluster environment with load balancers
experience.
• Oracle RAC 10g ASM installations and administration ASM instances.
Magnum Trust Bank PLC, Nigeria May 2004 – Dec.2005
• Experience with Oracle Administration 10g & Unix/Linux System Administration
• DB installation, upgrading and maintenance, administration 10g, 9i.
• Implemented the use of Oracle Recovery Manager (RMAN) to backup the databases
• Performed import and export as needed and scheduled nightly export on each database
• Perform various RMAN cold and hot backups.
• Troubleshoot and resolve various Oracle problems such as connectivity problems, backup and
performance issues.
• Perform maintenance and related preventative maintenance on databases
• Providing Oracle network troubleshooting, technical and administrative duties
• Resolve complex database issues
• Tune SQL queries and database performance for OLTP and DSS applications within various
environments
• Develop best practices based on associated security policies, industry security standards, and
audit regulations to ensure devices are appropriately secured from security breaches Resolve
compliance break-fix incidents based on vulnerability testing, audits, and/or associated security
monitoring systems
• Perform fine grain database auditing.
• Schedule jobs using various Oracle tools such as Oracle OEM, DBMS JOBS and SCHEDULER
• Maintained stored procedures, functions, triggers, packages and views used by the database
instance
• Documented database structure, changes, problems, issues for future reference
• Develop and enforce database related policies, standards, naming conventions, operating
procedures and best practices.
• Develop a strategic plan for the database development that supports the organizations operational
requirements.
• Administer database user accounts. Create, modify and deactivate user accounts; assign and
monitor user access rights
References:
Available upon request
Contact this candidate