Khalid Draper Email & Phone Number

- Wrote PL/SQL package for Oracle tablespace and datafile management which resulted in a 70% decrease in pageable alerts, and wrote an enterprise wide deployment script using PowerShell and PL/SQL.- Created Windows Powershell script to automate log file shrinkage for SQL Server databases.- Automated creation of SQL Server instances via GUI driven.

Raleigh-Durham, North Carolina Area

• Manage Oracle database administration assignments for various electric utility company clients. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning of database and.
• Developed a process to convert Oracle user accounts to match Active Directory naming convention across 100+ databases.
• Wrote and implemented UNIX shell scripts for rapid deployment of new Oracle databases using two methods: shell database and Oracle’s command line Database Configuration Assistant (DBCA).
• Developed a process using UNIX shell scripts and custom PL/SQL stored procedures to handle partition maintenance for Oracle databases.
• Wrote PL/SQL utility for statistics collection.
• Configured multitenant architecture (pluggable databases) for QA testers.

North Carolina, United States

• Managed DB2 databases supporting TRICARE (military healthcare) applications. Responsible for the end-to-end implementation of the DB2/LUW database systems. Managed the building and testing of new database environments.
• Lead DBA on several TRICARE applications
• Wrote database monitoring and statistics collection scripts.
• Configured HADR for DB2

North Carolina, United States

• Support and maintain DB2 databases for electric utility customers’ data collected from service meters, thermostats, hot water heaters, and pool pumps. Responsible for performance and tuning, high availability, and.
• Wrote stored procedures to simplify reorg, stats collection, and partition add operations.
• Wrote procedure to automate database builds.
• Wrote a shell script based procedure to implement and track application version specific DDL and DML.

Provided database administrative duties for the EPA's National Emissions Inventory production level database. Developed, wrote, and tested backup and recovery plan. Worked with customer to define and generate emissions reports. Wrote stored procedures to automate validation and loading of data. Installed and configured Linux (CentOS) virtual servers as.

Providing backend database support for PL/SQL and Java J2EE applications, including design analysis, performance and tuning, and server upgrades and migrations. Providing front end configuration and support for applications on Oracle iAS.

Atlanta Metropolitan Area

• Responsible for administering Oracle databases on Compaq Proliant servers running NT 4.0 and Windows 2000 server. Transfer of data from Sybase 11 to Oracle 8i instances. Using Erwin to plan entity relationships.
• Used SQL Server 7 data transformation utility in conjunction with MKS Toolkit UNIX emulator for windows to migrate data from Sybase System 11 database to Oracle
• Wrote Sybase BCP scripts to perform data dumps
• Managed 9 Oracle 8i instances
• Upgraded Oracle instances from 8.0.5 to 8.1.0.5 to 8.1.7.4
• Developed backup and recovery strategy for Oracle instances

PC support specialist. Server room operator. Help desk administrator. Sybase DBA.