Sign upLog in
Engineering Jobs

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

MicroHealth, LLC

Vienna, VA

Apply
JOB DETAILS
JOB TYPE
Full-time
SKILLS
Access Control, Analysis Skills, Automation, Best Practices, Business Support, Cloud Computing, Communication Skills, Computer Programming, Computer Science, Cross-Functional, Crystal Reports, Data Analysis, Data Migration, Data Modeling, Data Processing, Data Quality, Data Sets, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, DevOps, Disaster Recovery, Documentation, Error Handling, Federal Compliance Regulations, Healthcare, High Availability, IBM DB2, Identify Issues, Incident Response, Information Technology & Information Systems, Information/Data Security (InfoSec), Linux Administration, Linux Distributions, Linux Operating System, Maintain Compliance, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Microsoft Windows Operating System, Microsoft Windows Server, Microsoft Windows System Administration, Multiplatform/Cross-Platform, Operational Support, Operations Security (OPSEC), Performance Analysis, Performance Tuning/Optimization, Physical Demands, Problem Solving Skills, Production Control, Production Support, Production Systems, Quality Management, Query Optimization, Reconciliation, Regulatory Compliance, Requirements Validation/Verification, SAP, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Schedule Development, Scripting (Scripting Languages), Server Maintenance, Server Support, Software Development, Software Development Lifecycle (SDLC), Software Patches, Standards Development, Stored Procedures, Systems Administration/Management, Technical Leadership, Technical Support, Test Plan/Schedule, Unix Shell Programming
LOCATION
Vienna, VA
POSTED
Today
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 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 and administration
  • Advanced SQL programming skills with demonstrated experience optimizing complex queries
  • Strong Linux administration experience, including shell scripting and system management
  • Proven experience migrating databases and reports between different platforms
  • Demonstrated experience with Linux environments hosting database systems
  • Proven track record of successful database migration projects
  • 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
Preferred Qualifications:
  • SQL Server certifications
  • Healthcare data experience
  • Experience with Azure cloud database platforms
  • Knowledge of federal healthcare compliance requirements
Salary: $125,000 - $140,000 

Level 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 JazzHR

About the Company

M

MicroHealth, LLC

Similar Job Searches

Systems Engineer Jobs in Vienna, VATechnical Services Engineer Jobs in Vienna, VADesign Engineer Jobs in Vienna, VASolutions Engineer Jobs in Vienna, VAProcess Engineer Jobs in Vienna, VACustomer Engineer Jobs in Vienna, VAApplication Engineer Jobs in Tysons, VAApplication Engineer Jobs in Falls Church, VAApplication Engineer Jobs in Reston, VAApplication Engineer Jobs in Fairfax, VA