Noida, Uttar Pradesh, India;Bangalore, Karnataka, India;Pune, Maharashtra, India;Hyderabad, Telangana, India;Gurgaon, Haryana, India;Chennai, Tamil Nadu, India;Indore, Madhya Pradesh, India

Qualification

:

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
- up, DR, retention, and database security strategies
Lead database migration and modernization (on‑prem cloud, legacy
- contemporary 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

- 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

Skills Required

:

GCP, AlloyDB,Postgres , SQL

Role

:

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
- up, 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

- 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

Experience

:

12 to 16 years

Job Reference Number

:

13764

📌 GCP AlloyDB PostgreSQL Performance Architect (India)
🏢 Impetus Technologies
📍 India