2P Perfect Presentation

Senior Database Specialist

Riyadh, Saudi ArabiaPosted yesterday

Salary
AED 12k–18k a month· est.
Job type
Full time
Level
Junior
Field
Engineering & Technology
Work mode
On site

About the role

Since 2004, 2P – Perfect Presentation has been a leader in Saudi Arabia’s ICT landscape, delivering integrated technology solutions that help organizations accelerate digital transformation and improve operational efficiency. With a strong foundation in innovation and service excellence, 2P continues to provide end-to-end solutions through its specialized business units and trusted market expertise. We are looking for a Senior Database Specialist with hands-on experience in Microsoft SQL Server administration, T-SQL, performance tuning, backup and recovery, database security, and high availability. Role Summary The Senior Database Specialist will be responsible for supporting, maintaining, monitoring, and optimizing database environments to ensure availability, performance, security, reliability, and data integrity. Key Responsibilities • Administer and support Microsoft SQL Server database environments. • Monitor database performance, availability, capacity, and overall health. • Write, maintain, and troubleshoot T-SQL queries. • Perform SQL performance tuning and query optimization. • Manage database backup, recovery, and routine maintenance activities. • Support and maintain SQL Server Always On Availability Groups. • Manage database users, roles, permissions, and access controls. • Support database security requirements, including data masking and encryption. • Monitor and troubleshoot database incidents and performance issues. • Support SQL Server Agent Jobs and scheduled database activities. • Provide basic support for SSIS packages and related processes. • Support PostgreSQL database environments when required. • Perform regular database health checks and preventive maintenance. • Maintain accurate technical documentation and operational procedures. • Coordinate with application, infrastructure, and technical teams to resolve database-related issues. Requirements • 2–3 years of experience in Database Administration. • Good hands-on knowledge of Microsoft SQL Server. • Experience with T-SQL queries and performance tuning. • Knowledge of database backup, recovery, and maintenance. • Familiarity with SQL Server Always On Availability Groups. • Experience in database security and user access management. • Basic knowledge of SSIS and SQL Server Agent Jobs. • Basic knowledge of data masking and encryption. • Familiarity with PostgreSQL. • Strong troubleshooting and problem-solving skills. • Good documentation skills, including maintaining technical documentation and operational procedures. Key Technical Skills Microsoft SQL Server | T-SQL | Performance Tuning | Always On Availability Groups | Backup & Recovery | Database Security | SSIS | SQL Server Agent | Data Masking | Encryption | PostgreSQL

Requirements

2–3 years of experience in Database Administration. Good hands-on knowledge of Microsoft SQL Server. Experience with T-SQL queries and performance tuning. Knowledge of database backup, recovery, and maintenance. Familiarity with SQL Server Always On Availability Groups. Experience in database security and user access management. Basic knowledge of SSIS and SQL Server Agent Jobs. Basic knowledge of data masking and encryption. Familiarity with PostgreSQL. Strong troubleshooting and problem-solving skills. Good documentation skills, including maintaining technical documentation and operational procedures.

Responsibilities

Administer and support Microsoft SQL Server database environments. Monitor database performance, availability, capacity, and overall health. Write, maintain, and troubleshoot T-SQL queries. Perform SQL performance tuning and query optimization. Manage database backup, recovery, and routine maintenance activities. Support and maintain SQL Server Always On Availability Groups. Manage database users, roles, permissions, and access controls. Support database security requirements, including data masking and encryption. Monitor and troubleshoot database incidents and performance issues. Support SQL Server Agent Jobs and scheduled database activities. Provide basic support for SSIS packages and related processes. Support PostgreSQL database environments when required. Perform regular database health checks and preventive maintenance. Maintain accurate technical documentation and operational procedures. Coordinate with application, infrastructure, and technical teams to resolve database-related issues.

Skills

  • Microsoft SQL Server
  • T-SQL
  • Performance Tuning
  • Always On Availability Groups
  • Backup & Recovery
  • Database Security
  • SSIS
  • SQL Server Agent
  • Data Masking
  • Encryption
  • PostgreSQL
  • SQL
  • Troubleshooting
  • Documentation

Not sure you fit this role?

Upload your CV and see how you score against 2P Perfect Presentation and every other live job. It's free.

Get my free matches

Similar jobs in Saudi Arabia