Sr. SQL Database Administrator
Leapwork
Leapwork is a sophisticated piece of software, used by thousands of enterprise users every day, worldwide and across all industries. It is a hybrid application with both Windows, Mac, and Web components, and it integrates with other applications and operating systems on a low level.
We are seeking a highly skilled and experienced Senior SQL DBA with Azure expertise to join our dynamic team. The successful candidate will be responsible for maintaining and optimizing our SQL Server databases, designing, and implementing efficient data structures, creating and optimizing stored procedures, and managing execution plans. The Senior SQL DBA will play a crucial role in ensuring the performance, availability, and security of our database systems while leveraging Azure cloud technologies.
Responsibilities:
- Manage and maintain SQL Server databases hosted on-premises and within Azure environments.
- Design, develop, and optimize SQL stored procedures, functions, and triggers to support various application requirements.
- Analyze and optimize query performance by reviewing and tuning execution plans, identifying bottlenecks, and recommending improvements.
- Collaborate with development teams to understand application data access requirements and assist in designing efficient database structures.
- Monitor database performance, identify potential issues, and proactively implement solutions to ensure high availability and optimal performance.
- Implement and manage database security measures, including user authentication, role assignments, and data encryption.
- Perform database backups, disaster recovery planning, and ensure data integrity and consistency.
- Deploy and manage SQL Server instances within Azure, utilizing Azure SQL Database running on elastic pools.
- Stay current with industry trends, best practices, and emerging technologies related to SQL databases and Azure services.
- Provide technical leadership, mentoring, and guidance to junior DBA team members.
- Collaborate with cross-functional teams to ensure successful project delivery and timely issue resolution.
- Participate in an on-call rotation to provide 24/7 support for critical database incidents.
Qualifications:
- Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent experience).
- Minimum of 8 years of hands-on experience as a SQL Database Administrator.
- Proficiency in designing, developing, and optimizing SQL stored procedures, functions, and triggers.
- Strong expertise in performance tuning and query optimization, including analyzing and tuning execution plans.
- Hands-on experience with Microsoft Azure cloud services, particularly Azure SQL Database.
- Solid understanding of database security principles and best practices.
- Familiarity with disaster recovery strategies and high availability configurations.
- Excellent problem-solving skills and the ability to troubleshoot complex database issues.
- Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
- Relevant Microsoft certifications (e.g., MCSA, MCSE) and/or Azure certifications are a plus.
- Experience with other database platforms (e.g., MySQL, PostgreSQL) is a plus.
- Previous experience in mentoring and guiding junior team members is preferred.
- cations may vary based on the specific needs of your company.