SQL Server Senior DBA

Job description

Overview

SQL Server Senior DBA (Arabic Speakers) role at Dicetek LLC.

• 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

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 alert (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)

Seniority level

• Not Applicable

Employment type

• Contract

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Dubai, Dubai, United Arab Emirates

Required Skill Profession

Other General