Database Administrator (PostgreSQL & MySQL) - Saudi only
Lucidya | لوسيديا · Riyadh, Riyadh, Saudi Arabia
Tailor my CV for this job — freeAbout LucidyaLucidya is an AI-native Customer Experience Intelligence platform that helps organizations understand customer conversations, uncover actionable insights, and improve customer experiences through advanced AI capabilities.As the platform continues to grow, maintaining reliable, secure, and high-performing data infrastructure is critical to supporting our customers and enabling continuous product innovation.Our database environment spans multiple cloud platforms and hosting environments, supporting business-critical workloads, high-volume data ingestion, and multi-tenant applications. We are looking for a Database Administrator who can help strengthen our database operations, improve resilience, and ensure our data infrastructure remains reliable as we scale.Why this role mattersOur database infrastructure is growing in both scale and complexity. With production PostgreSQL and MySQL environments running across AWS, Google Cloud Platform (GCP), and our in-Kingdom hosting environment, maintaining database availability, performance, and recoverability is essential to the reliability of our platform.As a Database Administrator, you'll take ownership of the health and operational reliability of our production databases. You'll work on challenges that go beyond routine administration, including multi-terabyte database environments, high-availability architecture, disaster recovery, major-version upgrades, and safe database migrations.You'll also work closely with engineering, cloud, and reliability teams to help developers make better database decisions, prevent production incidents, and improve the way database changes are designed and delivered.If you enjoy solving complex database performance challenges, building resilient data infrastructure, and taking ownership of critical production systems, this role offers the opportunity to make a meaningful impact.What You'll DoManage and maintain PostgreSQL and MySQL databases across AWS, GCP, and self-managed environmentsMonitor database performance, availability, and capacityOptimize queries, indexing, and database resource utilizationManage backups, point-in-time recovery, and disaster recoveryImplement database replication, high availability, and failover strategiesPlan database upgrades, migrations, and safe schema changesMaintain database security, access controls, and auditingAutomate database operations using Bash, Python, or similar toolsTroubleshoot database incidents and perform root-cause analysisCollaborate with engineering, DevOps, SRE, and Cloud teams to improve database reliability and scalabilityWhat success looks like (First 90-120 Days)First 30 days:You've developed a clear understanding of the production database estate across AWS, GCP, and SITEYou understand the existing database architecture, operational workflows, monitoring, and recovery proceduresYou've built strong working relationships with the database team, Cloud Engineering, SRE, and development teamsYou've identified the most significant risks and improvement opportunities across availability, performance, backup, and recoveryBy day 60:You're independently handling assigned database administration and troubleshooting activitiesYou've reviewed backup configurations and started validating recovery procedures for critical databasesYou've identified gaps in database monitoring and alerting, including replication lag, WAL contention, autovacuum, and table bloatYou're contributing to database performance improvements and operational documentationBy day 90:Critical database restore tests have been completed or are progressing against an agreed recovery-testing plan, with gaps documented and corrective actions definedKey database failure scenarios are documented through practical runbooksDatabase monitoring and alerting improvements have been implemented for prioritized operational risksYou're actively contributing to database reliability, performance, and incident-prevention initiativesBy day 120:A safer database change-management process is in place, including appropriate reviews, DDL auditing, and rollback planningA practical PostgreSQL major-upgrade roadmap has been developed, with compatibility and migration risks assessedThe high-availability approach for the SITE database environment has been evaluated and documentedDatabase size and activity metrics are available to support the per-customer cost-allocation initiativeRequirementsWho You AreYou're an experienced Database Administrator who understands that managing production databases is about more than keeping services running. You know how to prevent data loss, diagnose complex performance problems, plan high-risk changes, and build systems that remain reliable under pressure.You're comfortable working with large, business-critical databases and can balance operational stability with the need to improve architecture, automation, and scalability.Technically, you likely:Have 5+ years of hands-on PostgreSQL administration experience in productionHave experience with AWS Aurora, Amazon RDS, MySQL, and self-managed Linux databasesUnderstand database performance tuning, replication, high availability, and disaster recoveryHave experience managing multi-terabyte databases, upgrades, and migrationsCan automate database operations using Bash or PythonWhen it comes to database resilience:You have hands-on experience with backups, recovery, replication, and failoverYou can troubleshoot database incidents and minimize downtimeYou follow safe change-management practices and maintain rollback plansWhen it comes to database performance:You can troubleshoot slow queries, indexing, locking, and resource utilizationYou understand PostgreSQL internals and multi-tenant database challengesWhat sets you apart:You take ownership and remain calm under pressureYou communicate clearly and collaborate effectively with engineering teamsYou document your work and continuously improve database reliabilityNice to Have (but not required)Experience with multi-tenant database architectures, particularly schema-per-tenant environments with thousands of schemasExperience managing databases larger than several terabytes with high write volumes and demanding availability requirementsHands-on experience with PostgreSQL tooling such as Patroni, pgBackRest, or WAL-GExperience supporting cloud migrations or moving customer workloads to in-Kingdom hosting environmentsFamiliarity with database observability, capacity planning, and per-customer database usage or cost allocationExperience working in SaaS, data-platform, fintech, banking, or telecommunications environmentsExperience with infrastructure-as-code tools and automated database provisioningRelevant certifications, such as EDB PostgreSQL or AWS certificationsWhat the hiring process will look likeMawhub screening Technical screen (45 min) — [DB Lead] Technical deep-dive (60-90 min) with a practical scenario: diagnosing replication lag and WAL contention, planning a zero-downtime major upgrade — [DB Lead + SRE Team Lead] Hiring manager interview — Mahmoud Moharam, Cloud Manager Culture fit interview - HR Director