Senior Database Engineer

Avrioc Technologies; Abu Dhabi; Hybrid; AED 300,000 - 520,000; Full time

Job summary

Avrioc Technologies seeks an experienced Senior NoSQL Database Administrator to own ClickHouse and MongoDB platforms across AWS, Azure, and on-prem environments. You will handle architecture, performance, HA/DR, backups, security, capacity planning, upgrades, migrations, automation, and 24x7 production support.

You should have 8+ years in IT/database administration with strong MongoDB and ClickHouse hands-on experience, plus relevant certifications and multi-cloud exposure.

Qualifications

• 8+ years IT and database administration experience with NoSQL focus.
• 5+ years MongoDB production experience (replica sets, sharded clusters, Atlas/Ops Manager).
• 3+ years ClickHouse production experience (cluster design, MergeTree, replication, distributed tables).
• Experience operating large-scale, multi-terabyte, high-availability database estates with strict SLAs.
• On-call production support experience for tier-1 platforms.
• Experience running databases on AWS, Azure, and on-premises or hybrid infrastructure.

Responsibilities

• Own day-to-day administration, monitoring, and health of ClickHouse and MongoDB environments.
• Install, configure, patch, upgrade, and decommission across cloud and on-prem estates.
• Manage user provisioning, roles, privileges, quotas, and access reviews.
• Maintain platform documentation, runbooks, SOPs, and configuration baselines.
• Design ClickHouse clusters with sharding, replication, and MergeTree configurations.
• Design MongoDB replica sets and sharded clusters with shard keys and indexes.
• Define database standards, naming conventions, and reference architectures.
• Deliver capacity planning for storage, memory, compute, and I/O.
• Performance engineering and optimization for ClickHouse and MongoDB.
• Establish performance baselines and SLA/SLO adherence.
• Implement high-availability topologies, replication, failover, multi-region support.
• Own backup and recovery strategy, including PITR and encryption.
• Plan and execute DR tests; validate RPO/RTO and remediate gaps.
• Security and compliance: encryption, authentication, auditing, key management.
• Support audits and vulnerability remediation and data protection compliance.

Skills

ClickHouse

MongoDB

AWS

Azure

HA/DR

Performance tuning

Automation

24x7 support

Education

Bachelor's Degree

MongoDB Certified DBA

ClickHouse certification

ITIL Foundation

Tools

MongoDB Atlas

Ops Manager

Job description

We are seeking an experienced Senior NoSQL Database Administrator to take end-to-end operational ownership of enterprise-grade ClickHouse and MongoDB platforms supporting business-critical, high-volume workloads across AWS, Microsoft Azure, and on-premises environments.

Deep, hands-on production expertise in ClickHouse and MongoDB is mandatory for this role. The successful candidate will own database architecture and design, performance engineering, high availability and disaster recovery, backup and restore, security and compliance, capacity planning, upgrades and migrations, automation, observability, and 24x7 production support.

Educational Qualification and Professional Certifications

• Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related technical field.

• MongoDB Certified DBA (Associate or Professional).

• ClickHouse professional certification or equivalent demonstrable vendor training.

• ITIL Foundation or equivalent IT service management certification.

Required Professional Experience

• 8+ years of overall IT and database administration experience, with the majority spent on NoSQL database technologies.

• 5+ years of hands-on production experience administering MongoDB, including replica sets, sharded clusters, and MongoDB Atlas or Ops Manager.

• 3+ years of hands-on production experience administering ClickHouse, including cluster design, MergeTree engine family, replication, and distributed tables.

• Proven experience operating large-scale (multi-terabyte), high-availability, business-critical database estates with demanding SLAs.

• Demonstrated experience delivering 24x7 production support and participating in an on-call rotation for tier-1 platforms.

• Hands-on experience running databases across AWS, Microsoft Azure, and on-premises or hybrid infrastructure.

• 8+ years of overall IT and database administration experience, with the majority spent on NoSQL database technologies.

• 5+ years of hands-on production experience administering MongoDB, including replica sets, sharded clusters, and MongoDB Atlas or Ops Manager.

• 3+ years of hands-on production experience administering ClickHouse, including cluster design, MergeTree engine family, replication, and distributed tables.

• Proven experience operating large-scale (multi-terabyte), high-availability, business-critical database estates with demanding SLAs.

• Demonstrated experience delivering 24x7 production support and participating in an on-call rotation for tier-1 platforms.

• Hands-on experience running databases across AWS, Microsoft Azure, and on-premises or hybrid infrastructure.

Key Responsibilities:

• Database Administration & OperationsOwn day-to-day administration, monitoring, and operational health of all production and non-production ClickHouse and MongoDB environments.

• Perform installations, configuration, patching, version upgrades, and decommissioning across cloud and on-premises estates.

• Manage user provisioning, roles, privileges, quotas, and access reviews in line with least-privilege principles.

• Maintain accurate platform documentation, runbooks, standard operating procedures, and configuration baselines.

• Architecture & DesignDesign and size ClickHouse clusters, including sharding and replication topology, MergeTree engine selection, partitioning, primary key and ordering key strategy, TTL, and materialised views.

• Design MongoDB replica sets and sharded clusters, including shard key selection, indexing strategy, schema design guidance, and read/write concern configuration.

• Define database standards, naming conventions, and reference architectures; review application data models before production release.

• Deliver capacity planning and growth forecasting for storage, memory, compute, and I/O.

• Performance Engineering & OptimisationProactively identify and resolve performance bottlenecks through query profiling, execution plan analysis, index tuning, and resource contention analysis.

• Tune ClickHouse query performance, merge behaviour, compression codecs, projections, skip indexes, and resource quotas for high-ingest analytical workloads.

• Tune MongoDB performance using the aggregation framework, index optimisation, WiredTiger cache sizing, and connection pool management.

• Establish and track performance baselines, and report on SLA and SLO adherence.

• High Availability, Backup & Disaster RecoveryImplement and maintain high-availability topologies, replication, failover automation, and multi-region or multi-AZ resilience.

• Own backup and recovery strategy, including scheduling, retention, encryption, offsite copies, and point-in-time recovery.

• Plan and execute regular restore drills and disaster recovery tests; validate RPO and RTO objectives and remediate gaps.

• Security & ComplianceImplement database hardening, encryption at rest and in transit, authentication and authorisation, auditing, and key management.

• Support internal and external audits, vulnerability remediation, and compliance with applicable regulatory and data-protection requirements.