Azure SQL Developer

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 looking to hire an Azure SQL Developer to join our growing Internal IT team.

About the role:

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

Essential Job Functions :

• 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

What you will need:

• Bachelor's degree or combination of 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 Resource Manager, Azure SQL Database, Azure Data Factory, Microsoft Fabric, and Azure Virtual Machines.
• 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 Perks:

• Flexible PTO (designed to offer flexible time away for you!)
• Up to 12 weeks paid parental leave
• Paid Volunteer Time Off
• Mental health coverage
• Quarterly Wellness stipend
• Fertility benefits
• Complete list of benefits here

#LI-DJ1

Equal Opportunity Employer /AA Employer/Minorities/Women/Protected Veterans/Individuals with Disabilities.

Click here to learn about your hiring rights.

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.