CV as Word Document

  Working in IT and still can't be bothered to put together a home page.  If you wish to contact me then I can 
be reached on nxil@nxildavixs.com having first replaced the 'x's with 'e's






















 

 

 



 

 



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

                                            





 



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.

 

 



 



                                            

 



 



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. 

 

 



 



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