Description
Summary:
Manage, maintain, and optimize database systems to ensure high availability, performance, security, and data integrity across various environments.
Highlights:
1. Manage database systems for high availability and performance
2. Design and implement robust backup, recovery, and security strategies
3. Collaborate with diverse teams on deployments and compliance audits
**Database Administrator (DBA) — Job Description**
**Role summary**
Manage, maintain, and optimize database systems to ensure high availability, performance, security, and data integrity across production and non‑production environments.
**Key responsibilities**
* Install, configure, upgrade, and patch database servers and related tools (e.g., PostgreSQL, MySQL, SQL Server, Oracle, MongoDB).
* Monitor database performance and capacity; tune queries, indexes, and configuration for optimal performance.
* Design and implement backup, recovery, and disaster‑recovery strategies; regularly test restores.
* Manage high‑availability and replication solutions (clustering, primary‑replica, Always On, Patroni, etc.).
* Perform schema design, data modeling, and maintain migrations in collaboration with developers.
* Implement and enforce database security: access controls, encryption at rest/in transit, auditing, and vulnerability remediation.
* Perform data migrations, imports/exports, and ETL support; optimize bulk loads and maintenance windows.
* Maintain database maintenance tasks: VACUUM, statistics updates, reindexing, partitioning, and housekeeping.
* Troubleshoot production incidents, perform root‑cause analysis, and drive long‑term fixes.
* Automate routine tasks using scripts and tools (Bash, PowerShell, Python, Ansible, Terraform).
* Maintain documentation, runbooks, and run regular capacity and performance reporting.
* Collaborate with DevOps/SRE, application teams, and security to support deployments, CI/CD pipelines, and compliance audits.
* Support performance testing, baseline measurements, and tuning for new features or releases.
**Required skills \& experience**
* 3–6 years experience as a DBA or in database operations (adjustable by seniority).
* Deep knowledge of at least one RDBMS (PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, or Oracle) and familiarity with one or more NoSQL systems (MongoDB, Cassandra, Redis).
* Strong SQL skills and experience with query profiling and optimization.
* Experience with backup/recovery tools and strategies; familiarity with point\-in\-time recovery and PITR.
* Knowledge of high‑availability, replication, and clustering technologies.
* Experience with automation, scripting (Python, Bash, PowerShell), and infrastructure\-as\-code tooling.
* Familiarity with Linux administration and basic networking concepts.
* Understanding of security best practices and compliance (encryption, RBAC, auditing).
* Experience with monitoring/observability tools (Prometheus, Grafana, Datadog, New Relic) and log analysis.
* Strong troubleshooting, documentation, and communication skills.
Pay: QAR320\.15 \- QAR702\.10 per hour
Work Location: On the road