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