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

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

Purpose: We are looking for React Native Application Developer who possesses a passion for mobile technologies.

Roles & Responsibilities:

• Ideal candidate should have Working knowledge of React Native and React JS is a must.
• Over 3+ years of React Native experience with strong basics.
• At least have done 4/5 projects using React Native.

• Strong passion for Programming in general and Android and IOS App development.

• Strong problem solving skills.
• Strong system design and architecture skills.
• Curiosity to tinker around, explore new paradigms and strong zest for continuous improvement.
• Over 3+ years of Mobile development experience with strong basics.
• E2E App development and/or experience of developing SDKs is good to have.

Expected Start Date: 1/4/2021

Job Type: Full-time