Oracle DBA, Project management, ETL

KERL SENA TSAHEY, PMP, OCA

Address: Dumfries, VA 22026.

Telephone: 202-***-**** Email: acdk74@r.postjobfree.com

OBJECTIVE

To get the opportunity to work as an Oracle DBA with an organization that will give me a chance to

maintain focus on implementing the most cutting edge and cost effective deliverables for specific client

needs, advise on available technology alternatives, architect optimal design strategies, execute

implementation and provide related training and ongoing support as needed. Thereby allowing me to

integrate my personal goals with that of the organization

EXECUTIVE SUMMARY

• A Highly motivated, self-starter with 5+ years of IT experience coupled with proven desire and

commitment to continually learn and apply new technologies.

• Maintain focus on implementing the most cost effective deliverables for specific client needs.

Advise on available technology alternatives, architect optimal design strategies, execute

implementation and provide related training and ongoing support.

• Proven ability to install and administer Oracle and SQL Server databases in a variety of operating

system environments including Microsoft Windows, Solaris, Linux, HP-UX, AIX and Unix SVR4.

• Proficient in Installation, Troubleshooting, Maintenance and Technical Support for Oracle (11g and

10g) Databases, Grid Control and OEM, RAC and Data Guard.

• Experienced in the use of replication technologies including Golden Gate, Streams, and

Materialized Views.

• Adept at providing leadership, managing multiple concurrent projects, being attentive to detail

whiles maintaining the ability to make rational decisions in pressure situations.

PROFESSIONAL EXPERIENCE

12AM SOLUTIONS INC., Brunswick, MD 03/2010-01/2014

[Customer: Engineering Consulting Services, Aetna, Chaveran Inc.]

Oracle DBA (Contractor)

Responsibilties:

• Installed Oracle Enterprise Manager and developing setup to help maintain all databases

centrally

• Lead database security audit vulnerability assessment and remediation projects.

• Installed, Maintained, and Upgraded database software and installed patches to different

versions of Oracle

• Performed Restoration, Recovery and refreshed databases as needed, using Data Pump and

RMAN utilities

• Designed executed and documented customized procedures for upgrading Oracle databases to

11gR2 using cloning methods to maximize efficiency.

• Used SQL*LOADER and Data Pump to parallel bulk load large amount of data (7 TB, more than

18,000 tables) into Oracle 10g, and 11g databases while ensuring data integrity.

• Developed custom utilities to automate manually intensive tasks including mass schema

changes, recovering Golden Gate corruptions and managing host/cluster maintenance mode

blackouts.

• Serve as Subject Matter Expert and Project Lead in a variety of areas including Oracle Streams,

database security and auditing, backup and recovery, performance tuning and Unix shell

scripting

UPTIME SYSTEM, Frederick, MD 03/2009-03/2010

[Customer: XCELTECH INC, GC&T]

Oracle Database Specialist (Contractor)

Tasks Undertaken:

• Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4-11.1.0.6

• Used Crontab and Windows Schedulers to schedule shell scripted jobs for automated database

system/operational monitoring (alert.log/trace files, CPU usage, synchronization, Oracle

background processes) and daily backup jobs (RMAN/EXPORT)

• Undertook writing of SQL & PL/SQL scripts to access, define, and manipulate Oracle data in

10g and 11g environments;

• Performed backup and Recovery procedures to include exporting and importing database

objects, Schemas and whole databases where needed;

• Ensured database security by creating/modifying user accounts, profiles and granting

appropriate privileges;

• Researched and implemented test methodologies for best practices;

• Analyzed user requirements, attended change request meetings to document and help

implement those changes into the testing cycle;

• Executed UNIX shell scripts and analyzed the execution logs of batch jobs.

EDUCATIONAL BACKGROUND

George Washington University, School of Engineering and Applied Sciences, Arlington, VA

Master of Science Engineering and Technology Management May 2014

Kwame Nkrumah University of Science and Technology, School of Engineering, Kumasi-Ghana

Bachelor of Science Metallurgical Engineering March 2002

OTHER QUALIFICATIONS AND CERTIFICATIONS

• Oracle Database 11g Administrator Certified

• Project Management Professional Certified (PMP)

• Scrum Master Certified

• Programming Languages: SQL, PL/SQL, Unix Shell Script (Korn, Bash Shells)

• Operating Systems: Unix (Solaris, HP UX, AIX), Linux, Windows 7, 2003/2008

• Databases: Oracle 11G/10G/9i MS SQL Server

• Tools: VI, Text Pad, Data Guard, Grid Control, OEM, Toad, Putty, VM Ware, RMAN, RAC, ASM,

SQL Loader, AWR, Service Manager

Contact this candidate