Senior Database Developer

CliftonLarsonAllen; Livingston (NJ); On-site; USD 113,000 - 170,000; Full time

Benefits offered by this job

Health benefits

401k

Wellness program

Job summary

CLA is seeking a Senior Database Developer to join our Information Technology team in New Jersey. The role focuses on 75% database development and 25% DBA work, delivering secure, scalable SQL Server databases and robust data solutions.

You will design schemas, implement complex queries, manage security and backups, and collaborate with developers to optimize performance. 4+ years of experience and a bachelor's degree are required, with strong Azure SQL skills.

Qualifications

• 4 years of relevant experience required.
• Bachelor's degree is required.
• Minimum of 3 years of experience in SQL Server development on the Azure Cloud platform.
• Strong proficiency in SQL Server development tools (SSMS, Azure Data Studio).
• Experience with Azure SQL Database, Azure Data Factory, Azure Synapse, Fabric, Cosmos.
• Experience with database security, backup, and recovery procedures in Azure.

Responsibilities

• Develop, design, and maintain complex SQL Server databases (schemas, tables, indexes, views, stored procedures).
• Create and optimize complex SQL queries and procedures.
• Manage database security, backups, and disaster recovery plans.
• Identify and troubleshoot performance issues and tune databases.
• Collaborate with software developers to meet their data needs.
• Document data flows, dependencies, and integrations.
• Develop monitoring plans for on‑prem and cloud databases.
• Provide disaster recovery planning and procedures.

Skills

SQL Development

Database Design

Performance Tuning

Azure Cloud

Stored Procedures

T-SQL

Security & Backups

Education

Bachelor's degree

Tools

SQL Server Management Studio

Azure Data Studio

Azure SQL Database

Job description

CLA is a top 10 national professional services firm where our purpose is to create opportunities every day, for our clients, our people, and our communities through industry-focused wealth advisory, digital, audit, tax, consulting, and outsourcing services. Even with more than 8,500 people, 130 U.S. locations, and a global reach, we promise to know you and help you.

CLA is dedicated to building a culture that invites different beliefs and perspectives to the table, so we can truly know and help our clients, communities, and each other.

CLA is growing and seeking to hire an experienced Senior Database Developer to join our talented Information Technology team. The position offers growth, flexibility and a collaborative work environment.

In this position you should have the following; excellent interpersonal skills with the ability to communicate at all levels. Strong problem solving and creative skills and the ability to exercise sound judgment. Most important, demonstrate a high level of integrity and dependability with a strong sense of urgency and results-orientation.

We are seeking a skilled SQL Developer/DBA to join our team. The ideal candidate will be responsible for 75% database development and 25% DBA work, ensuring our databases are secure, reliable, and efficient. As a SQL Developer/DBA, you will be responsible for designing, implementing, and maintaining our databases and ensuring that they meet our company's standards.

How you'll create opportunities in this Senior Database Developer role:

Develop, design, and maintain complex SQL Server databases, including designing and implementing schemas, tables, indexes, views, and stored procedures.

Create and optimize complex SQL queries, including the ability to write complex stored procedures and functions.

Manage database security and access control, including developing and implementing security policies and procedures, performing database backups, and implementing disaster recovery plans.

Identify and troubleshoot database issues and performance problems, including analyzing database performance metrics, diagnosing problems, and tuning databases to optimize performance.

Collaborate with software developers and other stakeholders to ensure that databases meet their needs and requirements.

Work with database vendors to stay up-to-date with new technologies, features, and trends.

Document database design, data flow, dependencies, and integrations for support

Analyze data and identify performance related gaps and provide solutions wherever applicable

Develop monitoring plans for proactive support of databases both on-prem and in the cloud

Create, document and support disaster recovery planning and procedure development

Develop, design, and maintain complex SQL Server databases, including designing and implementing schemas, tables, indexes, views, and stored procedures.

What you will need:

4 years of relevant experience required.

Bachelor's degree is required. Combination of relevant experience, education, and training may be accepted in lieu of degree.

Minimum of 3 years of experience in SQL Server development on the Azure Cloud platform.

Strong proficiency in SQL Server development tools, including SQL Server Management Studio, Azure Data Studio, and Azure SQL Database.

Experience in Azure Cloud platform features such as Azure SQL Database, Azure Data Factory, Azure Synapse, Microsoft Fabric, and Cosmos.

Experience with database security, backup, and recovery procedures.

Familiarity with database security, backup, and recovery procedures in the Azure Cloud.

Strong knowledge of T‑SQL programming, database design, and optimization techniques.

Familiarity with database performance tuning and optimization techniques.

Ability to write complex stored procedures, functions, and SQL queries.

Excellent problem-solving and analytical skills.

Strong communication and collaboration skills.

Our approach to compensation emphasizes collaboration and career growth. We pay competitive wages and view compensation as an investment in our people. Factors such as geography, experience, education, skills, and knowledge may impact the position of pay within the range.

The compensation range for this position in New Jersey is: $113,000.00 - 170,000.00

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

Wellness at CLA

To support our CLA family members, we focus on their physical, financial, social, and emotional well-being and offer comprehensive benefit options that include health, dental, vision, 401k and much more.

To view a complete list of benefits, click here.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

Wellness at CLA

To support our CLA family members, we focus on their physical, financial, social, and emotional well-being and offer comprehensive benefit options that include health, dental, vision, 401k and much more.

To view a complete list of benefits, click here.

Helping all candidates find great careers is our goal. The information you provide here is secure and confidential.