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

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
• 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
• Develop, design, 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
• 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
• 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
• 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 and administration
• Advanced SQL programming skills with demonstrated experience optimizing complex queries
• Strong Linux administration experience, including shell scripting and system management
• Demonstrated experience with Linux environments hosting database systems
• Proven experience migrating databases and reports between different platforms
• Strong experience with both Crystal Reports and SSRS development
• Healthcare data experience preferred
• Experience with federal healthcare compliance requirements preferred
• Microsoft SQL Server Administration (Windows and Linux)
• IBM DB2 and cross-platform SQL development
• Advanced T-SQL programming
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• SQL Server Agent and Database Mail
• SAP Crystal Reports
• Healthcare reporting methodologies and data models
• Business-rule translation and validation
• Database performance tuning and optimization
• Windows Server and Linux administration
• Production support methodologies
• Database security implementation and best practices
• Knowledge of high availability and disaster recovery solutions
• ETL processes and data integration
• Data modeling techniques
• Familiarity with cloud database platforms (Azure preferred)
• Advanced SQL programming and optimization
• Cross-platform SQL development (SQL Server, DB2)
• Enterprise report modernization
• Business-rule analysis and translation
• Healthcare data analysis
• Database reconciliation and data-quality management
• ETL development and maintenance
• Technical troubleshooting and problem-solving
• Excellent communication and documentation skills
• Ability to work independently and provide technical leadership
• Microsoft SQL Server (Windows and Linux)
• IBM DB2
• SQL Server Management Studio (SSMS)
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• SQL Server Agent
• Database Mail
• SAP Crystal Reports
• Windows Server
• Linux (various distributions)
• Azure DevOps or similar SDLC tools
• Shell scripting