Senior SQL Application Developer (SQL, Crystal Reports, ETL)

MicroHealth LLC; Virginia; On-site; USD 120,000 - 170,000; Full time

Job summary

MicroHealth LLC seeks an experienced Senior SQL Application Developer to lead enterprise database development and reporting modernization for NPIRS and HSP systems. You will manage SQL Server databases across Windows and Linux, develop SSIS/SSRS solutions, and coordinate data migrations with DB2 sources.

You will design complex SQL queries, optimize performance, and support disaster recovery and high-availability initiatives while collaborating with cross-functional teams to modernize reporting

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Minimum 10 years of experience with SQL database development.

Responsibilities

• Administer Microsoft SQL Server databases in Windows and Linux environments.
• Monitor SQL Server health, performance, storage, and availability across platforms.
• Develop, schedule, and troubleshoot SQL Server Agent jobs and automation.
• Translate healthcare reporting requirements into validated SQL datasets and reports.
• Migrate databases/reports between environments with minimal downtime.

Skills

SQL

Database Admin

ETL

Windows

Linux

SSIS

SSRS

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

Crystal Reports

IBM DB2

SQL Server

Job description

Job Description

MicroHealth is seeking an experienced Senior SQL Application Developer with strong expertise in SQL, database administration, Linux environments, database migration, and reporting solutions. This role provides advanced technical support for the program, serving as the principal technical resource responsible for enterprise database development, database administration, reporting modernization, production support, ETL development, and SQL Server operational maintenance supporting mission-critical healthcare reporting systems.

This incumbent will develop, administer, monitor, maintain, and optimize Microsoft SQL Server databases while developing SQL solutions against IBM DB2 healthcare data sources supporting NPIRS and HSP reporting. This position requires expertise in both Windows and Linux database environments, with responsibilities including SQL programming, SQL Server Agent automation, Database Mail, SSRS report development, Crystal Reports modernization, SSIS package development, production database support, infrastructure monitoring, server maintenance, and enterprise reporting solutions.

Key Responsibilities:

• Administer Microsoft SQL Server databases in both Windows and Linux environments supporting NPIRS production and development systems
• Monitor SQL Server health, performance, storage utilization, and database availability across multiple platforms
• Perform routine server monitoring and daily operational health checks
• Develop, schedule, monitor, and troubleshoot SQL Server Agent jobs, automated database processes, alerts, Database Mail notifications, and scheduled operational workflows
• Execute scheduled SQL Server maintenance activities, including weekly server patching and maintenance windows
• Troubleshoot SQL Server performance issues, database connectivity problems, and production incidents
• Maintain database security, permissions, access controls, and ensure compliance with organizational standards
• Support disaster recovery readiness, high availability solutions, and coordinate infrastructure upgrades
• Manage Linux-based database systems including shell scripting and system administration
• Design, develop, test, and maintain complex SQL queries, stored procedures, views, functions, and reusable database components
• Develop and optimize advanced SQL solutions utilizing Microsoft SQL Server and IBM DB2 healthcare data sources
• Develop cross-platform SQL solutions integrating SQL Server reporting environments with DB2 databases
• Translate complex healthcare reporting requirements and legacy report logic into validated SQL business rules, including exception handling, reconciliation, and data-quality controls
• Optimize SQL code for performance and scalability across multiple database platforms
• Create validation scripts and resolve database-related defects
• Implement data models and database structures according to best practices
• Design, develop, modify, validate, and maintain SQL Server Reporting Services (SSRS) reports
• Lead modernization efforts by converting SAP Crystal Reports to SSRS while maintaining functionality
• Translate legacy Crystal Reports business logic into validated SSRS solutions while preserving business rules and report functionality
• Interpret healthcare reporting requirements and convert them into validated SQL datasets, report parameters, reconciliation logic, exception processing, and data-quality controls
• Develop and maintain standardized reporting templates
• Perform report validation, peer reviews, and maintain SDLC documentation
• Develop, maintain, troubleshoot, and optimize SSIS packages supporting enterprise reporting and healthcare data integration
• Support automated processing, scheduled data loads, ETL workflows, and validation
• Support data integration initiatives across multiple systems and platforms
• Perform database migrations and conversions between platforms with minimal downtime
• Migrate databases and reports between different environments
• Support cloud database platform initiatives
• Ensure data integrity throughout migration processes
• Provide production support for NPIRS operational systems
• Monitor production database jobs, reporting services, SQL Server Agent jobs, and automated workflows
• Perform proactive morning operational monitoring and respond to infrastructure incidents
• Support production deployments, server patching, and operational documentation
• Collaborate with cross-functional teams to implement technical solutions

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field
• Minimum 10 years of experience with SQL database development an