Job ID :
2339
Company :
DC Government
Location :
washington, DC
Type :
Contract
Duration :
4 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

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.

 

Skills:

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

Required 8 Years 3 - Expert

 

Experience working with asp.net, 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

 

 

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

 

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