GCP AlloyDB PostgreSQL Performance Architect

Experience

Overall: 12+ years
Application Architecture: 4+ years
Alloy

DB / Postgre

SQL 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 Alloy

DB Postgre

SQL .

This role demands deep expertise in  distributed Postgre

SQL 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, Dev Ops, and security standards

Database & Data Architecture

Design, enhance, and maintain multi‑region Alloy

DB Postgre

SQL clusters on GCP
Architect for high availability, failover, and cross‑region replication
Optimize read/write distribution, latency, and throughput across regions
Perform deep Alloy

DB/Postgre

SQL 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 Postgre

SQL/Alloy

DB 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 Dev Sec Ops  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 / Pub Sub / SQS‑like systems)
Front‑end awareness:
React / Angular (high‑level)
Working knowledge of GenAI / Agentic AI / MCP workflows

Databases

Alloy

DB Postgre

SQL (deep internals – mandatory)
Other RDBMS:
MySQL, Oracle, SQL Server
No

SQL:
Dynamo

DB, Mongo

DB, Cassandra, or equivalent

Experience with large data volumes, OLTP/OLAP, and high‑throughput systems
Strong expertise in data modeling and performance engineering

Cloud & Dev Ops

Hands‑on architecture experience on GCP / AWS / Azure
Docker & Kubernetes (design‑level proficiency)
CI/CD tools:
Git, Jenkins, Git Hub Actions, Azure Dev Ops
Infrastructure as Code:
Terraform / ARM / Cloud Formation

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:
Big Query, 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

GCP, Alloy

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