SQL Server Senior DBA (Arabic Speakers)

Dicetek LLC; Sharjah; On-site; AED 120,000 - 200,000; Full time

Job summary

A leading database services provider in Sharjah is seeking a Senior SQL Server DBA to design, implement, and manage database environments. The successful applicant will collaborate with application developers, oversee database performance and integrity, and ensure backup and recovery processes. Candidates should have experience in disaster recovery strategies and 24x7 support, with strong skills in SQL Server and performance tuning. This role offers competitive remuneration and is based in Sharjah, UAE.

Qualifications

• Proficient in SQL Server installation and configuration.
• Experience with disaster recovery and high-availability configurations.
• Knowledge in monitoring and performance tuning.

Responsibilities

• Design and maintain efficient data models.
• Perform troubleshooting of database issues.
• Manage SQL Server environments and their integrity.

Skills

Database Performance Tuning

Disaster Recovery

Backup and Recovery Strategies

24x7 Support

Monitoring SQL Server

Tools

SQL Server

Oracle

Access

Informix

Job description

SQL Server Senior DBA

Roles And Responsibilities

• Work closely with Application Developers to design, test, implement, perfect and maintain efficient transactional and analytical data models
• Lead/engage in tuning, upgrade, and configuration projects to enhance performance and ensure stability
• Optimize and keep backup jobs and schedules as well as maintain Production, DR and Development environments
• Troubleshoot database and data issues as they occur
• Supply Ad Hoc data reporting and data pulls for Analytics teams
• Perform various ad-hoc data loading and data manipulation tasks
• Manage routine data exports for clients, partners, and SMEs
• Create and manage scheduled tasks and data processing scripts
• Document data collection, processing, and presentation procedures
• Help support architecture and process flow diagrams for data systems
• Participates in the evaluation, design, implementation, maintenance, support, and enhancement of sophisticated database systems and technologies.
• Manage all levels of database security and integrity, transaction activity and utilization.
• Responsible for defining and documenting policies, procedures, and standards related to database administration.
• Responsibilities include troubleshooting database issues, recovery, tuning of the database, software installation, resolving SQL Server errors and failures.
• Facilitate database backup and recovery as well as documenting and testing all backup and recovery procedures.
• Responsible for service level availability for all production and non-production SQL Server environments.

Required Technical And Professional Expertise

• Setup Test, Dev, Staging and Production Environments. (Installing SQL Server)
• Disaster Recovery
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration)
• Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)
• Work as part of a team and provide 24x7 support
• Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)
• From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)
• Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication, Always on)
• Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email (if there is one configured))
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)
• Documenting major changes to the SQL Servers. (General)
• Apply Service Packs. (General)