Manager Management

Henry Gyamfi

***** ******* *** *** ***********, VA 20155

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

OBJECTIVE

I am a highly motivated Database Administrator seeking to significantly contribute to a team of technical

professionals working on latest database systems with a company providing cutting-edge solutions -

driven applications.

PROFESSIONAL PROFILE

• Results-orientated, motivated with solid time management skills.

• Possesses a proven ability to analyze all aspects of database entry in a multi-dimensional

function, in terms of managing multiple tasks and projects with utmost accuracy.

• Displays a high level of energy, integrity and ethics with the exceptional ability to deliver

outstanding bottom line results with short deadlines.

• Possesses an analytical approach to problem solving and detail specificity.

• Highly organized with a focus in prioritizing workload and scheduling follow-ups.

• Excellent writing and organizational skills.

• 8+ years of IT experience and 4+ years of DBA experience.

• Works well under pressure in extremely fast paced environments.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, MS ACCESS.

Operating Systems: Sun Solaris 7,8,9,10, Red Hat Linux, Windows Server 2003/2008 .

Applications/Languages: Oracle Enterprise Manager, SQL, PL/SQL, MS ACCESS, Quest TOAD, SQL

Service, Linux Shell Scripting, SQL Loader, Oracle Recovery Manager (RMAN),

Oracle Data Pump, SSH, Putty VMware.

PROFESSIONAL EXPERIENCE:

Intersections, Inc., Chantilly, VA September 2010 – October 2013

Web Support Supervisor/Database Analyst

Web Support Database:

This database application is used in client server environment. It is used to

capture information regarding website complaints and issues. Monthly reports are

prepared to prioritize production issues.

Responsibilities:

• Interfaced with clients to gather information for various projects including data migration, patch

deployment and application enhancements.

• Installed software such as Oracle Server and Client, Oracle SQL Developer, and Remedy.

• Wrote simple and complex DML SQL statements for production, development and test databases.

• Created schema objects: tables, views, indexes, triggers, sequences, functions, synonyms and

PL/SQL procedures for databases.

• Troubleshot schema issues working with data sets from external sources using SQL Loader.

• Ensured that the non-production environments were kept in sync with the Oracle production

databases.

• Ensured completion of physical and logical database backups for restoration and recovery

operations.

• Established and maintained continuity for all connectivity issues in a client/server and 3 tier

environments.

• Contributed in the testing, analysis, maintenance and enhancement of various IT resources

including application servers, web servers, database servers and end-user computers.

• Performed regular health checkup of production and test databases.

• Performed backup and recovery using RMAN, Flashback Technology and user-managed

backups.

• Managed and performed Tablespace Management, Undo Management, Redo log management,

Control file management, online Redo log management and user privilege management.

• Administered and managed the Oracle Instance using Oracle Enterprise Manager (OEM)

database control.

• Performed Database Instance and SQL tuning using tools like EXPLAIN PLAN, ADDM and AWR

report.

• Performed database physical and logical design and procedures for Production, Development,

Q&A, Test and Training servers.

• Supported standby database and performed failover and switchover from primary to standby

database when needed.

• Performed Database or schema level refreshes using the traditional EXPORT/IMPORT and Data

pump or backup utilities.

• On-call database support.

ISHGLO-ONE CORPORATION Frederick, MD October 2008 – July 2010

Jnr IT Specialist – DBA (Contractor)

Isglo-One Corporation is a minority-owned IT provider of Oracle professional consulting services, specializing in

architecting, implementing, optimizing, and managing Oracle environments.

Responsibilities:

Performed backup and recovery using Oracle 10g's user managed backup such as automated or

manual cold backup and hot backup procedures.

Set up RMAN backups and recovery, RMAN tuning, and maintaining catalog schema. Proficient

in creating auxiliary and duplicate database using RMAN.

Created and configured database by making changes to the Initialization Parameters in

parameter file and dynamically in session.

Wrote scripts for informing the DBA’s regarding the status, performance and Space Management

of the Database.

Performed tuning such as database tuning, SQL tuning such as query optimization (RULE and

COST BASED), AUTOTRACE, and SQL Profile.

Wrote several ad hoc scripts for daily DBA activities such as backups, user creations, granting

roles and privileges, archiving of alert logs, verifying error entries and checking for space

usages/overages.

Upgraded the database from 10g to 11g database and applied database patches (CPU).

Worked with IT support to ensure secure access to database and applications by configuring and

limiting access to servers, managing users and database resources.

Project:

BENJIU EXPORTS Database

This database is used to record every export to comply with company requirement and is used to prepare

statistical reports for analysis.

Responsibilities:

• Designed and maintained Benjiu Exports database.

• Maintained multiple existing databases and prepared reports.

• Linked different database tables and used SQL to set criteria for Reports and forms.

• Used parent and child forms and reports to display user data.

• Prepared reports as needed.

• Used MultiSelet property to make user defined reports.

• Prepared DB manual for training purposes.

Datatrac Information Services, Inc. (Chantilly, VA) – June 2002 to September 2005

Content Research Database Analyst,

Responsibilities:

• Responsible for running developed scripts in TEST, QA and PROD databases environments and

made any necessary changes to correct errors.

• Participated in the planning, implementation and testing of applications and databases.

• Developed and documented processes for meeting compliance and clients’ standards.

• Responsible for loading, extracting, importing and exporting of data.

• Responsible for developing backup, restore and recovery strategy to meet SLA.

SPRINT PCS (Herndon, VA) October 1998 – February 2002

Wireless Data Analyst (Tier II)

Responsibilities:

• Prepared queries and reports for Support Services Department for forecasting

and budgeting, Call Center routing plans, and supporting a variety of ad hoc requests

and projects.

• Provided maintenance and backup security processes.

• Studied requirements and gathered information regarding website issues from

users.

• Used ER diagrams for logical database design and used GUI to physically

design the database.

• Protected database creating password requirements, roles, privileges and

granting access to users.

• Used SQL to prepare queries and build reports as requested.

EDUCATION

• BA, Business Administration (University of Science and Technology - Ghana, Africa) – August

1989 to June 1993

References Furnished upon Request

Contact this candidate