I am an experienced Oracle DBA/developer. I've been working in jobs related with Oracle Database since 2002. I've been focused around managing Oracle DB, troubleshooting Oracle performance, tuning Oracle instance, relational database design and development and tuning of SQL and PL/SQL to improve performance. Also SQLServer, MySQL and MongoDB Knowledge. You can check my linkedin full profile at: http://es.linkedin.com/in/joaquingonzalezcarrasco/en You can check my pl/sql & database design knowledge at: http://plsqlchallenge.com/pls/apex/f?p=10000:PROFILE:0::NO::P1051_USER_ID:5537: Currently ranked 42th among 10.000 players all over the world, playing daily quizzes about PL/SQL since 2010. Currently ranked 4th among 500 players over the world, playing weekly quizzes about Database Design since 2013. I'm currently available only for part time jobs.
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.
SUMMARY: • Over 4 years of experience in system analysis and software development based on Oracle products and technologies • Designing and developing database structure (OLTP systems, data warehouses) • SQL performance tuning. • Development of stored procedures/functions/triggers/packages/etc.(PL/SQL). • Analyzing and working out solutions for business objectives. • Administrating and maintaining Oracle database. • Working with Oracle EBS (creating and implementing Oracle Forms,Concurrent Programs etc.) – since November, 2013 TECHNICAL BACKGROUND Programming languages: PL/SQL, SQL DBMS: Oracle(9i-11g) IDEs: PL/SQL Developer, Toad, SQL Developer Requirements Development and Management tools: ERWin, Balsamic Mockups, SVN, Bugzilla Text and spreadsheet processors: Microsoft Office (Word, Excel, Power Point) Operating systems: Windows (expert user), Linux(novice)
5 years application development experience focus on web application and website build. like coding with PHP and Python language. familiar business knowledge about finance and telecommunication industry. more that 10 years Oracle database administration and performance tuning experience in finance industry and telecommunication industry with very Large Database and 7x24 huge DB. have 3 years work experience in oracle china delivery team.
I am a Oracle DBA with 5 years of experience. I have administer databases with different requirements and have experience in dealing with developers, system and network administrators and customers. My core competency lies in complete end-end management of a databases. I have experience in: - Installing, updating and patching database - Using imp/exp and data pump utilities - SQL tuning - Backup and restore planing using rman, cold backups and dumps - Writing scripts to automate work (Batch files and Shell scripts) - Setup RAC and standby systems - Monitoring and tuning of databases - Build heterogeneous systems with other databases (MySQL, MSSQL, Excel etc.) - Loading data from flat files and other sources - Make trace files and analyze it Work with both Windows and Linux operation systems.
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.
An Oracle professional with experience acquired during a wide range of projects in Banking, Insurance, Retail and Geodesy industries; Eight years of experience in analysis, design and implementation of IT solutions based on Oracle technologies and products: Oracle RDBMS 11g/10g/9i, SQL, PL/SQL, Oracle Forms/Reports, BI Publisher, E-Business Suite 11i, FlexCube 10, Oracle Retail; A solid background in the database and application performance tuning, database architecture design and solutions for data warehousing and ETL processes; Extensive experience in delivering comprehensive solutions for business – beginning with analysis and design through application programming and finishing with end-user trainings; A good learner, well-organized and committed enthusiast of Oracle technologies, particularly interested in ETL processes, data warehousing and business intelligence; Job type: Contract Contact: firstname.lastname@example.org LinkedIn: https://www.linkedin.com/in/marcinrydzoracleprofessional Certificates: Oracle Database SQL Certified Expert Oracle PL/SQL Developer Certified Professional Oracle Database 11g Administrator Certified Professional Specialties: • Oracle SQL, analytical SQL, PL/SQL, BI Publisher, Oracle Forms/Reports, Oracle XML, Oracle APEX • Oracle Data Warehousing, OLAP, ETL, Business Intelligence • Oracle RDBMS 9i/10g/11g administration, performance tuning, SQL and PL/SQL tuning • Oracle e-Business Suite 11i/R12 customizations: AP, AR, FA, PO, GL, OM • Oracle Customer Care & Billing • Oracle FlexCube Core and Direct Banking: CASA, IC, PC, FT, CL, EOC • UML, Enterprise Architect, Agile, JIRA, Mercury Quality Center, Mantis • SQL Developer, PL/SQL Developer, TOAD, SVN, CVS • Linux(Red Hat, OEL), Windows, Unix(Aix, Solaris)
Rade Pobulić Agency Contractor
A leading regional Oracle expert since 1987. Top system and solution architect. Highest level of SQL, PL/SQL, database design, performance tuning and BI Publisher skills. Good in XML (XQuery, XPath, XSLT) knowledge. Good in Oracle Apex, Oracle Forms. Good in Oracle EBS (EAM, Financials, Inventory, Purchasing, Order Management, HRMS, Service Contracts, Workflow), excellent customization skills. Basic Oracle BI, Endeca, BPM, Primavera, Fusion CRM skills.
Around Five years of experience in the IT industry. Expertise in Oracle Performance Consultant, Unix Shell scripting, SQL,PL/SQL development. In depth knowledge of of Oracle Architecture. Expertise in performance tuning of Oracle databases, applications and SQL's. Proven knowledge of data management and architecture techniques. Demonstrated indepth experience in database tuning, oracle performance optimisation. Expertise in production support, data analyst in BFS domain. Strong sql skills. Expert in database programming skills. Good analytical ability, conceptual thinking, planning and organisational skills. Demonstrates expert knowledge and understanding of AML Process, Sanction process and life-cycle of compliance systems and related technology.
IT professional with 11+ years of experience in Oracle DBA, PL/SQL, DB Architect and 3+ years of experience in DB2 in Mainframe environment. Worked on Banking domain for clients CITI-NAIT, Bank of America and Santander Banco. Worked on fully secured production and standby database by implementing Data Guard. Worked extensively on database upgrade and patch update. Extensively worked on SQL*Loader for large data load using direct path and parallel loading. Worked on Database Performance tuning and Oracle Enterprise Manager. Experience in designing, implementing backup and recovery strategies using RMAN and conventional methods Experience in writing SQL and PLSQL scripts like Stored Procedures, Functions, Packages, and Handling Exceptions, creating database triggers in Oracle 10/11G. Efficient in SQL query optimization using explain plan, TKPROF, reports, gathering statistics, pinning the objects, running scripts.
I am a professional software developer with more than 15 years experience in IT. I have developed a wide range of software using Oracle technologies: SQL, PL/SQL, Forms, Reports, XML Publisher, Oracle E-Business Suite R11, R12, sqlloader, OCI I also have experience in the following areas: Delphi, C, C#, .NET, MSSQL, MySQL, XML, XSL