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
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