Curriculum Vitae

							               CURRICULUM                                            VITAE
                                              as of 7th Oct 09




NAME:                  NEIL DAVIES
ADDRESS:               35 Semley Road,Hassocks,             TELEPHONE:
                       W. Sussex BN6 8PT                    Mobile: 07736 551934
                                                            Home: 01273 841680
EMAIL                  neil @neildavies.com
DATE OF BIRTH:         22nd July 1968




EDUCATION & QUALIFICATIONS
1979 - 1986            DAYNCOURT SCHOOL, Nottingham
                       Achieved 9 'O' Levels and 4 'A' Levels
1986 - 1990            BRIGHTON POLYTECHNIC, Brighton, E. Sussex
                       Achieved BSc (Hons) in Microelectronics and Information Processing



OVERVIEW               An experienced relational database practitioner specialising in Sybase SQL Server and
                       Microsoft SQL server. Over twelve years experience in design, support and
                       performance tuning of RDMS systems. All but one previous assignments have involved
                       major blue chip companies in the financial services industry.



HARDWARE / SOFTWARE

                       Windows Servers 2003/2008 REDHAT Linux

                       Sybase SQL Server 4.9.x - 12.5.x

                       Microsoft SQL server 6.5/7/2000/2005/2008

                       Sybase Replication Server 10 -12.1 SQL Server Transaction/Snapshot Replicatio

                       TSQL/Stored Procedures/

                       EMC Navisphere and SAN software.             Cisco Security Appliances



KEY SKILLS

                       Sybase/SQL Server Database and Application Design
                       Sybase/SQL Server Performance Monitoring and Tuning
                       Sybase/SQL Server Database Administration
                       Sybase/SQL Replication
                       Windows Hardware and Software System Administration


Curriculum Vitae: Neil Davies
EXPERIENCE

November 08           DC Storm Ltd, Middle Street, Brighton
To date               SQL Server DBA / Systems Administration
                      DC Storm is a small IT company involved in the tracking and analytics of web usage.
                      Daily tracking data produces upwards of 10million transactions a day which are
                      captured, aggregated and replicated to the clustered reporting environment. As its a
                      small firm I have responsibility for all SQL servers, Windows administration,
                      Network and SAN. I also do all IT purchasing and liase with co-location hosting
                      partners. Key projects of undertaken

                       -   Installation of new tracking datacentre. Physically installed, designed DNS
                           failover, firewall configuration and set up remote monitoring
                       -   TSQL performance tuning. Rewritting stored procedures, missing index
                           identification
                       -   Implementation of standardised backups and weekly maintainance (rebuild
                           indexing, archiving )
                       -   Enhancements to existing monitoring of SQL servers to include blocking, long
                           running queries, CPU usage and available space.
                       -   Installation, testing and implementation of our applications on SQL server 2008.
                           We now have about a third of our environment on SQL 2008, with new builds
                           running on Windows 2008 with SQL 2008.


September 04          Self Employed
Nov 08                I stopped working fulltime to spend more time with my young children. I had a
                      mixture of part time, voluntary and short term consultancy positions in IT and the
                      leisure industry. Namely;

                       -   Operating a small business / domestic computer support business ( www.mid-
                           sussex.co.uk)
                       -   Approx 40 days consultancy to Citigroup Bank on performance and tuning their
                           Equity derivatives Sybase servers and migration planning to SQL server. Last work
                           was July 2008
                       -   Adhoc consultancy for Citigate Data Ltd
                       -   Swimming teaching. A mixture of voluntary works at my club (Brighton Dolphin
                           SC), schools and learn to swim lessons at Olympus Burgess Hill.


March 03 -             GOLDMAN SACHS, Fleet Street, London
September 04
                       SYBASE / MS SQLServer DBA
                       Member of the database administration team responsible for all Sybase and SQL Server
                       products within GS. Daily duties were production and development support of Sybase
                       servers running releases 4.9.x through to 12.5 on Solaris/Linux with Replication Server
                       11/12.1. I supported all servers on a production support basis, but providing in-depth
                       advice on hardware and system specifications to my business area (Equities). This
                       included performance tuning on an adhoc emergency basis when there was production
                       problems and part of acceptance testing where I was active in mentoring developers on
                       how to write good code. I did the database designs for small projects and reviews of
                       data models/database designs on the larger ones. Ran several workshops for developers
                       ranging from tuning sql queries to logical data modelling. Spent a significant amount of
                       time improving the infrastructure for monitoring both Sybase and MS sqlservers (ver 7
                       and 2000). Most scripts where written in a mixture of Perl (ctlib) and stored procedures.
                       Installed and tested first Linux Sybase servers in London and made the necessary
                       changes to infrastructure scripts to port from Solaris.




Curriculum Vitae: Neil Davies
EXPERIENCE, continued
                       Environment had around 350 Sybase servers, 90 Microsoft SQL servers, 20 repservers
                       and 5 UDB servers running batchs via Autosys. As part of the on call rota I provided
                       out of hours support overnight and at weekends.

1 January 03 -         Rabobank International Limited, Upper Thames Str, London
February 03            SYBASE DBA
                       Hired for a short contract to upgrade a Sybase 11.0.3 server running on NT4 to Sybase
                       12 running on WIN2K. This involved building the test and production to be
                       environments, advising on hardware performance and issues relating to SRDF usage.
                       Debugging and recoding various stored procedures to cater for changes in some of the
                       system functions between releases and optimising sql with the additions of indexes and
                       various the new configuration parameters available in 12.0


May 01 -               Citigroup N.A. Tooley Str, London
December 02
                       SYBASE and SQLserver DBA
                       Member of the Database administration team responsible for all Sybase and Microsoft
                       SQLservers with Citibank. Responsibilities included fault resolution and general
                       maintenance (upgrades, releases, repserver trouble shooting etc). Sybase versions 11.x
                       – 12.5 running on HPUX,Solaris and NT4. Microsoft servers 6.5 and 7 including
                       replication.
                       Projects Included:
                        Migration of 12 ASE 11.5.1 servers running on 6 HP UNIX machines onto two
                            RP8400 and upgrading them to 12.0.0.6 ASE.
                        Plan, test and implement a phased upgrade of an 8 way peer to peer replication
                            system to repserver 12.
                        Upgrade and relocation of several MSSQL 7 servers to SQL 2000 running
                            Windows 2000. Included enhancements and implementation of revised auditing on
                            these servers as well as minor changes to application related procs.

Feb 99 -               GOLDMAN SACHS, Fleet Street, London
January 01
                       SYBASE DBA
                       Member of the Sybase administration team responsible for all Sybase products within
                       Goldman Sachs. Job role and description the same as position date Mar 03 – Sep 04


March96 -              ING BARINGS SECURITIES, London Wall, London
January 99
                       SYBASE DBA
                       Member of the Sybase administration team responsible for all Sybase products within
                       Barings Securities. Daily duties were production and development support of Sybase
                       servers running releases 4.9.x through to 11.9.2 on Solaris and SunOS with Replication
                       Server 10/11. For 12 months I was team leader responsible for co-ordinating the work
                       of the dba team and for setting the strategic direction of database products at the bank.
                       Responsibilities /Projects included -
                        Installation/Design of Repserver System 11 configured in ‘warm standby’ mode to
                         have local standby and then replicating via subscriptions to other remote sites
                        Upgrading SQL servers from 4.9.x and System10 to System11
                        Evaluating and Implementing performance tuning improvements available in System
                         11
                        Writing administration tools in Perl, Visual Basic and PowerBuilder
                        Installation and support of the GLOSS, SUMMIT (including SAL) and Peoplesoft
                         packages
                        Sybase Server consolidation onto SUN Enterprise 10000, which including designing
                         disk and domain layouts and planning migration of the application servers. Attended
                         SUN E1000 System Administration and Veritas Volume Manager Courses.



Curriculum Vitae: Neil Davies
EXPERIENCE, continued
                        Responsible for the design, implementation and running of a test environment for
                         development teams to test applications for Y2K compliance.
                        Support and maintenance for Microsoft SQL Servers installed
                        Installation/Design of 4 site replication systems using Repserver 11 and replicated
                         stored procedures and tables over WAN technology
                        Training of staff in several oversees offices which involved putting together training
                         materials and delivering the content as well as working day to day with them in their
                         offices as part of the skill transfer.

June 95 -
March 96               FIDELITY INVESTMENTS, Tonbridge Road, Tonbridge, Kent

                       SYBASE DBA
                       Responsible for support and administration of all Sybase SQL servers within Fidelity.
                       Environment consisted of approx. 50 Sun boxes ranging from SPARC 2’s to SPARC
                       1000E’s with SPARC Storage Arrays. Sybase servers running 4.9.1, System 10 and
                       System 11.
                       Responsibilities / Projects included -
                        Support of live, test and development Sybase and Unix environments
                        Upgrading of servers from SunOS 4.1.3 to Solaris 2.4
                        Performance tuning of existing production SQL servers
                        Installation of remote access to Fidelity systems, via Firewall and ISDN
                        Design and implementation of internal Web servers
                        Writing of shell scripts for various admin. tasks
                        Planned distributed data architecture using Sybase Omni connect and Replication
                         Server

November 1994          CHASE MANHATTAN BANK, Chaseside, Bournemouth, Dorset
-June 95
                       SYBASE DBA
                       Working in a newly formed team with the remit to support all Sybase servers within
                       Chase Europe and Asia. The team was set-up using myself and another consultant,
                       which provided a knowledge base to train permanent employees taken onboard. We
                       supported Sybase servers running versions 4.9.x through to 10.0.2 on SUN’s and
                       AT&T’s. Responsibilities included -

                          Production support of live dealing room and development servers
                          Implementing house keeping facilities for servers
                          Reviewing and implementing security issues in a client server environment using
                            System 10
                          Database design for several MIS type applications.
                          Performance monitoring and tuning using SQL monitor
                          Sybase and SQL support to developers
                          Sybase installation, upgrading and vendor liaison.
                          SunOS 4.1.3 installation and administration


August 1992 -          AMERICAN EXPRESS EUROPE LTD, Edward Street, Brighton, E. Sussex
November 1994
                           SYBASE ADMINISTRATOR
                           DATA DICTIONARY ADMINISTRATOR

September 1990 -       NATIONAL WESTMINSTER BANK PLC, London
August 1992             DATA DICTIONARY ADMINISTRATOR

June 1988 -            VOSPER THORNYCROFT CONTROLS
September 1989          INDUSTRIAL PLACEMENT




Curriculum Vitae: Neil Davies