Database Optimization Engineer

Role: DATABASE PERFORMANCE ARCHITECT

Experience: 10 years

Location: Noida (HYBRID)

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