Manager Oracle

Prince O. Igbineweka

PRINCE O. IGBINEWEKA

***** ****** ***, **********, ** 20613

******.**********@*****.***

Phone: 703-***-****

Secret Clearance

U.S Citizen.

A Certified Database Professional, with a focus in Oracle High Availability, Oracle Data Guard, ASM, RMAN backup and recovery, as well as OEM Grid Control.

SUMMARY OF QUALIFICATIONS

1. Detailed and goal-oriented Certified Oracle Database Administrator and Application Server Administrator with seven years of experience in designing, implementing and Maintaining Oracle 9i, 10g and 11g RDBMS. Worked across a multitude of platforms (WINDOWS NT/2000, Red Hat Linux, HP-UX & SUN SOLARIS) and (Web logic, PeopleSoft) in production and development environment with responsibilities of Troubleshooting, Performance Monitoring & Tuning, Data Load & Migration, RMAN Backup and Disaster Recovery, logical and physical design in a High availability RAC environment. Managed Oracle databases in very large (Over 50TB) databases and application environment to support over 10,000 concurrent users.

2. Configure databases to operate in cluster environment through the implementation RAC for high availability.

3. Skilled in designing and implementing Oracle Automatic Storage Management (ASM) to simplify file management with the ability to self-tune automatically.

4. Provide an efficient disaster recovery solution through the use of Oracle Data Guard configuration.

5. In-depth understanding of security LDAP Authentication, Auditing, Encryption and Authorization.

6. Superior communication, presentation, analytical and problem solving skill. Work well on all levels of business.

TECHNICAL SKILLS AND CERTIFICATIONS

Databases: Oracle11g/10g and RDBMS, MS SQL Server 2000/2005, MS Access.

Operating Systems: Windows Server /2000/2003/2008, Unix/ Linux (RHEL & Solaris)

Oracle Tools: Oracle Enterprise Manager (OEM) with Diagnostics, OUI, Oracle Data

Guard, DBCA, Database Upgrade Assistant, Oracle Net Manager, SQL*Plus

and Recovery Manager (RMAN), AWR, ADDM, ADRCI, Data Pump,

SQL*Loader, OracleVM Manager, Web Logic, Oracle Enterprise manager

grid Control, and command-line tools.

Client Tools: Putty, Winscp, VNC, Xwin32, Windows Terminal Service, 4nt, Bastion

Host, TOAD, SQL Developer.

Languages: SQL, Java, HTML, PL/SQL, UNIX shell scripting.

Backup Tools: Recovery Manager (RMAN), Oracle Secure Backup, Net backup &

UltracBac.

EDUCATION AND TRAINING

Bachelor of Science, Pennsylvania State University, State College, PA 2004

ORACLE UNIVERSITY: Backup and Recovery 11g Workshop

CERTIFICATIONS: ORACLE Database Certified Administrator 11g

ORACLE Database Certified Professional 11g

Oracle11g: SQL and PL/SQL

Oracle11g: Oracle Data Guard

Oracle11g: Performance Tuning

Oracle11g: Backup and Recovery

Oracle11g: Network Administration

Oracle11g: Architecture and Administration

Oracle11g: Oracle Real Application Clusters

Oracle11g: New Features for Administrators

Oracle11g: Oracle Grid Infrastructure Enterprise Manager

PROFESSIONAL EXPERIENCE

DOD/Defense Information Systems Agency (DISA) July 2012 - Present

Sr. Oracle Database Administrator/ Consultant

Perform database administration and configuration management functions to include the following duties:

1. Install and upgrade Oracle DBMS instances including all associated products, application specific utilities and add-on tools.

2. Allocation of system storage and planning for future storage requirements for the database and related functions.

3. Creation of primary database storage structures (tablespaces) and primary objects (tables, views, indexes) once application developers have designed an application.

4. Modify the database structure, as necessary, per direction given by the application developers.

5. Advise development staff on implications of any proposed changes.

6. Design, implement and maintain database security procedures. Ensure compliance with Oracle License agreement.

7. Control and monitor user access to the database.

8. Monitor and optimize the performance of the database, including advising development staff of opportunities to improve.

9. Plan and execute backup and recovery activities (Control Files, Redo Logs, Rollback Segments, System Data Files, etc) to ensure timely and complete recoverability. Maintain archived data on tape or other media as defined. Backup and restore the database (On line and Complete) to assure restoral capability.

10. Plan and perform set up, maintain, and troubleshoot replication tools and advise development staff of “best practices” in this area.

11. Complete Software Readiness Review Checklists and take action as required.

12. Stay current with Oracle’s emerging product line and with new additions that may complement existing applications.

DoD/Joint Improvised Explosive Device Defeat Org (JIEDDO)/SAIC August 2010 – July 2012

Oracle Database/System Administrator

While at SAIC, I operated and maintained a web-based information management system for the Joint Improvised Explosive Device Defeat Organization (JIEDDO). The JIEDDO Enterprise Management System (JEMS) supports JIEDDO business processes and document management through the integration of several Oracle products(including OAS, UCM, OID, OCS) as well as custom J2EE software development into a seamless information management system application with multiple modules.

1. Ensured Database technology with minimal Impact to Operations through Oracle Real application clusters and cluster ware.(Maximum High Availability)

2. Provided customer assistance includes general user assist, problem diagnosing/troubleshooting, user account management, and incident monitoring and response; system monitoring and basic maintenance support includes daily system health checks, database monitoring, FTP data management, Oracle Internet Directory, Windows and Linux operating systems, LDAP applications and network and security administration support.

3. Troubleshoot user issues while maintaining a secure OS computing baseline, analyzing system faults, reviewing audit logs, running diagnostic tests to detect problems, performing preventative maintenance, applying security patches and updates, and repairing system and operating environment problems.

4. Installed, configured and tuned various Oracle products for both client side deployments and in-house testing, including, but not limited to: Oracle Databases, Oracle Application Suite, Oracle Content Server, Oracle Directory Service Manager, Oracle Weblogic Server, and Oracle EM Fusion Middleware Control etc.

5. Participated in systems engineering activities which include one or more of the following: Analysis and Engineering, System analysis and design, Implementing and Managing System Interfaces, Maintaining a Secure OS Computing Baseline, Validation and Verification activities, Monitoring and Managing System and Operations, Performance Monitoring and Analysis, Incident Monitoring and Response, Decision Analysis and Resolution, Network and Security Administration and Patching, and Oracle Internet Directory Management. Capable of providing preliminary solutions to a variety of user and system problems that may arise in an expeditious, efficient, and timely manner.

6. Archived Database files/logs using automated scripts.

7. Scheduled scripts to monitor database growth and gather statistics database deployments.

8. Provided performance tuning, maintenance and troubleshot database problems.

9. Performed daily backup and recovery for numerous Oracle 10g/11g databases using RMAN, export and import and Data pump.

10. Supported and assisted database development efforts in the areas creating and maintaining database instances, and assisting development teams with stored procedures, triggers, tables and table structures, and creating views

11. Utilized SQL for different implementation such as generating data, queue data, modified, alter, update the database and schedule daily performance techniques.

12. Utilized LDAP and other account provisioning tools for database and server account management.

13. Implemented and installed web logic and Oracle Enterprise management Grid control.

14. Experienced with Oracle RAC, Oracle Web logic Application Server, Oracle Universal Content Manager, and Oracle Collaboration suite to include security support, performance tuning, administration, backup and recovery, patching and upgrading, and issue troubleshooting and resolution.

U.S. Department of State/SSCI-Contractor August 2007 – July 2010

Database Engineer

The CCD system is one of the largest data warehouse in the Washington, D.C. area that holds all of the current and archived data from all of the Consular Affairs post databases around the world. It contains over 100 million visa cases and 75 million photographs, utilizing billions rows of data, and has a current growth rate of approximately 35 thousand visa cases every day. Provide CA a near real-time aggregate of the consular transaction activity collected domestically and at post databases worldwide. The CCD is the IT implementation that provides for a set of centralized visa and American citizen services supporting consular posts. My main duties at DOS involved

1. Installing and creating Oracle 10g/11g Databases on Windows / Linux servers.

2. Implemented, Managed, Configured Oracle software on numerous databases at the American consulate around the world

3. Partitioned disk drives in Redundant Array of Independent Disks to increase data reliability and increase input/output performance.

4. Ensured the synchronization of Primary and standby databases at POST.

5. Performed regular maintenance and performance tuning on multiple databases

6. Responsible for Database Planning, Job scheduling, and Monitoring.

7. Configured the Real Application Clusters i.e. Data Guard, Maximum Availability, and RMAN

8. Experienced in planning, designing and implementing SAN on open systems for High availability and disaster recovery.

9. Managed and monitored NetApp filers at multiple locations

10. Performed storage admin duties such as creating, resizing and assigning volumes and Luns to ISCSI host.

11. Configured and managed Snap Mirror volume replications at all sites.

12. Collaborated and worked with onsite tech to resolve filer hardware issues like drive replacement and network issues.

13. Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity).

14. Experienced in creating Oracle VM Servers and VM host clones from templates.

15. Managed and connected Windows VM hosts using remote console and VNC viewer.

16. Implemented database Refresh (cloning) using full export for table level and full database defragmentation, resulting in improved performance and effective space management.

17. Provided DBA support and technical support for multiple applications in development, Test, QA, UAT and production environments.

FDIC-Contractor /SRA International October 2005 – August 2007

Oracle Database Administrator

1. Responsible for patching and performing upgrades on the Database, WebTier, and Grid Control Agent.

2. Configured and managed Oracle Data Guard on Linux servers.

3. Setup Oracle Grid Control to monitor the entire system performance.

4. Analyze data growth trends for capacity and resource planning.

5. Responsible for applying multiple oracle patches into several databases.

6. Backup management using Oracle Secure backup, Linux crons & shell scripting for automated RMAN backup and application operations.

7. Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.

8. Implemented database refresh using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.

9. Oracle database space management capacity planning Responsible for the design, implementation and administration of a highly available (OLTP) web logics database solution supporting over 1400 concurrent users.

10. Performed database tuning using Oracle Enterprise Manager, Explain Plans and utlbstat/utlestat.

11. Generated reports from the database using PL/SQL and SQL.

12. Specified user access levels for each segment of one or more data items such as insert, replace, retrieve and/or delete data.

References furnished upon request

Contact this candidate