SQL/SSIS/SSRS Developer (679546)

About the Opportunity

• We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
• We are only considering local candidates who currently reside within 45 minutes of postal code 20002
• No Third Party Agencies
• $76 per hour 1099, C2C, $64 per hour W2 + benefits
• Location: 100% On-site, downtown NE DC (Red Line: NOMA-Gallaudet)
• Job Id: CAI-679546
• Must be able to provide proof of COVID-19 vaccination plus booster shot
• Contract Term: Till end of the 2022 fiscal year with yearly extension based upon performance

Apply Now

Short Description

The District of Columbia’s Department of Human Services (DHS) is seeking a SQL/SSIS/SSRS Developer to design, develop, enhance, debug, and implement software, SQL queries, reports, procedures, functions, database backups, recoveries, and other necessary backend development and administration. The ideal candidate will have 16+ years of troubleshooting production problems related to software applications.

Required Skills/Years of Experience

• Bachelor’s degree in IT or related field or equivalent experience
• 16+ years of troubleshooting production problems related to software applications
• 11+ years of technical reporting, system setup, data analysis and analytics
• 11+ years of setting up and configuring MS SQL Server infrastructure
• 11+ years if creating and deploying reporting / dashboard solutions using Reporting Services of MS SQL Server
• 11+ years of designing, implementing and managing complex databases including administration tasks
• 8+ years of developing, designing and supporting computerized databases
• 8+ years of database technologies
• 8+ years of front-end development ( i.e. Cognos) and back-end programming language
• 5+ years of tuning Reporting Services
• 3+ years of analytical and communication skills
• 3+ years of working with a team
• 3+ years of reporting tools (SSRS, Business Objects, MicroStrategy Cognos, Tableau and/or Qlikview)
• 3+ years of ETL experience in Data Warehouse / Business Intelligence platforms (SSIS, Informatica, DataStage)
• 1+ years of SQL Server Management Studio, Code Editor for authoring Transact-SQL, MDX, DMX, XML/A, Reporting Services, Analysis Services etc.

Desired Skills/Years of Experience:

• 1+ years of hands on experience with .NET
• 1+ years of hands on experience with VB Script/JavaScript
• 1+ years of hands on experience with BPEL
• 1+ years of hands on experience with PHP and/or WebLogic

Complete Description

The District of Columbia’s Department of Human Services (DHS) is seeking a SQL/SSIS/SSRS Developer to design, develop, enhance, debug, and implement software, SQL queries, reports, procedures, functions, database backups, recoveries, and other necessary backend development and administration. The ideal candidate will have 16+ years of troubleshooting production problems related to software applications.

This position works under the Application Support Division I (ASD I) of the Office of Information Systems (OIS) to directly support TANF and SNAP related application stabilizations, enhancements, and operations and maintenance redesign.

The SQL/SSIS/SSRS Developer will be tasked to:

• Design, develop, deliver and enhance SQL queries, reports, procedures, functions and other necessary backend development and administration
• Perform database monitoring, backups and recoveries
• Implement and manage business aligned IT services
• Ensure the application platform is of high quality, defect free and adheres to industry standards
• Design, develop and deploy applications that support users on the client assessments and case and program management applications
• Provide mentorship and technical advice to a team of Application/Reports/Query developers
• Provide strategic advice to the lead, management and customers of the OIS
• Implement programming standards that support a secure and defect free application
• Interact daily with government clients in order to meet the technical requirements for new initiatives
• Work with Quality Assurance / Quality Control teams to ensure the application remains secure and defect free
• Evaluate, design, and implement accepted programming standards as they relate to the TCA and SNAP E&T application and infrastructure
• Define and document processes to be used by all application developers on the team
• Plan, research and recommend new equipment, software tools and related technologies
• Use monitoring and performance analysis tools to troubleshoot and isolate application performance issues
• Manage database environments, backups, restores and other administration tasks
• Update system and process documentation
• Produces user guides, ER diagrams, and SOPs as needed, including Visio Network design drawings
• Perform other duties as assigned
• Demonstrate the required initiative and critical thinking abilities necessary to resolve all problems and challenges accordingly
• Instruct, assign, direct and check the work of other software developers on the development team

Hiring Expectations

• We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
• No Third Parties
• Right to Represent authorization is required
• Expect technical interview screening
• Expect F2F interview
• Background check and/or credit check will be required

About Dantech

Dantech Corporation, Inc. is a Certified Business Enterprise (CBE) in the District of Columbia and a federally recognized Woman Owned Small Business (WOSB). The company has a history of technology, innovation and transformation since its launch in 1999. As an Equal Opportunity/Affirmative Action Employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, or disability status. For more information about positions with Dantech, please see: https://www.dantechcorp.com/staffing.