-
May 1999 – August 1999 Computer Aid Services
Hardware Environment Languages/Tools
Microsoft NT 4.0 Sybase 11,9
Sybase Replication Server version 11
Responsibilities
To provide consultancy and technical DBA support for a team
of developers during testing and final product role out.
-
September 1998 – April 1999 Maternity Leave
-
September 1996 – August 1998 JP Morgan
Hardware Environment Languages/Tools
Sun Ultra II Solaris 2.4 - 2.6 Sybase 4.92 , 10, 11, 11.5 (ASE)
Sun Enterprise SunOS Sybase Replication Server version 10, 11
PC Windows NT Lotus Notes, Microsoft Office
Production DBA part of team responsible for 24 x 7 support of 200
production and 400 development servers ranging in size from 500Mb
to 20Gb. The last 6 months were spent working on the Y2K project providing
information on compliant versions of the Sybase product range, organising
the implementation of upgrades and providing an isolated test environment
for application testing.
Main Responsibilities
- Capacity planning and installation of new Sybase servers
- Upgrade from version 4.92 to 11, from version 10 to 11 and from
11 to 11.5
- Performance monitoring and tuning
- Backup and recovery
- Problem Resolution
- Sybase Consultant to Application Developers
-
March 1995 – September 1996 Walt Disney Company
Ltd
Hardware Environment Languages/Tools
HP K200/H50 HP-UX 9.04/10 Sybase System 10/11
IBM PC Windows 3.x/95 SQL Anywhere, S-Designer (V4)
DBArtisan, Cyrano, Lotus Notes
Sybase Open Client 10.0.3
Systems
European/Asian sales and marketing database with a nightly feed from
a third party distribution system. Data was accessed via Powerbuilder
applications and reporting tools including Business Objects and Impromptu/Powerplay.
Responsibilities
Responsible for 8 Sybase production servers throughout Europe and
Asia and 2 development servers.
Up to 5 databases on each server, the largest being 10Gb. Tasks included:
- Design and QA of SQL for stored procedures, Powerbuilder applications,
Business Objects and Powerplay/Impromptu reporting tools.
- Installation of Sybase servers, upgrading of existing servers
from Sybase 10 to 11.
- Evaluation and selection of new DBA tools and database products
- Capacity planning and specification of servers for new projects
- Logical and Physical Data Modelling using S-Designer (V4).
- Configuration Control for database objects, providing written
procedures and coding standards
- Performance monitoring and tuning of all existing servers
- Backup and Recovery of databases and servers and other daily administration
tasks
-
November 1993 - March 1995 Lotus Development
Corporation
Hardware Environment Languages/Tools
Sun 20 UNIX Solaris 2.5 Sybase System 10, C
IBM PC/AT Windows 3.0, Visual Basic V3.0 (Professional)
OS/2 Lotus Notes
Sybase 4.2, Smartsuite
Apple Macintosh Deft
Project description
European Marketing Information System consisting of a database holding
customer information with the following client applications: Customer
Registration/Enquiry, Market Segmentation, Campaign Management and
Sales Order Processing.
Responsibilities
Analyst/Programmer responsible for analysis through to implementation
of the system in nine European countries. Each country had a separate
database ranging in size from 100 Mb to 1Gb. Development involved
coding Visual Basic front end programs and Sybase stored procedures
on the Unix server. Implementation involved creation of each database,
data migration from existing systems, travel to each country to check
installation and provide user training.
-
September 1992 - November 1993 Thames Water
Utilities Ltd
Project Description.
The system collected data from Thames Water's control and monitoring
systems and inserted it into a single relational database. The client
was developed in ENFIN/3, which is a Smalltalk based GUI.
Responsibilities
My main task was the logical and physical design of the VAX Rdb database
that was being used to hold all the measurements along with the and
static works details. The database consisted of 120 Tables and 4 million
rows.
-
August 1989 - September 1992
Sema Group Systems Ltd
Projects:
British Nuclear Fuels Limited - Real Time Process Control
System
June 1992 - September 1992
The manufacturing and control system part of the project involved
the use of SCADA machines to control and track the movement of fuel
rods along the fuel production line. Bespoke code written in VAX PASCAL.
Worked on the project as a designer using the YOURDON methodology.
Anglian Water - Operations Information System
Initially project roles included development, system testing and
telephone support of an Rdb/RALLY based system that kept details of
work carried out by sub contractors and produced a monthly invoice.
Following this I became increasingly involved in the analysis, design
and implementation of enhancements to the system, performance tuning
and monitoring of the production databases, technical supervision
of junior programmers.
