StaffDBA

## Accountabilities Design and maintain standardized data schemas across multiple enterprise data sources, ensuring consistency, scalability, and interoperability Define and enforce data models and contracts for core entities such as users, groups, resources, and permissions Develop schema evolution and versioning strategies to support continuous product development and platform scalability Design and optimize PostgreSQL and ClickHouse schemas for transactional, analytical, and time-series workloads Establish indexing, partitioning, and retention strategies to balance performance, cost, and scalability requirements Ensure alignment between data models, business logic, and reporting needs in collaboration with engineering and product teams Implement data quality standards, including validation, normalization, and consistency checks across systems Manage schema migrations and database changes through CI/CD pipelines and infrastructure automation workflows Collaborate with DevOps teams on Kubernetes-based deployments and infrastructure-as-code practices for database systems Support observability and monitoring initiatives to ensure data reliability and system performance Requirements: 5+ years of experience in data engineering, backend engineering, or database architecture roles Strong expertise in PostgreSQL, SQL optimization, and database performance tuning Hands-on experience with ClickHouse or similar analytical databases such as Snowflake, BigQuery, or Redshift Proven experience designing complex data models across multi-system or enterprise-scale environments Strong understanding of data modeling principles, schema design, and data lifecycle management Experience with schema versioning, data contracts, and data governance best practices Familiarity with metadata management and data documentation tools (e.g., dbt, OpenMetadata, or similar) Experience working with Kubernetes environments and containerized database deployments Knowledge of CI/CD pipelines and infras