Database Performance Architect

Position: DATABASE PERFORMANCE ARCHITECT
Role: DATABASE PERFORMANCE ARCHITECT

Experience:

10 years

Location:

Noida
Immediate Joiners Preferred

JD:

Key Responsibilities
Performance Diagnostics & Optimization

• Diagnose and resolve complex database performance issues across MSSQL Server, Postgre

SQL, and Oracle in both client on-premise environments and Neo Xam SaaS infrastructure (AWS RDS, Azure SQL Managed Instance)

• Perform deep analysis using database-native diagnostic tools:
Oracle AWR/ASH/ADDM/SQLT, SQL Server DMVs/Query Store/Extended Events, and Postgre

SQL _statements/EXPLAIN ANALYZE/

• Optimize slow-running queries, stored procedures, and nested views that support high-volume transactional reconciliation workloads and complex reporting pipelines

• Analyze and tune database parameters, memory allocation, I/O configuration, and connection pooling settings for optimal performance under concurrent multi-module access patterns

• Identify and resolve locking/blocking issues, deadlocks, tempdb contention (SQL Server), shared buffer misses (Postgre

SQL), and latch contention (Oracle) in high-throughput scenarios

• Establish performance baselines and conduct capacity planning to ensure databases scale with growing reconciliation volumes and client onboarding
Cloud Database Management (AWS & Azure)

• Understand cloud-hosted databases:
Amazon RDS (SQL Server, Postgre

SQL, Oracle), Aurora Postgre

SQL, and Azure SQL Managed Instance / Azure Database for PostgreSQL

• Configure and tune cloud-specific parameters: RDS parameter groups, Performance Insights, Enhanced Monitoring, Azure Query Performance Insight, and Intelligent Performance features

• Advise on right-sizing database instances, storage types (gp3, io2, Premium SSD), read replicas, and Multi-AZ configurations for cost-performance balance
Data Architecture & Design

• Partner with development teams to design optimal data models, indexing strategies, and partitioning schemes for the shared-database architecture that underpins all platform modules

• Review and improve existing schema designs, identifying opportunities to denormalize for read-heavy reporting workloads or normalize for transactional integrity

• Guide teams on view optimization — refactoring deeply nested views into indexed/materialized views, CTEs, or query rewrites that maintain readability while delivering performance

• Design data archival and retention strategies to manage table growth while preserving query performance for active reconciliation data

• Establish database development standards: naming conventions, migration practices (Flyway/Liquibase), code review guidelines for SQL, and anti-pattern documentation
Client-Side Support & Troubleshooting

• Act as the escalation point for database-related issues reported by clients, providing rapid diagnosis and resolution for production-critical performance degradations

• Conduct database health assessments for client deployments, delivering actionable reports on configuration gaps, missing indexes, statistics staleness, and resource bottlenecks

• Create and maintain runbooks, diagnostic scripts, and troubleshooting guides that enable support teams to handle common database issues independently

• Collaborate with client DBAs and infrastructure teams to implement recommendations, respecting client-specific security and change management policies

Required Qualifications

• 10+ years of hands-on database administration and performance engineering experience across at least two of the three:
Microsoft SQL Server, Postgre

SQL, and Oracle

• Expert-level proficiency in SQL query optimization: execution plan analysis, index design (covering, filtered, partial, composite), statistics management, and query rewrites

• Deep experience with database diagnostic and profiling tools:
Oracle AWR/ASH/SQLT, SQL Server Query Store/DMVs/Extended Events/Profiler, Postgre

SQL _statements/EXPLAIN/

• Proven track record of resolving complex performance issues in high-volume transactional systems (millions of rows per processing cycle)

• Strong experience with cloud-managed database services on AWS (RDS, Aurora) and/or Azure (SQL Managed Instance, Azure Database for Postgre

SQL), including Performance Insights, parameter tuning,…