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.
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
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:
Experience
- 4 years of relevant experience required.
- 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.
Education
- Bachelor's degree is required. Combination of relevant experience, education, and training may be accepted in lieu of degree.
#LI-JH1
Equal Opportunity Employer/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.