Douglas S. Hallford
Columbia, MD 21044
410-***-**** (home)
410-***-**** (cell)
SUMMARY OF QUALIFICATIONS
Mr. Hallford has over 35 years of experience in software design, development, test, documentation, and life cycle support of intelligence application systems in secure environments. His experience includes coding in T-SQL (Sybase), Sybase Replication Server, Hypertext Markup Language (HTML), GainMomentum Extension Language (GEL), Perl, Microsoft ACCESS Basic, PL/1, M204 User Language, PROGRESS, and IBM JCL. He has worked extensively with OS/MVS and MVS/XA operating systems using TSO and ISPF/PDF, as well as UNIX, Sun OS/Solaris 5.x, Linux, and Digital UNIX, Windows 95/98/NT and DOS operating systems. His hardware experience includes work with Sun Sparcstation 2/10/20 workstations, Enterprise Server (ES) 450 and DEC Alpha 2100 data server. He also has experience with IBM and clone PCS, XTs, and ATs, as well as Macintosh MAC Plus. He also has experience with IBM RISC 6000, IBM 370, 3084, 4381, and ES-9000 mainframes as well as a PDP-11/70 minicomputer. Provided support to Intel/DoDIIS community and DIA in mission application requirements definition and development.
PROFESSIONAL EXPERIENCE
Insight Global – August 2016 – Present
Senior Database Engineer
Maintain/troubleshoot/enhance SAP/Sybase Replication Server
Maintain/troubleshoot/enhance SAP/Sybase ASE
Install and Configure SAP/Sybase Sybsecurity
Install and Configure SAP/Sybase DBCCDB
Research and present findings on problems and performance issues
Design/code/test/implement automated DBA functions
Deploy/implement application/database software upgrades/enhancements/fixes
Crunchy Data Solutions – September 2015 – January 2016
Senior Database Engineer
Formal and informal training on PostgreSQL.
Attend meetings with current and potential customers to discuss migration issues.
SAP NS2 – October 2014 - September 2015
IT Technical Senior Consultant
Technical support for various SAP/Sybase products including ASE and Replication Server.
Assist in performance tuning, disaster recovery, and migration/installation issues.
SAP NS2 – October 2014 - March 2015
Business Process Senior Consultant
Informal training on SAP HANA product suite.
SAP NS2 (Sybase-Federal) – April 2004 - September 2015
Senior Consultant
DBA for several ASE 12.x and 15.x Servers Sun Solaris.
DBA for ASE 15.3 on Linux (x86)
DBA for several 12.x and 15.x Replication Server Systems.
Perform day-to-day administration tasks.
Designed, wrote, tested, and implemented automated database maintenance procedures.
Design, write, and test an implement adhoc T-sql code for special reports.
Write Sybase stored procedures for specific tasks.
Assist with implementation of Replication in operational and test environments.
Troubleshoot problems at the server and database levels.
Conduct performance and tuning analysis.
Provide technical support and research for various development groups concerning issues related to T-SQL, server performance, and Replication.
Wrote Sybase stored procedures to automate daily maintenance, including dbccs and database and transaction log dumps.
Design and implement Continuity of Operations (COOP) architecture for current project.
DigitalNet Government Solutions 2003-2004
Principal Database Designer/Administrator
DBA for the Sybase SQL database and Replication Server for the Community On-Line Intelligence System for End users and Managers (COLISEUM).
Performed data base and application development related consulting engagements.
Customer support to the COLISEUM user base.
DigitalNet Government Solutions (formerly Getronics Government Solutions) 2003-2004
Manager, Network Solutions
Member of the Intelligence Community Defense Messaging Office (ICDMO).
Test Director to ensure successful IC DMS OA/OT.
Support to Directory Working Group (DWG) for implementation of X.500 Directory Services in support of the IC DMS.
Assisted in the delivery of the Directory CONOPS.
Developed and updated the IC DMS Implementation Plan.
Assisted in the IC DMS Architecture design and development.
Reviewed and updated ICDMO documentation.
Wang/J.G Van Dyke & Associates – 1993 to 2001
Database Administrator
Lead engineer for the design, development, testing, and implementation of the Community On-Line Intelligence System for End users and Managers (COLISEUM).
Task lead and analyst for the DoD Intelligence Production Program (DoDIPP) procedure implementation.
Awarded the Computerworld Smithsonian Bronze Medal for Heroic Achievement in Information Technology for COLISEUM.
DBA for Sybase SQL databases and Replication Server.
Implemented enhancements to Perl Web utilities used on the COLISEUM project (LISA, CSR, COLISEUM Online User Registration.
COLISEUM Customer Support.
Designed, wrote, tested, and implemented COLISEUM 2.x Client using GainMomentum.
Passed DIA LAN LSA test in order to provide the Unix administration for COLISEUM.
Worked with Sybase Professional Services to design, test, and implement a methodology for converting SUN OS based systems to Solaris 2.5.1 for Y2K compliance.
Worked with Sybase Professional Services to design, test, and implement a methodology for converting System 10 (Server and Replication Server) to ASE 11.x for Y2K compliance.
Assisted in the configuration and security planning and testing of the COLISEUM architecture.
Assisted in the COLISEUM ‘cross-domain’ design and implementation using the Wang XTS-300.
Travelled to US and foreign sites (including MOD, DIO, and ASTJIC) to implement COLISEUM (Sybase Server and Replication Server) on Commonwealth, SIPRNET, and JWICS.
Conducted Coliseum User and system training at all sites visited.
Built COLISEUM Systems for OPEVAL tests at all MAJCOMs.
Designed and implemented the US Army’s Automated Requirements management System (ARMS) using Microsoft Access.
J.G Van Dyke & Associates – 1987 to 1993
Information Systems Engineer
Member of the technical staff of the Development and Implementation (D&I) contract supporting USCENTCOM and USSOCOM's development and integration of local and GFS software and software systems.
Provide technical support in the areas of IBM system utilities, Model 204 (M204) User Language and Progress database management.
Assisted in testing and evaluating locally developed, technology share, and GFS software.
Design, code, test, implement, and document M204 User Language and Progress software.
IBM Systems Manager to monitor and aid in the initial configuration and tuning of the IBM system environment.
Assisted in the completion of the "as-built" Program Specification (PS) for the software written in Progress.
Co-technical lead of the team responsible for migrating the M204 based applications (Target Support System (TGT), Battle Damage Assessment (BDA), and Command Position (CPS)) into the PROGRESS environment.
Team lead responsible for incorporating the spreadsheet capabilities developed for the TGT and BDA applications into a Force Status requirement.
Design, code, test, implement, and document the Information Assembly software (INF), an automated, generic report generator that interfaced with three other M204 applications.
Synectics Technology Corporation – 1986 to 1987
Software Engineer
Design, implementation, documentation, and testing of a large input/output oriented segment of application software coded in PL/1, Model 204, and JCL with COBOL/CICS interface.
Wrote PL/1 drivers for testing, creation, and analysis of test data developed documentation using Program Design Language, Yourdon structured design techniques, and structure charts, and wrote and fixed trouble reports during the testing phase of the project.
U.S. Air Force – 1982 to 1986
Information Systems Programming Supervisor
Designing, writing, testing, and implementing new software and JCL streams for several new and ongoing processes.
Debugged and modified current software and JCL streams.
Project Planner for daily and special processes supplying users with various types of data and modes of output.
Tested new software packages for the IBM PC/XT for implementation in the office environment.
Designed, implemented, and documented a CONDOR data base application.
Primary contact for additions, changes, and modifications to a Model 204 database.
EDUCATION
Technology Management, St. Leo College, 12 hours
A.A., St. Leo College, April 1990
Computer languages courses, USAF Technical Training School, 1982
Computer/college courses NMSU Las Cruces, NM, 1976
TRAINING
PMBP Training, November 2003
DII Guard Training, Getronics Government Solutions
DMS Directory System Administration, Lockheed Martin
Sybase Professional Training
Fast Track to Replication Server
Fast Track to Adaptive Server Enterprise (ASE15)
Powering Up with Adaptive Server Enterprise
Performance & Tuning for DBA’s: ASE
Advanced Administration and Troubleshooting for ASE
Technical and computer-related course work, National Cryptologic School, 1982-1986
CERTIFICATIONS
Replication Server 12.6 Professional
TECHNICAL SKILLS
Sybase Products: Sybase ASE 12/15
Replication Server 12/15
Languages: T-SQL, PL/1, Perl, C
Operating systems: UNIX (Solaris 2.x), Windows NT, MVS, MS-Dos, Linux (x86)
Databases: Sybase ASE, Model 204, Progress, dbase, Condor, Progress
Third Party Tools:
Hardware: IBM 370, IBM 3084, IBM 4381, IBM ES-9000, PDP 1170, IBM PC clones, Macintosh MAC Plus, IBM RISC 6000, Sun ES-450, Sun Sparcstation 2/5/10/20, Sun Blade, Sun 480, Sun 240, DEC Alpha 2100 dataserver, Dell PowerServer
SECURITY CLEARANCES
TS/SCI with Lifestyle Polygraph