Expert in Oracle Performance Tuning, Oracle Archit...
Last active: 17 days ago
worked on Oracle based technologies. Having strong technical skills in Oracle Performance Engineering/Tuning, Oracle Applications Finance modules, and good conceptual knowledge on Oracle Middleware technology (SOA) tool – Oracle BPEL & Integration architecture.
Excellent skills in Oracle Performance Engineering.
Prepared Oracle Best practices with Oracle 11g/10g new advance features.
Given many Oracle based training on Oracle Performance Tuning & Oracle PL/SQL Best Practices .
Worked on new ideas/ initiatives using Oracle Technologies to solve business problems and automation of business processes.
Written Technical White Paper on Oracle Performance Engineering, Oracle Report Server Architecture.
• Worked on Oracle Applications financials 11.0.3/11i
Expertise in oracle forms, reports, pl/sql , Toad
Working as a Sr Architect on multiple Oracle Performance projects to fix any performance issues related with Oracle Applications (ERP) on Oracle 11g/10g databases. I am responsible to execute, manage & delivery of multiple PE projects.
- helped organization to find & get right business opportunities in Oracle Performance area to achieve organizational growth.
- helped client to improve their oracle customizations having more than 150+ programs performance over 85% .
- Defined overall PE process / guidelines/ approach / PE checklist
- Mentoring to teams on Oracle Performance techniques & advance features.
- proving assistance to development team on how to write effective code to avoid any performance issues.
- guided business proactively on how to improve scalability of any oracle based program/ database/appln in design , development and on live environment.
following Oracle Performance techniques have been used for these projects :
- Oracle SQL Tuning
- Oracle Optimizer, statistics , Cost based optimizer
- Indexes , selectivity , full table scan, cardinality, costs
- Access path , Join orders , Join methods
- EXIST operator, set based operators
- SQL Plan management , SQL Profiles on Oracle upgrade projects
- TKPROF, Trace, ADDM , SQL Tuning Advisor, Explain plan
- All wait events, consistence reads, physical reads, response time,
- SQL Parsing, execute, fetch operations
- Function result cache, Pipeline functions
- Materialized views, Global Temporary tables, With Clause
- Bulk collect with limit , For All to avoid context switches
- Analysis of explain plan , Row source operations
- Histograms (frequency & height balance) ,
- Oracle Hints, Oracle pl/sql best practices
- Business Requirement Tuning, Design , Integration
- reduce work load on OLTP/ operational database.
- Other performance improvement techniques like purging / archiving / change frequency timing, usage of reporting database.