Position closes 01/31/2012
Contract in Washington, DC
Short Description:
SQL Server Developer/DBA 6-9 Years; 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 technology 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.
Required / Desired Skills
Experience with SQL Server 2005/2008 Create views, complex stored procedure (Required 8 Years)
Experience working with asp.net, C# (Required 4 Years)
Experience in Sql Server Reporting Services (SSRS) (Required 4 Years)
Expertise with T-SQL (Required 4 Years)
iText .Net (Required 2 Years)
Perform database performance analysis, reporting, and configuration (Highly desired 3 Years)
Strong understanding of framework/library design and best practice designs (Highly desired 5 Years)
Knowledge of database sizing, capacity planning and full life cycle (Nice to have 5 Years)
Experience with writing stored procedures, views, etc. (Highly desired 5 Years)
Firm understanding on OO concepts and design patterns utilizing C# (Highly desired 5 Years)
Development in Visual Studio 2010 using Team Foundation Server, Work Items (Highly desired 3 Years)
Expertise in data architecture (Highly desired 2 Years)
Use of the Microsoft AJAX Toolkit (Desired 2 Years)
Experience with Microsoft Unit Testing Framework or other Unit Testing tool (Highly desired 3 Years)
Ability to lead and mentor a team (Highly desired 3 Years)
Experience with Web services (Highly desired 3 Years)
Background Check required, if selected.
There are no reimbursable expenses.