Senior SQL Server DB Developer & DBA - Hybrid

Ahead; New Bedford (MA); Hybrid; USD 120,000 - 150,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Insurance

401(k) Plan with Company Match

Paid Time Off and Holidays

Employee Product Discounts

Job summary

Ahead, LLC is seeking a Senior SQL Server Database Developer / DBA to design, develop, troubleshoot, and optimize complex database solutions. The role emphasizes testing discipline, detail orientation, and collaboration with Java developers to ensure effective interaction between applications and SQL Server.

The successful candidate will have 5+ years in SQL Server DB development/DBA, expert T-SQL skills, and strong knowledge of performance optimization, security, backups, and maintenance.

Qualifications

• Significant experience (5+ years) as a SQL Server Database Developer and/or DBA.
• Expert-level T-SQL skills and extensive experience with stored procedures, views, functions, triggers, and complex reporting.
• Strong understanding of relational database design, transactions, locking, indexing, execution plans, and performance optimization.
• Experience with large databases and safely performing high-volume production data modifications.
• Strong SQL Server administration, backup/recovery, security, and maintenance knowledge.
• Exceptional analytical, troubleshooting, testing, and validation skills.
• Strong communication skills and demonstrated ability to collaborate effectively with application developers.

Responsibilities

• Develop, maintain, and troubleshoot complex T-SQL queries, procedures, views, functions, and triggers.
• Design efficient solutions with joins, CTEs, temp tables, window functions, aggregations, and advanced SQL techniques.
• Develop complex reports and queries involving large data volumes and detailed business requirements.
• Perform large-scale data updates, corrections, conversions, and cleanup operations safely.
• Thoroughly test and validate database code and data-modification scripts before production.
• Use safeguards like transactions, backups, staging tables, and validation queries for production changes.
• Troubleshoot and optimize performance using execution plans, indexing, statistics, and tuning.
• Support DBA tasks including backups/restores, security, monitoring, and SQL Server Agent jobs.
• Collaborate with Java developers to troubleshoot issues and optimize data-access patterns.
• Participate in code reviews, design discussions, and development of database standards.
• Clearly communicate designs, issues, risks, and recommendations to technical and non-technical teammates.

Skills

Java/JDBC

SQL Server

T-SQL

Performance tuning

Data warehousing

CI/CD

ETL

Power BI

Azure SQL

Education

5+ years SQL Server DB Dev/DBA experience

Tools

SSIS

SSRS

SSAS

Jenkins/Git CI

Job description

Ahead, LLC is seeking a Senior SQL Server Database Developer / DBA to design, develop, troubleshoot, and optimize complex database solutions. The role emphasizes testing discipline, detail orientation, and collaboration with Java developers to ensure effective interaction between applications and SQL Server.

The successful candidate will have 5+ years in SQL Server DB development/DBA, expert T-SQL skills, and strong knowledge of performance optimization, security, backups, and maintenance.