Manager Data

Eric N. Awambeng

***** **** ** **********, ** ***91.

Phone: 805-***-****.

E-mail: ****.********@*****.***

INFORMATION TECHNOLOGY:

Certified Oracle Professional with one year’s hands on experience. Highly motivated,

forward-thinking, performance driven professional. Aligns financial analysis/sales

proficiencies based on Service Level Agreements (SLA) to the requirements of each

Company.

TECHNICAL SKILLS:

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. Add more Oracle DBA specific skills here.

Other: Adobe Acrobat. Visio. Internet Explorer. Microsoft Access. Microsoft

Excel. Microsoft Power Point. Microsoft Project. Microsoft Word. Cute FTP

TOAD. Workstations. Network Infrastructure. Outlook.

UNIX. Linux. Solaris. Windows 98. Window NT and XP environment. Backup

packages.

TECHNICAL CERTIFICATIONS AND EDUCATION:

OCP

MASTERS DEGREE

BA

BUSINESS SUMMARY:

Led various initiatives and teams to improve data center capabilities, reduce costs,

Resume: Eric N. Awambeng

and develop applications to grow business opportunities & profit.

Mentored numerous individuals into leadership and account management roles.

Managed various technology engineering, systems development, operations and

project teams.

Experienced in data center planning, development, global sourcing, contract

management and business application integration.

Strong experience with identifying key technology deployments, business

partnerships and development initiatives to maximize business cash flow and

revenue/profit growth.

EMPLOYMENT PROFILE

System information Services Corporation (SIS),

Reston, VA

01/2013 - 6/2013

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.

Page 2 [805-***-****]

Resume: Eric N. Awambeng

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 (dB verify).

HURON CONSULTING GROUP, Washington, D.C

01/2011 - 12/2011

Oracle Database Administrator

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

Page 3 [Type your e-mail address]

Resume: Eric N. Awambeng

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 table spaces, tables, indexes, and databases to allow

for growth potential.

Created Analyzed database objects table spaces, 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.

08/2007 -11/2010

Page 4 [805-***-****]

Resume: Eric N. Awambeng

Jr. SQL Server DBA /Program Manager

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

Page 5 [Type your e-mail address]

Resume: Eric N. Awambeng

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.

COMMUNITY SERVICE:

Community Organizer and Pastoral Agent.

President Emeritus, Alumni Association.

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

Page 6 [805-***-****]

Contact this candidate