Manager Oracle

NICHOLAS M. FOMINYAM

703-***-**** ************@*****.***

INFORMATION TECHNOLOGY

Motivated, forward-thinking, performance-driven professional, with breadth of backgrounds, and deep

competencies for providing high-quality technology solutions and services to end users/client’s satisfaction while

contributing significant impact to maximization of corporate values. Aligns financial analysis/sales proficiencies

based on Service Level Agreements (SLA) to the requirements of that set Company.

TECHNICAL SKILLS

Adobe Acrobat. Visio. Internet Explorer, Microsoft Access, Microsoft Excel, Microsoft Power Point. Microsoft

Project. Microsoft Word. TOAD, Workstations. Network Infrastructure. Outlook. UNIX. Linux. Windows 98.

Window NT and XP environment . Backup packages. Database & Tools: Oracle 10gR2/11R2g, OEM, Oracle

Diagnostics & Performance Pack, Oracle RAC, DATA Guard, DataPump, SQL*Loader, OUI, DBCA, RMAN,

FLASHBACK, SQL/PL/SQL, LISTENER.

TECHNICAL CERTIFICATIONS AND EDUCATION

• Associate Degree in Information Technology (In progress)

Maxaur DBA Training Center – Reston, VA, April 2009

• Oracle Certified 10g Professional

University of Buea, Cameroon, June 2003

• BSc. in Geography

• Minor in Marketing Management

TECHNICAL SKILLS

• Adobe Acrobat. Visio. Internet Explorer. Microsoft Access. Microsoft Excel. Microsoft PowerPoint. Microsoft

Project. Microsoft Word. Cute FTP TOAD. Workstations. Network Infrastructure. Outlook. UNIX. Linux.

Solaris. Windows 98. Window NT and XP environment. Backup packages.

• Database & Tools: Oracle 10gR2/11R2g, OEM, Oracle Diagnostics & Performance Pack, Oracle RAC,

DATA Guard, Data Pump, SQL*Loader, OUI, DBCA, RMAN, FLASHBACK, SQL/PL/SQL, LISTENER.

PROFESSIONAL EXPERIENCE

Regions Financial Corporation 09/2013 – Present

Oracle Database Administrator

• Responsible for Designing/creating and maintaining client databases as well as, processing data for Oracle

databases

• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and

procedures.

• Participate in weekly On-call rotation to provide 24x7 Production support.

• Part of a team that tested and implemented a disaster recover procedures for the database environment

• Worked with vendors in evaluating and implementing new technologies.

• Troubleshoot database performance problems and escalate to senior team members and Infrastructure

teams as required

• Working with architecture, application development, and operations to help achieve a state-of-the-art

environment that meets current and future business objectives

• Part of a team involve in upgrading/Migrating Oracle 11gR2 to Oracle 12c

• Involved in Oracle Agent deployment and upgrade from 12.0.1.0 to 12.0.3.0.

• Monitor database systems and provide technical support for database issues and application performance

enhancement/improvement using both Oracle 10g Enterprise Manager Grid Control and DB Console,

Oracle 10g Enterprise Manager Client Console, TOAD for Oracle & SQL*Plus.

• Provided technical support to application development teams

• Performed ongoing tuning of the database instances using OEM 12c.

• Utilized OEM 12c to deploy agents and discover targets and Exadata database machines on various host.

• Assists in the development of database recovery plans and procedures

• Implement database refreshes using export and import tools and data pump utility

• Diagnose, troubleshoot and resolve any DB related problems. Work with Oracle Support if necessary to

bring problems to a successful resolution.

• Planed, implemented, and maintained backup and recovery of the Oracle database based on defined

standards.

• Controlled migrations of programs, database changes, reference data changes and menu changes through

the development life cycle.

• Implemented and enforced security for all Oracle Database instances, in conjunction with local database

administrators.

• Present disk requirements to UNIX teams, specify SAN requirements to SAN team

• Troubleshoot failed maintenance jobs, investigate errors from the alert log and slow or hung transactions.

Vanderbilt University and Medical Center 12/2012 – 06/2013

Database Administrator Enterprise Data Warehouse

• Responsible for developing and maintaining a data warehouse in an Oracle Server that supports the

Medical center and University reporting needs.

• Participate in the development of meaningful data to support data-driven decision-making at an institutional

level.

• Provide on-going support of the environment by assigning appropriate access rights, providing assistance

and answering Technical Assistance Center (TAC) calls.

• Keep pace with the latest technology and recommendations as appropriate.

• Monitor database usage and implement improvements needed to increase operational performance and

optimize disk space utilization.

• Maintain database environment by performing tasks such as installing new versions of Oracle and BI tools

and maintaining a current patch level.

• Manage data warehouse development, test and production environments; perform proactive application

monitoring

• Work with users and developers in project planning; make recommendations for use of technology and

development tools

• Oracle data loading features including SQL Loader, external tables, and dump file import/export

• Tuning of packages and databases.

• Write new programs or modify existing programs to meet customer requirements, using current

programming languages and technologies.

• Resolving customer related issues involving creating user accounts, changing user passwords, and

granting access to users on database tables, granting roles and privileges to users.

• Granting database links between different databases.

• Part of team involved in a database sync project, comparing and synchronizing all tables in the production,

test and development environment.

• Held weekly meetings with the Quality Patient safety team in and efforts to better understand the health

information we extract, transform and load into the warehouse.

Unix AIX (Training and Hands-on classes) 07/2012 – 10/2012

System information Services Corporation (SIS) – Reston, VA 01/2011 – 07/2012

Oracle DBA

• Responsible for Designing/creating and maintaining client databases as well as, processing data for Oracle

databases.

• Managed project resource allocation for team members and oversaw responsibilities, workflow and

dependencies between processes.

• Maintained servers and services ensuring stability and minimized possible service downtime. Monitored,

maintained and repaired production databases.

• Communicated with internal/external clients to define requirement, organization, and management of

evidence and case data.

• Define, communicate and manage project scope, notify team of client-requested updates and or changes to

project scope.

• Work with Application Developers and Data Architects to design/create new Oracle databases/create new

schemas/database objects, as well as making database changes following requests/demands from the

development team.

• Monitor database systems and provide technical support for database system issues and application

performance enhancement/improvement using both Oracle 10g Enterprise Manager Grid Control and DB

Console, Oracle 10g Enterprise Manager Client Console, TOAD for Oracle & SQL*Plus.

• Worked closely with UNIX/Linux System/Storage Administrators to Configure, Implement & Deploy Oracle

Single Instance 10gR2 (10.2.0.4) and 11gR2 (11.2.0.2 &3).

• Backup/Recovery Configuration of Oracle 10g/11g single instance/RAC databases using Oracle.

• Monitoring rollback segments, Adopting proactive maintenance strategies to curb extensive shrinking and

wrapping of rollback segments.

• Data loading using SQL*Loader and Impdp &Expdp, External table to assist Data loads with developers.

• Utilized Oracle 10g Flashback Features to ensure 5 day retention time for any object that is removed from

the production database.

• Performed recovery from missing or corrupted data files, redo log group, control files and recovery from

block corruption (dbverify).

Huron Consulting Group – Washington, D.C 12/2008 – 12/2010

Database Administrator (ORACLE)

• Installed and configured Database using Oracle’s Optimal Flexible Architecture (OFA).

• Performed successful & periodical Backup, Restoration & Tuning.

• Upgrading of Database from lower version to higher version.

• Work with System Administrators (UNIX & NT) to ensure Oracle related matters are handled properly.

• Diagnose, troubleshoot and resolve any DB related problems. Work with Oracle Support if necessary to

bring problems to a successful resolution.

• Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis,

Design, Test and Implementation through the phases of System Development Life Cycle.

• Worked with application developers to address and clarify data requirements to resolve technical and

functional issues by enforcing corporate business rules through adequate user/resource/object

management.

• Reconciled functional and technical problems through interaction with clients by researching and identifying

the defined issues and by fully testing and confirming possible solutions to the problems encountered.

• Part of a team responsible for a 7 x 24 Oracle database operation involving wireless market data collection.

• Monitored server performance, database and transaction log growth and error logs.

• Configured listeners and tnsnames using net manager and/or net configuration assistant.

• Established capacity planning of tablespaces, tables, indexes, and databases to allow for growth potential.

• Created Analyzed database objects tablespaces, Application Users, Database schemas, profiles, granting

privileges and roles, and database links.

• Established, designed, tested and implemented backup and recovery solutions including automated daily

hot/cold backups depending on criticality of the Database - (RMAN, EXP/IMP PUMP and shell scripts) and

database migration.

• Provided performance tuning activities for Oracle database improvement. Tuned database through

initialization parameter, SQL statement, and memory by performing routine checks of the SGA, CPU,

logical and physical I/Os and contention.

• Security implementation through basic and advance security techniques like applying recent Critical

Patches and upgrades, appropriate user grants, permissions and profile management.

• Utilized PL/SQL for programming and Stored Procedures especially enhancing capabilities to SQL.

• Restructured, tuned tracked, proactively monitored database load, fragmentation, contention, and overall

performance for optimal performance of the existing database.

• Monitored database growth, created objects, administered users and tuned expensive SQL statements

using EXPLAIN PLAN and SQL TUNING ADVISOR.

• Replicated Databases, using database links, streams for disaster recovery and cloning.

• Implemented database migration from 10g to 11g using data pump utilities.

Military Subsidy Program (NACCRRA) – Arlington, VA 09/2006 – 11/2008

Jr. SQL Server DBA /Data Entry Specialist

• Assist in data management processes.

• Assist in maintaining and improving database operational efficiency.

• Creating and inserting data into tables, loading data from external files/tables into database tables.

• Performs daily, weekly and monthly data maintenance task.

• Work with application developers and data architects to design/create new schemas/database objects.

• Provides supervision and technical support for the DoD/Military and AmeriCorps/Vista Online application

databases.

• Checks data from completed forms or other documents for accuracy and completeness and enters into

database.

• Reviews audit reports and resolves errors to ensure integrity of data.

• Identifies problems with database management policies and procedures and provides input into their

revision.

• Identify problematic areas and conduct research to determine the best course of action to correct the data.

• Analyze reports of data duplicates or other errors to provide ongoing appropriate interdepartmental

communication and monthly or daily data reports.

• Monitor for timely and accurate completion of select data elements (for example, verbal physician orders).

• Identify, analyze, and interpret trends or patterns in complex data sets.

• Monitor data dictionary statistics.

• Work as a liaison officer between the Military Families and Child care providers.

• Assist Coordinators with clarification of policies and procedures and handling the day-to-day application

process.

• Monitor call center log-ins and activity and ensures that Coordinators follow up on calls from their voice mail

and general voice mail. Monitors Coordinators' caseloads and backlogged cases.

• Ensure that Coordinators follow up on forwarded emails, ensures faxes are logged and distributed in a

timely manner.

• Ensure that incoming supporting documents are assigned in a timely manner and ensures that files,

documents, and attendance records are filed correctly and in a timely manner.

• Establish and monitor alerts for actions that are time sensitive and past due and assists Coordinators with

processing backlogged applications.

Contact this candidate