Senior SQL Developer

Senior SQL Developer Summary of Position: Reporting to the Director of Data Engineering, the senior-level SQL Developer is a hybrid role that sits at the intersection of SQL development and database administration, combining hands-on application and reporting SQL with critical production database ownership. The person in this role will be a foundational contributor to our data infrastructure — writing and maintaining the SQL that powers both our reporting and our primary application and acting as the guardrail between rapid development cycles and a stable, performant production environment. This senior-level position will also provide technical leadership and mentorship to the broader engineering team. Duties & Responsibilities: Design, write, optimize, and maintain complex TSQL stored procedures, functions, views, and triggers supporting production applications, APIs, and reporting workloads Review and partner with application engineers on SQL changes prior to production deployment, identifying performance and scalability risks early Analyze query execution plans, implement indexing strategies, and tune queries to ensure consistent performance as data volumes grow Support schema versioning and controlled database deployments across development, preproduction, and production environments Translate business, product, and reporting requirements into wellstructured, maintainable, and performant SQL solutions Diagnose and remediate production database issues impacting performance, availability, or stability Manage and validate structural database changes, including schema, indexing, and configuration updates, using proper staging and rollback procedures Support database security, access controls, patching, backup validation, archival, and disaster recovery practices Participate in supporting production database incidents and operational issues Serve as a senior technical resource for SQL Server development and database performance best practices Provide guidance to engineers on efficient SQL usage, schema design, and data access patterns Contribute to database standards, patterns, and technical decisionmaking across engineering and data teams Participate in code, design, and architecture reviews with a focus on performance, scalability, reliability, and compliance Collaborate with infrastructure teams to improve database deployment, monitoring, and operational efficiency Create and maintain technical documentation including data dictionaries, schema diagrams, stored procedure documentation, and process flows Document data lineage, transformation logic, and business rules across application and reporting layers Ensure database and datahandling practices are auditready and compliant with HITRUST and HIPAA requirements Perform other duties, as assigned, to ensure effective operation of the department and the Company Live by and promote Verisma Core Values Minimum Qualifications: Associate’s degree in Computer Science, Information Technology, or a related field required 6+ years of experience in seniorlevel database administration and SQL development roles supporting missioncritical systems Strong background in database administration, with demonstrated ownership of production SQL Server environments, including reliability, performance, security, and operational readiness Proven experience diagnosing, remediating, and preventing performance degradation in SQL Server production environments Expertlevel proficiency with Microsoft SQL Server (2016+), including deep handson experience with TSQL; SQL Server 2019 strongly preferred Strong understanding of database operational best practices, including indexing strategies, execution plan analysis, backup and restore strategies, disaster recovery, and access controls Demonstrated experience managing and validating structural database changes, including schema evolution, indexing changes, and configuration updates using controlled deployment and rollback processes Extensive experience designing, implementing, and maintaining stored procedures, functions, and database objects at production scale Solid understanding of relational database design principles, normalization, and schema management Experience maintaining and modifying SQL Server Analysis Services (SSAS) cubes, including troubleshooting, performance tuning, and structural changes Experience using version control (Git) and CI/CD practices for database schema and deployment workflows Working knowledge of Azure data services such as Azure SQL, Azure Synapse, Azure Data Factory, and Blob Storage Experience with schema migration and deployment tools such as Redgate Flyway or equivalent Exposure to ETL/ELT processes and data pipeline tooling (e.g., ADF, Synapse, Databricks, dbt, or SSIS) Experience supporting oncall rotations and responding to production database incidents Knowledge of HIPAA, HITRUST, or other regulated datahandling requirements Background working in healthcare technology or other regulated industries strongly preferred Microsoft certification such as Azure Database Administrator Associate or equivalent preferred Demonstrated ability to mentor engineers and developers on SQL performance, database usage patterns, and operational best practices Strong analytical, communication, and documentation skills, with the ability to translate technical findings into businessrelevant terms Willingness to travel up to 10% of the time