Database Performance Architect-Noida, India at NeoXam

Noida, Uttar Pradesh, India -

Full Time

Start Date

Immediate

Expiry Date

09 Jun, 26

Salary

0.0

Posted On

11 Mar, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Performance Tuning, SQL Optimization, Execution Plan Analysis, Index Design, Database Diagnostics, Microsoft SQL Server, PostgreSQL, Oracle, AWS RDS, Azure Database Services, Database Architecture, Data Modeling, Cloud Database Management, Performance Baselines, Troubleshooting, Capacity Planning

Industry

Software Development

Description

At NeoXam,we are looking for a Database Performance Architect to serve as the definitive authority on database performance, architecture, and reliability across our entire platform. You will work across both client-side deployments and our SaaS infrastructure, diagnosing and resolving complex database performance issues, optimizing queries and views, tuning database parameters, and helping engineering teams design the right data architecture from the ground up. This is a deep individual contributor role with high visibility. You will be the go-to expert when critical database issues arise at client sites or in production SaaS environments, and you will proactively drive improvements to our data layer that directly impact reconciliation throughput, report generation speed, and overall platform scalability. 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. 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

Responsibilities

The role involves diagnosing and resolving complex database performance issues across MSSQL Server, PostgreSQL, and Oracle in both client and SaaS environments, utilizing native diagnostic tools. Responsibilities also include optimizing queries, tuning parameters, and establishing performance baselines for high-volume transactional workloads.