Oracle DBA and Database Design and implementation specialist

John V. Baker

Summary: Over twenty years experience using relational database technology using Oracle including over eighteen years as an Oracle Database Administrator. Thorough understanding of the Oracle RDBMS engine and utilities required to provide a fully successful Oracle implementation. Understanding of analysis and database design, normalization, data modeling, and capacity planning in a multi-tiered environment. Solid understanding of Peoplesoft, Internet technology, windows based clients and network components. Excellent written, communications and interpersonal skills.

Skills Highlight:

Oracle Products:

RDBMS 11g, 10g, 9i, 8i, 8, 7 and 6, ASM, Designer 6, Developer 6, SQL Developer, SQL*Plus, PL/SQL, SQL*Loader, Data Pump, Oracle Programmer, Enterprise Manager 12c, RMAN, Oracle Application Server 11g,10g, 9

Peoplesoft:

CRM 8.8, HR HelpDesk, FDM 9.1, 8.8, 7.5, HCM/Payroll 9.1,8.9, 8, 7.5, 7.0, 5.12 and 3.22

Life Cycle Expertise:

Data Modeling, ER Modeling, Logical Database Design, Application Development, Test Plans, Testing, Data Conversion, Application Upgrades

Operating Systems:

IBM AIX 7, 6, 3.2.5, AT&T UNIX SVR4, BTOS, HP-UX 11i, 10, Windows Server 2012, XP, Vista, Windows 7, NCR UNIX, Sun Solaris 11, 10, 9, 8, 7, 2.6

Specialty Skills:

Database Administration, Database Tuning, Unix System Administration, Web Application Design and support, Application Migration, PeopleSoft installation and upgrades

Other Products/Languages:

Apache, BASIC, C, C++, Informix 7, Bi-Tech IFAS, HTML, MS Access, Java, Javascript, JServ, Tomcat, Weblogic 11, 10, 9, 8, 6

Project Experience:

Positive Database Solutions Inc., Charlotte, NC 1997-Present

Consultant on the following projects:

Enterprise Iron, Matawan NJ 2014-Present

Subcontractor to TIAA-CREF Charlotte, NC

Provide Oracle DBA support for the NYDFS Special Text Rules project. Responsibilities include automating backup solution. Creating and managing the monthly data load process for data feeds from various sources. Creating and modifying advanced reporting solutions for management on the status of the project. Maintaining and enhancing existing Microsoft Excel and Access Database forms for accessing Oracle database information.

The National Academies, Washington D.C. (part-time) 1997-2014

Provide DBA support for strategic applications including Peoplesoft HR/Benefits and Financials. Perform installation and upgrades of Oracle databases, and Peoplesoft applications including 6 major upgrades from version 5 all the way to version 9. Provide performance tuning of Peoplesoft reports and processes. Provide support for installation, configuration and operations support of department wide web server applications.

Systems Plus, Inc. Rockville MD (part-time) 1999-2014

Subcontractor to the United States Department of Labor

Provide Oracle DBA, UNIX and Windows 2003 system administration in support of Peoplesoft HRMS and payroll, and other department wide applications. Perform capacity planning, hardware selection and, performance tuning of Oracle Databases, as well as UNIX operating system and applications. Provide ongoing operations support and second tier support for the enterprise wide applications of the Department of Labor.

Prophecy Consulting Group, Alexandria, VA (part-time) 1997-2012

Subcontractor to the United States Army Audit Agency

Provide management of the Database Administration team and act as the primary contact to Prophecy Consulting Group. Provide Oracle Database Administration for the Army Audit Management System (TAMS) and its replacement system AASIST. Provide support for the continued maintenance, design and upgrade of the system using Oracle Designer 6, and Developer 6 tools, as well as J2EE and JSP utilizing Apache web servers and Tomcat application servers.

Systems Development Group, Torrance, CA (part-time) 1997-2006

Subcontractor to Sunrise Senior Living

Provide PeopleSoft application tuning, and application upgrade support for HRMS/Payroll and FDM applications. Act as primary contact between on-site consultants and Sunrise management with regards to staffing, billing, and project resources.

Subcontractor to TRW

Provide Peoplesoft Application tuning and upgrade support assistance for the Peoplesoft 6 upgrade of their HRMS/Payroll system.

Radcor Technology, Bethesda MD (part-time) 1997-1998

Consultant on the following project:

American Red Cross, Merifield, VA

Provided Oracle assistance as it relates to Peoplesoft HRMS/Payroll applications. Provided training of DBA’s in continued maintenance and upgrade procedures for Peoplesoft applications. Setup automated procedures for continued maintenance and backup of the Oracle databases.

The National Research Council, Washington D.C. 1995-1997

Provided Oracle and Informix Database administration in support of the Business Systems group applications. Helped to install, test and implement the NRC’s financial system (IFAS) on HP-UX servers. Provided PeopleSoft application administration and upgrade support for upgrades to the HRMS/Payroll system. Provided Oracle Database Administration in support of other department’s Oracle Database applications.

Oracle Government Services, Reston, VA 1993-1995

Consultant on the following projects:

Naval Aviation Systems Command, Crystal City, Virginia

Navair provides logistical support for the maintenance of Navy aircraft.

Provided DBA support for over 21 UNIX servers located throughout the country. Provided technical advice on several large development projects including the Logistical Management Decision Support System (LMDSS) which will be over a Terabyte in size. Performed installation and upgrades of many Oracle tools including Oracle Designer 2000, and Case 5.1.8 in a UNIX and Windows environment. Installed and configured Oracle World Wide Web interface kit and designed several web applications.

SDP Project, Defense Logistics Agency, Columbus, Ohio

The SDP project is a proof of concept project to provide the Department of Defense with a working prototype of a very large database that will replace a legacy system.

Provided technical assistance in solving problems related to very large database issues. Provided support to C-programmers, and UNIX programmers to assist in the development of the prototype. The model made extensive use of Oracle 7.1 advanced features including parallel direct loading, parallel index creation and parallel query capabilities.

PEMEX Project, Coopers & Lybrand

PEMEX Project provides the petrochemical company with a customized installation of Oracle Financials to automate all accounting functions.

Performed Data Base Administration and technical consulting for delivery of custom financials modules to nine remote sites. Environment consisted of NCR 3450 running UNIX SVR4, Oracle 7 and Release 9 of Oracle financials.

United States Army Europe Community Automation System (UCAS) Project, US Army

UCAS project provides the US Army in Europe with a theater wide system for automating all of the functions performed in support of relocating soldiers.

Provided application development expertise using SQL*Forms 3.0, SQL*ReportWriter, SQL*Menu 5.0, SQL*Loader, PL/SQL, SQL*Plus, Pro*C, and UNIX shell scripts on an AT&T 3B2 running UNIX and Oracle 6. Provided DBA Support of multiple local and remote database instances. Conducted performance tuning of Oracle databases. Performed system migration from 3B2 to 3B2 RISC platform.

Enlisted Career Management System (ECM/OCM),

United States Coast Guard, Ultra Technologies 1991-1992

ECM/OCM project provides a comprehensive system for tracking the careers of personnel in the USCG.

Provided full life cycle expertise utilizing Oracle Case 5.0 for database and module design. Case*Designer was utilized for data flow diagrams, and entity relationship diagrams.

Provided application development expertise using SQL*Forms 3.0, SQL*ReportWriter, SQL*Loader, PL/SQL, SQL*Plus, Pro*C and UNIX shell scripts.

Professional Membership:

Member of the Institute of Electrical & Electronics Engineers (IEEE).

Member of the East Coast Oracle Users Group (ECOUG)

Member of the Independent Oracle Users Group (IOUG)

Certifications:

Security+ (2013)

Education:

Bachelor of Science, Electrical Engineering Technology / Computer Science, LeTourneau University, Longview, TX.

Contact this candidate