Senior SQL Server Production Support & Data Engineer

SQL Server Engineer

Looking for a hands-on SQL Server engineer to support mission-critical healthcare systems. You'll own data cleanup and data engineering workflows, tune complex T-SQL/stored procedures, and resolve production issues that impact clinicians and members.

What You'll Do

Data cleanup / quality: Build repeatable scripts and jobs for de-duplication, referential integrity fixes, backfills, and drift remediation with strong audit trails.

Pipelines & jobs: Develop/maintain SSIS Packages, SQL Agent jobs, scheduling, monitoring, and alerting.

Production support: Triage and resolve SQL/database incidents (performance, deadlocks, blocking, failed jobs), drive MTTR down, and prevent recurrences.

SQL performance tuning: Analyze execution plans, reshape queries, optimize indexes/partitioning, parameter sniffing mitigation, statistics strategies, and plan cache hygiene.

Complex T-SQL & stored procedures: Design, refactor, and harden SPs, functions, views, and complex queries across SQL Server 2016 and 2019.

Release & change support: Participate in deployments, hotfixes, and post-release validation; uphold change controls and rollback plans.

Observability & RCA: Use logs/metrics/traces (Splunk/Dynatrace or similar) to pinpoint root causes; publish clear RCAs and preventive actions.

Security & compliance: Handle PHI/PII responsibly.

Collaboration: Partner with app teams, DBAs, SRE/DevOps, and Operations; communicate clearly with non-technical stakeholders.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy.