20 Aug
|
Impetus Technologies
|
Delhi
20 Aug
Impetus Technologies
Delhi
Role Summary
The Application & Database Architect will be responsible for defining, designing, and governing endtoend application and database architecture with a robust 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
📌 GCP AlloyDB Architect (Delhi)
🏢 Impetus Technologies
📍 Delhi