Senior SQL Developer

ADP, Inc.; Parsippany-Troy Hills (NJ); On-site; USD 100,000 - 120,000; Full time

Job summary

Agadia, headquartered in Parsippany, NJ, seeks a Senior SQL Server Developer to optimize SQL Server environments, ensure performance, availability, and security. You will handle T-SQL development, performance tuning, backups, and security, while collaborating with developers and analysts.

The role emphasizes proactive ownership, automation, and continuous improvement to support healthcare management technology solutions across the United States.

Qualifications

• Strong expertise in SQL Server, advanced T-SQL development, performance tuning, and database administration.
• Experience supporting production deployments, automation, and issue resolution.

Responsibilities

• Design, develop, maintain, and optimize Microsoft SQL Server databases and database solutions to support business and application requirements.
• Create, modify, and maintain complex T-SQL queries, stored procedures, functions, views, and triggers to ensure efficient data processing and retrieval.
• Develop and implement database structures using best practices in database design, normalization, and data integrity.
• Analyze and optimize query performance through indexing strategies, execution plan analysis, and SQL code tuning.
• Design and manage complex database operations utilizing joins, CTEs, temporary tables, and window functions.
• Monitor and troubleshoot database performance issues, including blocking, locking, deadlocks, and transaction-related concerns.
• Configure, maintain, and monitor SQL Server Agent jobs to support automated database operations and scheduled processes.
• Perform database backup, recovery, restoration, and disaster recovery activities to ensure data availability and business continuity.
• Implement and maintain database security by managing logins, users, roles, permissions, and data access controls.
• Utilize SQL Server Management Studio (SSMS) for database administration, development, monitoring, and troubleshooting activities.
• Develop and support ETL processes using SSIS and related data integration tools.
• Create, maintain, and enhance reports, dashboards, and analytical solutions using SSRS and/or Power BI.
• Support and administer Azure SQL Database and Azure Managed Instance environments to ensure reliability, scalability, and performance.
• Design and maintain data integration and data movement solutions using Azure Data Factory.
• Collaborate with application developers, business analysts, and stakeholders to gather requirements and deliver database solutions.
• Participate in code reviews, version control, and deployment activities utilizing Git and Azure DevOps.
• Provide production support, troubleshoot database-related application issues, and assist with release deployments and post-deployment validation.
• Document database architecture, processes, procedures, and technical specifications to maintain operational excellence and knowledge sharing.
• Recommend and implement database improvements, performance enhancements, and best practices to ensure scalable and efficient database operations.

Skills

SQL Server

T-SQL development

Performance tuning

Database administration

Tools

SSMS

SSIS

SSRS

Power BI

Azure SQL Database

Azure Data Factory

Azure DevOps

Git

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior SQL Developer

Full Time Parsippany, NJ, US

9 days ago Requisition ID: 1021

Salary Range: $100,000.00 To $120,000.00 Annually

About Agadia

Agadia specializes in healthcare management technology and provides utilization management software solutions to healthcare organizations across the United States. We are headquartered in Parsippany, NJ.

Agadia is seeking a Senior SQL Server Developer to support and optimize our SQL Server environments, ensuring high performance, availability, security, and reliability. The ideal candidate will have strong expertise in SQL Server, advanced T-SQL development, performance tuning, and database administration. This role is responsible for troubleshooting and optimizing database solutions, reviewing development code, supporting production deployments, building automation, and proactively identifying and resolving issues before they impact business operations. A solid understanding of both SQL development and DBA responsibilities is required.

Duties & Responsibilities

• Design, develop, maintain, and optimize Microsoft SQL Server databases and database solutions to support business and application requirements.
• Create, modify, and maintain complex T-SQL queries, stored procedures, functions, views, and triggers to ensure efficient data processing and retrieval.
• Develop and implement database structures using best practices in database design, normalization, and data integrity.
• Analyze and optimize query performance through indexing strategies, execution plan analysis, and SQL code tuning.
• Design and manage complex database operations utilizing joins, Common Table Expressions (CTEs), temporary tables, and window functions.
• Monitor and troubleshoot database performance issues, including blocking, locking, deadlocks, and transaction-related concerns.
• Configure, maintain, and monitor SQL Server Agent jobs to support automated database operations and scheduled processes.
• Perform database backup, recovery, restoration, and disaster recovery activities to ensure data availability and business continuity.
• Implement and maintain database security by managing logins, users, roles, permissions, and data access controls.
• Utilize SQL Server Management Studio (SSMS) for database administration, development, monitoring, and troubleshooting activities.
• Develop and support ETL processes using SQL Server Integration Services (SSIS) and related data integration tools.
• Create, maintain, and enhance reports, dashboards, and analytical solutions using SSRS and/or Power BI.
• Support and administer Azure SQL Database and Azure Managed Instance environments to ensure reliability, scalability, and performance.
• Design and maintain data integration and data movement solutions using Azure Data Factory.
• Collaborate with application developers, business analysts, and stakeholders to gather requirements and deliver database solutions.
• Participate in code reviews, version control, and deployment activities utilizing Git and Azure DevOps.
• Provide production support, troubleshoot database-related application issues, and assist with release deployments and post-deployment validation.
• Document database architecture, processes, procedures, and technical specifications to maintain operational excellence and knowledge sharing.
• Recommend and implement database improvements, performance enhancements, and best practices to ensure scalable and efficient database operations.
• Other tasks and responsibilities.
• Proactive Ownership – Identifies risks, trends, and performance issues before they become incidents.
• Performance Focus – Uses monitoring tools and system telemetry to improve SQL Server performance.
• Automation Mindset – Reduces repetitive DBA work through scripting and automation.
• Problem Solving – Troubleshoot complex production and application database issues.
• Communication – Clearly communicates technical risks, findings, and recommendations.
• Continuous Improvement – Regularly identifies opportunities to improve reliability, scalability, and operational processes.

Please note: The Salary range is based on our market pay structure & includes benefits (Medical, Dental, Vision, life Insurance, 401 & PTO, etc), and will be determined based on the candidate's experience, qualifications, and evaluation.