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 Powershell script which reduced instance creation turnaround time from 2 hours to 20 minutes.- Developed Powershell script to automate building of multi-instance SQL Server clusters, including High Availability groups, listeners, and port assignments.- Created Powershell script to automate creation of Oracle instances.- Developed Bash shell monitor to report up/down status for Cassandra databases.

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 application SQL, and conduct regular system backups. Ensure technical and functional designs meet business requirements. Administered Oracle databases (11g/12c/18c) on Unix(Linux), Solaris, and Exadata.• 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, and the enhancement, administration, and backup and implementation support for 10.1 and 10.5 database systems on AIX and RedHat Linux.• 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 backup and restore operation.• 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 well as build database instances for development, test, and staging environments. Migrated legacy data to new platform. Worked on the data modeling team to design physical and logical model for new emissions application.

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• Administered NT 4.0 and Windows 2000 server on Compaq Proliant hardware• Wrote customized export/import interface for Oracle instance in Visual Basic 5.0• 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• Developed backup and recovery procedures for NT servers• Worked with application developers to design sound application schema designs using ERwin• Managed and hosted applications in Microsoft IIS web server• Performed RAID 5 configuration

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