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.
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
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.