Printer friendly ]Freelance Senior Oracle Technical Consultant and Team Leader Congleton, Cheshire, UK
14 Years experience in various industries working as an Oracle Specialist with Oracle 10g, Forms, Reports, PL/SQL, Unix Programming, ETL techniques, Datawarehousing, Performance Tuning, SQL.
| Rating: | Unrated (New) |
| Hourly Rate / Cost: | £44.44 per hour |
| Daily Rate / Cost: | £355.56 per day |
| Available From: | Now |
| Seller ID: | 244736 |
[ 
Top | Ratings | 
CV | 
Skills ]
CV (Curriculum Vitae) / Résumé
PL/SQL Development from Oracle 8 - Oracle 10G databases
Forms/Reports 9i
Unix (Solaris, AIX, HP-UX) shell programming
SQL*Loader, External Tables
Data Migration
High Performance Tuning Specialization (Can make SQL run atleast 20% faster)
C, C++, C# programming
Database Administration and Database Monitoring
Employment History
(Apr 2006 to Sep 2006)
Senior Oracle Technical Consultant and Team Leader
Holmes ChapelAstron provides one of Europe’s leading and most comprehensive Integrated Document Outsourcing solutions.
My role involved using ETL techniques to extract data from an OLTP database and transform and transport onto another OLAP server with a staging area and load the transformed data into the OLAP (Datawarehouse) database. Used SQL Analytical functions, Partitioning, Table Functions, External Tables, SQL*Loader, and UNIX shell scripts.
(May 2005 to Mar 2006)
Senior Oracle Developer
ManchesterWorked as a Senior Oracle Developer on Oracle 10G. I was involved in integrating the ShopDirect system with Littlewoods System from designing, development and testing stages including System Integration testing.
I Used XML, Partitioning, Materialized views, pipelined functions, Parallel Processing, Bulk Processing and UNIX shell scripting. Developed some Java Applets and Java Server Pages to enable users to access data using JDBC.
(Oct 2004 to May 2005)
Senior Oracle Developer
FWL Technologies , LiverpoolWorked as a Senior Oracle Developer, developing various front end screens in Forms 6i/9i (migrating) and creating reports in Reports 6i/9i. Various technologies used are Oracle Database Server 9.2.0.3.0, Forms, Reports, PL/SQL, Toad, Unix. Used Java in J2EE environment to create Java Applets and design front end screens and create customized API’s to access data from the J2EE front end using JDBC.
(Apr 2004 to Oct 2004)
Senior Developer
Singlepoint Solutions Ltd (Part of Vodafone) , Stoke On TrentWorked as a Senior Developer, developing interfaces and supporting various applications.
Technologies used are Oracle Database Server 8i, PL/SQL, PRO*C, C, AIX, Crystal Reports, Toad, Geneva Billing System, Siebel Tools, Windows NT.
(Jun 2001 to Apr 2004)
Team Leader/Senior Oracle Developer/Database Administrator
Control Force Ltd , Congleton, CheshireWorked as a Team Leader/Senior Oracle Developer/Database Administrator, Leading/Developing and supporting various Mobile Application Technologies for various Clients.
Also involved in Migrating Oracle Projects from Windows NT to Solaris environments and from Forms 6i to Forms 9i.
Environments: Windows NT, Solaris, Oracle 8i (8.1.7) Server, Oracle 9i, Forms 9i, Forms 6i, Reports 6i, PL/SQL 8.1
Professional Qualifications
Bachelor’s Degree.
Post Graduate Diploma in Computer Applications
Skill Summary
• 14 Years of IT experience in application development and designing.
• High Performance Tuning Specialisation.
• 13 Years of Oracle development.
• 2 Years of experience of Oracle 10G R2 database development with features including External Tables.
• 4 years of Oracle 9i, Oracle 9i Application Server, Web Forms 9i including Migrating from previous versions, Web Reports 9i experience.
• 6 Years of Oracle 8i (8.1.7) and 4 Years of Web Based Forms 6i, Reports 6i.
• 8 Years of Unix Shell Programming on AIX, Sun Solaris, SCO UNIX, HP-UX
• Very good experience of PRO*C
• 4 Years of experience in Oracle Database Administration on Windows NT and Solaris Platforms with skills including Backups (Hot & Cold) and Recovery and also involved in Various Migration Projects.
• Understanding of Application Express (HTML DB) 2.0
• Basic understanding of XML
• Exceptionally good in Migrating Oracle Projects between Operating Systems.
• Very good experience in Oracle Utilities – SQL*Loader, Export and Import
• Unified Modelling Language (UML).
• 6 Months experience in creating Java applets, JSP’s. Used JDBC as the database connectivity.
• Good experience of Data warehousing with Star Schema and ETL techniques.
• Understanding of Business Objects.
• Crystal Reports.
• Familiar with .NET Framework, JavaScript, MS Access.
• Understanding of Oracle Discoverer.
• Knowledge of Siebel CRM (Siebel Tools and Siebel Communications) including table mappings etc,.
• Knowledge of Geneva Billing System and API’s
• 3+ Years Team Leading experience
• Ability to lead Geographically placed teams.
• Good Communication skills and excellent team player.
Industries Worked: Banking, Telecommunications, Logistics, Utilities, Retail, Mobile, Printing
Oracle Development Skills (Oracle 8i/9i):
• Forms 10g, Forms 9i/6i, Reports 9i/6i, PL/SQL, PRO*C, SQL
• High Performance Tuning & Optimization
1. SQL Tuning 2. PL/SQL Tuning 3. Use of Explain Plan, TKPROF etc.
• Extract, Load & Transform techniques (ETL techniques).
• SQL*Loader
• Migration of Finished products between Operating Systems.
Database Administration Skills (Oracle 8i/9i):
• Hot Backups & Cold Backups
• Use of ntbackup on Windows platforms
• Use of tar, cpio, dump on Unix platforms
• Export & Import techniques
• Media Recovery
• High Performance Tuning & Optimization
1. Tuning I/O 2. Tuning SGA 3.Tuning Initialization Parameters
• Installation of 8i & 9i Database Servers.
• Patch Installations and Upgrades.
• Enterprise Manager.
• Data Migration.
Unix Skills: (SOLARIS, SCO-UNIX, HP-UX)
Shell Scripting (Korn Shell) and AWK Programming
Assignment History
(This Seller has recently been shortlisted or contracted for the following people4 assignments)
- Sun engineer require3d for a memory upgrade on a Sun system V240.
- Sun engineer required for a memory upgrade on a Sun system V240 and a V440.
Freelancers, Contractors & Consultants that have been shortlisted with this Seller:
- Seller 249304, Stevenage, Hertforshire, UK [£33.33 per hr]
23 years I.T. experience with 17 years solid ORACLE : Oracle DBA experience : Oracle 10gR2,Oracle 9i Development : in depth Forms , Reports, Discoverer, Oracle 10g , 9i and 8i , ETL,OWB
- Seller 274083, Watford, Hertfordshire, UK [£61.11 per hr]
I have over ten years experience in Developing/supporting Oracle based Systems. My clients have ranged from Blue chip companies to startup businesses. Whatever solution you require, I'll deliver.
- Seller 294409, Croydon, Surrey, UK [£25.56 per hr]
I am an experienced Oracle professional with 5 years of exp in Oracle,Forms,Reports,VB6,Sql Sever 2000 development and testing.
[ Top | Ratings | CV | Skills ]
Categories & Freelance Skills
IT & Internet
Categories
Skills
- 10G (Database Development & Admin - Oracle)
- 9i Application Server (Database Development & Admin - Oracle)
- 9i Database Enterprise (Database Development & Admin - Oracle)
- 9i Database Standard (Database Development & Admin - Oracle)
- 9i Developer Suite (Database Development & Admin - Oracle)
- Application Server 10G (Database Development & Admin - Oracle)
- Crystal Reports (Reporting & Analysis)
- Data Architecture (Database Development & Admin)
- Data Warehouse (Database Development & Admin)
- Oracle (Database Development & Admin)
More Sellers...