Description :
Role : Infrastructure Engineer Database & Storage
About the Role :
We are hiring an Infrastructure Engineer Database & Storage to architect Perceive Now core data-fabric layer, ensuring high availability, low-latency access, and secure storage of all evidence artifacts. You will design multi-region, versioned, and auditable storage systems that form the foundation of Perceive Now trust layer.
Responsibilities :
- Design and maintain PostgreSQL clusters, OpenSearch indices, and Azure Blob / S3 buckets for high-throughput, low-latency operations.
- Architect schema registries, metadata catalogs, and time-versioned stores to track dataset evolution and lineage.
- Implement replication, partitioning, sharding, and query optimization for large-scale relational workloads.
- Configure read replicas, PITR (point-in-time recovery), and WORM (Write Once Read Many) compliance for immutable data.
- Set up encryption-at-rest (AES-256), encryption-in-transit (TLS 1.3), and key rotation policies via KMS / Vault.
- Develop infrastructure automation using Terraform, Helm, and Ansible, integrated into GitHub Actions / Azure Pipelines.
- Manage monitoring and failover automation using Patroni, PgBouncer, Prometheus, and Grafana.
- Collaborate with DevOps to deploy cross-region replication and disaster recovery (DR) strategies.
- Benchmark I / O performance, indexing efficiency, and query response times for continuous optimization.
Required Qualifications :
6+ years of experience in database administration or cloud infrastructure engineering.Deep knowledge of PostgreSQL internals (VACUUM tuning, query planning, lock management, indexing strategies).Experience deploying and managing OpenSearch / Elastic clusters and object storage solutions (S3 / Azure Blob).Hands-on with IaC (Terraform, Helm) and Kubernetes-native DB deployments.Strong understanding of backup automation, replication lag analysis, and read / write consistency management.Familiarity with high-availability setups, failover orchestration, and secrets management (Vault / KMS).Preferred Skills :
Experience implementing schema registries, data catalogs, or metadata versioning systems.Knowledge of policy enforcement using OPA and audit pipelines to SIEM tools (Splunk / Sentinel).Exposure to OLAP optimization, columnar storage, or vector search (pgvector, Milvus) for high-dimensional data.(ref : hirist.tech)