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