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 looking to hire a SQL Developer/DBA - Lead to join our growing Internal IT team. About the role: 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. 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 in computer science, information technology, or equivalent experience. • 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. • 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 The wage range for this position is: Chicago, IL $113,772 - $170,658 Factors such as geography, experience, education, skills, and knowledge may impact position of pay within the range. #LI-DJ1 Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities 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 . #J-18808-Ljbffr

Requirements