Database Application Developer

Summary

The Software Developer I supports data production and systems activities by developing, maintaining, and enhancing applications and databases used for survey data and metadata management. This role supports National Health Information System (NHIS), RSS, and other District Health Information System (DHIS) surveys through database development, application programming, reporting, documentation, and quality assurance activities.

• Provide database support by studying, loading, modifying, and enhancing the MID database schema using SQL DDL statements.
• This is a Remote (work from home) position.
• Develop SQL queries (CRUD operations), stored procedures, functions, and views to implement business logic while preserving database integrity and optimizing retrieval performance.
• Provide programming support by developing interactive applications using the MVC design pattern as part of dashboard application suites.
• Develop applications that generate reports, update individual database records, support flexible search and retrieval, display matching variable metadata, and extract metadata for downstream applications.
• Perform data quality checks and generate final user documentation using software development best practices.
• Edit, test, and debug programs in an agile development environment to deliver robust and reliable applications.
• Use business intelligence tools to develop reporting solutions, including documents and dashboards, as part of data release products.
• Follow best practices for documenting all programs with meaningful comments and ensure documentation is Section 508 compliant for accessibility.
• Perform quality assurance testing for all system modifications and develop formal application test plans and test requirements documents as required.

• Minimum four (4) years of college-level education and 3–5 years of relevant experience.
• Familiarity with web development and relational database technologies.
• Experience with ETL (Extract, Transform, Load) processes for data integration.
• Knowledge of Microsoft SQL Server and its BI tools, including:
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)
• Experience with Visual Studio, ASP.NET, and C# (highly desirable).
• Ability to load, edit, and modify metadata within databases.
• Experience generating reports, creating dashboards, and extracting metadata for external applications.
• Understanding of interfacing applications with a SAS environment for data processing.