Pods People Ltd - Perfect People for Perfect Placement

Candidate reference – Can -10079
Curriculum Vitae

PROFILE

Professional Summary

Nicolas is an IT professional with sixteen years experience of database administration, application development, consultancy and support. He has specialised in Relational Databases and has a vast amount of Oracle DBA experience, including RAC, Backup & Recovery (including RMAN), Performance tuning, Partitioning and Standby Databases.

His development expertise being with Visual Basic, PL/SQL, C++ and Pro*C. He has proven technical skills, gained over 16 years, as an Oracle Database Administrator covering Oracle versions 6 through 10g, and on O/S platforms Sun Solaris, HP/UX, IBM AIX and NT; and has proven experience in many areas such as consultancy, development, installation, technical implementation, RAC, maintenance, backup, performance tuning, data warehousing and Unix shell scripting.

Oracle 10G, 10G RAC, 10G Application Server, RMAN, PL/SQL, logical standby, Sun Solaris, AIX, VERITAS SFRAC, EMC SRDF is the most recent environment he has worked in.

Key Skill Areas (Technical)

ORACLE DBA (up to 10g), RAC (9i & 10g), ORACLE 10g Application Server, SQL, PL/SQL, Visual Basic, C++, Pro*C, ASP, Sybase DBA, MS SQL, Transact SQL, UNIX administration and shell scripting, HTML, XML and Java.

Education/Qualification/Training

BSc (Hons) 2:2 in Computing at University of Westminster

Oracle Database Administration (1993)
Unix Scripting (1994)
Oracle Pro*C (1995)
Oracle PL/SQL (1996)
C++ for C Programmers (1997)
Performance Measurement (1998)
Investment Management Certificate (2000-2001)
Introduction to Risk Management (2001)

PROJECT DETAIL

June 2004 – August 2008 Royal Bank of Scotland
Consultant DBA

• Initially part of the 24 Support team for the Group Mortgage Capability project. This was a high profile and very large project. I was heavily involved in Support, problem resolution (including formulating and applying solutions to problems with the XML development kit and advanced queuing), productionisation of new technologies, backups and recovery (RMAN), performance tuning, application (SUMMIT) upgrades.
• After the GMS project I was retained by RBS and joined the Technical Development Lead team within the Oracle Projects team. This team was responsible for reviewing design documents of the numerous projects using Oracle to ensure that bank and team standards were being followed. In addition the team was responsible for productionising new technologies for the purpose of allowing other projects to use the new technologies. I was solely responsible for the productionisation, and introduction of Oracle 9i and 9i RAC to the bank.
• I was the (Oracle) technical lead of the Oracle High Availability for Core Web Security project, which was responsible for productionising (introducing and standardizing) Oracle 9i and 9i RAC (i.e. this was the first project within the bank to be migrated to Oracle 9i and 9i RAC). The Core Web Security system secures Internet and Intranet applications within the bank.
• I have over 3 years experience with 9i and 10g RAC and have a thorough understanding of TAF, load balancing, lock management, VIPs, VERITAS DBE and Clusterware amongst other attributes of RAC.
• Other projects worked on were Group Datawarehouse and Corporate Electronic Sales and Delivery.
• In August 2006 (after a short break) I re-joined Royal Bank of Scotland in the Production Support team as a member of the Oracle 10g Migration Programme which had a remit to upgrade the production databases to Oracle 10.2. As part of this programme I worked on the projects to introduce and install 10g RAC and 10g Application Server to the bank. I migrated the bank’s Reconciliation system and Image Signature Verification system to the 10g RAC Cluster.
• Design and deployment of Oracle 10g RAC to the bank. The design uses Oracle 10g RAC and Veritas SFRAC 4.1 on Solaris 10 clustered domains.
• Technical lead on the Oracle 10g Application Server project which designed and deployed 10g Application server in the bank for the first time, all Forms and reports applications are being migrated onto the Application server.
• Upgrades of the bank’s Fraud Profiling, Reconciliation, Coutts Optics, Image Signature Verification and Serious Fraud Detection systems to Oracle 10.2.

April 2003 – December 2003 Greenland International Ltd
Consultant DBA

 Development and database administration for company providing response services to many well-known clients and organisations.
 Responsible for the migration of the database platform from DB2 to Oracle 9i
 Development of database administration guidelines and procedures written in PL/SQL.
 Development in Visual Basic and C development, for web based work.
 Visual Basic .NET development.

September 1998 – March 2003 Strategic Asset Management Solutions Limited
Senior Technical Consultant & DBA Team Leader

 I was employed as a technical consultant (primarily for my Oracle DBA & PL/SQL expertise) by a software house providing technical solutions to the Investment Management industry. The application was named Socrates. Software modules included Portfolio Reporting, Performance Measurement (GIPS Compliant), Composites and Attribution. OS and Database platforms were supported including Unix
 Developed the installation procedures and was solely responsible for most client installations and technical implementations (including Scottish Widows, Capital, Allianz, Barings and Abbey). Technical lead for those implementations.
 On-site and remote support for clients.
 Capacity planning, analysis and design, development of bespoke work for clients.
 Extensive PL/SQL development and coding, modules included Portfolio Reporting, Performance Measurement and Attribution. Development of PL/SQL programming standards and guidelines.
 Development of the Socrates Daemons (NT Services written in C++ and Pro*C)
 Development and maintenance of the company’s intranet using ASP.
 Fixed term assignment as team leader of database administration team. Database administration for clients and SAMS including: - database and SQL tuning, business processing logic, PL/SQL code tuning, backup & recovery strategies, use of Enterprise Manager, Parallel Server, Data Warehousing.
 Responsibility for the migration of database platform from Oracle 7.3.4. through Oracle 9i

March 1998 - August 1998
Raindrop Information Systems – Technical Consultant

 Development of property management application using Visual Basic and PL/SQL. Database platform was Oracle 7.3.4.
 Analysis & development of Interest on Arrears, Rent Review and Debt Recovery modules.
 Responsibility for all production and development database administration. Database design and creation, backup & recovery, database and SQL performance tuning, Enterprise Manager, technical issue resolution.

April 1996 - January 1998
Ionica Telecommunications Plc – Technical Consultant

 Design & development of the Incident Handling System (IHS) Escalation and Notification Engines, written in C++, Oracle Pro*C and PL/SQL.
 Database Administration for the Systems Development Department (Oracle 7.3 and PL/SQL)
 Enhancements to the Service Management System, Client Management Application and Tariff Management Application (using PL/SQL packages and Triggers)
 Unix and SQL scripting for Outage identification module.

March 1995 - April 1996
Ernst & Young – Senior Analyst Programmer & DBA

 Development and maintenance of the firm’s HR system called EYSIS.
 Development of ad-hoc query tool using Visual Basic of large Reports using Oracle Pro*C.
 Production and development Database Administration using Oracle versions 6 and 7.
 Development and implementation of new modules including London Reorganisation and Maternity.
 Unix and SQL scripting.

October 1993 - March 1995
Walkers Financial Solutions (WFSL) – Analyst Programmer & DBA

 Core product development for APTOS (suite of accounting modules) on UNIFACE 4GL, using a Unix/Client server environment.
 Senior developer of the Sales Invoicing, Sales Order Processing and Enquiry modules.
 From the period Jun-94 to Oct-94, senior development on bespoke project for the Ionica Telecommunications Company (later employed directly by Ionica as a contractor).

July 1992 - October 1993
Digital Processing Transcription Services (DPTS) – Analyst Programmer & DBA

 Development of a number of applications for the Oil sector using Uniface 4GL (versions 4 & 5) including LogPrep and LogSort (which digitized and sorted historical data).
 Systems and Database Administration on the various VAXs (running VMS and Ultrix). The database platform was Oracle version 6.
 Sole responsibility for all DBA tasks including design, creation, performance tuning and backups.

Submit Job