Experience

- Overall: 12+ years
- Application Architecture: 4+ years
- AlloyDB / PostgreSQL Internals: 6+ years (mandatory)

Role Summary The Application & Database Architect will be responsible for defining, designing, and governing end‑to‑end application and database architecture with a strong focus on GCP AlloyDB PostgreSQL . This role demands deep expertise in distributed PostgreSQL systems , performance engineering , and cloud‑native architectures , ensuring highly scalable, secure, and high‑performance solutions aligned with business and enterprise standards.

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

Key Responsibilities Application Architecture

- Define end‑to‑end application architecture across UI, services, integration, and data layers
- Design microservices‑based, event‑driven, API‑first architectures
- Review and govern application designs, frameworks, and coding standards
- Guide teams on non‑functional requirements: scalability, performance, security, reliability
- Lead application modernization and cloud migration initiatives
- Evaluate and recommend technology stacks, frameworks, and tools
- Ensure alignment with enterprise architecture, DevOps, and security standards

Database & Data Architecture

- Design, enhance, and maintain multi‑region AlloyDB PostgreSQL clusters on GCP
- Architect for high availability, failover, and cross‑region replication
- Optimize read/write distribution, latency, and throughput across regions
- Perform deep AlloyDB/PostgreSQL performance tuning
- Diagnose complex production issues such as:

- Idle transactions

- Long‑running queries




- Subtransaction overhead and lock contention
- Analyze and optimize queries using EXPLAIN / ANALYZE
- Fine‑tune 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 (on‑prem → cloud, legacy → modern DBs)

Cloud & Platform Architecture

- Define cloud‑native architectures on GCP (AWS/Azure exposure is a plus)
- Design solutions using managed cloud services (databases, messaging, caching, storage)
- Establish CI/CD, IaC, and DevSecOps standards for applications and databases
- Drive cost optimization, performance tuning, and reliability engineering in cloud environments

Governance & Technical Leadership

- Act as a cross‑team technical authority
- Conduct architecture reviews and design walkthroughs
- Mentor senior developers, DBAs, and solution architects
- Collaborate with product owners, business stakeholders, and security teams
- Support pre‑sales, estimations, and technical solutioning when required

Required Technical Skills Application & Integration

- Programming: Java / Python / Node.js (any two preferred)




- Spring Boot, RESTful APIs, event‑driven systems
- API gateways, messaging platforms (Kafka / PubSub / SQS‑like systems)
- Front‑end awareness: React / Angular (high‑level)
- Working knowledge of GenAI / Agentic AI / MCP workflows

Databases

- AlloyDB PostgreSQL (deep internals – mandatory)
- Other RDBMS: MySQL, Oracle, SQL Server
- NoSQL: DynamoDB, MongoDB, Cassandra, or equivalent
- Experience with large data volumes, OLTP/OLAP, and high‑throughput systems
- Strong expertise in data modeling and performance engineering

Cloud & DevOps

- Hands‑on architecture experience on GCP / AWS / Azure
- Docker & Kubernetes (design‑level proficiency)
- CI/CD tools: Git, Jenkins, GitHub Actions, Azure DevOps
- Infrastructure as Code: Terraform / ARM / CloudFormation

Security & Reliability

- Secure design principles, IAM, encryption, auditing, compliance
- Observability: logging, monitoring, tracing
- DR, resilience, and fault‑tolerant design

Good to Have

- Experience with data platforms: BigQuery, Databricks, Redshift, Snowflake
- Exposure to ETL and streaming architectures
- Experience in regulated environments (finance, data‑privacy heavy systems)
- TOGAF or Cloud Certifications (GCP / AWS / Azure)

Soft Skills

- Robust stakeholder communication and technical storytelling
- Decision‑making with clear trade‑off analysis
- Mentoring and technical leadership
- Ability to work across multiple programs and priorities

GCP, AlloyDB,Postgres , SQL

Soft Skills

- Strong stakeholder communication and technical storytelling
- Decision‑making with clear trade‑off analysis
- Mentoring and technical leadership
- Ability to work across multiple programs and priorities

📌 GCP AlloyDB PostgreSQL Performance Architect (Indore)
🏢 Impetus
📍 Indore