Sql Server Engineer

Timothy D. Collins

**** * ****** **

Washington, DC 20009

571-***-**** cell

abqzur@r.postjobfree.com

DOD Secret Clearance

EDUCATION:

B.S. UMUC – IT Major. 2014 Completion Date (In Progress)

A.S. from Northern VA CC (1999-2003). Graduated Cum Laude, National Deans List. Biology concentration. Writer for school newspaper, Vice President of Student Gov., Tutor .

FSE University Graduate 2008. Field Service Engineer training (ITV software) to support Army/Civilian BCS3 Customers in the field. Data feeds: MTS, XML, USAREUR, GDMS, RFITV, LTM, C2PC, GTN

SKILLS:

Oracle 11g Certified Associate Database Administrator.

SQL Server 2000/2005/2008 SSRS/SSAS/SSIS

Oracle 10/11g - Linux-RHEL

SQL Plus – DML, DCL, DDL, Constraints, Variables

RMAN- Point in time/Tag recovery, Compressed/Incremental/Full backups

Oracle Enterprise Manager – System/Performance Monitoring

Database tuning- Query tuning/rebuilding indexes, snapshots

SQL Loader- control files, alter/update tables, load flat files to DB.

SQL Server Integration Services/Reporting Services, Stored procedures, Triggers

VM Ware- Virtual Machines

Professional training in SQL Server 2008 & BizTalk

EXPERIENCE:

Criminal Justice Coordinating Council: 1-3-2012-Present

Database Administrator

Washington DC Government (ES-7)

Support of twenty one databases across twelve servers including BizTalk and SQL Server 2k/2008. The CJCC aggregates and distributes criminal justice data from eleven different agencies for the purposes of case initiation and information portal access. Criminal justice entities such as the US Attorney’s office, MPD, or Pretrial Services can look up defendant information and receive court case updates. PM of integration projects. Development of Test Cases, develop Statements of Work, Maintenance, Tuning, ETL, Backup and Restore, Scripting, Optimization of databases.

Northrop Grumman: 2010-2011

Information Systems Generalist

Headquarters Department of the Army AE2S FDIIS G8 Pentagon/Fort Belvoir, VA

I support the Force Development Information Investment System.

The financial system that plans and projects the Army’s budget.

Perform SQL queries for tier IV support and user support as well as quality control on data sets.

Data/server migration to local DOIM network. SQL 2005/2008.

Configuration management and requirements tracking (software change requests).

Intecon Inc. – 8/2010-10/2010

Same as Tapestry Solutions below. Contract was sold

Tapestry Solutions a Boeing Company, Fort Belvoir, VA: 2008 - 2010

Customer Support Engineer- 2nd Shift Lead

Army Battle Command Sustainment Support System (BCS3), Fort Belvoir, VA

This is an Army/Marine Corp In-Transit Visibility/Logistics program providing near real time availability of assets to the Army, Marine Corp, and National Guard on a DIACAP MAC1 24X7 Oracle system. Duties include ensuring clients are receiving most current and accurate data in a timely fashion. Resolving connection issues throughout our Global network from Germany, Iraq, and Korea. Duplicating and resolving user issues. Creating Oracle user accounts. Troubleshooting user issues. Data swivel from non-secure (NIPR) to secure systems (SIPR). Interfacing with customers and data source providers to resolve any issues with latency, software, or connectivity. Producing company-wide reports.

Duties range from basic computer troubleshooting to briefing two-star Generals.

IRM ( BMC Remedy) - Logging and tracking issues through ticketing system for trend analysis and development reference.

Combat Power – Combat readiness program that utilizes LOGSTAT and ILAP to provide asset information to the user.

Logistics Reporting Tool (LRT) – Provides user unit roll-up maintenance information from company level.

United States Navy 1997-1998

Norfolk, VA USS Enterprise CVN 65

Certifications:

Oracle Certified Associate (DBA), DOD IA (Information Assurance), Export Awareness, Retina Scan

Contact this candidate