Lane Jamboretz

Cell Phone: 636-***-****

E-Mail: ac18i7@r.postjobfree.com

SUMMARY

Dedicated, self-motivated professional with more than 28 years of system engineering experience, including database development and administration, data, testing/quality assurance of data, software integration and programming, and call center support. 18 years management experience in database arena. 20+ years of experience with Oracle Relational Database Management System (RDMBS), PL/SQL, UNIX and Disaster Recovery. Quality assurance of data and data integration testing ensure applications function as designed. Continuous testing as required as data and business requirements change.

PROFESSIONAL EXPERIENCE

Adaptive Solutions Group December 2015 – February 2016

Oracle 12c Database Administrator: Engagement CSC, Inc.

United States Airforce

Created and maintained Oracle 12c SSL, Wallets and Certificates using Oracle Wallet Manager (OWM).

Installed and Applied Oracle Enterprise manager installation and security patches.

Worked on migrating databases from Sybase to Oracle on Windows and UNIX servers.

TEKsystems, June 2014 – November 2014

Oracle Database Administrator – Lead: Engagement at SRA International

United States Army (SDDC) – O’Fallon, IL

Manage day-to-day operations of over 50 critical Oracle schemas in an Agile environment.

Created, tested, integrated, maintained and executed SQL.

Solaris UNIX system administration to enhance security; verified changes to meet security requirements would not cause application issues.

Apply Oracle security patches.

Tools: TOAD, ERWIN, SQL Developer

Ferguson Consulting, March 2014 – May 2014

Oracle Database Administrator – Monsanto (St. Louis, MO)

Manage day-to-day operations of over 40 critical Oracle schema’s, 50 TB or more.

Created, maintained integrated and executed Oracle SQL and PL/SQL scripts to update various complex data and relationships for data and application quality assurance. Tested data updates to insure accuracy.

Oracle APEX quality assurance, integration quality assurance application testing.

ASM Research Inc., October 2008 –March 2014

Oracle Database Administrator – Lead: Engagement at United Sates Army Reserve Human Resource Command – St. Louis (HRC-STL), St. Louis, MO

Human Resource Command – Fort Knox Center of Excellence (HRCoE), Fort Knox, KY

Manage and integrate day-to-day operations of over 25 mission essential Oracle instances, lead and mentor diverse team of ASM Research, contractor, and Government Oracle DBAs.

Successfully integrated and migrated databases and systems from St. Louis to Ft. Knox Center of Excellence during the U.S. Army Base Realignment and Closure. Became part of a larger team of Oracle database administrators on AIX, HPUX, and LINUX. Provided quality assurance and testing of data and applications during the entire migration process.

Design, develop, test, integrate, implement, enhance, and administer Oracle databases (30-50 Terabytes) to meet the needs of the Army Reserve Human Resource Command. Provide quality assurance of data for various applications.

Upgrade databases from Oracle 10g to 11.2.0g. Verified data quality, databases and application testing before and after each patch set was applied. Researched possible problems prior to applying database or UNIX upgrades.

Applied required security technical implementation guideline changes (STIG) to multiple Oracle databases. Researched guideline changes, informed and worked with appropriate personnel to incorporate new guidelines.

Design, integrate data and program PL/SQL; program UNIX shell scripts. Verified data at all levels of integration.

Design, document, implement, and participate in disaster recovery exercises at remote locations; verified data, access and applications for quality; all exercises successful.

Monitor and integrate more than 200 external and internal system interfaces using reusable code to maintain mission essential data from external agencies. Provide quality assurance testing in all areas of data transfer.

Apply Oracle upgrades and security patches. Verified data, access and applications prior to and after each patch set were applied. Informing appropriate personnel of possible application implications.

Design, ingrate and verify new backup solutions and implement new technology. Documented, tested backup and restore procedures as new backup solutions were implemented.

Interact daily with developers, functional users, AIX system administers, network administers, and backup team; test and support new development and multiple application enhancements.

Transformed Army Human Resources Command Surgeon review process; eliminated manual scanning of physical exam documents, drastically reducing time needed to review a soldier’s exam and certify for continued military service. Tested documents to verify only the user appropriate documents were displayed and managed.

Extensively supported various data calls, reverse engineering of databases, business process improvement, and application software development and testing.

Tools: TOAD, PL/SQL Developer, ERWIN and RMAN.

Northrop Grumman Information Technology, November 1995 – October 2008

Manager, Oracle Database Administration, Engagement at United States Army Reserve Human Resource Command - St. Louis (HRC-STL), St Louis, MO

Manage day-to-day operations of over 20 mission essential Oracle instances, manage and mentor diverse team of Northrop Grumman, contractor, and Government Oracle DBAs.

Design, develop, implement, enhance, integrate, test and administer Oracle 10 databases to meet the needs of the Army Reserve Human Resource Command.

Design, program and integrate PL/SQL programs UNIX shell scripts for data integration and quality assurance purposes. Verified data from the correct and accurate source was used in the application/reports.

Design, document, implement, and participate in disaster recovery exercises at remote locations; verify data, access and applications; all exercises successful.

Monitor and integrate more than 200 external and internal system interfaces using reusable code to maintain mission essential data from external agencies. Verify data for quality assurance purposes.

Apply Oracle upgrades and security patches; integrally involved with testing and successful migration to IBM database servers and NetApp SAN solution.

Interact daily with developers, functional users, AIX system administers, network administers, and backup team; support and integrate new development and multiple application enhancements. Work with developers and users to verify the quality of the data was used as designed.

Extensively supported various data calls, reverse engineering of databases, business process improvement, and application software development.

Provided past performance for award winning recomplete of the Human Resource Command (HRC-STL) task; participated on HRC IT Support Order proposal team.

Computer Sciences Corporation, June – October 1995

Lead Sybase Database Administrator, Engagement at Boatmen’s Trust, St. Louis, MO

Administered 5 production banking Sybase databases (approximately 200GB).

Created, enhanced, tuned, maintained, and upgraded Sybase databases from Version 4.9.2 to Version 10.

Monitored, maintained, integrated and enhanced daily data replication of production financial data.

Envision, Inc., April 1992 - May 1995

Database Administrator, (Engagement at McDonnell Douglas).

Administered 3 large MVS/Oracle production databases.

Developed backup and recovery strategies; managed database security and tested and tuned applications; reduced production backup costs by 50%.

Implementation Analyst, (Engagement at Southwestern Bell Technology Resources).

Administered UNIX system and Oracle database; installed, created, tested maintained and tuned Oracle databases; ensured data integrity and consistency.

Maintained software control of FLEXPRO, a TRI-developed communications service platform using a UNIX host, programmable telephone switch, voice processing equipment, network interfaces, and Oracle databases.

Designed, tested and implemented integration, system, and acceptance test plans. Tested all new and existing functionality.

Tested and Integrated C++ software, performed line level debugging, and assigned responsibility and prioritized software problems.

Authored extensive documentation on FLEXPRO project.

Managed software control for all developers; created tested and integrated system builds and make files, and debugged compilation errors.

Pipkins, Inc., Jan 1991– April 1992

Implementation Analyst,

Designed and implemented call center forecasting and scheduling software. Tested data and software for quality and reliability.

Authored and implemented integration, system, and acceptance test plans.

Designed and executed user training and training material.

Supported Marketing Team with System engineering.

Affinitec, Inc., March 1988– Jan 1991

Implementation Analyst/Support,

Supported software integration life cycle; customized and tested software, trained user personnel, and supported pre/post installation.

Volt, Inc., March 1986– October 1987

Implementation Analyst/Support,

Created, monitored and maintained corporate interfaces to enhance company asset and crew information.

EDUCATION

B.S. Mathematical Programming, Mathematics, Marine Science Biology

University of Tampa, Tampa, FL 08/1982-05/1986

Contact this candidate