2+ Query optimization Jobs in Mumbai | Query optimization Job openings in Mumbai

Role Summary

The Performance Architect is responsible for driving performance, scalability, and reliability improvements across the Vantagepoint enterprise platform. This role focuses on identifying, analyzing, and resolving complex performance issues spanning databases, reporting, APIs, and application architecture, with a strong emphasis on real-world impact in high-concurrency, enterprise environments.

Position Responsibilities

Mandate Skill set -SQL Server, Performance tuning, performance optimization, Performance Engineer,query tune,

Performance Analysis & Optimization

• Analyze and resolve high-impact performance issues affecting critical client workflows
• Optimize SQL queries, execution plans, indexes, and transaction scopes
• Identify and mitigate deadlocks, blocking, and contention hotspots
• Improve performance of reports, dashboards, and batch processing workflows
• Tune API and application-layer performance
• Validate improvements through benchmarking and regression testing

Architecture & Scalability

• Design solutions balancing short-term remediation and long-term scalability
• Evaluate tradeoffs across multiple active release versions
• Address performance-related technical debt
• Support schema evolution and data access optimization

Collaboration & Execution

• Work closely with Development, QE, Automation, DBA, and Architecture teams
• Participate in design reviews and spike investigations
• Support testing cycles and defect resolution
• Document performance findings and best practices

AI-Specific Responsibilities

• Use AI-assisted tools to accelerate performance analysis and root cause investigation
• Analyze execution plans, deadlock graphs, and query behavior using AI
• Compare performance characteristics across releases and environments
• Identify recurring performance antipatterns
• Validate AI-generated insights through empirical testing

Qualifications

Technical Skills & Expertise

Database & SQL Server (Required)

• Advanced SQL Server performance tuning (query optimization, execution plans, index design)
• Deadlock diagnosis and resolution using Extended Events and deadlock graphs
• Locking and blocking analysis (wait stats, lock escalation, transaction optimization)
• Stored procedure optimization (parameter sniffing mitigation, plan cache management)
• Index strategies, including covering, filtered indexes, and fragmentation management
• Statistics and cardinality understanding

Performance Analysis Tools (Required)

• SQL Server Profiler and Extended Events
• Execution plan analysis (SSMS, Azure Data Studio)
• SET STATISTICS IO/TIME analysis
• Query Store and performance insights
• Wait statistics and blocking chain analysis

Enterprise Application Architecture (Required)

• Multitier application performance patterns (.NET, C#, VB.NET, JavaScript, TypeScript)
• API performance optimization and parameter management
• Caching strategies (plan cache, data cache, predictive paging)
• Large-scale reporting architectures (SSRS, custom frameworks)
• Database schema evolution and backward compatibility

Performance Methodologies (Required)

• Performance testing and benchmarking
• Load testing and scalability analysis
• Root cause analysis for performance regressions
• A/B testing for optimization validation
• Performance monitoring and alerting

Office Location: Goregaon Mumbai

Position description:

4+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.