Highly experienced Oracle professional with expertise in following areas: SQL - 20+ years PL/SQL - 20+ years Forms/Reports - 20+ years Designer - 15+ years Analyse, Design, Build and implement complex business applications Oracle eBS techno/functional consultant, experienced ( 6+ years ) in GL, AR, AP, AX, CE, INV R11, R12
oracle performance tuning Job Cost Overview
Typical total cost of oDesk oracle performance tuning projects based on completed and fixed-price jobs.
oDesk oracle performance tuning Jobs Completed Quarterly
On average, 4 oracle performance tuning projects are completed every quarter on oDesk.
Time to Complete oDesk oracle performance tuning Jobs
Time needed to complete a oracle performance tuning project on oDesk.
Average oracle performance tuning Freelancer Feedback Score
oracle performance tuning oDesk freelancers typically receive a client rating of 4.98.
Hi, I'm Ashu, a Oracle Consultant based in India mostly working on Oracle APPS (Ebusiness Suite), PLSQL, unix, APEX in an agile manner. Several applications that I architected, implemented and maintain are in active production use. I have overall 7+ years of experience and have worked around the world.
Talented and accomplished Oracle Professional with proven ability to successfully implement multiple projects for RAC enabling EBS and Peoplesoft applications. Experience with multi platform High Availability Solutions and complex multiple-node RAC 11g, 10g, and 9i implementations on Linux, Solaris, and HP. Hien has experience in deploying disaster recovery solutions with standby databases compliant to Oracle MAA. Hien has been engaged to perform end to end performance tuning, architected High Availability and Disaster Recovery solutions. Hien has provided professional services to many US Federal Government Department including Department of State, Department of Energy and Department of Defense, Manufacturing, in addition to Health Care and Social Media firms. Hien has in-depth knowledge of Oracle Applications technology stacks, including architecture, installation, configuration, maintenance, cloning and patching procedures.
Over the last 8 years, I have developed and designed a wide range of database applications at enterprise level. My greatest strength is performance tuning back-end applications by optimizing the processes by redesigning and rewriting. I have extensive experience in writing OLTP batch processes and datawarehouse applications. Highly experienced in developing ETL processes using unix shell scripting and Oracle PL/SQL. I also have worked with Informatica, Microsoft SSIS and SSRS reports.
7+ years exp in Oracle Applications (11i & R12) in the modules like, OM , INV, AP, AR GL, SC, IB. Industry Exp: 1) Manufacturing 2) Telecommunication 3) Distribution and Sales 4) Softwares Technical Expertise in 1) Advanced PLSQL, PLSQL 2) SQL 3) Unix Shell Scripting 4) OAF 5) SOA 6) Oracle Reports 7) XML Publisher Reports I like Writing Complicated queries , Providing Approach and Solutions to business strategies involving Oracle Applications.
SUMMARY OF QUALIFICATIONS: • Over all SEVENTEEN years of total experience as an Oracle professional on various H/W with UNIX & Windows platform. • Over NINE years of experience as Oracle Apps DBA R12.2/R12.1/11.5.10/11.5.9/11.5.8/11.5.7/11.5.5/11.0.3/10.7 on Sun Solaris, HP-UX, AIX, Linux Servers. • Over SEVENTEEN years of experience as Core DBA on Sun Solaris, HP-UX, AIX, Linux Servers &Windows platform. • As Oracle Apps DBA an excellent record in delivering results to users. Blend the ability to conceptualize a range of innovative technical solution to complex business problems, with the responsibility of delivering concrete programmatic, reliable systems that work for end users. • Experience in Installation 12.2/12.1/11.5.10/11.5.9/11.5.8/11.5.7 Sun Solaris, HPUX and Linux. • Experience in implementation of Oracle E-Business Suite R12, 188.8.131.52, 11.5.9 on HP-UX and Sun Solaris and Linux with complete lifecycle using AIM Methodology. • Handled independently the upgrade project of Oracle Apps 11.0.3 and 11.5.7 to 11.5.9 and 184.108.40.206 right from project initiation to go-live with conversion of single-Organization to Multi-Organization. • Experience in Oracle Applications Patching, APPSADMIN (Ad utilities) and SYSADMIN on various UNIX platforms. • Experience in Cloning using Adclone, Rapidclone and Adconfig. • Having good understanding of RAC & Clustering technologies on Multi-Node with Parallel Concurrent Processing PCP and Load Balancing LB of Oracle Application. • Troubleshooting Oracle Apps Concurrent Manager, Forms and Reports related issues with Performance Tuning of Oracle Server and Applications. • Experience in performing Backup & Recovery using various backup tools like Veritas Netbackup with RMAN integration, LEGATO, OMNI Backup. • Experience on MongoDB key concepts and installation, Creating, reading and updating data CRUD, query conditionals and Aggregation Framework, configuring and monitoring replica sets, optimizing monitoring and understanding MMS, sharding setup sharding monitoring shard key selection inserting large amounts of data, Security & backups and restoring of Mongo Database. • Experience in the development of client-specific solutions, including technical design of servers and determining server sizing requirements. • Understanding of High Availability and Disaster Recovery requirements and solutions. • Experience in Evaluating, monitoring and managing the Oracle database, Oracle application server and application performance. • Experience in Apache, Forms, Reports Server administration. • Experience in Production Support of Oracle database 220.127.116.11 and 18.104.22.168 with upgrade of 22.214.171.124 to 126.96.36.199. • Experience in using monitoring tools like HP-Open View, FogLight, SpotLight, OEM, TOAD • Oracle 9I Certified Associate. TECHNICAL SKILLS: Oracle E-Business Suite: Oracle Apps 188.8.131.52/11.5.9/11.5.8/11.5.7/11.5.5/11.0.3/10.7. Operating Systems: Windows NT 4.0/2000, Sun Solaris 7.0/8.0/9.0, Linux 3.0 Server, HP-UX 10.20/11.11i, Compaq True 64, SCO Open 5.0, SCO UNIX 3.2.4, UNIX 3.1, Windows 95/98 and OS/400. RDBMS: Oracle 9.0/9.2 under Sun Solaris, HPUX, Linux and Windows, Oracle 184.108.40.206 under Sun Solaris, HPUX, Windows, Oracle 7.3 under Sco Open 5.0, Oracle 7.3 under HP-UX 10.20, Oracle 7.0 & 6.0 under SCO UNIX (SQL*DBA, Server Manager, SQL*Plus, PL/SQL, Imp/Exp, SQL*Loader, OEM), MS SQL Server 7.0 and MYSQL (Overview), DB2/400 on AS/400 UNIFY under UNIX 3.1. Front End Tools: Oracle Developer/2000 (Form 5.0 & Report 3.0), SQL*Form 3.0, Pro*C, SQL*ReportWriter, SQL*Menu, Visual Basic 6.0. Programming Languages: C/C++, COBOL (DOS/UNIX), TURBO PASCAL 7.0, FORTRAN 77, CL/400, RPG/400, PL/SQL.
Experience of 9+ years in ORACLE Development with PMP/ITIL/OCA/OCP Certification Key Skills: - Oracle 9i/10g PL/SQL, D2k, Unix,Spotfire Languages Oracle Forms, Oracle SQL & PL/SQL, Reports, BIRT report Databases Oracle 9i,10g,11g Tools Oracle Developer Suite SQL * Plus SQL* Loader Peregrine 5.1.4(Kite) Form 9i, 10g Report Builder 9i, 10g Quality Centre • Having comprehensive knowledge of Software Development Life Cycle (SDLC), software engineering processes and backbone processes for Software Development and implementation. • Project engagements ranges from requirement gathering to analysis, analysis to design and design to development.
Having good experience in which Information Technologies industries on Database, Data warehousing Reporting Tools developing Business Intelligence Oracle Applications. With strong knowledge in SDLC such as Developing, Coding, Testing Strong knowledge in SQL, PL/SQL queries analysis developed Well-built knowledge on Package, Procedure, Function, Database Objects Having excellent quality of adapting of latest technology with analytical, logical and innovative knowledge to provide solutions. Sound knowledge on OOP’s concepts functionalities and methods. Strong ability to understand project life cycle development issues and an ability to quickly understand business requirements Proficient knowledge on Data warehousing concepts, techniques, Web Intelligence Reports Having knowledge on designed and developed a series of Business Intelligence solutions using Business Objects Tools.
• 4+ years of experience on Oracle Database Administration, PL/SQL Programmer and Developing application including Lead DBA. • Proficient in Installing, configuring, managing and supporting (24X7) Oracle 11g/10g/9i production, QA/staging and development databases in different type of operation systems such as Linux, Sun Solaris, UNIX and Windows. • Very Well and in-depth knowledge on wait events, Performance tuning, Time Module, Trace File, Index analysis, SQL & PL/SQL Execution Elapsed Time, Identify Problem SQL Statement, Query Execution Plan, Using SQL Performance Analyzer, SQL Hints, SGA, AWR, ASH, tkprof, ADDM, Baseline, Shared Pool tuning, statspack, Enterprise Manager and v$ dynamic performance views. • Very much proficient in tuning SQL queries, SQL Optimization, PL/SQL Codes, PL/SQL Optimization and using explain plan. • Expertise in Shell Scripting, analytical sql, designing index strategy, parallel query operation, optimization technique, hints and regular expression. • Experience on capacity planning at storage and resource management. • Experience with Oracle 10g/11g Real Application Clusters (RAC), Load Balancing and Dataguard. • Experience on Oracle Flashback Technology. • Experience on oracle DB Cloning, Upgrading, Patching, partitioning, migration and replication using oracle CDC, streams, advanced replication, materialized view and GoldenGate. • Extensive Experience on (RMAN). • Very Deep Knowledge on Oracle APEX, Forms & Reports 6i/10g/11g, Oracle Weblogic 11g, Fusion middleware 11g . • Have Experience on Data Modeling. • Experienced with all phases of Software Development Life Cycle. • Experience with Image Processing (.img file to .tiff), XML file generation & extraction. • Experienced with General Banking System. • Having advanced knowledge of Oracle 10g/11g technical database concepts such as: logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques.