Previous Job
Previous
NCDHHS ECHO MSSQL Srv Database Developer
Ref No.: 16-00558
Location: Raleigh, North Carolina
Client:   NC DHHS: Assistance - NC Department of Health and Human
Location: Raleigh, NC
Duration:2+ Months
Agency Interview Type: Either Phone or In Person



Job Description:
NC DHHS is seeking a MS SQL Server Database Developer with strong system analysis and programming skills/experience to design, develop, and maintain web-based ASP.NET systems using SQL Server Integration Services (TSQL) and Stored Procedures.
NC DHHS is seeking a MS SQL Server Database Developer with strong system analysis and programming skills/experience to design, develop, and maintain web-based ASP.NET systems using SQL Server Integration Services (TSQL) and Stored Procedures for the Division of Public Health, Communicable Disease Branch.

Duties include but are not limited to writing SSIS packages to load, transform, compare/match, and export data from various data sources (CSV, XML and Excel etc.) based upon business and technical requirements; document the architecture, design and flow of the packages; create SSRS reports based upon business requirements and allow reports to be exported to CSV, Word, Excel, PDF, etc. formats. The systems will be web-based .NET programming and database design. The selected resource will be required to work closely with the business clients, the web developer and technical lead, NC DHHS database support team and the Project Manager.  
 
Knowledge, Skills, and Abilities Requirements:
Responsibilities / Expectations:


SSIS (SQL Server Integration Services)
• Design, develop and maintain data movements using SQL Server Integration Services, TSQL and Stored Procedures
• Consult with the business to determine logical design for new business solutions
• Perform code reviews, analyze execute  plans, and re-factor inefficient code
• Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes
• Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements

SSRS (SQL Server Reporting Services)
• Design, develop, modify, and implement reports using SQL Server reporting Services
• Deliver ad-hoc extracts that support different business requirements
• Resolve report performance issues
• Perform data integrity and audit checks to ensure accuracy of reports
• Support and perform software life-cycle development
• Ensure standards and best practices used in development are followed and maintained
 
Skill
Required / Desired
Amount
of Experience
 
IT industry experience
Required
5
Years
SQL Server Integration Services (SSIS) and Reporting Services (SSRS)
Required
5
Years
Expertise in SQL programming
Required
5
Years
Experience with Microsoft Business Intelligence
Required
2
Years
Data Warehouse development experience
Required
2
Years
Able to Demonstrate sample of past SSIS/SSRS projects
Nice to have
 
 
 
 
Questions
 
 
Description
 
Question 1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2
All work must be completed on site. Do you accept this requirement?
Question 3
Please list candidate's email address HERE that will be used when submitting E-RTR.
Question 4
Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.
Question 5
Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?
Question 6
Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement?