SUMMARY:

• Highly skilled Oracle DBA with strong PL/SQL and SQL programming skills and experience modeling, administrating, optimizing, and otherwise refactoring business critical database applications.
• Performance tuning skills include STATSPACK, AWR, TKPROF, and explain plan.
• UNIX skills include Linux, Solaris, Confidential - UX, and AIX.
• Led large Oracle database application projects for both Department of Confidential, and various Fortune 500 organizations
• Identified and tuned worst SQL reducing batch processing time for Oracle/Java AMEX Name and Address matching application from eight hours to several minutes
• Reduced Wells Fargo Cost Recovery batch processing from 7 hours to approximately 70 minutes for Oracle data warehousing web application
• Reduced HDS Confidential PL/SQL batch processing from 12 hours to less than 90 minutes to comply with Bristol-Myers Squibb SLA (Service Level Agreement)
• Assisted in development and documentation of PL/SQL coding standards for APS, Confidential, Cyclone Commerce, Wells Fargo, Advanced Foodsystems, and various Confidential agencies
• Staffed, mentored, and managed outsourced Oracle DBA support teams
• Refactored and normalized database schema serving as backend to Cyclone Commerce’s flagship e-commerce application dramatically improving performance and data integrity
• Proficient using Oracle tracing, TKPROF, AUTOTRACE, DBMS PROFILER, and AWR in conjunction with OS performance statistics to identify and eliminate severe SQL and PL/SQL bottlenecks and dramatically improve response time

EXPERIENCE:

Confidential, AFB Ogden, UT

Oracle DBA

Responsibilities:

• Responsible for installing, configuring, backing up, patching, and otherwise troubleshooting Confidential databases in support of various Confidential agencies including upgrades to 11g and administration of Oracle Application Server.
• Upgraded 10g databases to 11g prior to Oracle support deadline
• Applied July CPU to Confidential databases per Customer requirements
• On-Call rotation in troubleshooting and otherwise supporting various 24x7 defense systems
• Responsible for all RMAN backups, cron jobs, and other scheduled processes using Control-M

Confidential, Fairborn, OH

Technical Lead

Responsibilities:

• Led technical effort to win Confidential IT tracking system including the installation, configuration, and overall reverse engineering of application database and source code.
• Responsible for scheduling and managing weekly tasks as well as project requirements.
• Oracle DBA, PL/SQL programmer, and Discoverer 11g administrator
• Ran, customized, and otherwise created all Reports for Pentagon and Confidential CIO
• Installed Oracle 10G on VMWare running Windows 2003 Server
• Installed Subversion and migrated production Repository to test environment
• Created and managed MS Project schedule for initial migration requirements
• Reverse engineered Confidential tracking system data model consisting of approximately 376 tables and 100,000 lines of PL/SQL in Packages, Procedures, and Functions
• Maintained ERwin Data Model Subject Areas to assist in mapping Change Requests and identifying core application tables
• Responsible for all Reporting BCRs and production maintenance and troubleshooting of EITDR (Enterprise Information Technology Data Repository)

Confidential, Washington, DC

Sr. Oracle DBA

Responsibilities:

• Installed and upgraded Oracle 10G database for new CLEOC environment
• Installed missing and required Red Hat Linux packages for Oracle 10G
• Installed OPatch and configured Enterprise Manager patching for new production database
• Configured RMAN backups
• Completed PL/SQL Server Pages bug fixes for CLEOC User Interface to enforce required fields, format masks, and fix other dependencies for management of Juvenile court cases
• Worked with NCIS end users to gather requirements for code fixes
• Coordinated testing with test team
• Used Subversion with Tortoise for CM and source code repository

Confidential, Melbourne, FL

Oracle DBA

Responsibilities:

• Reactivation of Top Secret clearance and full scope polygraph for deployment.

Confidential, Fairborn, OH

Sr Oracle Consultant

Responsibilities:

• Program Management Office Sr. Analyst managing portfolio of Interfaces and Data Conversions including monitoring and troubleshooting BPEL, working directly with FMO and SI (System Integrator), and authoring Sustainment and Scalability whitepaper for Director of the DEAMS program.
• Managed portfolio of legacy system interfaces to Oracle Federal Financials
• Worked with SI (System Integrator) and FMO (Functional Management Office) to monitor and expedite creating, testing, and deployment of SOA-based interfaces
• Provided Program Director with Sustainment and Scalability analysis of DEAMS
• Worked with Confidential legacy system Interface Partners to assist in validation of DEAMS BPEL outbound interfaces
• Assisted System Integrator in troubleshooting of BPEL related errors including BPEL processes not archiving inbound files to NFS mounted directory

Confidential, Beavercreek, OH

Oracle ERP Technical Lead

Responsibilities:

• Led a team of 9 technical data migration programmers and developers in test loading Confidential legacy source data to Oracle EBS target.
• Defined all programming and best practices standards for Extracting Transforming and Loading Confidential legacy data
• Led GCSS-AF integration team to ensure compliance with IA, security, and production migration standards
• Led development of CV.060 AIM template modifications to mirror our data migration process
• Worked with IA and Security to ensure compliance with Confidential security standards for Conversions including source code scans for potential security vulnerabilities

Confidential, Beavercreek, OH

Sr. Oracle ERP Consultant

Responsibilities:

• Assisted in conducting Source to Target mapping data migration workshops for Customer, Price List, Carriers, and Maintenance Programs with Confidential legacy systems Subject Matter Experts.
• Assisted in data mining, profiling, and test loading of Source legacy data across all ERP modules.
• Assisted in authoring and editing Data Migration Strategy CDRL for Confidential review and presentation to Pentagon
• Profiled legacy system data for mapping from source to target using Business Objects Composer, Business Objects Insight, as well as PL/SQL Developer
• Used PL/SQL and Oracle 10G regular expressions to profile, aggregate, and otherwise analyze Confidential legacy system data for data cleansing recommendations
• Leveraged Business Objects Composer to map legacy data to Oracle r12 API interface tables
• Generated and assisted in editing AIM documentation including BR100sw, CV40s, and CV60s
• Assisted Solution Design Lab team with loading sample Air Force data for Air Force personnel on-hands training labs
• Led and conducted various Process Team sessions in completing deliverables for CRUD Matrix and mapping of Air Force external interfaces to business process flows

Confidential, Garland, TX

Database Engineer

Responsibilities:

• Assisted in Oracle 10G RAC administration and configuration on Red Hat Linux
• Used HammerOra to stress test mission critical e-borders use cases and transactions
• Installed and assisted in administration of Oracle Designer
• Worked with Data Architects in designing of abstract, logical, and physical generation of 3NF database application schema
• Assisted in configuring Hibernate, mapping, and generating Java source files from application schema including installation of Hibernate, Ant, and Oracle JDBC drivers
• Used RunStats package to benchmark BULK COLLECT/BIND as well as general use of BEFORE triggers versus Hibernate sequence and timestamp generation on INSERT or UPDATE

Confidential, Fairborn, OH

Oracle DBA

Responsibilities:

• Assisted full time DBA team in installation, troubleshooting, and optimizing of Oracle 10GAS Air Force budgeting application.
• Provided recommendations to management regarding application refactoring, scalability, and migration to CBO.
• Assisted in installation and configuration of Oracle 10G RAC lab environment
• Identified and created missing FK indexes to prevent locking and unnecessary full table scans
• Identified and created missing PK constraints including unique indexes
• Assisted full time DBA regarding AWR, performance tuning, and testing of 10G AS web cache

Confidential, Mason, OH

Lead Oracle DBA

Responsibilities:

• Led DBA team in the backups, administration, troubleshooting, and performance tuning of Oracle 10G RAC on Linux.
• Provided troubleshooting and SQL tuning assistance to offshore team of Java Developers.
• Configured RMAN incremental and full database backups for two node RAC cluster
• Led and standardized all database DDL, DML, and PL/SQL related releases including coding standards and SCM workflow
• Worked with preferred vendors and IT Management to architect next generation release of STARS loan application for migration to local data center
• Benchmarked and tuned various PL/SQL packages, procedures, and functions used by core business for operational reporting
• Assisting in evaluating and staffing offshore team of Jr. Oracle DBAs and Java Developers

Confidential, Reston, VA

Oracle DBA Consultant

Responsibilities:

• Assisted DBA team in support of Oracle 9i databases on Confidential -UX including capacity planning, replication, and troubleshooting of various SQL based reports.
• Authored Confidential employee timesheet data extract from Data Basics payroll software as part of Federal requirement to track Confidential hours and billable activities
• Assisted in SQL Loader scripts and syntax for migration template of LAWSON data to SAP as part of ERP migration
• Assisted in installing, configuring, and integrating APEX/HTML DB with Active Directory using custom AUTHORIZATION layer for SOX compliance

Confidential, Scottsdale, AZ

Oracle Consultant

Responsibilities:

• Provided both DBA and developer skills in working with newly acquired Financial Services module.
• Assisted developers in export and import of tables, schema changes, and synchronizing of development schemas
• Wrote PL/SQL code for ETL on source data provided by Chase Bank.
• Write algorithm for comparing custom FICO ranges as part of ETL

Confidential, Fairborn, OH

Oracle DBA Consultant

Responsibilities:

• Provided expert Oracle DBA skills in optimizing database batch processing and overall database performance for Confidential budgeting application.
• Assisted in Oracle 9iAS administration including Discoverer Plus report optimization and applying security related patches.
• Installed and leveraged STATSPACK to collect Oracle 9i baselines
• Refactored Oracle 9i ETL package using BULK COLLECTING, BULK BINDING, Index Organized Tables, global temporary tables, direct path load, and commit frequency reducing load time by more than 50% for Confidential budgeting application
• Used DBMS MVIEW package with MV CAPABILITIES TABLE table to rewrite materialized views for FAST REFRESH reducing refresh time from more than 12 hours to approximately 2
• Implemented PL/SQL package to issue commit at set interval to optimize batch processing reducing redo log related waits
• Optimized Teradata ETL process using FastLoad with FastExport and MULTISET global temporary tables

Confidential, Versailles, OH

Oracle DBA Consultant

Responsibilities:

• Oracle 11i DBA assisting developers in meeting custom reporting requirements defined by end users and analysts in Finance, Order Management, and Accounting.
• Provided expert assistance in troubleshooting various Oracle 11i performance issues as well as application errors.
• Created Discoverer 4i reports for business analysts and management
• Leveraged STATSPACK to identify key bottlenecks in 11i modules
• Introduced Discoverer 4i summary management for long-running reports
• Provided reporting strategy for building Discoverer EUL against 11i

Confidential, Huntsville, AL

Oracle DBA

Responsibilities:

• Oracle DBA for uniRAM application used by Army and Confidential in testing, auditing, and reporting of equipment reliability, availability, and maintenance.
• Provided Forms and Reports 6i expertise as well as Discoverer SQL Server 2000 administration skills.
• Installed and configured Oracle 10G for Linux (Fedora) on Dell server
• Assisted in the development, troubleshooting, and refactoring of application 6i Forms and Reports
• Developed PL/SQL XML module for extracting and transforming uniRAM data using XSLT
• Configured Discoverer 4i Viewer for XP and Windows 2000 clients using IE 6.0 browser with Microsoft JVM
• Assisted Sr. Web Developer in configuring ASP .NET application to connect and authenticate against Oracle 9i
• Leveraged Oracle Migration Wizard to convert SQL Server 2000 stored procedures to Oracle 9i

Confidential, Scottsdale, AZ

Oracle DBA Consultant

Responsibilities:

• Assisted in database migration from Sybase to Oracle 9i.
• Provided expert assistance and direction to developers and Oracle DBA regarding database backups, hardware requirements, and PL/SQL best practices.
• Converted Sybase stored procedures to Oracle 9i PL/SQL for government application used to reverse engineer various networks for both foreign and domestic governments
• Set up weekly backups using OEM 9i
• Configured OEM 9i Change Management baselines for scheduled synchronization between development and production databases
• Developed PL/SQL template for converting remaining Sybase stored procedures eliminating need for redundant coding efforts

Confidential, Phoenix, AZ

Principal DBA

Responsibilities:

• Responsible for all Oracle database administration and integration including the development of documented installation and configuration standards.
• Project lead and principal architect on divisional Oracle database consolidation initiative.
• Configured and optimized RMAN Oracle backups on Solaris 8
• Architected and configured Sun Fire V1280 solution for migration and consolidation of Oracle databases running on OpenVMS
• Upgraded FACTORYworks Oracle 8.1.7.4 database and assisted in upgrade of clients
• Standardized Oracle file system and documented future OFA compliant naming standards
• Designed first draft of data mart star schema working with various Engineers and QA professionals

Confidential, Scottsdale, AZ

Oracle DBA Consultant

Responsibilities:

• Provided expert assistance and documentation in troubleshooting and eliminating reoccurring outages associated with mission critical e-commerce application responsible for conducting business with large clients including Confidential .
• Analyzed and eradicated various JDBC and Oracle related errors.
• Provided expert assistance to DHL Express in cooperation with production Oracle DBA.
• Eliminated reoccurring outage in mission critical e-commerce application used to transact daily business between DHL and Hewlett Packard
• Reduced Cyclone Central UI (User Interface) response time from over several minutes to less than 10 seconds
• Eliminated severe bottleneck in mission-critical nightly archiving process reducing processing time from over two hours to less than three seconds
• Reset RESOURCE MANAGER PLAN initialization parameter to eliminate severe Oracle database hang
• Installed STATSPACK in order to provide baseline of performance monitoring and comprehensive metrics regarding overall throughput and peak concurrency

Confidential, Phoenix, AZ

Oracle DBA Consultant

Responsibilities:

• Provided expert troubleshooting and performance tuning skills in identifying top five waits as well as various JSP and Excel based web report errors.
• Served as Oracle technical lead as well as Sr. DBA in optimizing and further developing Name and Address matching application for Confidential Tier II credit card markets.
• Configured all RMAN backups, OEM 9i events, and provided training to outsourced DBA team in India
• Identified most intensive SQL as well as code related dependencies reducing processing time for several reports from six to eight hours to several minutes
• Authored over two hundred PL/SQL audit reports for Java based Name and Address matching application being launched in tier II credit card markets
• Rewrote Mexico Match Report critical to validating Name and Address matching statistics for bi-monthly processing
• Mentored team of developers in BULK COLLECTING and BULK BINDING as well as Oracle PL/SQL best practices
• Leveraged Oracle tracing and TKPROF in tuning worst application SQL
• Optimized bi-monthly batch processing for Brazil eliminating prior snapshot too old errors as well as intensive parsing and table fragmentation

Confidential, Phoenix, AZ

Oracle DBA Developer

Responsibilities:

• Assisted in architecting and configuration of Oracle 9i release 2 database and UNIX server for benchmarking and stress testing.
• Provided documentation and advice to Team Lead in migrating the Confidential development lifecycle to leverage Extreme Programming and unit testing practices.
• Documented and mentored developers in using utPLSQL, an open source unit-testing application.
• Installed utPLSQL and provided over thirty examples as well as documentation for unit testing of PL/SQL
• Extended utPLSQL API to include testing and comparison of Oracle collections
• Installed and configured STATSPACK for benchmarking and stress testing of retail software application
• Provided initialization parameters and best practices for initial configuration of Oracle 9i stress testing and benchmarking environment
• Configured NCOMP (Native Compilation) for benchmarking of mathematically intensive PL/SQL
• Configured Oracle 9i Directory Objects in order to avoid dependence on UTL FILE DIR
• Installed DBMS PROFILER for stress testing and analysis of PL/SQL bottlenecks utilizing BULK COLLECTING, BULK BINDING, and RECORDs of COLLECTIONS

Confidential, Phoenix, AZ

Sr. Web Developer

Responsibilities:

• Assisted in architecting, authoring, and implementing web application for Scottsdale, AZ Application Service Provider offering various advertising and promotional services.
• Functioned as both web developer and MySQL DBA in developing PHP, Perl, and JavaScript web application as well as configuring production Solaris 9 server.
• Designed 3NF data model using ER/Studio and IDEFX1 convention
• Assisted in authoring of PHP, Perl, JavaScript, and HTML code for MySQL database application serving as primary business application for Add Vantage services offering
• Assisted in the installation and administration of MySQL Max 3.23.54
• Installed and compiled PHP 4.3.1 as Apache 2.0 module on Solaris 9 test environment
• Provided expert advice and assistance to ISP in configuring Apache 2.0 and MySQL Max

Confidential, Phoenix, AZ

Oracle Lead Architect

Responsibilities:

• Advised Vice President, CEO, and IT Manager in identifying and eliminating severe ERP application bottlenecks. Architected, documented, and recommended migration path to Board of Directors.
• Provided production Oracle DBA support to key customers in the US and Canada including RMAN, OEM, and basic database maintenance
• Identified and documented severe application bottlenecks in architecting long-term refactoring strategy for Velocity ERP currently serving as new strategic direction
• Providing benchmarking results and system architecture recommendation to Board of Directors under extremely compressed deadline of 30 days
• Authored custom benchmarking and load simulation scripts to document and validate limits of Velocity ERP application scalability
• Set undocumented SQL Server 1211 trace flag eliminating severe performance degradation and application hang occurring at customer site
• Performed all benchmarking and scalability testing of flagship ERP application running on Oracle 9i and Solaris 9
• Installed Solaris 9 and Oracle 9i on SUN FIRE 4800 loaner server for scalability testing