We provide IT Staff Augmentation Services!

Database Administrator Programmer Resume

5.00/5 (Submit Your Rating)

Ashburn, VA

EDUCATION

A.A. Computer Information Systems
B.S. Computer Information Systems

SUMMARY

Several years of computer related experience. During this span worked in Data Communications, Computer Operations, Application Programming, Quality Assurance, and Database Administration. Supported several Government and commercial programs that provided design, development and implementation experience having national and international scope. As senior technical person responsible for several major projects in the areas of Datacom, COBOL/IDEAL programming, Database Administration, Software Conversion, and Quality Assurance, Documentation and Program development and maintenance. Experience on several releases of Datacom/DB using IDEAL and COBOL in an MVS environment.

WORK EXPERIENCE

Confidential 2006 - 2009
Database Administrator/Programmer Confidential Ashburn, VA

As a consultant with Syslogic Technical Services working at a Verizon Business site as a Datacom DBA. Write COBOL and IDEAL programs against Datacom databases to test out various functions and to assist application developers in debugging IDEAL and COBOL programs as necessary. Currently performing various DBA maintenance task on a large mission critical Verizon billing system residing on a large IBM Enterprise mainframe. The F and E System contains 440 DBID’s and 1600 tables. Maintenance activities include creating new databases, tables and modifying existing tables and/or key structures using the Datacom Data Dictionary online and it batch. Responsible for migrating database structures from development to test and production environments during scheduled maintenance windows. Responsible for System monitoring, collecting PXX stats and running a variety of Datacom utility jobs such as unloads, loads, RETIX’s, CXX Reports etc. Responsible for generating online URT’s, creating dataviews modeled and sequential for IDEAL programmers and cataloging these dataviews in IDEAL. As the most experienced Datacom DBA at this site responsible for training other DBA’s in performing Datacom maintenance and migration of structure changes to other Datacom environments. Perform 24 X 7 system oncall maintenance support as required.

Confidential2005 - 2006
Database Administrator /Programmer Confidential

Brattleboro, VT

As a Database Administrator at C and S Wholesale Grocers (CSWG) upgraded Datacom 10.0 to Datacom 11.2. In addition to upgrading Datacom I also upgraded other CA products to the latest releases and service packs and applied appropriate APARS. These products include CAIIPC, IDEAL, VSAM-T, DBSERVER and Datacom CICS Services. I was responsible for system performance monitoring using TSO and SYSVIEW. Wrote batch COBOL programs read/update to compare large Datacom tables with table compression turned on and turned off to determine DASD savings and determine IO and CPU usage differences.

One of my tasks at CSWG was to collect weekly system stats at MUF shutdown, create a baseline of data in EXCEL. Once the baseline was established tweaking was accomplished by tuning one object at a time and then comparing before and after results. As a Database Administrator maintained database tables containing up to 400,000,000 rows. CSWG is a large database shop doing about 1.5 billion I/O’s per week. DBA task include Data Dictionary Online/batch work to change database structures and catalog new structures to the CXX. As a DBA at CSWG responsible for running database which included EXTRACTS, LOADS, BACKUPS and RECOVERY, EXTENDS to name a few. Other functions here include mapping of data using IBM IICF and EDBC mapping tools to map Datacom table data to flat files and/or VSAM-T files. Other products used to perform administrative security maintenance were Dataquery and IDEAL.

Confidential 1995 to 2004

Database Administrator Confidential Alexandria, VA

As a Database Administrator at the Army Human Resource Center (AHRC) responsible for database maintenance on four major systems for the federal government across multiple platforms to include development, test, production, and production look-a-like environments. The systems were 1) TAPDB Army Officer 2) TAPDB Army Enlisted 3) TAPDB CORE and 4) Army Civilian databases. As a DBA at AHRC I supported these four major systems day-to-day maintenance-utilizing tools such as CA’s Data Dictionary on-line and batch utilities, CA’s ROSCOE, CA’s SYSVIEW monitoring tool, CA’s Visual DBA monitoring tool, CA’s Erwin Data Modeler. I was also responsible for several database maintenance functions, including database design, table loads and unloads, database reorganizations, migration of database structure definitions among the various platforms (i.e., development to test and test to production). As requested assisted developers with various application problems in COBOL and IDEAL.

Computer Associates 1991 to 1995

Database Administrator Confidential Newington, VA

Responsible for maintaining two large application systems written in the IDEAL programming language using SDLC methodology. These two IDEAL systems interfaced with 75 DATACOM tables containing several million records. Implemented improvements to the system such as key changes, panel and program changes to improve the overall operational efficiency of the two systems. Prepared test plans, tested modules and generated program and system documentation in accordance with existing standards. As a Database Administrator at the U.S. Customs Data Center was primarily responsibility for the logical and physical design of U.S. Customs databases. This responsibility included the approval and implementation of changes to the logical and physical database structures; enforcement of database field naming standards implemented by application development management. As part of the DBA Staff was also responsible for the for DBA support for over 20 DATACOM Multi-user facilities (MUFS) running in the IBM MVS/ESA environment. Responsible for the physical access to the various databases, including the maintenance of User Requirements Tables (URT’s) and sign-on ID’s for IDEAL and those DBMS-related products, which required individual sign-on ids. As a DBA at U.S. Customs responsible for Database maintenance functions, including database table loads/unloads migration of database structures definitions among the various platforms for each environment (i.e. development to test and test to production).

Confidential 1986 to 1991

Programmer Analyst Confidential Rosslyn, VA

As a Senior Systems Analyst, responsible for the design, development, testing, implementation and documentation of several new Army Enlisted Distribution and Assignment System (EDAS) modules using Datacom. These modules were written for an IBM MVS operating environment utilizing both COBOL batch and CICS programs. The programs within these modules interface with Datacom databases reading directly, querying though subroutines, or updating directly or through subroutines. Responsible for developing program specifications, design testing requirements and coding of modules according to specifications and customer standards.

We'd love your feedback!