SQL Server Database Administrator (DBA)

Thumbay Technologies; Ajman; On-site; AED 240,000 - 420,000; Full time

Job summary

Thumbay Technologies in the United Arab Emirates seeks an Experienced Senior SQL Server Database Administrator with 10+ years of hands-on experience managing large-scale databases (1 TB+). You will optimize performance, design backup and disaster recovery, and enforce security protocols across multiple systems.

The ideal candidate excels in high-availability environments (Always On, clustering, mirroring), performs query tuning, patching, and automation, and provides mentorship to junior DBAs.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 10+ years of hands-on experience in SQL Server database administration.
• Extensive experience in managing and optimizing large databases (1TB+).
• Strong expertise in SQL performance tuning, index optimization, and query optimization.
• Advanced knowledge of SQL Server high-availability solutions, including clustering, mirroring, replication, and Always On Availability Groups.
• Proficient in designing and implementing disaster recovery strategies.
• In-depth knowledge of database security best practices, including encryption, access control, and auditing.
• Hands-on experience with SQL Server versions 2014 R2 through the latest releases.
• Expertise in T-SQL, scripting, and automation of database tasks.

Responsibilities

• Manage and administer large-scale SQL Server databases (1+ TB) with a focus on performance optimization and availability.
• Install, configure, upgrade, and patch SQL Server databases from SQL Server 2014 R2 to the latest versions.
• Design, implement, and maintain database backup, recovery, and disaster recovery strategies.
• Optimize complex queries, stored procedures, and indexes to improve performance.
• Implement robust security measures, including encryption, auditing, and access control, ensuring compliance with industry standards.
• Monitor database performance using tools and scripts, addressing any issues related to slow queries, locks, or deadlocks.
• Troubleshoot and resolve complex database issues, ensuring minimal downtime and maintaining high availability.
• Develop and maintain high-availability (HA) and disaster recovery (DR) environments using techniques like clustering, mirroring, replication, and Always On Availability Groups.
• Automate routine database maintenance tasks and monitoring.
• Collaborate with application development teams to enhance database design and optimize queries.
• Conduct regular capacity planning, forecasting, and performance reviews to ensure optimal system performance.
• Provide mentorship and technical leadership to junior DBAs and development teams.

Skills

Performance tuning

Security hardening

Backup & DR planning

Always On availability groups

T-SQL scripting

Automation

On-call production support

Mentorship

Education

Bachelor’s degree in Computer Science/IT

Tools

Azure SQL

PowerShell scripting

SQL Server 2014 R2 to latest

Job description

Experienced Senior SQL Server Database Administrator DBA with over 10 years of experience in managing large-scale databases The ideal candidate will be highly proficient in database optimization recovery strategies fine-tuning and security protocols This role involves maintaining high-performance databases and ensuring data integrity availability and scalability across multiple systems.

• Manage and administer large-scale SQL Server databases (1+ TB) with a focus on performance optimization and availability.
• Install, configure, upgrade, and patch SQL Server databases from SQL Server 2014 R2 to the latest versions.
• Design, implement, and maintain database backup, recovery, and disaster recovery strategies.
• Optimize complex queries, stored procedures, and indexes to improve performance.
• Implement robust security measures, including encryption, auditing, and access control, ensuring compliance with industry standards.
• Monitor database performance using tools and scripts, addressing any issues related to slow queries, locks, or deadlocks.
• Troubleshoot and resolve complex database issues, ensuring minimal downtime and maintaining high availability.
• Develop and maintain high-availability (HA) and disaster recovery (DR) environments using techniques like clustering, mirroring, replication, and Always On Availability Groups.
• Automate routine database maintenance tasks and monitoring.
• Collaborate with application development teams to enhance database design and optimize queries.
• Conduct regular capacity planning, forecasting, and performance reviews to ensure optimal system performance.
• Provide mentorship and technical leadership to junior DBAs and development teams.

Required Skills and Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 10+ years of hands-on experience in SQL Server database administration.
• Extensive experience in managing and optimizing large databases (1TB+).
• Strong expertise in SQL performance tuning, index optimization, and query optimization.
• Advanced knowledge of SQL Server high-availability solutions, including clustering, mirroring, replication, and Always On Availability Groups.
• Proficient in designing and implementing disaster recovery strategies.
• In-depth knowledge of database security best practices, including encryption, access control, and auditing.
• Hands-on experience with SQL Server versions 2014 R2 through the latest releases.
• Expertise in T-SQL, scripting, and automation of database tasks.
• Strong analytical and problem-solving skills, with a focus on continuous improvement.
• Ability to provide 24x7 on-call support for critical production environments.

Preferred Skills (Optional):

• Experience with SSIS, SSRS, and SSAS.
• Proficiency in cloud-based database solutions such as Azure SQL.
• Experience with PowerShell scripting and database automation.
• Familiarity with other database systems (MySQL, PostgreSQL) and NoSQL technologies.