About the Role:
This temporary remote role offers the opportunity to manage and optimize high-volume Microsoft SQL Server environments supporting globally distributed digital products. You will work with databases ranging from tens of terabytes, tackling complex performance, reliability, and scalability challenges. The position combines advanced T-SQL development with deep database administration and SQL Server architecture expertise. You will investigate execution plans, optimize queries and indexes, and address bottlenecks across memory, disk, locking, and system performance. You will also maintain high-availability infrastructure and help technical teams access and work with critical data. This role is well suited to an experienced SQL professional who enjoys solving complex database problems and working independently in a high-load environment.
Ready to apply for roles like this?
Unlock the company name and direct application link. Subscribers get instant access to fresh jobs across Dubai, Abu Dhabi and Riyadh, many with visa support.
Unlock employer & apply directly
Accountabilities:
- Develop advanced T-SQL scripts and solutions for Microsoft SQL Server environments spanning versions 2008 through 2019.
- Review SQL code developed by other engineers, analyze execution plans, and identify and resolve performance issues, including procedures running at extremely high execution volumes.
- Optimize database performance across queries, stored procedures, indexes, locking, disk utilization, memory, and related database resources.
- Identify and resolve system bottlenecks, including urgent production issues that require rapid investigation and remote troubleshooting.
- Support and maintain an AlwaysOn availability group consisting of primary and mirror servers.
- Provide data access and retrieval support to analysts and machine learning engineers.
- Perform routine database administration and maintenance activities, including archiving, recovery strategies, security policies, and data integrity checks.
- Manage and support high-load databases with data volumes reaching tens of terabytes.
- Monitor database and server performance proactively, identifying potential issues and taking preventive action before they result in incidents.
Requirements:
- Hands-on professional experience working with Microsoft SQL Server 2008–2019.
- Deep understanding of Microsoft SQL Server architecture, internals, and database behavior.
- Advanced T-SQL skills with extensive developer-level scripting experience, including stored procedures, user-defined functions, triggers, and distributed transactions.
- Strong understanding of relational database fundamentals and data structures.
- Proven ability to optimize complex SQL queries, stored procedures, and functions for performance and scalability.
- Ability to analyze execution plans and identify the underlying causes of database performance issues.
- Strong code-reading skills, with the ability to understand and troubleshoot SQL code written by other developers.
- Ability to independently identify logic and data-related issues by analyzing database structures and source code.
- Strong analytical and problem-solving skills, with the ability to investigate complex technical issues independently and respond effectively to production challenges.
Benefits:
- Temporary, full-time remote opportunity.
- Initial compensation level or salary range shared with candidates during the recruitment process and before employment begins.
- 28 calendar days of vacation per year.
- 7 wellness days per year that can be used for personal recovery, household matters, or other needs without using sick leave.
- Bonuses of up to $5,000 for successful employee referrals.
- 50% reimbursement for professional training, international conferences, and professional meetings.
- Corporate discounts for English-language lessons.
- Health support of up to $1,000 gross per year per employee when corporate medical insurance is not available, which can be used toward personally purchased health insurance or eligible medical expenses for the employee and close relatives.
- Workplace equipment and workspace support, including reimbursement of up to $1,000 gross once every three years for eligible home-office or coworking expenses.
- Internal gamified recognition system where colleagues can receive bonuses that can be exchanged for merchandise, team-building activities, massage certificates, and other rewards.
