Experience

- Overall: 10-15 years

Role Summary

As an Associate Database Architect, the person will be responsible for defining, designing, and governing endtoend database architecture with a strong focus on GCP AlloyDB PostgreSQL.
This role demands deep expertise in distributed PostgreSQL systems, performance engineering, ensuring highly scalable, secure, and highperformance solutions aligned with business and enterprise standards.

The architect will act as a technical authority, driving database modernization, cloud migration, and database optimization for high throughput, low latency, and high availability systems deployed across multiple regions.

Key Responsibilities

Database engineer & Data Architecture

- Design, enhance, and maintain multiregion AlloyDB PostgreSQL clusters on GCP
- Architect for high availability, failover, and crossregion replication
- Optimize read/write distribution, latency, and throughput across regions
- Perform deep AlloyDB/PostgreSQL performance tuning
- Able to review most optimized Postgres code
- Diagnose complex production issues & provide solution for problems like:-
- Idle transactions
- Longrunning queries
- Subtransaction overhead and lock contention
- Slow stored procedure execution

- Analyze and optimize queries using EXPLAIN / ANALYZE
- Finetune PostgreSQL/AlloyDB parameters for:

- Parallel query execution
- CPU and memory utilization
- High concurrency workloads
- VACUUM and AUTOVACUUM internals

- Drive data modelling (conceptual, logical, physical) and schema governance




- Define indexing strategies and query optimization standards
- Own backup, DR, retention, and database security strategies
- Lead database migration and modernization (onprem cloud, legacy modern DBs)
- Have good knowledge in pre-identifying DB critical stages

Governance & Technical Leadership

- Conduct database architecture reviews and design walkthroughs
- Mentor team of database developers
- Collaborate with product owners, business stakeholders, and security teams
- Support estimations and technical solutioning for databases when required

Required Technical Skills

Databases

- AlloyDB PostgreSQL (deep internals)
- Writing high throughput queries and SPs
- Other RDBMS: Oracle
- Experience with large data volumes, OLTP/OLAP, and highthroughput systems
- Strong expertise in debugging, data modeling and performance engineering

Security & Reliability

- Secure design principles, IAM, encryption, auditing, compliance for Alloy DB PostgreSQL
- Observability: logging, monitoring, tracing for Alloy DB PostgreSQL database
- DR, resilience, and faulttolerant design for Alloy DB PostgreSQL

Valuable to Have

- Experience with data platforms: BigQuery, Databricks, Redshift, Snowflake
- NoSQL: MongoDB
- Exposure to ETL and streaming architectures
- Experience in regulated environments (finance, dataprivacy heavy systems)
- GCP Professional Cloud Database Engineer

Soft Skills

- Strong stakeholder communication and technical storytelling
- Decisionmaking with clear tradeoff analysis
- Mentoring and technical leadership

📌 PostgreSQL Alloy DB Architect (Maharashtra)
🏢 Impetus Technologies
📍 Maharashtra