Oracle Assistant

MD ***** • *********@*******.*** • 410-***-****

Current Title:

Oracle DBA

Current Program/Project Name:

CMS Health Care Quality Information Systems (HCQIS) and Data Center Support (HIDS) Project

SUMMARY OF PROFESSIONAL EXPERIENCE AND SKILLS

A highly skilled Oracle professional with over 15 years experience in IT. I have led or been part of many Software Development projects for the Financial, Health, Manufacturing and Educational sectors. I currently work as an Oracle DBA on the HIDS project for CMS (Centers for Medicare and Medicaid). Our team manages about hundred (100) Oracle databases with some more than 100TB. On a previous project, I was an Oracle Subject Matter Expert (SME) on the IRS Affordable Care Act project. On this project, I worked closely with the development team responsible for very high impact solutions to the US economy providing insight to Oracle Technologies. The environment utilized several databases running on single-instance as well as Oracle RAC databases that are over 5TB large in an Agile Development Framework.

EDUCATIONAL BACKGROUND

Institution Name

Level/Degree Obtained

Major

Nottingham University, UK

Master of Science (MS)

IT – specialized in Software Engineering

University of Ghana

Bachelor of Science (BSc)

Computer Science and Physics (Combined Major)

CREDENTIALS

Professional Training:

Advanced Oracle on Linux; Oracle RAC on Unix/Linux

Introduction to JAVA and basic Python

Deploying Oracle Applications on the Internet

Visual Basic, C++

Presentation Skills

SCO Unix Administration

BASIC; COBOL; Windows NT Administration; Forefront Systems Development Methodology

Professional Certifications:

OCA (Oracle Certified Associate)

OCP Admin II

Tools, Technologies, Techniques:

Deployed, configured, and managed Windows, UNIX/Linux and Novell Netware

Extensively used Microsoft Office Suite

Trained in Visual Basic, C++, BASIC, COBOL

S-Designer for translating requirements into entities, relationships and constraints

TOAD for Oracle, PL/SQL Developer, Oracle Enterprise Manager/Grid Control

Oracle RAC 10g, 11g, 12c

WORK HISTORY

Ventech Solutions (HIDS project) 10/2017—Present

Oracle DBA

Deploy Oracle code (through ticketing system - JIRA) in support of the Application Development Organizations (ADO)

Troubleshoot ADO code as one of Oracle Database and PL/SQL subject matter experts on our team

Create and maintain all databases required for development, testing, and production

RMAN and Oracle Data Pump Backup and Recovery

Control migrations of database changes, reference data changes through the development life cycle

Implement and enforce security for Oracle Databases

Enforce and maintain database constraints to ensure database integrity

Administer database objects, including tables, indexes, views, sequences, packages and procedures

Troubleshoot problems regarding the databases, applications and development tools

CSRA (DECC project) 12/2015—10/2017

Senior Oracle DBA

Act on behalf of DBA Lead when needed

Mentor other DBAs in our team

Cordinates workload (through ticketing system) in support of the Development team

Create and maintain all databases required for development, testing, and production

RMAN Clonning

Work closely with the system administration team in performing capacity planning required to create and maintain the databases

Perform tuning of the database instances including re-organization as required to assist performance and ensure maximum uptime of the database

Install new versions of the Oracle RDBMS and apply patches as needed

Plan and implement backup and recovery of all Oracle databases

Control migrations of database changes, reference data changes through the development life cycle

Implement and enforce security for all of the Oracle Databases

Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance. I help to perform reviews on the design and code frequently to ensure standards are being adhered to

Enforce and maintain database constraints to ensure database integrity

Administer all database objects, including tables, indexes, views, sequences, packages and procedures

Assist with impact analysis of any changes made to the database objects

Troubleshoot problems regarding the databases, applications and development tools

Create new database users as required

Software Tech Enterprises (IRS/ACA Project) 05/2015—12/2015

Oracle Subject Matter Expert (SME)

Providing expert support to Operational DBAs during installations, upgrades and deployments throughout the project life-cycle ( from development, testing, through to production)

Work with responsible teams in providing recommendations for hardware sizing

Perform tuning of the database instances and queries which sometimes involve about a billion records

Co-ordinate Oracle parameter changes in all life-cycle environments

Liase with security teams to ensure system compliance

Provide technical support to application development team

Assist with impact analysis of any changes made to the database objects

Troubleshoot problems regarding the databases, applications and development tools

Liase between other Project Teams and Operational DBAs as needed

Acentia, LLC (CMS/DECC Project) 12/2010—05/2015

Senior Oracle DBA (also a Lead DBA at various times)

Create and maintain all databases required for development, testing, and production

Work closely with the system administration team in performing capacity planning required to create and maintain the databases

Perform tuning of the database instances including re-organization as required to assist performance and ensure maximum uptime of the database

Install new versions of the Oracle RDBMS and apply patches as needed

Plan and implement backup and recovery of all Oracle databases

Control migrations of database changes, reference data changes through the development life cycle

Implement and enforce security for all of the Oracle Databases

Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance. I help to perform reviews on the design and code frequently to ensure standards are being adhered to

Evaluate releases of Oracle and its tools, and third party products to ensure that we are running the products that are most appropriate

In collaboration with the Application Developers and System Administrators, I plan to ensure that the introduction of any new product or release upgrade takes place with minimal impact

Provide technical support to application development team and liaise with Oracle Corporation on their behalf

Enforce and maintain database constraints to ensure database integrity

Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures

Assist with impact analysis of any changes made to the database objects

Troubleshoot problems regarding the databases, applications and development tools

Create new database users as required

Manage sharing of resources amongst various applications

Part of a team with ultimate responsibility for the physical database design

Chaveran Systems, Inc 01/2010—12/2010

Oracle DBA/Teaching Assistant

Installation, configuration and upgrade of Oracle Servers (10g and 11g) and related products

Extensive development and management of PL/SQL Packages, Triggers and Stored Procedures; also creating and maintaining other database objects

Maintaining Oracle Security/Audit using tools such as Oracle Enterprise Manager (OEM)

Enforcing and maintaining database constraints to ensure integrity

Perform Oracle database, SQL and application tuning and monitoring; analyzing impact of changes made to database objects

Help prepare students for Oracle Certification

Independent Consultant 1997—01/2010

Oracle/IT Consulting

Directed and partook in the creation of Supply Chain Management Software for a Canned-Tuna Manufacturer – a subsidiary of Heinz - saving them over US$ 2million dollars in quality control penalties. Recently added a Bar-Code option

Design and review of Oracle Backup and Recovery Strategies for clients in multiple sites

Developed and implemented Supply Chain Management and Equipment Maintenance Software for multi-million US$ Oil Blending plant

Led and participated in the design and development of Financial Systems for managing Loans, Financial Instruments (e.g. Bills), general Discount House operations, Human Resource/Payroll, Asset Management, Credit Union System, and Credit Information System for Bankers' Association

Designed and implemented Logical and Physical Database Architectures for several clients in various industries

Performed capacity planning of resulting databases by working closely with Systems/Network Administrators; provides technical support to application developers

Created an Educational software and concept for School Administration and Performance Analysis (with Data Center for processing outsourced schools’ academic records)

Managed teams with about 100 clients some of which are 1,500+ staff-strong

Engineered a Hospital System for managing Outpatient Departments

Used S-Designer and other tools to translate many system requirements into entities, relationships, constraints and attributes

Tara Systems Limited 1993—1995

Systems Support Executive

Installation, configuration and upgrading of Oracle Servers (versions 6 and 7) and related products internationally (e.g. sites: Chaveran Inc, Commercial Bank with over 150 branches, University of Ghana, Electricity Company, Social Security and National Insurance Trust)

Deploying, Configuring, and Managing Windows, Unix/Linux, MS DOS and Novell Netware

Migrating MS SQL*Server/Access databases to Oracle

Extensively used and trained clients in the use of Microsoft Office Suite and Microsoft Project

Taught self in the use of Oracle Development tools like Forms, Reports, Discoverer/Query Builder, Graphics, PL/SQL, Designer, WebDB, and XE and have since trained many others

University of Ghana 1992—1993

Teaching Assistant

Conducted tutorials and marked scripts for University students as a Teaching Assistant after 1st degree

Contact this candidate