Senior SQL Engineer

Benefits: Competitive salary Location 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. Established in 2004, Smart Tech Skills is a top technology and professional services firm specializing in innovative technologies. Headquartered in Marlborough, MA, the company effectively addresses clients’ technology needs nationwide, making advanced technology management easier.