Site Reliability Engineer 5 - Live SRE
Role details
Job location
Tech stack
Job description
We are building a cutting-edge Platform that will transform the way our customers identify, protect and govern their data. This will revolutionize how customers secure their data by placing identity at the core - providing unparalleled visibility and control., We are seeking a Staff DBA with a strong background in data engineering and backend architecture to help define and standardize how data is stored and modeled across our Data Security Posture Management (DSPM) platform.
This role focuses on data schema design, consistency, and interoperability - ensuring that data collected from multiple enterprise systems (such as Active Directory, SharePoint, Entra ID, and file servers) is represented in a clear, unified, and scalable structure. You will work closely with backend and platform engineers to design the data models, schemas, and standards that power analytics, reporting, and policy enforcement across the platform., Schema Design & Data Modeling
- Design and maintain standardized data schemas used across different data sources and storage systems.
- Define data contracts and models to ensure consistent representation of entities such as users, groups, resources, and permissions.
- Develop and maintain schema evolution and versioning processes to support iterative product development.
- Ensure data models are optimizedfor both transactional and analytical workloads.
- Collaborate with engineering and product teams to align data models with business logic and reporting requirements.
Analytical & Application Storage
- Design and optimize ClickHouseschemas for analytical and time-series workloads.
- Maintain PostgreSQL schemas for metadata, configuration, and application-level data.
- Develop indexing, partitioning, and retention strategies that balance performance, scalability, and cost.
- Define transformation specifications to ensure consistency between raw and analytical data layers.
Data Quality & Governance
- Establish naming conventions, data types, and relationship standards for all stored data.
- Implement validation and normalization checks to ensure incoming data adheres to defined schemas.
- Partner with QA and product teams to verify that stored data accurately represents system behavior and business intent.
- Maintain clear documentation and metadata definitions for all datasets and structures.
Infrastructure & Automation
- Manage schema migrations and versioning through CI/CD workflows.
- Collaborate with DevOps teams to deploy and monitor databases in Kubernetes-based environments.
- Use Infrastructure as Code tools (Helm, Terraform, or similar) for consistent database provisioning.
- Support observability andmonitoring for data performance and reliability.
Requirements
Data & Database Expertise
- 5+ years of experience in data engineering, backend development, or database architecture.
- Hands-on experience with ClickHouse or other columnar analytics databases (e.g., Redshift, BigQuery, Snowflake).
- Strong proficiency in PostgreSQL and SQL query optimization.
- Solid understanding of database administration, indexing, and performance tuning.
Data Modeling & Standards
- Demonstrated experience designing data models for complex or multi-system environments.
- Familiarity with data contracts, schema evolution, and versioning best practices.
- Experience enforcing data standards and conventions across teams or systems.
- Understanding of metadata and documentation management (e.g., dbt, OpenMetadata, or similar).
DevOps & Tooling
- Experience deploying and managing databases with Kubernetes and containers.
- Knowledge of CI/CD pipelines and Infrastructure as Code (Helm, Terraform, GitHub Actions, etc.).
- Understanding of observability and performance monitoring for data systems.