OBJECTIVE:

• To obtain a career with a dynamic company where I can best use my expertise and enthusiastic, team player work ethics.

TECHNICAL SKILLS:

Languages: PHP, Ruby, ASP, JavaScript, VB, VBA, PL/SQL, Unix Shell Scripting (Korn, Borne, Bash), Perl, Java, HTML, C/C++, ADA, Assembler, Pascal, SmallTalk

Applications: WebLogic Server 8/9/10, Altova XMLSpy2007, TortoiseCVS 1.8.x, Eclipse v1, DreamWeaver UltraDev 4/MX, Adobe DreamWeaver CS3, Citrix Applications Administration, FrontPage, Visual Studios, Visual Basic for Applications, Oracle Designer, T.O.A.D., SQL Navigator, SQL Developer, MS Office, Publisher98, Turbo Pascal, Lawson, Peregrine ServiceCenter, VMWare Adminstration/Player, TIBCO BusinessWorks, TIBCO ADB, TIBCO TRA/EMS/Hawk, IBM iSeries Navigator, IBM MQ Broker v7/8, Rumba DB2 tools, DBA Expert DB2 utilities, Oracle DataGuard, Oracle Grid Control (OEM), Oracle Goldengate, Informatica, Oracle Veridata, Subversion, WINCVS, ServiceNow, Aginity, AquaData Studio

Operating Systems: Linux RedHat RHEL 3/4/5/6, Burroughs DOS, MS DOS, Windows 3.1/95/98/NT/2000/ME/XP/2003/2008 Server, Windows NT Server 4, Windows IIS 3 / 4, Apache, SUN Solaris 7/8/9/10, HPUX 11i, SCO UNIX, z/OS 7/8

Protocols: TCP/IP, IPX, HTTP, FTP, UDP

Databases: Oracle 8i/9i/10g/10gRAC/11g/11gRAC, MSDE, MS SQL 7/2000/2005/2008/2008 R2, DB2 UDB, Access, MySQL, iSeries

PROFESSIONAL EXPERIENCE:

Confidential

Sr Oracle DBA / GoldenGate SME / ParAccel DBA

Responsibilities:

• Responsible for managing and mentoring the DBA team, handling the on - call rotation and escalation processes.
• Managing the daily activity and support of the Oracle 10g/11g standalone and RAC database systems.
• Assisting in and providing support on the Stability Project(s) associated with the major production systems.
• Responsible for the development, implementation and support of the GoldenGate replication (10.4/11.1/11.2 ) between DB2/MSSQL/HP NonStop/Oracle databases; and to the Oracle ODS environment.
• Responsible for the monitoring of the GoldenGate Extracts, Replicats and Pump processes. Responsible for the utilization and monitoring of our Veridata servers and jobs for validation of the replicated data between environments.

Confidential

Oracle DBA Consultant

Responsibilities:

• Lead Oracle DBA for the development, tuning and continued administrative support of Oracle 11g RAC and 10g RAC database clustered Linux environments.
• Implemented Oracle DataGuard for the QA and Production 10gRAC and 11gRAC environments.
• Installed and implemented the Oracle Grid Control monitoring.
• Responsible for the installation, support, monitoring, administering, and tuning of SQL Server 2000, 2005, 2008 & 2008R2 instances.
• Lead and implementer for the Oracle 11gR2 RAC cluster upgrades.
• Responsible for the support, tuning and administration of iSeries (AS/400) database instances.
• Responsible for the Administration of the TIBCO EMS server cluster, TRA server cluster and TIBCO Hawk Monitoring for all deployed Replication and Business Processes in the Development and Production environments.
• Responsible for gathering replication requirements, building/designing and deploying Publisher and Subscriber deployment (ear) files.
• Provided and received approval from IBM Sterling (EDI) support for the redesign of provided LOB storage table structures for the use of IOT/IOTO table storage to improve performance prior to implementation of the database and application project.
• Provided administrative, tuning, cloning and upgrade support for the E-Business Oracle Financials Application Development, QA and Production environments using Oracle Financials R12, APEX 4.0 and Oracle 10.2.0.4 databases.
• Designed, tested and implements the following Korn and Bash shell scripts for the Oracle database environments: monitoring ASM Disk usage Tablespace usage shared and local filesystem disk space usage tablespace growth metrics LOB storage growth metrics index rebuilds based upon percentage of empty leaf blocks statistics gathering RMAN full/incremental/block change backups datapump backups the addition/modification/deletion of schema object alerting database health reports (html) daily listener log archival/purges daily alert log archival/purges

Confidential

Sr. Oracle Database Administrator & Sarbanes-Oxley Controls Developer/Implementor

Responsibilities:

• Responsible for the Installation/Development/Tuning/Support of 107 Oracle Databases (5 - 10g RAC(2node) and 2 separate Standby nodes, 4 - 10g, 3 - 9i RAC 1 standby node, 34 - 9.2.0.7, 11 - 8.1.7.4, 5 - 8.1.7.1b, 34 10.2 Grid Control environments). WebLogic System Administrator, PL/SQL, UNIX Shell, Pearl, Java scripting/programming. Support Analyst for Web Base Financial Applications.
• Implementation and testing of IBM’s Websphere Partner Gateway 6.0 for Linux SP6 for upgrades to WICS and ESB infrastructure enhancements. Responsible for review and redesign of DBLoader scripts for IBM identified bugs with the Linux/Oracle 9i version of the software. Provided detailed explanation of reasoning for need redesign of this DBLoader software, particularly for proper Oracle OFA standards, improper assignments of tablespace and user information. Designed, tested fixes for IBM through software demonstrations, teleconferencing and on-site visitations.
• Design, development, setup, implementation and support of Oracle 10g RAC (10.2) 2 node databases using ASM Diskgroups for Data and Flashback Recovery areas and OCFS v2 shared SAN filesystems in conjuction with Failover capabilities using Physical Standby databases running DataGuard Broker agents setup for the Catused.com Development, Testing, UAT and Production environments.
• Responsible for the complete setup of Cat Financial’s Finance Express 9i RAC (9.2.0.7) - 2 node cluster and Physical Standby DataGuard setup with OCFS v1.2 SAN filesystems.
• Fully engaged the CRM upgrade project to both upgrade the Oracle database to Oracle 9i (9.2.0.7) and SIEBEL Application to version 7.7. Provided these efforts with an unlimited commitment to time and resources to meet an aggressively set project schedule. After several successful practice runs in development and a dry run on the Production server over a weekend, the project was successfully accomplished and by further providing 30+ hours of DBA support over the Implementation weekend the systems were tested and validated within a timely manner.
• Planned, tested and implemented the January 2006 - Oracle Critical Patch Update on all Oracle database environments. This is includes upgrading all 9i environments to 9.2.0.7 and applying patches to the 10g and 8i databases as well. Successfully completed the mid year CACD Audit for Sarbanes-Oxley and Database Technology Controls Compliance with many compliments by CACD on the efficiency and effectiveness of our implementation for these Database Technology Controls. Coordinated the Oracle 9i upgrade of both JD Edwards development and production database environments for the same weekend with the requirement of 24hr window for Analyst testing/troubleshooting and the smallest timeframe possible for rollback to Oracle 8i; work to be done in Q3.
• Facilitated DBA cross by providing as much and OJT time with other developing DBAs as possible. Have trained on and delegated the Database Technology and CITA Controls - Monthly Review Process to Junior DBAs as part of this cross- process.
• Working with and other DBA(s) on the utilities and methods that will be used to apply the January 2006 - Oracle Critical Patch Update on all Oracle database environments.
• Designed and tested scripts for the monitoring of the 10gRAC database specifically the status of ASM (Automated Storage Management) which is absolutely critical in the availability of the Catused Database.
• Assisting and the UNISON DBA personnel as needed. Most assistance this year has been on Monitoring and Database Technology Controls. Providing new concepts and Caterpillar Security Control processes and methods to Oracle Contract personnel onsite for development of the new Oracle11i, 11h and 12 Applications OLM module for Leasing to replace the existing Unidata Infolease systems.
• Developed, tested and continue to update the Account Management and Database Technology Controls processes with revisions providing greater clarification of duties and backup/rollout steps.
• Evaluating and providing feedback to ISS in Peoria on potential new Database Technology Control Compliance Scans that will be performed by Peoria.
• Evaluating latest Database Technology Controls from ISS in Peoria for “Locked Accounts”.
• Continuing to work toward the completion of the necessary Database Technology Controls and Key Sarbanes-Oxley Controls to all Production oracle databases.
• Architecting a new database user account password expiration email setup to notify users of looming password expiration, actual expiration and notifications prior to account removal.
• Installed Oracle 10g EM Grid Control to help establish an enterprise wide Utility that can be used to monitor, update and manage all Oracle database environments from one console.
• Developed a handbook to use as a tracking tool for the Account Management process. Continuing to train and mentor the other DBAs on best practices also putting forth best effort to keep all up to speed on changing processes.
• Working on processes and policies for our DBA group to help fit the new DB Technology Controls and CITA compliance into our work flow. Continuing to train and mentor the other DBAs on best practices also putting forth best effort to keep all up to speed on changing processes.
• Continuous review of DB Technology Controls Compliance Monthly Review process. and Mentoring other DBAs while getting them involved in the procedures for implementing and validating of Controls within all Oracle databases.
• Worked from home developing a Web based Application to help manage, monitor and activate accounts for the Sarbanes-Oxley Auditing process in Finance Express and JD Edwards using DreamWeaver 8 (ASP / JavaScript).
• Developed on a new auditing method in the 9i RAC environment for Finance Express which will better account for multiple Help Desk or CCM Ticket completions in a 24 hour period.
• Interpreted, designed, coordinated, tested and implemented new Database Technology Controls to include required CITA password standards on the FSA production and development databases. Worked on completing the effort on all other production and development databases.
• Have designed, tested, implemented Compliance process documents and “Proof of Compliance” reports for the Oracle Databases which will be used monthly for the mandated Compliance Review. Have also organized filed exceptions and evidential materials for the Data Services group to use for .
• Set up and trained the CCM group so that they could use their own database accounts to promote Data Modification changes within the JD Edwards production database.
• Provided to the UNISON Team all associated design, implementation, process and procedure documentation, as well as code and applicable correspondence for the Sarbanes-Oxley controls that I developed for Cat Financial.
• Worked on and successfully deployed nightly export scripts for the UNISON database environments which helps the DBAs in that group recover their databases if corruption occurs.
• Provide and mentoring on the Oracle database environments and HP-UX and Linux scripting efforts to our other DBAs.
• Attended a Customer Service Class at FPD in September to help identify any additional areas that could be improved to provide greater quality of support to our customers.
• Attended a Business Writing course at FPD to enforce my writing skills and help promote a higher standard of customer support results based on clarity of communications.
• Provided about new Data Modification process and procedures for FSA databases to all DBAs.

Confidential

Administrator and Sr. Oracle 9i Application Systems Administrator

Responsibilities:

• Senior Database Administrator, responsible for Database and System Administration of 2 Oracle Database 8i servers.
• Senior Oracle 9i Applications Administrator, responsible for Application and System Administration of 2 Oracle 9i Application servers.
• Responsible for redesign and fixes needed for Oracle Developer 6i Reports.
• Design reports for Department of Labor for Annual and Quarterly reporting of Performance Measures statistics and grant review.
• Responsible for tuning of current 8i Databases to increase performance and data integrity.
• Systems Administrator on four servers which initially ran on Windows NT, which after performance evaluations were upgraded to Windows 2000 Server. Responsibilities include network interoperability, maintenance and troubleshooting, loading/unloading of software upgrades and/or enhancements.
• Responsible for developing and staging a Mentorship program for Information Systems Alabama State employees using Oracle products

Confidential

Developer / Customer Support / Database Architect

Responsibilities:

• Developed a web-based application using Active Server Pages (ASP) as the primary method of interfacing with a MSSQL database server to call and present data as well as save data back to the database server; using HTML and JavaScript to give functionality and interactive objects to the user through a Graphical User Interface (GUI) allowing Air Force budget planners to more accurately forecast future budget requirements to support operation of Air Force bases worldwide.
• Responsible for all developed functionality of the web application to include budget scenario generation, budget scenario archiving, budget scenario recall, budget scenario graphical generation, report generation, user registration, user login, and user settings. The budget scenario generation function includes identifying when attributes fall outside predetermined performance values. Additionally, the budget scenario generation function included the use of a linear programming mathematical algorithms which I developed and implemented through the use of
• Statistical Analysis textbooks.
• Developed access levels, rights and secure key methodology using the industry-standard RC4 algorithm; which is secure and reversible.
• The development of the database was initially designed and tested using ACCESS 2000 and then re-engineered to use MS SQL.
• Web Chart 7.0 is the tool used to develop the graphs needed to display the placement or displacement of the numbers generated through the system to give a better understanding and to give more meaningful results to the customer. This web-charting tool was used more as a jpeg generator for the graphs and the format and data queries were done using both ASP and
• JavaScript. e-Learning Course Development / Code Enhancement / Testing
• Onsite consultant for TOOLBOOK e-Learning course developers involved in Java, Java BeansJavaScript, VBScript and Lawson software.
• Designed and developed login and security access level user methodology for coding of web- based e-Learning courses and Managerial, Professional and Student Quality Management questionnaire website applications.
• Learning Management Systems (LMS) Developer
• Analyzed and determined problem sources in COM objects (.dll) for re-engineering to make enhancements for Learning Management System course connections to better handle AICCSCORM, NETG and HTTP DOC e-learning courses and memory error handling.
• Database Administration (MS SQL Server 2000)
• Alternate MS SQL 2000 Database Administrator on servers handling three Instances with a total of 13 databases for six Learning Management Systems, four on-line websites and 3 website applications.

Confidential, Montgomery, AL

Lead Oracle Database Administrator/Lead PL/SQL Programmer/Systems Administrator

Responsibilities:

• :Performed Oracle database administration functions for the On-line Vehicle Interactive Management System (OLVIMS), affecting over four hundred Air Force Units and one hundred and ten thousand vehicles worldwide.
• Responsible for designing, developing and maintaining an Oracle 8.1.6 Database on four HP servers (1 L-class, 2 N-class, 1 V-class) and 1 SUN Enterprise 5500 with thirteen materialized views made up of snapshots from all 335 schemas, which resided on each server.
• Maintained all servers as System Administrator. Proficient in shell scripting with HPUX, SCO UNIX and Solaris.
• Lead programmer for 67 OLVIMS Vehicle Dispatch PL/SQL reports. Responsible for verification of reports with the customer and accurate completion of all requirements.
• Configuration Manager responsible for tracking and maintaining all software, scripts, Java code/objects and design documentation using Starteam 3.25 and PVCS CM software tools.
• Constructed and maintained Replication Schema process for Oracle databases allowing same data on multiple servers.
• Developed and implemented database backup and recovery actions.
• Created software programs that automate DBA functions.
• Responsible for performance and tuning of databases for optimal performance.

Confidential, Montgomery, AL

Computer Programmer

Responsibilities:

• Primary programmer for Pascal, Assembler and database software, made modifications that enabled new procedures and hardware utilization, resulting in sixty percent faster software changes and system testing.
• SCO UNIX System Administrator, responsible for system communications, security, shell scripting, backups and auditing.
• Lead tester for operational test and acceptance of contractor installed hardware upgrades at US Strategic Command, a seven month, $250,000 project resulting in a ten percent faster system and more reliable access to the emergency messaging system.
• Solely responsible for the modifications to IEMATS Communication Assembler Language software, a three hundred percent increase in emergency message storage capacity, which was a direct impact for national security personnel.

Confidential, Montgomery, AL

Computer Programmer and Technical Advisor - ADA Programmer

Responsibilities:

• Redesigned five programs in ADA programming language saving over $80,000 in contracted development costs and shortened delivery schedule by 25 percent.
• Helped with research done in preparing for the Oracle Forms conversion decision.