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, PostgreSQL, and Oracle in both client on-premise environments and NeoXam 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 PostgreSQL pg_stat_statements/EXPLAIN ANALYZE/auto_explain

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 (PostgreSQL), 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, PostgreSQL, Oracle), Aurora PostgreSQL, 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, PostgreSQL, 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, PostgreSQL pg_stat_statements/EXPLAIN/auto_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 PostgreSQL), including Performance Insights, parameter tuning, and instance right-sizing

Solid understanding of database internals: buffer management, lock escalation, transaction isolation levels, WAL/redo log mechanics, and their performance implications

Experience optimizing nested views, stored procedures, and complex reporting queries in shared-database architectures where multiple applications access the same schema concurrently

Strong communication skills ability to explain complex database concepts to development teams and present findings to non-technical stakeholders and clients

Preferred Qualifications

Domain experience in capital markets, financial services back-office operations, or reconciliation/settlement systems

Experience with all three database engines (MSSQL Server, PostgreSQL, and Oracle) at a production scale

Certifications: Oracle OCP/OCM, Microsoft MCSA/MCSE Data Management, AWS Database Specialty, or Azure Database Administrator Associate

Experience with database observability platforms: Datadog, SolarWinds DPA, Redgate SQL Monitor, or pganalyze