> Markdown version of [/jobs/ext/2514394-senior-sql-engineer](https://www.wearedevelopers.com/jobs/ext/2514394-senior-sql-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior SQL Engineer - **Company:** The Smart - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, .NET Framework, Agile Methodology, JIRA, LAMP (Software Bundle), Code Review, Databases, Continuous Integration, Data Governance, Data Integration, Extract Transform Load (ETL), Data Systems, Data Warehousing, Database Development, Database Storage Structures, DevOps, Document Management Systems, Microsoft Visual Studio, Microsoft Software, Microsoft SQL Server, Operational Databases, Performance Tuning, Query Optimization, Release Management, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Transact-SQL, Enterprise Data Management, Data Ingestion, Database Optimization, Database Performance, Indexer, Git, Information Technology, Deployment Automation, Health Level Seven International, Software Version Control, Jenkins - **Published:** August 6, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=3e83ec0b5874051a ## About the Role Senior Level (5+ Years SQL Engineering Experience), * 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 ## Description 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Software Engineer Salary in The UK](https://www.wearedevelopers.com/magazine/231-software-engineer-salary-in-the-uk)