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