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.