Navaneethakrishnan Ammamuthu
Fremont,CA
Summary
Results-oriented Oracle Database Performance Tuning Specialist with over 12 years optimizing Oracle databases and enhancing system efficiency. Skilled SQL and PL/SQL programmer with 13 years of experience in developing and maintaining database systems. Expertise in analyzing complex database architectures, identifying performance bottlenecks, and implementing solutions to improve query performance and streamline operations.
Overview
23
23
years of professional experience
1
1
Certification
Work History
DATABASE PERFORMANCE ENGINEER
Cisco Systems Inc
San Jose, USA
08.2021 - Current
- Developed an AI-driven RCA tool using Oracle APEX, utilizing LLMs and prompt engineering to automate performance diagnostics and SQL optimization suggestions.
- Engineered machine learning predictive framework using SVM and classification algorithms to forecast program runtimes and trigger automated performance alerts, enhancing proactive performance management.
- Led technical design and SQL code reviews for Oracle ERP Supply Chain and Finance customizations, mentoring developers to proactively prevent performance bottlenecks.
- Architected a suite of self-service performance portals via Oracle APEX REST APIs, empowering cross-functional teams to independently monitor metrics, and validate SQL performance.
- Implemented Python-based ETL scripts with SQLAlchemy and Pandas to automate data movement from Oracle Archive to Snowflake, facilitating a scalable, cloud-native migration.
- Leveraged Oracle SPA and Database Replay to capture production workloads and conduct impact analysis for DB version upgrades and hardware refreshes, proactively identifying and tuning regressed SQL before production deployment.
- Resolved critical SLA breaches in high-volume OLTP/OLAP environments with AWR, ASH, 10046, and 10053 Optimizer Trace for deep-dive performance tuning, stabilizing system performance.
PRINCIPAL PERFORMANCE ENGINEER
Oracle America Inc
Redwood City, USA
06.2016 - 08.2021
- Contributed expertise as a member of SQL Tuning specialist team, optimizing performance through understanding of Cost-Based Optimizer (CBO).
- Actively resolved high-priority Oracle SR tickets, ensuring optimal database performance for global, top-tier customers.
- Worked with Oracle Optimizer development team to resolve product bugs, reproducing issues on local server and documenting clear summaries, causes, and solutions.
- Presented compelling evidence and effectively demonstrated to the storage administration team the direct correlation between degraded IO latency/throughput.
DATABASE PERFORMANCE ANALYST
Cisco Systems, Dataformix Technologies
San Jose, USA
06.2015 - 05.2016
- Utilized Oracle performance monitoring tools such as Oracle Enterprise Manager and OS Watcher to analyze database performance metrics, such as CPU usage, memory utilization, and disk I/O.
- Collaborated with developers and database administrators to identify and resolve performance bottlenecks, optimizing SQL queries and enhancing database design.
- Collaborated with migration team to analyze and optimize data migration workflows, identifying bottlenecks and implementing strategies to enhance performance.
- Conducted capacity planning to assess future database growth and resource requirements, ensuring scalability and maintaining optimal performance.
SENIOR SOFTWARE ENGINEER
Mercator Solutions FZE
Dubai, UAE
07.2014 - 04.2015
- Collaborated with business analysts and end users to gather requirements and translate them into effective PL/SQL code
- Developed and maintained numerous stored procedures, functions, and packages in Oracle PL/SQL to support application functionality
- Executed testing and debugging of PL/SQL code to identify and resolve issues, ensuring code quality and performance
SENIOR SOFTWARE ENGINEER
Emirates Airlines, DNATA
Dubai, UAE
03.2007 - 07.2014
- Developed and maintained numerous stored procedures, functions, and packages using Oracle PL/SQL to enhance database functionality and performance
- Created Virtual Private database by using policies to restrict the access of data
- Provided effort estimation with breakdown to project management for informed decision-making
- Guided team in preparing and reviewing flow diagrams for complex requirements to ensure clarity and alignment
SOFTWARE ENGINEER
Akshay Software Technologies Ltd
Dubai, UAE
09.2005 - 03.2007
- Developed and maintained stored procedures, functions, and packages in Oracle PL/SQL to support application functionality
- Collaborated with business analysts and end users to gather requirements and translate them into functional PL/SQL code
SENIOR SOFTWARE ENGINEER
Eolas Consultancy Pvt Ltd
Tamilnadu, India
03.2003 - 09.2005
- Developed front-end application using Visual Basic to enhance user experience
- Created stored procedures, functions, packages, and triggers using SQL and PL/SQL to optimize data processing
Education
BACHELOR OF ENGINEERING - COMPUTER SCIENCE
Madurai Kamaraj University
Skills
- SQL / PLSQL
- SQL / Database Tuning
- Python
- Linux
- Database Design
- Machine Learning
- LLM
- System Prompt
Certification
- Oracle Cloud Infrastructure Foundations 2020
- SnowPro Core (Snowflake) certification Certified Associate
Timeline
DATABASE PERFORMANCE ENGINEER
Cisco Systems Inc
08.2021 - Current
PRINCIPAL PERFORMANCE ENGINEER
Oracle America Inc
06.2016 - 08.2021
DATABASE PERFORMANCE ANALYST
Cisco Systems, Dataformix Technologies
06.2015 - 05.2016
SENIOR SOFTWARE ENGINEER
Mercator Solutions FZE
07.2014 - 04.2015
SENIOR SOFTWARE ENGINEER
Emirates Airlines, DNATA
03.2007 - 07.2014
SOFTWARE ENGINEER
Akshay Software Technologies Ltd
09.2005 - 03.2007
SENIOR SOFTWARE ENGINEER
Eolas Consultancy Pvt Ltd
03.2003 - 09.2005
BACHELOR OF ENGINEERING - COMPUTER SCIENCE
Madurai Kamaraj University