Job Description
– Participate actively in architecture design sessions alongside Solution Architects and Engineering Leads; review application-level designs to identify upstream data risks early – Propose and evaluate database architecture patterns (e.g., CQRS, event sourcing, data mesh) and assess trade-offs between RDBMS, NoSQL, NewSQL, and time-series solutions – Design, implement, and optimize database schemas, stored procedures, indexing strategies, and access patterns; manage full database lifecycle (provisioning, patching, migration, decommissioning) – Analyze how application code interacts with the database layer; identify N+1 queries, ORM anti-patterns, and connection pool misconfigurations in collaboration with backend engineers – Design and maintain HA/DR strategies including replication topologies, failover automation, and RTO/RPO planning; lead incident response and root cause analysis for database-related issues – Implement and audit RBAC, data masking, encryption at rest and in transit; ensure compliance with relevant standards (GDPR, ISO 27001, PCI-DSS) – Serve as a technical reference for developers and junior DBAs; produce Architecture Decision Records (ADRs), data modeling standards, and internal knowledge-sharing sessions – Collaborate with DevOps/SRE teams to ensure database infrastructure is cloud-ready, observable, and integrated into CI/CD pipelines with proper migration tooling (Flyway, Liquibase, or equivalent) – Other tasks assigned by supervisor.
