IN-DCS-Application System Analyst Programmer 705566 - REMOTE - 31 MARCH 23

Agency Interview Type: Webcam only

Short Description:

System functional design, technical design, and programming experience with a Statewide Automated Child Welfare Information System (SACWIS). Strong understanding of SACWIS functionality. Knowledgeable of data structures and data relationships within SACW

Only candidates CURRENTLY living in Indiana will be considered.

Complete Description:

Only candidates CURRENTLY living in Indiana will be considered for this position.

Responsibilities Include:

- Expertise with full software development life cycle including software system analysis, functional design, technical design, development, testing, code review and production system support.
- Software design and development expertise with n-tier application system architecture including use of PostgreSQL, Microsoft SQL Server Enterprise 2008/2012, and Microsoft SQL Server Reporting Services including SSRS, SSIS, and SSAS.
- Expertise with SSRS. Integration of SSRS Reports with Visual Studio .NET. Write queries within Microsoft SQL Server Reporting Services. Expertise with grouping, sub-grouping, formatting, conditional formatting, and creating complex formulas. Test report output. Export report output to Microsoft Excel format.
- Expertise with software design and development in Microsoft SQL Server 2012 and PostgreSQL database environment using SQL and T-SQL for stored procedures and functions. Expertise in data analysis and data design. Knowledgeable of performance tuning database stored procedures and functions.
- Experienced in providing production system support and solving daily production issues for SACWIS environment. Strong analytical, troubleshooting, and problem solving skills. Effective communication with technical and non-technical personnel. Ability to plan work tasks and projects. Research technical issues, problems, procedures, and methods and advise management. Provides technical expertise and input on projects.

Skills : Database Systems/Database Tools (Microsoft SQL Server RDBMS Advanced and PostgreSQL Advanced)