Senior SQL Server Developer

We are seeking a Senior SQL Server Developer to support and enhance a mature Microsoft-based data and reporting environment. This role will be heavily focused on SQL Server development, SSRS reporting, ETL processes, database optimization, and data analysis that supports critical business operations. While the organization continues to expand its Azure footprint, the primary focus of this position is designing efficient database solutions, building reports, and ensuring high-performing data environments. The ideal candidate is a senior-level SQL professional who enjoys solving complex data challenges, tuning queries, optimizing database performance, and working directly with business stakeholders to deliver reliable reporting solutions.

Responsibilities

SQL Server Development

Design, develop, and maintain SQL Server databases, stored procedures, functions, views, and data structures.

Write and optimize complex T-SQL queries involving multiple joins, aggregations, and large datasets.

Develop scalable solutions that support operational reporting, analytics, and business processes.

Maintain data integrity and ensure consistent performance across database environments.

Reporting & Analytics

Design, develop, and support SSRS reports and operational reporting solutions.

Partner with business users to gather requirements and deliver meaningful reports and dashboards.

Troubleshoot reporting issues and validate data accuracy across multiple systems.

Support ongoing reporting enhancements and modernization efforts.

Performance Optimization

Analyze query execution plans and identify opportunities for optimization.

Implement indexing strategies and database tuning techniques to improve performance.

Resolve performance bottlenecks impacting applications, reports, and ETL processes.

Monitor database health and proactively recommend improvements.

ETL & Data Integration

Develop and maintain ETL processes supporting data movement across enterprise systems.

Support data validation, auditing, reconciliation, and quality assurance efforts.

Troubleshoot integration and data flow issues impacting reporting and operational systems.

Assist in automating recurring data processes where appropriate.

Azure & Database Support

Support Azure-hosted SQL Server and Azure SQL environments.

Assist with database maintenance, monitoring, backups, and scheduled jobs.

Participate in cloud modernization initiatives while supporting existing SQL-based solutions.

Collaborate with application development teams on database design and deployment activities.

7+ years of SQL Server development experience.

Advanced expertise with T-SQL, stored procedures, views, functions, triggers, and query optimization.

Strong experience developing and supporting SSRS reports.

Deep understanding of SQL Server performance tuning, indexing strategies, and execution plans.

Experience supporting ETL processes and data integration workflows.

Experience working with Azure SQL and Microsoft Azure environments.

Strong understanding of relational database design and normalization principles.

Experience troubleshooting complex database and reporting issues.

Ability to work directly with end users and business stakeholders to translate requirements into solutions.

Preferred Qualifications

Experience with Azure Logic Apps, Azure Data Factory, or similar automation tools.

Experience with Power BI and business intelligence reporting.

Familiarity with PowerShell scripting and SQL automation.

Experience supporting healthcare, occupational health, or other regulated environments.

Knowledge of data governance, compliance, and HIPAA-related requirements.

Exposure to DevOps practices and database deployment automation.

Skills

SQL Server, T-SQL, SSRS, Azure SQL, ETL Development, Query Optimization, Performance Tuning, Stored Procedures, Indexing Strategies, Database Design, Power BI, Azure Data Factory, Azure Logic Apps, PowerShell, Data Integration, Reporting & Analytics, Database Administration, Data Validation, SQL Performance Monitoring, Business Intelligence Reporting

3.93.9 out of 5 stars Remote $100,000 - $125,000 a year - Full-time