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

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.The 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 systemsMonitor SQL Server health, performance, storage utilization, and database availability across multiple platformsPerform routine server monitoring and daily operational health checksDevelop, schedule, monitor, and troubleshoot SQL Server Agent jobs, automated database processes, alerts, Database Mail notifications, and scheduled operational workflowsExecute scheduled SQL Server maintenance activities, including weekly server patching and maintenance windowsTroubleshoot SQL Server performance issues, database connectivity problems, and production incidentsMaintain database security, permissions, access controls, and ensure compliance with organizational standardsSupport disaster recovery readiness, high availability solutions, and coordinate infrastructure upgradesManage Linux-based database systems including shell scripting and system administrationDesign, develop, test, and maintain complex SQL queries, stored procedures, views, functions, and reusable database componentsDevelop and optimize advanced SQL solutions utilizing Microsoft SQL Server and IBM DB2 healthcare data sourcesDevelop cross-platform SQL solutions integrating SQL Server reporting environments with DB2 databasesTranslate complex healthcare reporting requirements and legacy report logic into validated SQL business rules, including exception handling, reconciliation, and data-quality controlsOptimize SQL code for performance and scalability across multiple database platformsCreate validation scripts and resolve database-related defectsImplement data models and database structures according to best practicesDesign, develop, modify, validate, and maintain SQL Server Reporting Services (SSRS) reportsLead modernization efforts by converting SAP Crystal Reports to SSRS while maintaining functionalityTranslate legacy Crystal Reports business logic into validated SSRS solutions while preserving business rules and report functionalityInterpret healthcare reporting requirements and convert them into validated SQL datasets, report parameters, reconciliation logic, exception processing, and data-quality controlsDevelop and maintain standardized reporting templatesPerform report validation, peer reviews, and maintain SDLC documentationDevelop, maintain, troubleshoot, and optimize SSIS packages supporting enterprise reporting and healthcare data integrationSupport automated processing, scheduled data loads, ETL workflows, and validationSupport data integration initiatives across multiple systems and platformsPerform database migrations and conversions between platforms with minimal downtimeMigrate databases and reports between different environmentsSupport cloud database platform initiativesEnsure data integrity throughout migration processesProvide production support for NPIRS operational systemsMonitor production database jobs, reporting services, SQL Server Agent jobs, and automated workflowsPerform proactive morning operational monitoring and respond to infrastructure incidentsSupport production deployments, server patching, and operational documentationCollaborate with cross-functional teams to implement technical solutionsQualifications:Bachelor's degree in Computer Science, Information Technology, or related fieldMinimum 10 years of experience with SQL database development and administrationAdvanced SQL programming skills with demonstrated experience optimizing complex queriesStrong Linux administration experience, including shell scripting and system managementProven experience migrating databases and reports between different platformsDemonstrated experience with Linux environments hosting database systemsProven track record of successful database migration projectsStrong experience with both Crystal Reports and SSRS developmentHealthcare data experience preferredExperience with federal healthcare compliance requirements preferredMicrosoft SQL Server Administration (Windows and Linux)IBM DB2 and cross-platform SQL developmentAdvanced T-SQL programmingSQL Server Reporting Services (SSRS)SQL Server Integration Services (SSIS)SQL Server Agent and Database MailSAP Crystal ReportsHealthcare reporting methodologies and data modelsBusiness-rule translation and validationDatabase performance tuning and optimizationWindows Server and Linux administrationProduction support methodologiesDatabase security implementation and best practicesKnowledge of high availability and disaster recovery solutionsETL processes and data integrationData modeling techniquesFamiliarity with cloud database platforms (Azure preferred)Advanced SQL programming and optimizationCross-platform SQL development (SQL Server, DB2)Enterprise report modernizationBusiness-rule analysis and translationHealthcare data analysisDatabase reconciliation and data-quality managementETL development and maintenanceTechnical troubleshooting and problem-solvingExcellent communication and documentation skillsAbility to work independently and provide technical leadershipMicrosoft SQL Server (Windows and Linux)IBM DB2SQL Server Management Studio (SSMS)SQL Server Reporting Services (SSRS)SQL Server Integration Services (SSIS)SQL Server AgentDatabase MailSAP Crystal ReportsWindows ServerLinux (various distributions)Azure DevOps or similar SDLC toolsShell scriptingPreferred Qualifications:SQL Server certificationsHealthcare data experienceExperience with Azure cloud database platformsKnowledge of federal healthcare compliance requirementsSalary: $125,000 - $140,000Level of Responsibility:The incumbent functions as a Senior Hybrid SQL Developer/SQL Database Administrator, independently performing advanced database administration, SQL development, enterprise reporting, ETL development, production support, infrastructure monitoring, and reporting modernization. The incumbent provides technical leadership in translating healthcare reporting requirements into validated SQL business rules supporting mission-critical NPIRS reporting systems.This position directly supports the availability, reliability, accuracy, and performance of NPIRS reporting systems. The work ensures secure database operations, successful report modernization, reliable healthcare reporting, and uninterrupted production support for critical federal healthcare programs.Physical Demands:While performing the duties of this job, the employee is regularly required to sit. The employee frequently is required to walk; use hands to finger, handle or feel; reach with hands and arms; and talk or hear. The employee is occasionally required to stand. The employee may lift or move objects up to 5 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus.If you need a reasonable accommodation due to a disability for any part of the employment process, please send an e-mail to hr@microhealthllc.com with your request and contact information.MicroHealth is an equal employment opportunity employer. We do not discriminate against employees or qualified applicants for employment based on race, color, religion, gender, national origin, disability status, veteran or military status, genetic information, sexual orientation, or any other characteristic protected by law.Powered by JazzHR7pWXJhtOEM