Job ID :
Company :
DC Government
Location :
Type :
Duration :
4 Months
Status :
Openings :
Posted :
19 Feb 2013
Job Seekers, Please send resumes to

Short Description:

SQL Server Developer/DBA; This position will specialize in areas of new application/database development and support current production applications especially with creation of views and working on SSRS.


Complete Description:

The candidate will become an integral part of a dynamic team tasked with Record Management Systems Reporting tool. This position requires candidates to work closely with developers to create the views for reports and system engineers to manage the company*s SQL Server databases. This is a production Developer/DBA role; as such it will require some after-hours support. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports  on a daily basis to ensure service related issues are identified and resolved, and working with team members to come up with strategic solutions. Position will be responsible for the design and development of all reports and reporting mechanisms supported by MPD System that also includes iText open source utility used for PDF Reporting.



Other duties include:

--Experience writing, debugging, and optimizing complex stored procedures, Queries.

--Designing views from multiple tables.

--DTS programming

--Developing reports using .net technology (visual studio 2008/2010)  Sql Server Reporting Services.

--Developing reports using itext utility in .net technolgoy to support PDF reports.

--Developing computer codes to support various business process and business requirements.

--Working with CTO to determine where and how to make additions and/or changes to existing database structure and processes.

--Testing and debugging all codes.

--Developing and implementing programs to ensure that systems, networks, and data users are aware of, understand, and adhere to IT security policies and procedures.

--Performing guidance and oversight of server administration, database performance tuning, security, records management, maintaining and troubleshooting all activities related to this application.

--Guiding development and network teams in designing, modeling and creating the application for the production, test and training environment.

--Following agency best practices and standards for Application and network architecture

--Providing network administration services to include the creation and maintenance of WAN and LAN Maps and Architectures

--Performing installation of third party tools such as databases for business objects.

--Participating in the design of new or changing programs.

--Participating in problem solving and troubleshooting for the assigned project, and communicating with users to resolve their issues.

--Working with application owners and engineers on new and existing projects to ensure database capacity and availability.

--Implementing procedures for moving data and database objects between development, testing and production environments.

--Designing and implement database restore and recovery plans.

--Documenting all tasks performed and technical notes.


Candidate must have excellent analytical, problem-solving and communication skills and experience with similar application/system integration projects also required.


Behavior Characteristics:

Works under IT supervisor and business process owner. Independently plans, designs and carries out assignments in accordance with established policies and practices. Must work in a team. Must be able to learn quickly and work well under pressure.



Exp. w/ SQL Server including 2005/2008 Create views, complex stored proced.

Required 8 Years 3 - Expert


Experience working with, C#

Required 4 Years 2 - Proficient


Experience in Sql Server Reprting Services (SSRS)

Required 4 Years 3 - Expert


Expertise with T-SQL

Required 4 Years 2 - Proficient


Experience with iText .Net

Desired 2 Years 2 - Proficient


Experience with performing database performance analysis, reporting, and configuration

Highly desired 3 Years 2 - Proficient


Strong understanding of framework/library design and best practice designs

Highly desired 5 Years 2 - Proficient


Knowledge of database sizing, capacity planning and full life cycle

Nice to have 5 Years 2 - Proficient


Experience with writing stored procedures, views, etc.

Highly desired 5 Years 2 - Proficient


Firm understanding on OO concepts and design patterns utilizing C#

Highly desired 5 Years 2 - Proficient


Development in Visual Studio 2010 using Team Foundation Server, Work Items

Highly desired 3 Years 2 - Proficient


Expertise in data architecture

Highly desired 2 Years 2 - Proficient


Use of the Microsoft AJAX Toolkit

Desired 1.5 Years 2 - Proficient


Experience with Microsoft Unit Testing Framework or other Unit Testing tool

Highly desired 3 Years 2 - Proficient


Ability to lead and mentor a team

Highly desired 3 Years 2 - Proficient


Experience with Web services

Highly desired 3 Years 2 - Proficient


Question 1 

The candidate must be prepared to attend an In-Person interview, if requested. 

Question 2 

This position is expected to last for 4 months. Please acknowledge. 

Question 3 

Candidate must pass an MPD fingerprint background check (in addition to the standard background check) before engagement. Please confirm that the candidate has never been convicted of a misdemeanor or felony charge. 

Question 4 

If the candidate is a strong candidate, they may be fingerprinted after the interview. This does not guarantee an engagement. Please acknowledge.