Stuart Cheshire Email & Phone Number

Worked within a Sybase development team within the Investment Bank group. The team supported and develops the many data feeds which feed in & out of the IB databases.- Feed process design and development including Sybase v12.5 database transact SQL; writing stored procedures & table design; UNIX Shell scripting; management of feed process; XML & XSLT – transformation of feed data into required formats. - The Development process was based on specifications derived in conjunction with the business or a 3rd party. Delivered to deadlines following a defined release schedule. - Production support of these same UNIX feed & Sybase processes.- Identification of service improvement. This ranged from process improvements to how our team functioned to technical improvements including performance optimisation of stored procedures & UNIX processes. - Code control using Clearcase and database development using DBArtisan.

I worked within a team which focused on Service Delivery of IT Systems. Based on Oracle(9i & 10g) & Sybase 12.5 databases on UNIX(AIX) & Windows platforms. I performed the following tasks mainly within an ITIL framework• Application support to all levels of environment(SIT,UAT & Prod)• Extensive use of Sybase Transact SQL & Oracle PL/SQL• Sybase & Oracle DB performance tuning• Creation and monitoring of daily housekeeping• Project planning of implementations, releases & upgrades• PVCS Admin where labeling & promotion groups were used to manage releases• Writing re-usable scripts to use in standardizing processes like Builds;Releases;Upgrades;Monitoring;Auditing & Housekeeping • Development & maintenance of system DR processes• Sybase & Oracle Migrations• Worked on the commercialization of Fidelity’s Fund management system• Problem Management using TestDirector

•DBA responsibilities for a telecommunications Object Orientated Customer Care system. The role involved general administration tasks, development of a backup strategy; DBCC housekeeping tasks, system upgrades and system performance and optimization.•Set-up and administration of Sybase Replication server.•Extraction of data from existing Sybase system as well as migration of data from other data sources to generate data warehouse.

• Database design and development on a financial accounting system. Wrote stored procedures and triggers using Transact SQL. Worked alongside users in determining system requirements. Used PVCS as version control and release management software.• Creation & management of a required backup strategy• Daily database administration tasks including the monitoring, support & development of housekeeping tasks.• Production database systems support. Including troubleshooting application problems, DB administration SQL Server configuration.• Installation and configuration on NT platforms for Sybase 11 and ASE 11.5.• Performance optimization by improving indexing & by using partitioning and caching techniques. Analysis of performance using sp_sysmon.• Gained extensive experience using Visual Basic 6 while writing a fully user definable and automated database housekeeping IE4 browser application.•Fundamental understanding of Replication server and SQL Anywhere.

Worked extensively within a team of developers on the design, development, installation and subsequent support of a newspaper advertising business system. I gained extensive experience in the following areas• Systems analysis using ERD modelling and data flow design using DEFT & S-designer• RAD development in a client server environment using powerbuilder (v3 to v5) and Sybase(v10,11 and 11.5)• Working with customers in defining specific system requirements• Extensive installation, support and administration of Sybase systems on Unix Sun Solaris(upto v2.6)• Sybase development using transact SQL, stored procedures, triggers and table definitions• Support of Production environments • Extensive work on Performance tuning• Support of Housekeeping and disaster recovery processes• Setup & administration of disk arrays utilizing various different storage options - striping, mirroring or raid • I also have experience in Unix shell scripting, ODBC, foxpro and turbo pascal