Himanshu Nagia

• Led Oracle database performance tuning initiatives across US and global environments, improving SQL execution efficiency by up to 40% and ensuring 99.99% uptime for critical customer systems.
• Replicated and diagnosed complex customer performance issues in controlled test environments, reducing resolution time by 35% through targeted root cause analysis.
• Leveraged AWR/ASH reports, ADDM, and internal diagnostic tools to perform deep SQL and database performance analysis, delivering actionable optimization strategies that improved transaction throughput by 30%.
• Owned and resolved high-priority customer escalations for, cutting incident resolution time from 8 hours to under 2 hours.
• Collaborated with development teams to identify and document SQL engine and optimizer-related product bugs, directly influencing three major performance feature enhancements in subsequent releases.
• Authored and maintained a comprehensive Oracle Performance Tuning Knowledge Base covering Database / SQL optimization, improving internal case resolution efficiency by 25%.

Job Duties:

• Managed and optimized Oracle Databases (11g, 12c) in RAC and standalone environments, improving system uptime by 99.9%.
• Configured and maintained Oracle Data Guard (Active and Physical Standby), ensuring seamless disaster recovery with minimal downtime.
• Led data replication initiatives using Oracle GoldenGate, MySQL, MariaDB, MongoDB, and other tools, resulting in faster data synchronization, and improved data consistency across platforms.
• Optimized SQL queries using trace analysis (TKPROF, EXPLAIN PLAN), reducing query processing time by up to 30%.
• Collaborated with development teams to enhance database performance and availability, achieving a 25% increase in system efficiency.
• Performed database backups, restores, and migrations using RMAN and Data Pump, ensuring 99.95% data availability and quick recovery in case of failure.
• Led cloud migration projects (AWS, Azure, Oracle Cloud), optimizing post-migration performance, reducing infrastructure costs by 20%, while ensuring high availability.

• Implemented GoldenGate replication for bi-directional data movement between two data centers, ensuring high availability and data consistency.
• Consolidated tables and enabled GoldenGate replication by segregating application data for optimized performance.
• Configured conflict detection and resolution in Oracle 11gR2 for active-active replication environments, automating timestamp resolution for common conflicts.
• Set up Before and After Image captures for accurate conflict detection and resolution.
• Monitored real-time bidirectional data replication to ensure seamless data synchronization.
• Provided Heterogeneous environment support for seamless data integration across platforms.
• Utilized OGG Studio for managing GoldenGate files across DEV, QA, and production environments.
• Integrated data using Oracle Data Integrator (ODI) to load data from SQL Server to Oracle, improving cross-platform data flow.
• Actively monitored conflict detection and validated stats on an hourly basis to ensure data consistency.
• Implemented Veridata to verify data consistency and ensure alignment across replicated databases.

Job Duties:

• Installed, configured, and maintained Oracle databases (9i/10g/11g/12c) on Linux, UNIX, and Windows platforms; and SQL Server on Windows Server (2008/2012/2016).
• Configured heterogeneous services for data integration between DB2, MS SQL Server, SAP, and Oracle using Oracle Gateways.
• Optimized database performance and performed tuning using 12c Grid Control, including setting up alerts, metrics, and monitoring templates.
• Led migrations and upgrades from AIX/Solaris to Red Hat Linux for cost efficiency and to support server lease expiration projects.
• Managed database performance using AWR, ADDM, ASH reports, and performed health checks and metric collection for system optimization.
• Configured Dataguard to ensure high availability and disaster recovery for critical enterprise data.