AccessWave · 13 hours ago
Senior SQL Developer
AccessWave is a company seeking a Senior SQL Developer to take full ownership of SQL development and performance tuning across SQL Server and PostgreSQL environments. The role involves designing complex stored procedures, leading performance tuning efforts, and optimizing database structures while ensuring data quality and integrity.
Commercial InsuranceEmployee BenefitsLife Insurance
Responsibilities
Design and implement complex stored procedures, functions, and SQL scripts
Lead performance tuning across both SQL Server and PostgreSQL
Analyze and optimize execution plans, indexes, and schema design
Work independently with product team to translate requirements into efficient SQL solutions
Troubleshoot and resolve production performance issues
Support ETL processes, data pipelines, and staging systems
Maintain data quality, integrity, and consistent performance across environments
Recommend improvements to table structures, indexing strategies, and partitioning
Qualification
Required
Bachelors Degree
7+ years of SQL development experience
Strong, senior-level expertise in SQL Server (T-SQL)
Strong experience with PostgreSQL (PL/pgSQL)
Deep knowledge of indexing, execution plans, statistics, and concurrency
Proven experience tuning large tables (millions to billions of rows)
Ability to independently gather requirements and deliver complete SQL solutions
Strong communication skills to work directly with product and engineering teams
Preferred
Experience with AWS RDS / Aurora
Experience with high-availability, replication, or partitioning
Exposure to .NET or backend development patterns (bonus)
Benefits
PTO
401k sponsored plan
Health/Dental insurance