Job Description

Category Software Engineer Location Abu Dhabi, UAE Experience 3 years

• Minimum 3 years of experience as a core database administrator
• Expertise in failover clustering, always-on, and other high availability technologies.
• SQL Server merge, peer to peer, or transactional replication.
• Analysis Services, Integration Services, or Reporting Services.
• Experience in Enterprise Applications for high volume, transactional environments.
• Experience in virtualized environments.
• Manage SQL Server databases through multiple product lifecycle environments from development to mission-critical production systems. Configure and maintain database servers and processes including monitoring system health and performance, to ensure high levels of performance, availability, and security support day-to-day operational activities for the database platform including service requests and tickets, monitoring, and troubleshooting performance issues.
• Supports Microsoft Windows 2016 and 2019 Enterprise Servers that support the SQL application, including configuration and maintenance.
• Configure database backups to meet the business's Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Implement and supports high availability solutions for MS SQL including Always-On.
• Install and configure Microsoft SQL Server and Microsoft Windows.
• Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance.
• Provide guidance and support to Application Developers, identifying the most resource-intensive queries on the server and suggesting ways to improve performance on each.
• Analyze/design indexes for existing applications, proactively monitor query performance, and provide analysis on when to add or remove indexes.
• Investigate, analyze and troubleshoot system performance and suggest/implement tuning as needed.
• Develop system tools and utilities (i.e. scripts, etc.) to simplify and support business operations.
• Provide a high level of customer satisfaction for internal and external customers, applying the necessary sense of urgency and creativity in problem identification and prompt incident resolution.
• Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end. Determine the most effective way to increase performance, server configuration changes, or index/query changes. Assist developers with complex query tuning and schema refinement.
• Troubleshooting SQL Server service outages as they occur, including providing support during after-hours and weekends. After-hours work may also include, but is not limited to scheduled maintenance, supporting application deployment, and hardware/software upgrades.
• Plan and schedule the installation and configuration of new SQL Servers. Analyze the requirements for new projects and determine whether to use failover clustering, log shipping, always-on, or other technologies to solve a business problem.
• Experience on Azure platform, DBaaS & Key vaults. Managing & securing credentials.

Skills MS SQL DBA, SQL DBA, Database Administrator Job Type: Full-time