Headline

Database and Application Tuning

About

High-stakes specialist in SQL Tuning, Database Modernization, and Cloud Migrations. I solve the mission-critical performance bottlenecks that stop revenue-generating applications. Expert in translating complex architectural failures into stable, scalable business outcomes. Core Expertise: Performance Engineering, Cross-Platform Migrations, and SDLC Optimization. Value Prop: I don't just "troubleshoot"—I re-engineer data access layers to safeguard SLAs and slash infrastructure costs. Leadership: Proven track record in escalation management and steering architectural strategy for enterprise-scale production environments. Global Consulting Footprint I’ve successfully delivered performance solutions to over 50 top-tier organizations across India and the globe, including: Barclays, RBS, HDFC, SBI, Axis Bank, Airtel, Marks & Spencer, Target, British Telecom, Honda, Doosan, Motherson Sumi, AT&T, Essilor, Ministry of Defense (GOI), NHPC, and Central Excise, among others. Passion Building robust, future-ready data ecosystems that power innovation, efficiency, and business growth. #PostgreSQL #MySQL #oracle #sqltuning #PerformanceEngineering #DatabasePerformance #SQLTuning #DatabaseConsulting

Location

Gurugram

Work experience

Performance Tuning SME at Oracle, Aug 2022 - Present · 3 yrs 9 mos, Gurugram, Haryana, India, Working in Advance Customer Services (CSS) division on multiple Customer projects with primary focus on Performance Optimization, Database Design in live production environments. Architecting Database Solutions: Designing and implementing efficient, scalable, and high-performance database architectures that support complex applications. SQL & NoSQL Performance Tuning: Leading the optimization of SQL and NoSQL queries, fine-tuning database performance to reduce latency and improve processing times. Data Modeling & Design: Creating and refining logical and physical data models to ensure data consistency, scalability, and optimal performance. Query Optimization: Analyzing and optimizing complex SQL queries and execution plans to improve database response times. Troubleshooting & Diagnostics: Conducting in-depth performance diagnostics and resolving bottlenecks across diverse database systems.

Database Solution Architect at JPMorgan Chase & Co., Mar 2021 - Jul 2022 · 1 yr 5 mos, Bengaluru, Karnataka, India, Worked as Database and Solution Architect in centralized Architect team , helping the teams in CIB LOB during the cloud migration journey from in premise to cloud for all kind of databases - Migrating across database flavors like from Sybase to Postgresql , Sybase to SQL Server, Vertica to Redshift , Oracle to Postgresql etc. - Helping the teams understand various aspects of Risk and Controls related to Banking system - Giving performance tuning recommendations to multiple internal customers

Data Service Lead at Barclays, May 2019 - Feb 2021 · 1 yr 10 mos, Noida, Uttar Pradesh, India, Worked in Risk and Finance Team (RFT) LOB and helped the team in cloud migration to AWS from on-premise, database design, development and performance optimization of existing applications. All applications belonged to GRC(Governance, Risk and Compliance) domain which acts as golden source of all Control’s information for Bank - Successful Cloud migration of Core OLTP application of RFT from on premise Oracle 12c to AWS RDS (Oracle) . - Resolved more than 2 year pending production issue of Oracle PGA memory leaks ( caused by Java leaks) for vendor application without increasing hardware as demanded by vendor, thus saving more than 50K per year. - Successfully lead team of 5 members following Agile Methodologies - Successful migration of RFT’s strategic datawarehouse and reporting system from Oracle 11g to 12c -Used new features like In-memory and partitioning . - Improved the datawarehouse SCD type-2 design which lead to reduction of overall size

Senior Database Analyst at Verifone, Jan 2018 - Apr 2019 · 1 yr 4 mos, India, Worked in Application Service Delivery(ASD) team as SME for applications and databases on Production and Development Systems • PostgreSQL Performance Optimization for custom applications by adding partitions, indexes, implementing optimal object models/schema and managing large datasets using Sharding • Upgrade of Demantra applications from oracle version 11.2.0.4 to 12.2.0.2. Performance got improved by more than 40% by implementing partitioning, indexing and code refactoring • Upgrade of Amdocs applications from v7 to v10. Improved performance of web application and OLAP queries • Working on performance of both Production and Dev servers for Oracle Apps, Demantra, Amdocs, Tableau and Datawarehouse systems • Performed capacity planning for database growth. • Database Performance tuning which includes CPU and Memory resizing, SQL and PL/SQL Tuning

Principal advanced support engineer at Oracle India Pvt. Ltd, Aug 2015 - Dec 2017 · 2 yrs 5 mos, Noida Area, India, Worked in Advanced Customer Support (ACS) team as on-premises Database Consultant for Production environments of Indian clients(~25) which include Oracle Applications, PeopleSoft, Siebel, E-Commerce, Custom applications for large sized customers across private and Public Sector in India with database size in Terabytes and concurrency of more than 500 people. •Solved the issues by working with multiple business and technical teams of customers and Oracle •Involved in database and application upgrades of Oracle Applications 11.5.10, R12.x, Peoplesoft •Resolved pre and post go-live performance issues for Siebel, Oracle Apps •Performance optimization of existing and new applications to help customer to meet SLA’s •Involved in discussions on scalability of applications •Database Performance tuning, SQL and PL/SQL Tuning- Analyzing tkprofs, tuning by changing/optimizing code , adding hints •Database design and Code reviews

Education

Bachelor of Technology (B.Tech.), Computer Science, Shaheed Bhagat Singh State University

Senior Secondary, Khalsa College Amritsar