Highly experienced Sybase Database and Replication Server Administrator, having worked (almost) exclusively with Sybase products for more than a decade. Through the variety of positions I have held in the past, I also have experience in application development in Perl, and web developement using Apache, Perl, CGI, DHTML, JavaScript and CSS.
Joined Red Rock as Senior Sybase Consultant, helping with the transistion of the Accident Compensation Corporation (ACC) account from the previous outsourcer. I have also contributed to security and health-check audits of other customers.Techincal skills currently in use are Sybase ASE 12.5 - 15.5 on Solaris, Linux and Windows platforms. Replication Server 12.6 to 15.2 on Solaris and Linux. Also continuing development work for management and monitoring toolsets in Perl, SQL, Java, Shell Script and whatever else is needed ;)
Client lead on the Accident Compensation Corporation (ACC) account. 24/7 support for the corporation’s key systems, as well as the DBA representative to the corporation for technical issues. Skills involved include (among others) design, build and deployment of new db systems, analysis and design of disaster recovery plans, monitoring, performance tuning, and capcity planning. Responsible for both the ongoing continuous improvement of DBA services to the client, as well as participation in incident and problem management forums to resolve issues and prevent future problems.Technical environment was a system of large Solaris server platforms (E25k) and some smaller ones, hosting 20 Sybase servers (ASE 12.x & 12.5.x) with instances of Replication Server (12.6) using both warm standby and replication definitions. Front end applications in Visual Basic & Java, mostly through application server middle layers, and some interface to/from Oracle databases (no heterogeneous replication though).
24/7 support for the bank’s market and credit risk systems. Responsibility for maintaining all areas of the system, including incoming and outgoing data streams, monitoring and enhancing performance of database and non-database objects, checking and correcting data integrity. Also responsible for developing departmental intranet site using HTML, JavaScript, CSS and Perl for CGI-enabled applications.Technical environment was a system of multi-gigabyte (250+) Sybase 11.9.2 databases on an HP-UX 11 platform with front end applications in Visual Basic and intranet Perl/CGI. Back end applications in a mixture of Perl, Intranet/CGI, C, C++ and Unix shell.
Responsible for the management and enhancement of the data model for the Equity Sales IT department. Responsibilities included the enhancement of the data model to include new applications and feature. Also responsible for the redesign of the legacy data model to conform to current standards and best practice (the system was very old).Technical environment was several medium-sized Sybase 11.9.2 databases on a Solaris platform. Front end applications were in Visual Basic and also web-based (internet and intranet) with a middle tier transaction server for database connectivity.
24/7 support of the main trading system running on Sybase 11.0 on Solaris. As well as the standard DBA duties, I also did considerable development on automating DBA activities to free up the DBAs for more productive tasks - something I have continued in all future engagements.
Joined DRA from university as a 50/50 office assistant and scientific officer in the Land Systems (LS1) division. Having passed PV(S) security checks, was moved to full-time on techincal work, mostly in the database area using SuperBase, MS Access and Sybase (on VMS!)
The "Manangment Sciences" course, run by the Manchester School of Management (now part of Manchester Business School) covers many areas used in management that have a quasi-scientific background. Modules I took included: Financial Accounting, Organisational Psychology, Economic History, Sociology, Optimal Resource Allocation, Management Statistics & Management Information Systems. The course content was reviewed by HEFCE in 1994:"The assessors come to the overall conclusion, based on the assessment visit and analysis of the self- assessment, together with the statistical indicators, that the quality of education in business and management at the UMIST Manchester School of Management is excellent."
http://www.qaa.ac.uk/reviews/reports/subjectlevel/q200_94_textonly.htm#conc
Alan is a fellow consultant at Red Rock. We have worked together since October 2008.
Mark was the team leader at Unisys NZ, and is now a fellow consultant at Red Rock. We have worked together since April 2005.