What are the responsibilities and job description for the Senior SQL Developer position at Agadia Systems Inc?
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.
Job Overview
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.
Key Competencies
- 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.
Salary : $100,000 - $120,000