Please mention DailyRemote when applying
AI Summary
The Senior SQL Engineer will lead the design, optimization, and support of mission-critical SQL Server environments for healthcare operations. Responsibilities include database architecture, performance tuning, ETL development, and collaborating with DevOps teams on CI/CD integration.
Benefits:
- Competitive salary
Location
Remote
Experience Level
Senior Level (5+ Years SQL Engineering Experience)
Remote
Experience Level
Senior Level (5+ Years SQL Engineering Experience)
Position Overview
The Senior SQL Engineer will lead the design, optimization, support, and continuous improvement of mission-critical SQL Server environments supporting healthcare operations. This role is responsible for database architecture, performance tuning, ETL development, production support, CI/CD integration, and data governance. The ideal candidate combines deep SQL Server expertise with strong analytical, troubleshooting, and stakeholder management skills to deliver scalable, secure, and high-performing data solutions.
Key Responsibilities
Database Architecture & Development
- Design, architect, and optimize SQL Server databases supporting high-volume healthcare systems.
- Develop advanced T-SQL solutions including stored procedures, triggers, views, functions, and indexing strategies.
- Design scalable database structures supporting operational and analytical workloads.
- Drive database architecture decisions including normalization, partitioning, and schema evolution.
Performance Tuning & Optimization
- Lead SQL Server performance tuning initiatives.
- Analyze execution plans, query performance, and database workloads.
- Optimize database structures, indexing strategies, and SQL code.
- Identify and resolve bottlenecks impacting system performance and availability.
- Monitor database performance and recommend long-term improvements.
ETL & Data Integration
- Design, develop, and support ETL processes using SSIS and custom frameworks.
- Manage data ingestion, transformation, and delivery processes.
- Support integration of healthcare data across multiple applications and platforms.
- Ensure data quality, consistency, and integrity throughout data movement processes.
DevOps & Database Deployments
- Collaborate with DevOps teams to support CI/CD pipelines for database deployments.
- Implement version control, automated deployments, rollback procedures, and release management processes.
- Support database modernization and automation initiatives.
- Utilize Git, Jenkins, and related DevOps tools.
Production Support & Operations
- Support production SQL Server environments and mission-critical applications.
- Troubleshoot and resolve database, application, and integration issues.
- Monitor overnight jobs, scheduled tasks, and automated processes.
- Manage incident response, root cause analysis, and corrective actions.
- Support after-hours deployments and maintenance activities as needed.
Leadership & Collaboration
- Mentor junior developers and database professionals.
- Conduct code reviews and establish SQL development standards.
- Partner with business analysts and stakeholders to translate requirements into technical solutions.
- Lead technical demonstrations and solution reviews.
- Work closely with development, infrastructure, vendor, and business teams.
Governance & Documentation
- Maintain database documentation, operational procedures, and data flow diagrams.
- Support data governance, security, compliance, and audit requirements.
- Document system dependencies, support processes, and database standards.
- Participate in strategic technology planning initiatives.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or related field, or equivalent experience.
- 5+ years of experience in SQL Server database engineering or related roles.
- Deep expertise with:
- T-SQL
- Stored Procedures
- Triggers
- Views
- Query Optimization
- Indexing Strategies
- Execution Plan Analysis
- Experience with SQL Server performance tuning and troubleshooting.
- Experience building and supporting ETL solutions using SSIS or similar technologies.
- Experience supporting production database environments.
- Experience with CI/CD pipelines, Git, Jenkins, and automated deployment processes.
- Strong understanding of the Microsoft technology stack, including .NET and Visual Studio.
- Excellent analytical, troubleshooting, and problem-solving skills.
- Strong written, verbal, and presentation skills.
Preferred Qualifications
- 2+ years of healthcare insurance, payer, provider, PBM, or PPO experience.
- Experience with healthcare data standards and regulatory environments.
- Experience with enterprise data warehousing solutions.
- Experience with LAMP stack technologies.
- Experience with Jira and Agile project environments.
- Experience supporting third-party healthcare integrations.
- Experience managing large-scale healthcare data platforms.
Core Skills
- Microsoft SQL Server
- T-SQL Development
- Performance Tuning
- Query Optimization
- Database Architecture
- ETL Development
- SSIS
- Data Warehousing
- Stored Procedures
- Indexing & Partitioning
- CI/CD Pipelines
- Git
- Jenkins
- .NET Technologies
- Production Support
- Database Administration
- Healthcare Data Integration
- Root Cause Analysis
- Data Governance
- Agile Methodologies
- Jira
This is a remote position.
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
