Head – Database Architecture (MongoDB + PostgreSQL + Cloud + AI)

Overview

Experience: 10–18 Years

About The Role

• We are seeking a highly experienced Head – Database Architecture to design and scale a hybrid database ecosystem using MongoDB and PostgreSQL, deployed in a cloud-native environment.
• AI-readiness is a strategic priority.
• This role will architect databases not just for transactions, but for analytics, automation, and AI-driven workflows.
• You will own:
• **Database design & architecture**
• **Performance & scalability**
• **Data security & compliance**
• **Cloud-native DB strategy**
• **AI-enabled data infrastructure**

Core Expectations

1️ Hybrid Database Architecture (MongoDB + PostgreSQL)

• **Design hybrid architecture strategy (SQL + NoSQL separation of concerns)**
• **Define when to use MongoDB vs PostgreSQL**
• **Design transactional schema in PostgreSQL (ACID compliance)**
• **Design scalable document schema in MongoDB**
• **Implement replication, partitioning & sharding strategies**
• **Optimize high-concurrency workloads**
• **Design event-driven data flows between DB systems**
• **Ensure cross-database data consistency**

2️ PostgreSQL (Deep Expertise Required)

• **Advanced schema design & normalization strategy**
• **Indexing, query plan analysis & performance tuning**
• **Stored procedures (when required)**
• **Transaction isolation & locking strategies**
• **High availability (read replicas, failover)**
• **Backup & disaster recovery planning**
• **Partitioning for high-volume tables**
• **Performance benchmarking under load**

3️ MongoDB (Advanced Architecture Knowledge)

• **Schema modelling for scalable document storage**
• **Aggregation pipeline optimization**
• **Sharding & horizontal scaling**
• **Replica sets configuration**
• **Index design & query optimization**
• **TTL and memory optimization**
• **MongoDB Atlas configuration (if cloud-managed)**

4️ Cloud-Native Database Strategy

• Strong exposure to:
• **AWS / Azure / GCP**
• **EC2 / Virtual Machine**
• **Storage & IOPS**

Responsibilities Include

• **Designing HA & multi-AZ DB setups**
• **Auto-scaling strategies**
• **Cloud backup & snapshot management**
• **Infrastructure as Code (Terraform preferred)**
• **Cost optimization**
• **Cloud monitoring integration**
• Must understand:
• **Multi-region replication**
• **Failover strategies**
• **DB performance under load balancers**
• **Secure VPC architecture**

5️ AI-Ready Data Architecture (Critical)

Responsibilities Include

• **Structuring data pipelines for ML/AI use cases**
• **Designing data models for analytics & predictive systems**
• **Integrating vector storage where required**
• **Supporting real-time data streaming**
• **Preparing datasets for AI model training**
• **Implementing AI-assisted query optimization tools**
• **Leveraging AI tools for schema design & DB performance analysis**
• **Enabling data lakes or warehouse integration**
• Exposure to:
• **Vector databases (pgvector preferred)**
• **Embedding storage**
• **AI-driven query tuning tools**
• **Data warehouse architecture concepts**

6️ Security & Compliance

• **Encryption at rest & in transit**
• **Role-based access control**
• **Audit logging**
• **Data masking & anonymization**
• **Secure credential management**
• **Compliance alignment (financial-grade systems preferred)**

7️ Monitoring & Performance Engineering

• **Database performance monitoring**
• **Query plan analysis**
• **Index health tracking**
• **Use of monitoring tools (CloudWatch / Prometheus / Grafana)**
• **Latency reduction strategies**
• **Incident root cause analysis**

8️ Leadership & Governance

• **Define database standards**
• **Conduct architecture reviews**
• **Guide backend teams on DB best practices**
• **Establish performance benchmarks**
• **Define scaling roadmap**
• **Evaluate AI-based database optimization tools**
• **Mentor DB engineers**

Mandatory

• Expert-level PostgreSQL
• Advanced MongoDB architecture knowledge
• Cloud-native database deployments
• High-scale transaction optimization
• AI-enabled data modeling experience
• Hybrid database strategy experience

Strongly Preferred

• Experience in fintech or transaction-heavy platforms
• Experience handling 100K+ daily transactions
• Real-time systems exposure
• Vector database exposure
• Infrastructure as Code

Success Metrics

• 99.99% database uptime
• Reduced query latency under load
• Zero data integrity failures
• AI-ready data structure implementation
• Successful multi-region DB strategy
• Cost-optimized cloud database spend
• Reduced performance bottlenecks

Why Join Us?

• Build the core data backbone of a scalable platform
• Architect hybrid MongoDB + PostgreSQL ecosystem
• Enable AI-driven data strategy
• Lead database scaling in cloud-native environment
• Work on real-time, high-volume transactional systems
• Apply Now – Send your CV and portfolio to **[email protected]**
• About the Company:
• Welcome to the Future of Personal Mobility at Self Drive.
• A Mobility Tech Platform Established in 2016 in the Middle East with its Head Quarters in DUBAI and a team of over 140+ employees that operates across 10 countries around the world.
• Self Drive Mobility is backed by car manufacturers, dealers and the top leasing companies with managing assets worth over USD 1 Billion on its platform making it the fastest-growing Mobility Tech Company in the GCC Region.
• Self Drive Mobility operates across UAE, Oman, Qatar, Bahrain, Kuwait, Saudi Arabia, Turkey, Ireland, Scotland, United Kingdom and India with an fleet of over 25000+ units offering Daily \| Weekly \| Monthly car subscription rentals & Digital Leasing Solutions targeting D2C & B2B Clients.
• The company achieved a milestone by serving 1.5 million customers & reached 3 Million days of reservation & is currently the largest mobility platform across in the Middle East.

Application Open

Location

Job Types: Full-time, Permanent