Full CV available on request.

Raymond Ko

PROFILE

TECHNICAL EXPERTISE

• Real world expertise in MS SQL Server 7, 2000, 2005 and 2008 implementations including; installation, configuration, administration, security, database backup, performance monitoring, and disaster recovery.
• Adept in the creation and maintenance of; T-SQL, stored procedures, triggers, indexes, replication, scripting, import and export of data, and database schema changes.
• Hands on experience of SQL Server 2008 Reporting Services.
• Familiar with the use of SQL Server tools including those bundled with SQL Server; SQL Profiler, tuning wizards, DTS, and 3^rd party tools including ERWin, and DBArtisan.
• Technical, change control, and release support for existing applications.
• Full project life cycle experience; including configuration management and change management.
• Development and support of Java based applications based on the Silverstream application server technology.
• Customer facing website support and maintenance using Dreamweaver and Fireworks MX.
• Inter-site disaster recovery implementation, testing, and documentation.
• Operational knowledge of Windows based servers and communications technologies.

PERSONAL STRENGTHS

• Flexible and adaptable approach to tasks
• Works effectively as an individual or contributing as part of a team
• Excellent troubleshooting and problem solving skills
• Passionate

SELECTED ACHIEVEMENTS

• SQL Server technical lead for corporate website project.  This involved working alongside in-house and 3^rd parties with regards to requirements, implementation, testing, and on-going support.  (Honda UK)
• Installation, maintenance and support of Microsoft SQL Server 2005 cluster configurations hosted by Honda Europe. (Honda UK)
• SQL Server technical lead for upgrading entire Honda UK SQL Server 2000 infrastructure to SQL Server 2005.  Implemented as in-place and side by side processes using in-house project methodology. (Honda UK)
• Enhanced existing development and database change control procedure to enhance data integrity.  (Suzuki GB PLC)
• Reengineered an existing custom Oneworld interface for use within a web browser environment using T-SQL and Silverstream, a Java application server technology.  The streamlining resulted in lowering training and support costs.  (Suzuki GB PLC)
• Developed a variety of reports using T-SQL and Crystal Reports allowing the dealer network and head office staff to have current information, enabling decisions to be made. (Suzuki GB PLC)
• Contributed as a team member to re-platform an existing dealer facing vehicle warranty system to use a web browser using Silverstream.  (Suzuki GB PLC)

Career summary

May 2010-Present

Database Administrator – First Central Insurance Management, Haywards Heath, West Sussex

·       Working as Database Administrator managing 8 MS SQL Server instances ensuring availability and resilience.  MS SQL Server implementations; 2005 and 2008 in single instance installations in non-clustered environments on physical and virtual infrastructure.

·       Provide day to day support to business units, application support team and integration team.

·       Working alongside suppliers and supplier database administrators to implement infrastructure, database, and data changes, and troubleshoot issues.

·       Produced documentation for standardisation of company SQL Server installations, security and ongoing support.

·       Development of additional reports using SQL Server Reporting Service technology.

Technologies: MS Windows Vista, 2003 and 2008.  MS SQL Server 2005 and 2008, T-SQL, SQL Server Reporting Services, Redgate SQL Backup, MS Office.

Nov 2006 – May 2010

SQL Server Database Administrator - Honda Motor Europe ISD, Langley, Berkshire

·       Sole SQL Database Administrator managing over 40 MS SQL Server instances ensuring availability, capacity and resilience.  MS SQL Server implementations; 2000, 2005 and 2008 in single and multiple instance installations, and in high availability, clustered and non-clustered environments.

·       Providing day to day support to development and support teams to; resolve issues, regular maintenance, SQL and server optimisation, database creation, rollout support, SQL Server transactional replication and linked server for SQL Server to SQL Server communication and SQL Server to DB2 client connectivity Supporting systems used by dealers, UK and other EMEA head office staff.

·       Creation and maintenance of SQL Server standards, procedures, and other support documentation.

·       Liaising with in-house and 3^rd parties to resolve connectivity, security, hardware, and software compatibility issues.

·       Working within a SOX environment and responsible for the promotion of SQL Server objects and scripts to environments, including the execution of corrective action scripts in a production environment.

·       DBA lead to plan, budget, evaluate risk, and implementing on upgrading existing SQL Server 2000 environments to SQL Server 2005.

·       Disaster recovery coordinator for Honda UK SQL Servers.  Involved in the recovery plan documentation for the SQL servers, relevant storage, communication, and selected applications.  Involved in the invocation in a test environment as part of DR testing.

Technologies: MS Windows XP, 2000, and 2003, MS SQL Server 2000, 2005 and 2008, T-SQL, SQLDelta, MS Office, Lotus Notes, DB2 Client Tools, Orion Solarwinds

Aug 2006-Sep 2006   

Database Support Analyst - Identex Ltd, East Grinstead, West Sussex

• Database analyst using Microsoft SQL Server 2000, T-SQL, third party, and in-house tools to manipulate and cleanse external data sources to ensure deliverables match requirements.

Technologies: MS Windows XP, MS SQL Server 2000, T-SQL, MS Office, Informatica

1999-Jul 2006

IT Database Co-ordinator - Suzuki GB PLC, Crawley, West Sussex

• DBA for SQL Servers serving head office and field based staff, automobile, motorcycle, ATV and marine dealer network and multiple Microsoft SQL Servers running versions 7 and 2000.
• Provide 1^st line support to head office, field based staff, and suppliers, and 2^nd and 3^rd line support to dealer network with regards to application defect resolution, change controls, testing, and deployment.
• Responsibilities include day to day support, regular maintenance review, SQL and server optimisation, disaster recovery planning and testing, and custom database installation support.
• Work closely with head office staff, suppliers, and customers to ensure that development requirements are met for data requests, reports and change control specifications.
• Ensuring database integrity, security, performance, and application issues are resolved within acceptable timescales.
• Involved in a number of high profile projects in both full and partial lifecycles developed using; Java, Silverstream application server, T-SQL, and Crystal Reports.
• Enhanced and maintained standards and procedures documents to support department quality.

Technologies: MS Windows NT, XP, 2000, and 2003, MS SQL Server 6.5, 7, and 2000, T-SQL, Crystal Reports, CA ERWin, MS Office, MS Access, Java, Tridion R5, Silverstream 3.7, Macromedia Dreamweaver and Fireworks MX, HTML, Embarcadero DBArtisan, Veritas BackupExec, Visual Basic, IIS, JD Edwards Oneworld.

1997-1999

Software Engineer - EASAMS Engineering Systems, Borehamwood, Herts. 

• Participation as a team member sub-contracted out to the Radar and Countermeasures division of GEC-Marconi, Stanmore. Reviewing of design documentation, coding, testing, delivery, and producing associated documentation in a timely manner.
• Contributed in the development, testing, and delivery of military specification code written to company ISO9001 standards.

• Involvement with prototype database design and development of an in-house metrics system.

Technologies: SunOS Unix and X Windows, MS Windows, MS Office, Ada, Teamworks, MS Access, Visual Basic

OTHER RELATED EMPLOYMENT

In 1997 created company websites for two companies based in Hampshire; “Easy networks” and “Captain Packaging”.  This involved gathering requirements, development, testing, and deployment.

Technologies: MS Frontpage, MS Office, IIS

TRAINING & DEVELOPMENT

Self Paced Training    Microsoft SQL Server 7, 2000, 2005, and 2008.

Honda Europe             Honda Project Management Methodology (HPMM)

Tridion                         DialogServer Publication Development Course and Tridion Delta Training

Silverstream               Silverstream Programming Fundamentals

Sun Microsystems      Java Programming Language

JD Edwards                JD Edwards Technical: CNC Foundation and System Administration

EASAMS Limited        Software Process Improvement

EDUCATION

1996 – 1997    University of Portsmouth, Hampshire - BSc(Honours) Computing

1994 – 1996    University of Portsmouth, Hampshire - BTEC HND Computing

1992 – 1994    Haywards Heath College, West Sussex - 2 A-Levels, inc. Computing (B)

1987 – 1992    Oathall Community College, West Sussex - 10 GCSE’s, 1 RSA, and 1 Pitman.