One of a leading Engineering MNC Group into major engineering projects with the UAE Government is looking for a Database Administrator with 3-5 years of experience to handle a major public transport government project.

• The candidate will be part of a software development team to deliver large scale public transportation related projects.
• A professional Database Administrator (DBA) will keep the database up and running smoothly 24/7.
• The candidate will specifically focus on MSSQL Enterprise with High Availability configurations, including Cluster Failover and Availability Groups, while maintaining robust security practices.
• The goal is to provide a seamless flow of information considering both backend data structure and frontend accessibility for end-users.

Responsibilities:

• MSSQL Enterprise Management: Install, configure, and maintain MSSQL Enterprise database servers to ensure high availability, security, and optimal performance.
• High Availability (HA) Setup: Design and implement SQL Server High Availability solutions using Always On Availability Groups, SQL Server Failover Clusters, and Database Mirroring to ensure the database is always available and resilient against server failures.
• Performance Tuning & Optimization: Conduct performance tuning and optimization (PTO) of MSSQL servers, using native monitoring tools, and work on query optimization, indexing strategies, and system resource management.
• Security Management: Implement advanced database security measures, ensuring data encryption, access control, and compliance with CIS security standards. Conduct regular security audits and ensure the database infrastructure is secure and meets industry standards.
• Backup & Recovery: Oversee database backup strategies, ensure recovery procedures are in place, and perform regular recovery drills to ensure minimal downtime during system failures.
• Cluster Failover & Availability: Manage and troubleshoot SQL Server Failover Clustering and ensure seamless failover to secondary systems in case of primary system failure, ensuring minimal disruption to services.
• Database Maintenance: Perform installation, patching, upgrading, and troubleshooting of the database and its infrastructure to ensure uptime and reliability.
• Account Management: Support and perform database account management tasks, including user role management, and periodic reviews of user accounts to ensure proper access control.
• Database Reports & Dashboards: Create and manage database reports, visualizations, and dashboards to monitor database performance, security, and availability.
• On-call Production Support: Provide ongoing production database support and be available for on-call support, especially in critical situations or emergencies.

Education and Experience Requirements:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience in database administration, information technology, database architecture, or a related field.
• Hands-on experience with MSSQL Enterprise and expertise in setting up and managing SQL Server High Availability solutions, including Always On Availability Groups and SQL Server Failover Clustering.
• Strong understanding of performance tuning and optimization (PTO), using SQL Server’s native tools such as SQL Profiler, Extended Events, and Dynamic Management Views (DMVs).
• Experience with advanced database security, including data encryption, CIS compliance, and access control policies.
• Experience with Linux, Unix, and Windows Server environments, with a strong preference for SQL Server management in these systems.
• Experience with backup, recovery, and disaster recovery planning, particularly for high-availability database environments.
• Familiarity with PostgreSQL, MongoDB, or Oracle Exadata is a plus.
• Excellent written and verbal communication skills, and the ability to multi-task and collaborate effectively with different teams.
• Ability to context-switch between various tasks and responsibilities while maintaining focus on high-priority issues.

Job Type: Full-time
Pay: AED5,000.00 - AED10,000.00 per mont

• MSSQL Enterprise Management: Install, configure, and maintain MSSQL Enterprise database servers to ensure high availability, security, and optimal performance.
• High Availability (HA) Setup: Design and implement SQL Server High Availability solutions using Always On Availability Groups, SQL Server Failover Clusters, and Database Mirroring to ensure the database is always available and resilient against server failures.
• Performance Tuning & Optimization: Conduct performance tuning and optimization (PTO) of MSSQL servers, using native monitoring tools, and work on query optimization, indexing strategies, and system resource management.
• Security Management: Implement advanced database security measures, ensuring data encryption, access control, and compliance with CIS security standards. Conduct regular security audits and ensure the database infrastructure is secure and meets industry standards.
• Backup & Recovery: Oversee database backup strategies, ensure recovery procedures are in place, and perform regular recovery drills to ensure minimal downtime during system failures.
• Cluster Failover & Availability: Manage and troubleshoot SQL Server Failover Clustering and ensure seamless failover to secondary systems in case of primary system failure, ensuring minimal disruption to services.
• Database Maintenance: Perform installation, patching, upgrading, and troubleshooting of the database and its infrastructure to ensure uptime and reliability.
• Account Management: Support and perform database account management tasks, including user role management, and periodic reviews of user accounts to ensure proper access control.
• Database Reports & Dashboards: Create and manage database reports, visualizations, and dashboards to monitor database performance, security, and availability.
• On-call Production Support: Provide ongoing production database support and be available for on-call support, especially in critical situations or emergencies