Sql Server Software Engineer

Michael Keast, PMP

***** ******* **, *******, ** 22030

703-***-**** *********@*****.***

Career Summary

SENIOR DATABASE ADMINISTRATOR, SOFTWARE DEVELOPER, AND SYSTEM ADMINISTRATOR

WITH 20 YEARS OF BROAD EXPERIENCE DELIVERING PRODUCTIVE INFORMATION

SYSTEMS. PMP CERTIFIED TEAM LEADER WITH STRONG MICROSOFT SQL SERVER

DEVELOPMENT AND ADMINISTRATION EXPERIENCE, POWERBUILDER CLIENT/SERVER

APPLICATIONS DEVELOPMENT, AND WEB DEVELOPMENT USING HTML, ASP, JAVASCRIPT,

AND VISUAL STUDIO 2005/2008 ASP.NET/C#.

Career History

WYLE INFORMATION SYSTEMS, WASHINGTON D.C. MAY 1999 - AUGUST 2009

SR. DATABASE ADMINISTRATOR/SENIOR SOFTWARE ENGINEER

Provided SQL Server database administration, software development, and

server administration support to the Federal Motor Carrier Safety

Administration.

* Designed and implemented a new database, stored procedures to support

new and existing web applications.

* Developed a web application module using ASP .NET to manage

application user accounts, groups, roles, and application roles for a

web portal.

* Transferred SQL Server 2000 databases and IIS 6 websites to new Hyper-

V virtual machines running on Windows Server 2008.

* Developed backup and disaster recovery procedures for SQL Server and

the Windows Servers, using SQL jobs and Symantec Back Exec 12.5.

* Provided database guidance to the web developers.

Team Leader for FAA Office of Accident Investigation (AAI)

* Participated in all phases of the Software Development Life Cycle for

activities that involved AAI, including cross-functional projects.

* Participated in the Certification and Accreditation (SCAPs) of all AAI

systems as required by the Department of Transportation.

* Created System documentation for all AAI database applications that

complied with the recently adopted AVS Software Development Life

Cycle. Created a baseline configuration document for the AAI servers.

* Designed and developed client/server information systems using

PowerBuilder and Microsoft SQL Server. Developed web-based

applications using ASP/ASP.Net on IIS 4/5/6.

* Administered AAI Windows NT/2000/2003 servers and Microsoft SQL Server

(versions 4.21a through 2005), including backup and recovery, disaster

recovery planning and testing, system maintenance and monitoring

through scheduled jobs

* Delivered several versions of the Aviation Mishap Information System

(AMIS) in association with the National Transportation Safety Board

(NTSB). Evaluated and integrated NTSB change requests. The NTSB

subsequently adopted AMIS as their new accident database solution.

Worked closely with NTSB to assist with transition issues and

problems.

* Installed, configured, and maintained all AAI Dell PowerEdge servers,

which ran Windows NT, Windows 2000 Server, and Windows 2003 Server, as

well as several versions of Microsoft SQL Server (4.21a, 6.0, 6.5,

7.0, 2000, 2005).

* Wrote proposal with corporate team for AAI contract. Sole presenter of

the proposal to the FAA contracts division.

Alcosys, Inc., Washington D.C. February 1994 - May 1999

Sr. Database Administrator/Senior Software Engineer

. As the software development team lead, designed and developed several

versions of the "Improved Accident/Incident Data System", a national

client/server system implemented using PowerBuilder and MS SQL Server.

. Developed a large data conversion application that consolidated data from

multiple external sources, including the National Transportation Safety

Board (NTSB). Developed two Recommendation Tracking Systems that are used

by oversight programs to manage the FAA and NTSB recommendation

processes.

. Developed several internal systems that provide data entry, query,

quality assurance, and data conversion functionality.

. Performed all Windows NT and MS SQL Server administration. Maintained

existing FoxPro applications.

Computer Resource Management, Herndon, Virginia September 1992 - February 1994

Senior Systems Analyst

Responsible for the initial design and implementation of the "Improved

Accident/Incident Data System" (IAIDS), a client/server FAA aviation event

information system created using PowerBuilder 3.0 and Microsoft SQL Server

running on Windows NT.

CASDE Corporation, Arlington, Virginia March 1988 - September 1992

Senior Programmer/Analyst

Developed a division-level Management Information System (MIS) for the Navy

(PMA-251) using FoxPro 2.0 and Microsoft LAN Manager.

Developed a multi-user graphical analysis application written that

processed submarine weld inspection data. Developed an image-processing

database for a NAVSEA customer using Microsoft C.

Developed a management accounting system for Foreign Military Sales of U.S.

developed hardware, which was used by five PMA offices.

Many other in-house projects were created using Microsoft C and Turbo

Pascal. Provided ad hoc FORTRAN programming support to CASDE engineers

using Intergraph CAD-II UNIX workstations.

Developed several file format conversions programs to allow Prime

minicomputer files to be output into specific PC file formats.

Education

B.S. COMPUTER SCIENCE, GEORGE MASON UNIVERSITY, FAIRFAX, VA

Professional Certifications

. PMP (PROJECT MANAGEMENT INSTITUTE) PMP NUMBER 1291521

. ITIL V3 Foundation

. Microsoft Certified Professional - SQL Server 7.x, Microsoft Windows 2000

Server

. PowerBuilder - Introduction to PowerBuilder, Advanced Datawindows,

Performance Tuning

Hardware/Software Experience

. POWERBUILDER (V2-V10), C#, ASP.NET, ASP, C, C++, PASCAL, VISUAL BASIC,

WINDOWS IIS 4/5/6, MICROSOFT PROJECT 2003

. Intel-based PC's and servers running Windows 2000 Pro, Windows XP,

Windows NT, Windows 2000 Server, Windows 2003 Server, and Windows 2008

Server. Dec Alpha running Windows NT. VAX 6000 running VMS.

Other Interests

. PRIVATE PILOT SINCE 1998, INSTRUMENT RATED SINCE 2000.

Contact this candidate