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)
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.
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.
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)
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.
Having 3 years of experience as Oracle DBA in 10g &11g. Currently working as a Database Administrator in Exa InfoTech Pvt Ltd Gurgaon from June 2012 to current. Worked as Oracle Database Administrator in Microcell System Pvt. Ltd, Noida from June 2011 to May 2012. Oracle Database Design both physical and logical. Installation and up gradation of Oracle database 9i/10g & 11g on Linux and Windows NT Platforms Experience in Oracle database upgradation from 9i to 10g. Good Knowledge on Physical Standby Database. Backup and Recovery strategies through RMAN. Created and maintained different database entities included table spaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers. Cloning of Databases as and when required Designing and Coding of Triggers/Procedures/Functions/Packages using Sql, Pl / Sql. Managing database security. Creating and assigning appropriate roles and privileges to users depending on the client requirement. Good in Performance Tuning. Knowledge of setting up an Oracle Enterprise Manager for basic administration of database check database health checkup Database health monitoring using trace files and alert.log Planning and Performing Daily, Weekly and monthly Offline and Online Backups to avoid any data loss. Moving data between Database using oracle utilities like Export/Import and Transportable Table space. Oracle network Administration by configuring tnsnames.ora, listener.ora. Applied database patches using Opatch utility. Analyzing STATISTICS and monitoring the system performance and tune accordingly with the help of AWR. Working Knowledge of ERP module like production, Payroll, Sales etc. Technical Qualifications B.Tech in Computer Science from KIIT College of Engineering Technology Certification Course in Linux from HCL . Language : Sql, Pl/Sql Operating System : Windows Servers, DOS, Red Hat Linux, Unix. Databases : Oracle 9i/10g & 11g. Tools : Toad 9.0/ 9.5, Expdp, Impdp, Sqlldr, Putty, OEM, AWR, RMAN, NETCA, DBCA.
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.
-- Creating and Maintaining Oracle Database -- Performance Tuning and Health Monitoring -- Backup/Restore using RMAN -- Expertise in Oracle Import/Export and Data Pump -- Writing scripts to automate work (Batch files and Shell scripts) -- Oracle Upgrade and patching -- Good experience in SQL Server 2005/2008/2012 Management -- Good experience in MySQL database Administration -- Knowledge of SSIS,SSRS -- Good experience in database migration (Oracle, MSSQL, MySQL) -- Good experience in Configuration of Amazon Ec2 instances, Amazon RDS and Amazon S3 along with Amazon Cloud Watch. -- Successfully completed 3 Implementation Project of Amazon AWS and Database Migration from Company Hosted Server to Amazon RDS -- Experience in Cross DBMS Migration(i.e Migration of Oracle to Sql Server etc) -- Good knowledge of data modelling -- Knowledge of Mongodb administration