SUMMARY:

• A self - motivated and results oriented IT expert with over 15 years’ experience of providing MIS solutions in the of Relation Database Design and Development for Client/Server environments.
• Competent Oracle Database administrator with proven project experience in rapid application development.
• A certified professional Oracle database administrator.
• Mr Oreagba’s current areas of concentration are in the design, delivery and maintenance of relational database in a three-tier application development environment.
• Mr Oreagba also has good knowledge of Oracle Exadata.
• Good working knowledge of EMC GreenPlum Database
• Expert Database administrator with more than 14 years’ experience in various business Sectors.
• Outstanding productivity both as a Production and Development DBA.
• Unique combination of experiences on UNIX, LINUX and Windows Platforms
• Dynamic leader and team builder, consistently motivating others towards success.
• Implementation of high-availability systems using RAC and Recovery Manager (RMAN) for very large databases (VLDB) 500GB - 23TB within an EMC SAN environment.
• Implemented Tier 1 high-availability Production system using RAC and Oracle GoldenGate

SKILL:

Languages and Tools: SQL, PL/SQL, SQL*NET, SQL LOADER OO, JAVA, XML and XSL

Operating Systems: Windows XP, 2000, 98, 95, Windows NT, UNIX, and MS-DOS.

Databases: Oracle 7.3/ 8/ 8i/9i- RAC 10 & 11g Enterprise Edition, Oracle Exadata, MS Access & SQL Sever, Oracle Data Warehouse.

Application Severs: J2ee, OID, SSO, BI Publisher, Oracle Application Express, Oracle Grid Control, Oracle GoldenGate

Application Packages: Windows NT; Windows95; GUI Tools - Developer/2000 (Forms, Reports, Graphics), Oracle Designer/2000, SQL*DBA, Microsoft Word for Windows, WordPerfect, MS-Query, Excel

Hardware: Sun, IBM Mainframe/Compatibles and other workstations), Greenplum Database and Data Computing Appliance

PROFESSIONAL EXPERIENCE:

Confidential, Lanham, MD

Senior Database Administrator

Responsibilities:

• Monitor DCA and Greenplum Data for Confidential DEV, TEST, PERF and PROD
• Resolve Q-Tickets for issues relating to DCA and Greenplum Database
• Resolve user request relating to user permission and roles
• Create user, role and grant permission on Greenplum database using PSQL command line
• Created Greenplum database, schemas and roles
• Backup and restore schema from PROD to DEV using the gpcrondump
• Backup and restore tables from PROD to DEV using gp dump
• Investigate and recover failed segment using the gpstate and gprecovseq
• Perform health check of the DCA using the dcacheck command
• Grant resources and role to users
• Managed user accounts and resolved locked accounts
• Managed database activities, start/stop Greenplum database
• Monitor DCA and Greenplum health using GPCC and review daily alerts
• Monitor long running queries using GPCC and resolved hanging issues with queries
• Deployed DDL in all environments for Greenplum databases
• Familiar with transmittal processes for the DDL deployments.
• Resolved Incident tickets for DCA and Greenplum issues.
• Execute users SQL scripts on Greenplum Databases using PSQL command line
• Extensive use of SOL for all tasks on the Greenplum Database
• Performed SQL tuning, table and schema analyze for GPDB
• Familiar with Tableua for Greenplum for analytic and visualization of data

Confidential, Richmond, VA

Senior Database Engineer

Responsibilities:

• Designed and documented (SOP) Oracle RAC database Architecture for the Bank critical database for new Data Centers
• Designed and documented (SOP) for the databases capacity planning and the file system layout on the SAN for Oracle 10.2.0.5 & 11g RAC.
• Implemented the RAC databases (10.2.5 & 11g) of two and four Nodes on Linux for the Development, UAT, Production and Contingency
• Designed and implemented backup strategy using the Oracle Recovery Manager (RMAN)
• Prepared Unix Shell script for daily monitoring of the critical databases.
• Implemented Oracle Services for different application access to specific Nodes in the RAC databases.
• Implemented Bi-directional Oracle Streams between two data Centers on Oracle RAC database.
• Implemented Uni/Bidirectional Oracle GoldenGate for UAT and Production environment.
• Upgrade Oracle Streams bidirectional Production to Oracle GoldenGate.
• Implement Oracle Standby database for the Production Environment.
• Providing 24/7 supports for the Bank Critical Production RAC databases.
• Supports the Developer in tuning application code using Grid Control ADDM and TOAD
• Performs RAC database Performance tuning for UAT and PRODUCTION using the AWR.
• Cloned UAT and Production RAC databases using the RMAN Duplicate for Oracle Data Guard
• Implement Active Data guard for Oracle RAC UAT and Production Environments
• Implemented Oracle Golden Gate in UAT and Production Environments
• Setup and Administration of High Availability systems using Oracle Data Guard and Real Application Clusters with ASM.
• Day-to-Day support of both production and development environments that includes performance tuning and database monitoring.
• Implementation of Backup and Recovery Solution using RMAN and VERITAS Netbackup 5.1
• Design and Implementation of Database security using Oracle Auditing.
• Installation, creation and configuration of Oracle 11g databases on Linux
• Upgrade Oracle RAC 10.2.0.5 to Oracle 11g
• Apply Patches and PSU’s to Oracle RAC and Standalone Database in QA and Production environments.
• Configure and Implement RapidDB Oracle Schema for Dev, UAT and Production Environments.
• Configure and implemented GreenPlum database 4.2 for DEV and UAT environments using the Initialization Utility.
• Manage and Administer Greenplum Master and Segments Databases using the Greenplum command center
• Configure Oracle compatibility for GreenPlum Database.
• Create and manage database tablespaces, schema and tables for Greenplum database
• Bulk data Load using GPLOAD, COPY, Power Exchange for GreenPlum and Integration with Informatica Administration Console
• Prepared SOA for the daily activities, backup and restore for the GreenPlum Databases

Confidential, Suitland, MD

LEAD DBA/Senior Database Engineer

Responsibilities:

• Designed and documented(SOP) the (VLDB) RAC database Architecture l for the Censuses Paper Base Operation project
• Designed and documented (SOP) the databases capacity planning and the file system layout on the SAN.
• Implemented the RAC databases(10.2.4) of two and four Nodes on Linux for the Development Environments
• Designed and implemented backup strategy using the Oracle Recovery Manager(RMAN)
• Implemented the RAC databases of four Nodes for BETA and PRODUCTION on Linux.
• Implemented and upgraded the BETA and Production four Nodes RAC databases to Eight Nodes RAC databases
• Implemented Oracle Services for different application access to specific Nodes in the RAC databases.
• Implemented Oracle Streams between the OLTP RAC database and the REPORT RAC database.
• Configured Oracle GRID Control for the Development and Production environments
• Providing 24/7 support for development, BETA and Production RAC databases.
• Implemented GRID alert notifications for the RAC databases
• Supported the Ingestion of 15TB of data for the Census PBO decennial project on the RAC databases
• Supports the Developer in tuning application code using Grid Control ADDM and TOAD
• Performs RAC database Performance tuning for BETA and PRODUCTION using the AWR.
• Supported Oracle RAC Database for Oracle E-Business and SOA suites
• Supported Cluster Middle tier SOA suite and J2ee for the application access.
• Cloned Beta RAC databases using the RMAN Duplicate
• Implemented the storage for logical deisgn for the data using Partitions

Confidential, Largo, MD

SENIOR ORACLE DBA

Responsibilities:

• Support Development team on the Census 2010 project
• Managed the 36 databases for the 3 major Linux environments.
• Administered and supported 8 Nodes RAC on Linux Servers using Oracle Grid Control.
• Installed and configured Oracle 10g Grid control to monitoring, send reports and alert messages to the email and on-call pager.
• Extensive use of Data pump
• Extensive use of Oracle Grid control for performance tuning (using ADDM), Database cloning, Job scheduling, Backup and recovery (using RMAN).
• Created, managed and support Oracle 10g AS (10.1.0.2) with J2ee component, OID and SSO middle tier
• Deployed Oracle Business Intelligence and Oracle Business Application express
• Installed Oracle 10g software on Linux and created new databases for new development environment
• Upgraded Oracle 10g base version from 10.1.0.1 to 10.2.0.3.
• Extensive use of Grid Control for management and deployment for all the databases
• Implemented and documented disaster Recovery strategies using RMAN for the Staging Environment.
• Mentored Junior DBA’s on the team.
• Setup and Deployed Streams on all the environments
• Support and resolved developer issues during deployment.
• Cloned database for new environment in different regions.
• Implemented change control for new builds versioning with the use of IBM Clear Quest rational.
• Deployed CPU, One-off and Oracle upgrade patches.

Confidential, VA

Senior Oracle DBA

Responsibilities:

• Responsible for assessing the impact analysis and the redesign of Client Databases
• Liaised with Clients to define and in corporate new functional requirements for database design for reporting function
• Responsible for managing the migration of existing corporate data from various platforms into Oracle include definition of production/development architectures, development of project approach; define project timelines with Client coordinators and senior project managers.
• Implemented RAC database architecture in a test LINUX environment on a 2 node cluster.
• Responsible for managing data cleansing for reporting repositories into a single Oracle 9i repository prior to migration., and installation and configuration of Oracle database for production/development/ disaster recovery environments.
• Prepare detail documentation to facilitate Oracle stream for reporting repositories (Data Warehouse Load) using Oracle 9i.
• Responsibilities for the development of end user training workshops, setup QC testing strategy with business users, production rollout and support.
• Implementation of Backup and Recovery Solution using RMAN and Veritas Netbackup 5.1
• Provide DBA support in the areas of performance tuning, bug fixing, capacity planning, connectivity issues and data management for all environments
• Migration of databases from Oracle 8i and 9i to 10.2.0.3

Confidential, Coudersport, PA

Oracle DBA

Responsibilities:

• Team Leader responsible for preparing specification for Oracle databases design and Architectures
• Responsible for data analysis and migration from Mainframe into Oracle database
• Liaised with Senior Management, end-user and other team for defining requirement specification for new databases.
• Responsible for installation and creation of Large Oracle database for generating report for the end-user
• Manage oracle databases using Oracle Enterprise Manager
• Design report for user to interface with oracle database
• Perform data cleansing for mainframe data before migration onto oracle database.
• Extensive use of SQL/PSL, SQL Loader, ODBC Connection for data migration onto Oracle database
• Setup and maintain high level database security for users
• Performed database restoration and recovery on Unix( Sun Solaris)

Confidential, Melville, NY

Analyst/Programmer

Responsibilities:

• Team member responsible for generic development of real time web applications for semi-conductors Suppliers, customers and clients using Java, XML and XSL.(Data Access(Java), Application(XML) and Presentation(XSL)Classes)
• Designed, implemented and maintained Invoice on line Customer details, and Sales order information with PL\SQL and HTML (web application basic).
• Analysed, created Oracle table and implemented data migration from Mainframe to Oracle database with SQL* Loader and PL\SQL.
• Analysis and normalization of existing packages resolving cross- reference between packages.
• Enhance and resolute on line user problem with web applications
• Development of tables, indexes for optimal performance.
• Manage and maintain database performance.

Confidential

Oracle DBA

Responsibilities:

• Upgrade Oracle7 to Oracle8 database, both on development & quality environment.
• Identify migration issues and provide detail documentation for production implementation
• Identification of procedure for depersonalisation of data for migration testing
• Apply backup of the production database to the development database and tape device.
• Regular maintenance of database i.e. re-organisation of tables, indexes and addition of datafiles and rollback segment.
• Identification of business/system requirement of database.
• Resolve user issues concerning the database data.

Confidential

Oracle DBA

Responsibilities:

• Prepared technical specification designed and developed on demand customer reporting system with Oracle Report Server 2.1.
• Identified user requirements and system objectives based on a through understanding of business requirements.
• Identified and defined database tables requirements for the report generation.
• Implemented background processes that kick-start PL/SQL codes that generate reports at predetermined time.
• Implemented SQL and PL/SQL as required for the report generation.
• Involved in series of JAD session and liaison with the client
• Created Oracle database, backup the database in Archive log Mode.
• Prepared SQL scripts for database Tables, Views and Tablespaces creation
• Enforced users security at the database level.
• Used SQL * Loader to migrate existing flat files into Oracle database.
• Used Export and Import Utilities to migrate tables remotely between Oracle databases.

Confidential

Oracle DBA

Responsibilities:

• Designed developed and implemented a Miscellaneous Invoice Generation and Scheduling System.
• Responsible for user requirement analysis and the development of functional specification.
• Implemented Entity Relationship (ER).
• Designed user interface with Oracle developer/2000.
• Used Oracle Designer/2000 to reverse engineering existing Oracle forms and Reports. liaised with the users ambassadors to agree on the system scopes, processes and requirements identified.
• Implemented SQL and PL/SQL that enforces both database and application access security.

Confidential

Oracle DBA

Responsibilities:

• Migrated Microsoft Access database into Oracle7 database
• Implemented database sizing and Entity Relationship.
• Developed Oracle forms and Reports
• Implemented SQL and PL/SQL procedures, triggers and packages both at the database level and on the application level to enforce users requirements validations.
• Enforce application and database user security.

Confidential

Oracle developer/Oracle DBA

Responsibilities:

• designed, developed and implemented user interface enhancement with Oracle forms 4.5
• Developed Oracle Report 2.5 for council tax refund and debt recovery.
• Migrated transactional data from the legacy COBOL system to an Oracle Database.

Confidential

Information Support/Administrator

Responsibilities:

• Database design and application development using MS Access.
• Created Reports, Forms and Queries.
• Resolution of user problems.
• Set-up users and database Access control.
• Designed and Implemented relational database.