Database Administrator
Job Description
Experience
4 – 9 Years
Job Location
Abu Dhabi – United Arab Emirates
Education
Any Graduation
Nationality
Any Arabic National
Gender
Any
Vacancy
10 Vacancies
Job Description
· 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 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 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 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 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.
·
· Qualification
· Minimum 3 years’ experience as 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.
· SQL 2012 – 2016, Azure, MCTS, MCITP, and/or MCDBA certifications are a plus.
· Experience on NoSQL platform like MongoDB, Cassandra or Cosmos
