Desktop Computing and Communications
(desktopcomputingandcommunications.com or sprowl.net)

Resumes

Robert D. Sprowl
Millbrook, AL 36054
Cell: (334) 221-4280  Email: robert@sprowl.net

OBJECTIVE

Seeking a technical position in a team oriented and goal driven environment, specializing in team cohesion and time driven schedules.

EDUCATION

  • Pursuing B.S., Computer Science, Troy University
  • Oracle Master Certificate in Database Administration
  • PeopleSoft Database Administrator Pro Certificate
  • PeopleSoft System Administrator Pro Certificate

KEY SKILLS

Oracle DBA, SQL, PL\SQL, COBOL, PeopleSoft PeopleCode, SQR, Toad, UNIX Scripts, Crystal Reports, Oracle Reports, Oracle Application Server, Erwin Data Modeler

EXPERIENCE

Superindent, CAS Development:  U.S. Air Force  2009 to Present
Managed a 15 member team consisting Java, Oracle, and WAS developers for a $34B munitions inventory system.  Performs manpower and training assessments at project level across the entire program.

  • Oracle Technical adviser responsible for database maintenance and tuning and SQL development.
  • Directed four concurrent releases - cleared 210 user-reported and 481 team identified problem reports.
  • Directed and performed system and software analysis, assessment, integration, and configuration based on Solaris 10, WebSphere Application Server (WAS) 6.1, and Oracle RDBMS 10GR2.

Technical Lead, CAS Oracle DB Development:  U.S. Air Force  2007 to 2009
Technical lead of 4 person Oracle database team responsible administration of 8 development and 2 field look-a-like database instances and 4 database servers.

  • Development and tuning of SQL and PL/SQL reports, packages and stored procedures.
  • Analyzed impact and migrated Oracle database from 9i to 10g to 11g.
  • Developed Unix Shell scripts to push Oracle schema changes to a production database.

Technical Lead, Data Services, Oracle Development:  U.S. Air Force  2006 to 2007
Technical lead 3 person Oracle database team responsible for analysis, design, development and testing of Oracle databases.

  • Standardized software release process and automated deployment of database installations.
  • Established configuration mangement process for maintenance of DB development.
  • Developed Unix Shell scripts to push Oracle schema changes to production database.
  • Wrote and maintained PL/SQL stored procedure, packages and reports.

Centralized Disbursing System DBA:  U.S. Air Force  2004 to 2006
Primary Oracle DBA and Configuration Manager for Centralized Disbursing System.  Responsible for all application security, and database tuning.

  • Administrator for six Oracle development databases, managed migrations and system testing. Installed tools, application patches and upgrades.
  • Primary configuration manager of work orders, database objects, scripts (both UNIX shell and Oracle), and of development documentation using PVCS and RCS software.
  • Alternate system administrator for servers running HPUX-11i.  Responsible for UNIX shell scripts, applying all OS and security patches.

Deputy Software Project Manager:  ARMS U.S. Air Force  2003 to 2004
Manager of a team of nine developers and two Oracle Database Administrators.  Developed Aviation Resource Management System (ARMS) software development schedules maintenance.

  • Prepared and managed development schedules for Risk Management Matrixes.
  • Database administrator responsible for tuning, backup and recovery, stored procedures, and migration scripts.  Applied all applicable Oracle patches and dbms upgrades.
  • System administrator of HP UNIX development servers running HPUX-11i.  Responsible for UNIX shell scripts, applying all OS and security patches.

PeopleSoft SA/Oracle DBA/Programmer:  U.S. Air Force  1997 to 2002
Administrator for five PeopleSoft / Oracle Databases, manage migrations from development through production.  Performed backup and recovery, installed tools and application patches and upgrades.  Responsible for all application security.

  • Analyzed business processes, designed applications, developed and built customizations (using PeopleTools, PeopleCode, SQR, and Crystal Reports), prototyped and tested modules, developed procedures, and converted legacy data.
  • Responsible for all Oracle tuning to include SQL, PL/SQL, tablespaces, rollback segments, monitor and manage extents.
  • Implemented PeopleSoft Student Administration replacing multiple legacy systems.
  • Performed basic administration on two HP servers (V2650 and D380) the databases and application servers.
  • Managed four Citrix Servers, published applications, and fileservers.tested modules, developed procedures, and converted legacy data.

COBOL Programmer / Workgroup Managers:  U.S. Air Force  1991 to 1997
Maintained and developed mainframe COBOL programs for Core Automated Maintenance System.

  • Work the following CAMS subsystems TICARS, Training, Engines, and Scheduling.
  • Windows network work group manager for Cams NT domain.
  • ADPE custodian for 80 percent of CAMS IT hardware and replace and configured all workstations and servers on the account twice in less than 24 mos.
  • Expert in COBOL, Unisys 1100 Executive Control Language and File Transfer Protocol.

Technical Training:  Kessler AFB, Biloxi, MS  1991
Programming Training - COBOL, ADA, programming principles, and Software Engineering Process.

Autotracking Radar Specialist:  Eielson AFB, Fairbanks, AK  1988 to 1991
Operated and maintained MSQ/T43D Threat Emitting Radar which provided simulated AAA/SAM threat to DOD and NATO pilots for Electronic Warfare Training on a tactical bombing range.  Performed maintenance to the component level.

Technical Training:  Kessler AFB, Biloxi, MS  1987 to 1988
Basic and Advanced Electronic Training Autotracking Radar Specialist Training Course.