Dofactory.com
Dofactory.com

SQL Server Developer/DBA

Company
CliftonLarsonAllen
Location
Minneapolis, MN
--
Remote
Job Type
Fulltime
Level
Senior level
Skills

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 Server Developer/DBA - Lead to join our growing Internal IT team.
About the role:
We are seeking a skilled SQL Server Developer/DBA 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 SQL Server 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 related field.
  • 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.

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
.
 
Ref #
2759920
Posted
30+ days ago
  •  
Last updated 30+ days ago


Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.