Senior Database Administrator — OLTP & OLAP Databases

Senior Database Administrator — OLTP & OLAP Databases Location: Ukraine, Armenia, Moldova, Brazil(Remote)

Our trusted high-growth healthcare technology partner is seeking a talented Data Engineer to join their dynamic team. This innovative company is dedicated to revolutionizing the healthcare industry through cutting-edge technology solutions.

About the Role

We're hiring a Senior DBA to own the database layer across our production systems — OLTP relational databases as the operational store and an OLAP columnar database for analytics. Data flows between them via a CDC pipeline (Debezium → Kafka) managed by our infrastructure team. You'll own what's on both ends: schema design, data modeling, query performance, and analytics enablement. This is a high-ownership role. You'll be the technical authority on how our data is structured, how it performs, and how schema changes propagate safely from OLTP to OLAP stores. You'll work closely with application teams, data consumers, and the infrastructure team that operates the CDC pipeline.

What You'll Own OLTP schema design: Data modeling, indexing strategies, migration planning, and performance tuning across multiple database clusters OLAP data modeling: Table design, materialized views, partitioning, and query optimization for analytics workloads Schema evolution: Coordinating schema changes with the infrastructure team to ensure safe propagation through the CDC pipeline Query performance: Profiling, optimization, and capacity planning across both OLTP and OLAP stores Data integrity: Validation, reconciliation, and monitoring to ensure consistency between OLTP and OLAP stores Technical leadership: Standards for schema management, review processes, mentoring, and cross-team collaboration

Tech Stack OLTP: Aurora MySQL 8.0 (multiple clusters, multi-AZ) OLAP: ClickHouse 25.x CDC Pipeline: Debezium 3.3.2 → Kafka 4.0 → ClickHouse Observability: Prometheus, Grafana, OpenTelemetry Cloud: AWS (EKS, RDS, S3)

Requirements 5+ years as a DBA or data engineer, 2+ in a senior/lead role Strong experience with OLTP relational databases (MySQL, PostgreSQL, Oracle, or similar) — schema design, indexing, query optimization, replication, migrations Strong experience with OLAP/columnar databases (ClickHouse, Vertica, Greenplum, Druid, Doris, or similar) — table design, materialized views, partitioning, query optimization Deep SQL expertise across both transactional and analytical query patterns Experience with schema migration strategies in environments with downstream consumers (CDC, ETL, replication) Familiarity with data consistency challenges between OLTP and OLAP systems

Nice to Have Experience with Debezium or CDC systems — understanding how schema changes affect downstream pipelines Healthcare data or regulated environments (HIPAA, SOC2) Data quality frameworks — validation, reconciliation, anomaly detection dbt, Airflow, or similar transformation/orchestration tools Performance benchmarking and capacity planning for OLAP databases Experience with AWS RDS/Aurora operational features — Parameter Groups, Performance Insights.

Benefits: Competitive salary to recognise and reward your achievements. Flexible work environment. Opportunities for professional and personal growth.