Key Responsibilities Multi-Engine Management: Administer a hybrid database environment, ensuring seamless data flow between PostgreSQL (Live Trading) and ClickHouse/Snowflake (Analytics). Data Movement & ETL: Own the reliability of CDC pipelines that stream data from production Postgres instances into the analytical layer. Schema Evolution: Manage schema changes across different engines, ensuring that transactional data models translate effectively into columnar formats for analytics. Monitoring & Cost Governance: Implement unified observability for the entire stack. Specifically, monitor Snowflake credit usage and ClickHouse resource utilization to ensure peak ROI. Automation: Use Python, Bash and/or Ansible to automate routine maintenance tasks and deployments and monitoring services. Technical Stack Our data ecosystem is built for massive scale and diverse query patterns: Primary Transactional: PostgreSQL (Self-managed on EC2/K8s and AWS RDS/Aurora). Real-Time Analytics: ClickHouse (used for sub-second telemetry, high-throughput event logging, and real-time trading dashboards). Data Warehousing: Snowflake (our central source of truth for cross-team BI, regulatory reporting, and historical trend analysis). Orchestration: Kubernetes (EKS), Terraform, Ansible and on prem. Data Pipelines: Kafka, CDC (Change Data Capture) tools like Debezium. Technical Requirements Essential Expert-level knowledge of PostgreSQL (Performance tuning, vacuuming, indexing). Hands-on experience with ClickHouse (managing clusters, MergeTree engines, and tuning for high-concurrency). Proficiency in Snowflake administration (RBAC, Warehouse sizing, Snowpipe, and Task management). Experience with AWS (specifically RDS and Aurora). Proficiency in Linux/Unix administration and shell scripting. Knowledge of monitoring tools (e.g., Prometheus, Grafana, CloudWatch). Desirable Knowledge of the betting or financial trading industry. Relevant certifications (AWS Certified Database, Postgres Professional). Soft Skills Problem Solver: You enjoy "under the hood" troubleshooting and RCA (Root Cause Analysis). Calm Under Pressure: Ability to handle high-stakes production incidents effectively. Communicator: Can translate complex technical database issues to non-technical stakeholders. Team Player: Enthusiastic about knowledge sharing and mentoring others