Source description
About the role
Role Summary The Application & Database Architect will be responsible for defining, designing, and governing endtoend application and database architecture with a strong focus on GCP AlloyDB PostgreSQL . This role demands deep expertise in distributed PostgreSQL systems , performance engineering , and cloudnative architectures , ensuring highly scalable, secure, and highperformance 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 endtoend application architecture across UI, services, integration, and data layers Design microservicesbased, eventdriven, APIfirst architectures Review and govern application designs, frameworks, and coding standards Guide teams on nonfunctional 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 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 Diagnose complex production issues such as: Idle transactions Longrunning queries Subtransaction overhead and lock contention 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) Cloud & Platform Architecture Define cloudnative 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 crossteam 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 presales, estimations, and technical solutioning when required Required Technical Skills Application & Integration Programming: Java / Python / Node.js (any two preferred) Spring Boot , RESTful APIs, eventdriven systems API gateways, messaging platforms ( Kafka / PubSub / SQSlike systems ) Frontend awareness: React / Angular (highlevel) 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 highthroughput systems Strong expertise in data modeling and performance engineering Cloud & DevOps Handson architecture experience on GCP / AWS / Azure Docker & Kubernetes (designlevel 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 faulttolerant design Good to Have Experience with data platforms : BigQuery, Databricks, Redshift, Snowflake Exposure to ETL and streaming architectures Experience in regulated environments (finance, dataprivacy heavy systems) TOGAF or Cloud Certifications (GCP / AWS / Azure) Soft Skills Strong stakeholder communication and technical storytelling Decisionmaking with clear tradeoff analysis Mentoring and technical leadership Ability to work across multiple programs and priorities
More at Impetus Technologies