Primarily responsible for SQL and database level tuning and scalability projects for Corporate Express primary OLTP systems. Modified systems to enhance scalability due to migration from legacy systems. Increased workload 100 in two months with no loss of response time. In project to purge approximately 50GB of old data, improved performance by twenty-fold by tuning or re-writing the SQL and parallelizing the process. Performance white papers were written for this client on buffer busy waits, sequential read waits, db_block_size comparison, SQL tuning and file I/O load balancing.
Manage over 35 production and development databases on 14 systems HP, SUN, IBM-AIX, NT . Databases support Peoplesoft HR, Oracle GL and GEMMS in 7/24 operation. Upgraded systems from 7.3 to 8.0 and 8i using Oracle s migration utility and import/export. Created processes to monitor and implement changes to all systems from one machine with shell scripts ksh via remote shell, SQL and other methods. Simplified systems to have a similar look and feel for ease of maintenance, i.e. naming conventions for datafiles, tablespaces and directories, scripts written once to modify any or all of the instances as well as logical and physical backup scripts using BMC SQL*Backtrack. Database project lead for advanced technology projects to include sales-force automation updateable snapshot replication , imaging and Oracle Express all on Oracle 8i. Created and executed plan to move several 100GB+ databases from New York to North Carolina to include tablespace consolidation and reorganization within a very limited timeframe..
Oracle DBA Resume - Donald K. Burleson
Oracle 11.5.1 11I. Fast track implementation of GL, AP, AR, FA, OE, PO, I-procurement, Oracle Projects and Oracle Inventory. Business process reengineering, documentation and setup configurations of Oracle s core financial suite. Setup Oracle Order Entry, Oracle Projects,Oracle OM with Advanced Pricing, Oracle Sales Compensation, Oracle Purchasing with I-procurement, Oracle General Ledger, Oracle Accounts Receivable, Oracle Assets, Oracle Inventory, Oracle Human Resources and Oracle Purchasing. Led a team of 12 consultants and completed on time and on budget. GL Setup with three business entities requiring a set of books for each entity. Setup multiple Inventory Organizations and Operating Entities to facilitate the integration with Oracle Purchasing and Human Resources. Oracle Order Entry was setup for Assemble to Order for specific customer requests with full implementation of Oracle Pricing which is licensed as Oracle Advanced Pricing. Currently providing remote production support on a part-time basis for the client. Upgrade from oracle 11.0 to Oracle 11i.