Database Administrator Fort Meade Maryland
JOB OBJECTIVE:
A responsible and challenging database administration position that utilizes database design and development skills.
EXPERIENCE:
October 2002 to August 2012 Technical Software Services, Inc., Pensacola, FL
I was the Project Leader for the Tools Development Project which was responsible for developing the fourweb-based applications, using a SQL Server database as a repository for the Space and Naval Warfare Systems Center Atlantic (SSCAtlantic). As the Project Leader I was responsible for overseeing the administration of each of the four databases.
I developed plans and process manuals for SSCC Level 3 CMMI efforts. I helped write the six management plans for the Space and Naval Warfare Systems Support Center, Charleston, SC (SSCC).
I wrote the Segment Specification for the Software Engineering Center at Fort Meade, MD.
I am a Software Engineering Institute (SEI) certified instructor and lead appraiser, and have taught the Introduction to the Capability Maturity Model® Integration (CMMI®)more than ten times.
I participated in three Standard CMMI® Appraisal Method for Process Improvement (SCAMPI) assessments forprojects at SSC-C.
I was the lead appraiser assessments for seven organizational units, both commercial and government.
I developed and taught Requirements Management and Measurement and Analysis Workshops for SSC-C.
I taught the Configuration Management and Process and Product Quality Assurance Workshops developed by TECHSOFT.
I worked as the Measurement Analyst, Configuration Manager and Requirements Manager for the CICS project and wrote the CICS System Specification and the SecureD™ Subsystem Specification. Later, I assumed responsibilities as project Systems Engineer.
Skills Used:Microsoft Project, Microsoft Office,Microsoft Visio, SQL Server, SharePoint, Visual SourceSafe, Appraisal Wizard,Transact SQL, SQL
January 1997 to September 2002 Confidential,
Fort Meade, Maryland
As the Database Administrator for the Software Engineering Center, I designed and implemented the Jackpot Database by working with others to establish the requirements for the database. The database was designed primarily to support the collection and analysis of software measurement data. The database used Oracle products, including a Web Server, Developer/2000, and Net8. My initial work accomplished in 12 months what the previous contractor could not do in two years. The Jackpot Database provided a solid foundation for establishing process improvement procedures throughout the agency.
I expanded the Jackpot Database to provide the tools to support the collection and analysis of data about the agency's diverse software systems using web pages maintained in the Oracle database. This effort involved designing a web-based questionnaire, collecting the data and analyzing the results. While the analysis is still on going, the initial prototype was built in three months. When I left, data had been collected on over one thousand systems almost half of the total inventory. As a result of this effort, the agency has established a foundation upon which decisions can be made to eliminate or keep the systems. I generated several ad hoc reports in response to requests from Congress.
After building the database, I was assigned three contractors from other companies to build additional reports and data entry forms. I was responsible for assigning tasks and overseeing the quality of the product and data, as well as tuning the performance of the database. The Jackpot effort had over 1000 objects, including tables, views, and P/L SQL packages.During this time, I was responsible for upgrading the database from Oracle version 8i to Oracle version 9i, and for introducing the Oracle Application Server.Each of these upgrades were performed as part of semi-annual releases. I also created an automated process for generating a spreadsheet compatible output on a daily basis so that it could be used by some of the analysts that were uncomfortable with accessing data directly in a database. My team was also responsible for creating roles and views to ensure that only authorized users had access to some of the sensitive data.
I also put in place procedures for backing up the database on a weekly basis in addition to the backups performed by the network support group.
I was tasked to generate a quick reaction capability to meet critical mission needs. The current developer was not able to provide the necessary functionality so the customer asked the Software Engineering Center if we could deliver the desired capability. In three weeks, I led the effort to design, implement, test and deploy a web-based capability that would allow users to enter either requirement information or personnel information to allow the customer to track this information, and make appropriate assignment decisions. The customer was very pleased with our responsiveness and quality of work.
I added additional tables to the Jackpot Database to capture information about an effort to move UNIX applications to an NT environment.
I also designed and helped implement a set of data entry forms to capture information about legacy databases. This information was provided to other contractors to help them migrate the data from the old databases to a new, more up-to-date database. Once again we were only given two months to deliver an initial capability. Our initial prototype was quite successful. Because the customer was not ready to collect data when the initial prototype was delivered, he asked for additional modifications that we added without any problems.
Skills Used: Microsoft Project, Microsoft Visio, FrameMaker, Oracle database, Oracle Application Server,PL/SQL, SQL, HTML, Sablime, Microsoft Office, Telelogic DOORS, Vitech Core, Unix, data analysis
October 1993 to January 1997 Confidential,
Pensacola, Florida
As Technical Director, I was responsible for managing the technical aspects of all development and maintenance efforts. I developed the company's design and coding standards. I was responsible for developing and implementing the company's configuration management procedures.
As a Senior Software Engineer, I was responsible for performing Independent Verification and Validation (IV&V) on the development of the TACINTEL II system. Documents that I reviewed included: Software Development Plan, System Specification, System/Segment Design Document, Software Requirements Specification, Software Test Plan, Software Design Document, and Software Test Description. The TACINTEL II system was developed using the Shlaer-Mellor object-oriented analysis and design methodology.
I developed the Database Administrator (DBA) portion of the database course that was taught by the University of West Florida for the Naval Security Group (NSG). These lessons taught the student a variety of DBA skills, including: how to install a SYBASE Relational Database Management System (RDBMS), allocate resources, manage user accounts and perform backups and recovery. Upon successful completion of the course, the students were awarded 3 semester credit hours.
I developed all the database lab sessions for the above database course. These labs covered skills ranging from accessing the database to actually designing and building simple databases.
I designed and implemented a database to support the Air Force's Housing Information Management System. This effort involved converting an un-normalized Microsoft Access database into a normalized ORACLE database. These database modifications resulted in queries taking only minutes instead of hours.
I designed and developed the database for NSG's System Security Plan software. This effort involved converting an un-normalized dBase III application to work in a FoxPro environment. Additionally, I designed and developed data entry screens using FoxPro's tools.
I assisted with the development of a Software Engineering Environment (SEE) for the Naval Security Group Activity (NSGA) Pensacola. This SEE provided the Naval Security Group's Software Support Activity with a state-of-the-art programming environment for maintaining complex computer systems which range from simple personal computers to large networks of UNIX and VMS operating systems.
I provided guidance and assistance with the analysis of data collected by NSGA Pensacola. This analysis has resulted in several reports on the metrics effort at NSGA Pensacola and how to improve it.
I developed the TECHSOFT’s process manuals to support the Software Capability Maturity Model.
Skills Used: Microsoft Project, Oracle database, SourceSafe, Microsoft Office, Telelogic DOORS, dBase, FoxPro, Microsoft Access database, Sybase database, Unix, VMS,Cadre Teamwork, Ada programming, IV&V testing
March 1992 to September 1993 Confidential,
Hampton, Virginia
As the Database Administrator, I lead a team of software engineers responsible for developing the Joint Forces Air Component Commander's (JFACC) Decision Support System (JDSS). This effort required the development of requirements, specifications and an implementation plan. The first prototype was developed in less than nine months with a minimum staff and very few resources at the beginning. I analyzed the existing ORACLE databases and developed a method of accessing the data elements to make them available to the JFACC staff using a Motif-based interface and the Common Mapping Program.
I was the lead software engineer responsible for the performance tuning of the Contingency Theater Air Control System (TACS) Automated Planning System (CTAPS) ORACLE database. I was responsible for analyzing the database design, SQL*Forms and query structure and recommending, implementing and testing improvements. During this project, I was responsible for upgrading from Oracle version 6 to Oracle version 7. I introduced the use of PL/SQL to the other database staff. Because it is based on Ada, a language that I had been using, I was able to accomplish the training quickly.
Skills Used: Microsoft Project, Oracle database, SCCS, UNIX, SQL*Forms, C programming, PL/SQL, SQL
August 1988 to December 1991 Confidential,
San Diego, California
I supervised the personnel who were providing software support to the Naval Security Group Detachment, Pensacola, FL.
My primary job was to function as the detachment's Database Administrator. I designed the activity's Corporate Database composed of 40 tables and 10 views using the Oracle relational database management system. Additional duties included the drafting of reports using the Constructive Cost Model and data that had been entered into the Corporate Database. I provided guidance on the management of several programs that were supported by the detachment. These programs included the Data Handling System, the Operational Intelligence (OPINTEL) Broadcast, Centerboard/Flaghoist and CLASSIC AERIE.During this time, I was responsible for upgrading from Oracle version 5 to Oracle version 6.
Skills Used: Oracle database, VAX VMS, SQL*Forms, Ada, Pascal, Fortran
CLEARANCE: TOP SECRET SBI
EDUCATION: 1974 - 76 University of Texas, Austin, Texas 78712. Confidential,
B. S. Degree in Mathematics;
B. A. Degree, Major: Computer Science.
1980 - 82 Confidential,
M. S. Degree in Electrical Engineering.
1991 – 98 Confidential,
M. S. Degree in Software Engineering.
Certifications:
SCAMPI Lead Appraiser for Development and Services
Instructor for:
Introduction to CMMI® for Development
Services Supplement for CMMI® for Development
Introduction to CMMI® for Services
Development Supplement for CMMI® for Services
PROFESSIONAL/TECHNICAL KNOWLEDGE:
Programming languages used: Ada, Java, JavaScript, C++, C, Pascal, FORTRAN, COBOL, MIX (Knuth's assembly language), BASIC, LISP, APL, Z80 Assembler, PC Assembler, PL/SQL, SQL, Pro*C, Visual Basic, Transact SQL
Database management systems used: Oracle, dBase II, dBase III+, dBase IV, Sybase, Paradox, FoxPro, Microsoft Access, Microsoft SQL Server, My SQL
Development tools: Sablime, Telelogic DOORS, Vitech Core®,Oracle Application Server, Cadre Teamwork,
Administrative tools: Microsoft Office including Word, Excel, PowerPoint, and Outlook, Microsoft Project, Microsoft Visio, FrameMaker, Appraisal Wizard
Training Received:
Carnegie Mellon University, Software Engineering Institute
Introduction to Capability Maturity Model Integration (CMMI®)
Introduction to CMMI® for Services
Intermediate Concepts of Capability Maturity Model Integration (CMMI®)
SCAMPI Lead Appraiser Training
CMMI Instructor Training
CMMI Version 1.2 Upgrade Training
CMMI Version 1.3 Upgrade Training
Digital Equipment Corp.
VMS Utilities and Commands
VMS System Management
VAXset Tools
Learning Tree International
Java Programming
Java Programming with Swing
ORACLE
Introduction to Oracle for Developers
Advanced Oracle for Developers
Relational Database Design
Oracle Database Administration
3GL Programming
Oracle Tuning
ORACLE Web Server Administration
ORACLE Web Server Application Development
Project Technologies
Shlaer-Mellor Method: Fundamental Concepts
SAIC
Principles of Software Engineering
Vitech Corporation
Introduction to Core® Systems Engineering
Courses Taught:
Embedded Programming Using Ada UWF COP 5235 Fall 1994
Shlaer-Mellor Object Oriented Analysis UWF CEN 5990 Fall 1995
Shlaer-Mellor Object Oriented Analysis UWF CEN 5990 Fall 1996
Embedded Systems Programming UWF COP4990/EEL4991 Spring 2009
Introduction to CMMI Version 1.1 September 13 - 15, 2005
Introduction to CMMI Version 1.1 August 8 - 10, 2006
Introduction to CMMI Version 1.1 August 20 - 23, 2007
Introduction to CMMI Version 1.2 July 15 - 17, 2007
Introduction to CMMI Version 1.2 July 15 - 17, 2008
Introduction to CMMI Version 1.2 March 31 - April 2, 2009
Introduction to CMMI Version 1.2 June 9 - 11, 2009
Introduction to CMMI Version 1.2 June 22 - 24, 2010
Services Supplement Version 1.2 June 25, 2010
Introduction to CMMI Version 1.2 August 10 - 12, 2010
Services Supplement Version 1.2 August 13, 2010