I am a strong leader, who manages, develops and motivates my team. Dynamic, self motivated with exposure to a wide range of technologies highly specialising in design / support of database systems and management systems. Proven experience in management of IT projects across various sectors from financial institutions to the resource domain. Coupled with a willingness to work hard and advice whether to my team, application developers, management or to end-users.
Main Skills 10 yrs Sybase DBA 10 -- 15 8 yrs Microsoft SQL Server 6.5 -- 2000 5 yrs Data Warehousing 9 yrs T-SQL / SQL / Stored Procedures 5 yrs DTS 4 yrs AIX / SOLARIS Support 8 yrs Shell Scripting 8 yrs NT / 2000 / 2003 3rd line support 4 yrs Project Management 5 yrs System Manager 6 yrs Report Writing / designing 7 yrs Server Tuning Backup and Recovery Disaster Fallback planning Capacity planning Database modelling Support procedural documentation writing Installation documentation writing SLA creation
Employment History
UBS Investment Bank Head Office Zurich Oct 2005 to Present Database Development Manager
I am currently working as the Development manager within the FX trading arena. I develop database solutions on Sybase and Oracle predominately for cash, options trading. I do also manage credit checking databases as well as a number of reporting sites run via database back ends.
• Project manager of all Sybase and Oracle products from specification through to production release • Co-ordination with different groups / business or application front end developers to implement deliverables • Experience in managing aggressive development cycles • Assist group members to provide support and advice • 24 hour Database Production support o Analysis / diagnosis of critical trade system issues • Sybase Support of versions 12.5 to 15 • Database administration • Database design, tables, indexes, Stored procedure etc • Advise on database design and functions • UNIX Shell scripting • Perl Scripting • Data extracts via stored procedures and UNIX scripts • DBCC checking automated and checked via UNIX scripts • Performance / tuning of Sybase procedures / databases objects • Understand business logic and strive for efficient technical and practical solutions • Complete tasks as assigned by management • Perform back-up duties as assigned by management • Out of hours support • Ability to work in a fast moving environment • Implement Sybase database objects and functions into replicated database environments
OMRON Europe B.V. Based -- Netherlands May 2005 to Oct 2005 SENIOR SQL SERVER DBA
• Responsible for professionalising the European wide SQL environment • Database level • Indexes / structure / stored procedures etc • Administration / support • Server installations • System, installation, maintenance documentation • Testing • Reporting on necessary Hardware requirement • Upgrading and consolidation of distributed SQL Servers • Liaison between European Operations and European DWH teams • Creation of Replication models for hot spare databases • Creation of disaster recovery procedures for European mission critical systems • Creation of Backup / Maintenance plans schedules using SQL Agents and DTS packages • SQL writing for reporting purposes / analysis • Support of Windows 2000 / 2003 • Tuning of SQL Servers, OS 2000 /2003 • Performance monitoring • Client Connectivity to database platforms • Extraction of data for migration from JDE into SQL Server 2000 • Data transformation via DTS packages from Lotus Notes into SQL Server 2000 Responsible for professionalising the SQL environment throughout Europe, the continued maintenance of databases in development, test and production and the establishment of policies and procedures with regards to the management, security and maintenance of the database management system. Databases range from 100mb to over 100GB.
IFF -- Netherlands May 2001 to May 2005 PROJECT MANAGER / SENIOR SYBASE / SQL SERVER / DBA / DEVELOPER
• Project Manager / Business Analyst for all data related projects across Europe • DBA Manager responsible for 10 European countries running of Sybase 10 -- 12.5 and Microsoft SQL Server 2000 24 x 7 • Responsible for Sybase Replication within Europe and between USA • Missed replicated transactions could lead to millions of revenue lost, or incorrect reporting on the hazardous chemicals that were used within the factories • Support and development of Unix scripting for Sybase batch processing / jobs • AIX / Solaris / NT / Windows 2000 support • Business / technical analysis for the generation of new business reports • Database Tuning • Backup / Disaster Recovery • Data extraction / migration from Legacy mainframe systems into SQL server • User Administration / Support • Client Connectivity to database platforms
Getronics Based - Netherlands December 2000 to April 2001 SQL SERVER DBA / DEVELOPER / DATABASE DESIGNER
• Senior SQL Server DBA • Stored Procedure performance tuning / Writing / Report writing • Database architecture design & implementation of Data warehouse, • Including:- • Data extraction from numerous sources via DTS packages into source databases • Transformations of data from source databases into main Data warehouse database • Design of interfaces to Legacy systems, • Integration of database applications, • Business Objects Support • CRM Support • User Administration • Backup Strategy / Disaster Fallback • Client Connectivity to database platforms
Global Knowledge Based - Netherlands July 2000 to November 2000 PROJECT MANAGER / SQL SERVER DBA / SYBASE / DEVELOPER
• Senior DBA Responsible for all SQL Servers, (across 6 European Countries) • Supporting / Developing of ASP pages for data migration / extraction • Business / technical analysis for the generation of new business reports • Debug of Visual Basic programs • Development of the Intranet site for reporting • Writing of SQL stored procedures for generation of report • Client Connectivity to database platforms • Business Objects Support
Getronics Based -- Netherlands January 2000 to July 2000 SQL SERVER DBA / DEVELOPER • DBA responsible for all database design, installation and upgrades, the database performance monitoring, tuning and backups • Review database projects/proposals and systems integration of new implementations and developments from both internal sources and third party suppliers • Support of all CRM Systems • Database Design, Data modelling • DTS / BCP scripts • Creation of backup strategy • Documentation of all work and creation of support procedures
Rabobank International Based -- Netherlands / UK / Spain / Germany PROJECT MANAGER / Senior DBA June 1998 to Dec 1999
• Project Management and team leader responsibilities • DBA supporting Sybase and Microsoft SQL Server • Inventory and documentation of hardware/software profiles/ site sign -- off reports • Providing last line support to the team under my responsibility • Support of mission critical systems, Sybase, SQL Server • Writing / testing of stored procedures • Assisted in successful rollout of new mission critical systems across five European countries • Creation of backup strategies • Database performance tuning and DBCC checks • Business / technical analysis for the generation of new business reports • Creation of Sybase and SQL Server standard build, including complete step by step installation
Hitachi Data Systems -- EDS Based - England February 1998 to June 1998
• SQL Server DBA 6.5 • Citrix Winframe supporting 500 + users • Window NT server / workstation Support • Cisco switches / Firewall configuration Airtours -- EDS Based - England August 1997 - February 1998 Desktop Support, Network Support, Server Support • Microsoft SQL Server DBA 6.5 • Window NT server / workstation Support • Microsoft Exchange Server Support • Network / DNS / Wins Support • User Administration / Support • Project co-ordination
Ventura Based - England May 1997 - August 1997 Desktop Support, Network Support, Server Support • Window NT server / workstation Support • Microsoft Mail Support • Window 95 Support • User Administration / Support • Network / DNS / Wins Support • Firewall Setup • Cisco Support • Project co-ordination Yorkshire Electricity Based - England November 1995 - May 1997 Desktop Support, Network Support, Server Support • Window NT server / workstation Support • Windows 95 / Windows for workgroups support • Microsoft Mail Support • Network Support • User Administration / Support
Certifications
See above
CONTACT DETAILS
You must be logged in and have a current resume access subscription. Login or Register »