Senior Database Engineer

We are seeking a highly skilled Senior Database Engineer to join our team. The ideal candidate will have 5+ years of experience managing, optimizing, and administering high-performance database systems. You will be responsible for architecting, maintaining, and optimizing ClickHouse, MongoDB, and SQL databases while ensuring scalability, security, and efficiency. Experience with Apache Airflow and data orchestration tools is a plus.

Key Responsibilities:

• Database Management: Administer, optimize, and maintain ClickHouse, MongoDB, and MariaDB databases.

• Database Architecture & Design: Develop efficient schemas, indexing strategies, query optimization techniques, sharding, and replication strategies.

• Performance Tuning: Optimize queries, allocate resources, and implement caching mechanisms for maximum performance.

• Database Administration: Ensure database security, compliance, monitoring, backup, and recovery strategies.

• Data Orchestration & ETL/ELT: Work with Apache Airflow, Luigi, Prefect, Dagster to streamline data pipelines.

• High-Velocity Data Streaming: Collaborate with ETL engineers to ensure efficient ingestion of real-time data into ClickHouse, including schema compatibility and ingestion performance tuning.

• ClickHouse Optimization: Design schemas, optimize analytical queries on multi-billion row datasets, and implement data retention and roll-up strategies using background merges and view hierarchies.

• DevOps & Automation (Preferred): Work with Docker, Kubernetes, Terraform to deploy and manage database infrastructure.

• Collaboration: Work closely with cross-functional teams, including Data Engineers, Software Developers, and DevOps, to implement robust and scalable database solutions.

Key Skills:

• Databases: ClickHouse, MongoDB, MariaDB

• Database Optimization: Query tuning, indexing, replication, sharding

• Programming: SQL, Python, Bash scripting

• Data Orchestration: Apache Airflow, Luigi, Prefect, Dagster

• Streaming & ETL: Clickhouse Kafka Table Engine

• ClickHouse Internals: Data parts, merges, materialized views, TTLs, partitions

• Security & Compliance: Backup, monitoring, access control

Required Experience:

• 5+ years of hands-on experience in database management and optimization.

• Strong expertise in ClickHouse administration and architecture.

• Experience with query optimization, sharding, replication, and indexing strategies.

• Strong debugging and optimization skills for complex SQL joins and aggregations.

Preferred Qualifications:

• Familiarity with DevOps tools like Docker, Kubernetes, Terraform.

• Experience in data security, compliance, and governance best practices.

• Exposure to high-velocity, real-time data streaming environments.

• Strong expertise in MongoDB administration and architecture

• Strong expertise in MariaDB administration and architecture

• Hands-on experience with Kafka, Apache NiFi, Talend for data ingestion and processing.

Benefits:

• Competitive salary and performance-based bonuses.

• Flexible work environment (Remote or On-site in Dubai).

• Opportunity to work with cutting-edge database technologies.

• Career growth and learning opportunities in a fast-paced environment.