Job Title

Role: DATABASE PERFORMANCE ARCHITECTExperience: 10 yearsLocation: Noida (HYBRID)Immediate Joiners PreferredJD:Key ResponsibilitiesPerformance 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 onboardingCloud 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 balanceData 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 documentationClient-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 policiesRequired 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 clientsPreferred 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