MSSQL/PostgreSQL DBA(Database Administrator)

Confidential Company; Dubai; On-site; AED 120,000 - 200,000; Full time

Job summary

A leading tech company in Dubai is seeking a skilled Database Administrator to manage and optimize MSSQL and PostgreSQL databases. This role is crucial for ensuring data integrity, security, and high availability, working closely with development and infrastructure teams. Candidates should have a strong background in performance tuning, backup strategies, and automation tools, contributing to the business's overall data strategy and integrity.

Qualifications

• Minimum of 3-5 years of DBA experience with MSSQL and PostgreSQL.
• Hands-on experience with automating deployments and backup plans.
• Proficient in writing scripts to automate database maintenance tasks.

Responsibilities

• Manage, optimize, and maintain MSSQL and PostgreSQL databases.
• Implement backup and disaster recovery strategies.
• Monitor database performance and troubleshoot issues.

Skills

Performance Tuning

Backup and Recovery

Query Optimization

Database Security

Automation

Replication

Education

Bachelor’s degree in Computer Science

Tools

MSSQL

PostgreSQL

Liquibase

Azure DevOps

Ansible

Flyway

Job description

The Database Administrator (DBA) is responsible for managing, optimizing, and maintaining the MSSQL and PostgreSQL databases. This role ensures data integrity, security, and high availability across both database platforms. The DBA will work closely with development, infrastructure, and business teams to ensure database performance, troubleshoot issues, and implement best practices for backup, recovery, and disaster recovery. This role also focuses on database performance tuning, query optimization, and ensuring that database systems meet the needs of the organization.

Key Responsibilities

• Install, configure, and maintain MSSQL and PostgreSQL databases to ensure optimal performance, security, and reliability.
• Perform regular updates, patches, and upgrades on both MSSQL and PostgreSQL database systems.
• Monitor and optimize the performance of MSSQL and PostgreSQL databases, focusing on query performance, indexing, and resource utilization.
• Implement database indexing strategies, query optimization, and schema design best practices to improve system performance.
• Design and implement backup and disaster recovery strategies for both MSSQL and PostgreSQL databases to ensure data integrity and business continuity.
• Regularly test and validate backup processes to guarantee quick and reliable recovery in case of failure.
• Manage user access and database permissions to ensure database security and compliance with organizational policies.
• Investigate, diagnose, and resolve database performance issues and incidents in a timely manner.
• Monitor database growth and performance trends, plan for future capacity requirements, and ensure the system scales effectively with increasing data and traffic.
• Responsible for Creating and publishing database health checks to monitoring systems for the following:
• Index usage patterns
• CPU usage
• Memory usage
• Locks
• Number of connections
• Any other relevant params
• Implement partitioning, replication, and other scalability solutions to optimize database performance.
• Work closely with development teams to optimize queries, improve database schema, and support application development.
• Provide advice on database design, schema changes, and query performance improvements for both MSSQL and PostgreSQL systems.

Automate the process of deploying database changes to streamline the release management process and reduce manual intervention, ensuring smooth and consistent deployment across environments.

Desired Candidate Profile

Educational Qualifications

• Bachelor’s degree in computer science, Information technology or a related discipline (or equivalent experience)

Years of Experience

• Minimum of 3–5 years of experience in database administration, specifically with MSSQL and PostgreSQL.
• Proven track record in maintaining, optimizing, and troubleshooting production-level databases.
• Experience with automating database deployments, including using tools like Liquibase, Flyway, or Azure DevOpsfor continuous integration and deployment (CI/CD).
• Experience in designing and implementing backup and disaster recovery plans for both MSSQL and PostgreSQL environments.

Nature of Experience

• Proven experience in administering and optimizing MSSQL and PostgreSQL databases in production environments, including performance tuning, backup/recovery management, and troubleshooting database-related issues.
• Hands-on experience with automating database deployments and integrating database changes into CI/CD pipelines, ensuring efficient and consistent release management across environments.
• Expertise in MSSQL and PostgreSQL database administration, configuration, and troubleshooting.
• Strong experience in implementing and managing HA solutions like AlwaysOn Availability Groups, Replication, and Log Shipping in MSSQL.
• Expertise in PostgreSQL high availability tools like Patroni, RepMgr, and Logical Replication to ensure data redundancy and minimal downtime.
• Proficient in automating backup schedules and ensuring consistent backup execution using SQL Server Agent and third-party tools.
• Proficient in using pgBackRest and pgBarman for PostgreSQL backup management, ensuring efficient and reliable backup, restore, and disaster recovery strategies.
• Expertise in creating indexes, analyzing execution plans, and performing query optimization in both MSSQL and PostgreSQL to improve database performance and reduce resource consumption.
• In-depth knowledge of transactional replication, merge replication, and peer-to-peer replication in MSSQL, and experience with PostgreSQL replication methods like Streaming Replication, Logical Replication, and Synchronous Replication.
• Strong experience with database security, including user management, role-based access control (RBAC), data encryption, and audit logging for both MSSQL and PostgreSQL environments.
• Strong experience in writing shell scripts (Bash, Sh, etc.) for automating routine database maintenance tasks, including backup, restoration, health checks, and log rotation.
• Proficient in writing scripts to automate database monitoring tasks, such as checking database status, replication health, disk space usage, and performance metrics.
• Proficient in using automation tools like Ansible and Flyway for automating database deployments, version control, and schema migrations.
• Ability to tune MSSQL and PostgreSQL databases for peak performance, including query optimization and resource management.
• Expertise in ensuring business continuity by designing and testing robust backup and recovery solutions.
• Effective in working with developers and infrastructure teams to ensure smooth database integrations, optimizations, and migrations.

Good to have

Experience with K8s administration, including deploying and managing containerized database services (e.g., PostgreSQL, MSSQL) using K8s, Helm, and Docker

Be part of a team shaping the future of smart technologies at Dubai Technologies.

Disclaimer: Naukrigulf.com is only a platform to bring jobseekers & employers together. Applicants are advised to research the bonafides of the prospective employer independently. We do NOT endorse any requests for money payments and strictly advice against sharing personal or bank related information. We also recommend you visit Security Advice for more information. If you suspect any fraud or malpractice, email us at [e-mail]