Regan Galbraith

Current

2nd Line MSSQL Production DBA - EMEA at Barclays Capital

Past

Senior DBA Consultant at IVIS Group
DBA Consultant at IVIS Group
Data Architect at Standard Chartered

DBA Consultant at Gijima AST
DBA at Sanlam

see less...

2 more...

Education

University of Port Elizabeth

Recommended

7 people have recommended Regan

Connections

219 connections

Industry

Banking

Regan Galbraith’s Summary

With over 14 years experience in the IT industry, as a DB2 MVS and SQL Server DBA. I have focussed on SQL Server for the past 8 years and have extensive experience as a project DBA, responsible for the design and delivery on scalable database solutions, and as a production DBA, supporting critical production environments.

Through these roles I have specialized in strong relational database design, administration, implementation and support skills, most recently on Microsoft SQL Server 2005, and also with Microsoft SQL Server 7, 2000, 2005 and DB2 for Z/Os (versions 3, 4 and 5).

My success in the positions I have held is as a direct result of my ability to take the initiative and get the job done with energy and enthusiasm. I regard myself as a professional and conduct myself accordingly.

Regan Galbraith’s Specialties:

Microsoft SQL Server 7, 2000 and 2005
o Using:
• SQL Server Integration Services (SSIS & DTS),
• SQL Profiler,
• SQL Broker Services (SBS),
• SQL 2005 DB Mail
• SQL Server Management Studio (SSMS & EM/QA for SQL 2000)
• Business Intelligence Development Studio (BIDS)
o To perform:
• Design,
• QA to standards,
• Dev (incl. Stored Proc's, Functions, Triggers, SSIS etc.),
• Installation,
• Implementation,
• Performance & Optimization,
• Automated Monitoring & Support

Regan Galbraith’s Experience

2nd Line MSSQL Production DBA - EMEA

Barclays Capital

(Public Company; BARC; Investment Banking industry)

July 2009 — Present (6 months)

Barclays Capital is the investment banking division of Barclays Bank PLC. With a distinctive business model, Barclays Capital provides large corporate, government and institutional clients with a full spectrum of solutions to their strategic advisory, financing and risk management needs.

The EMEA 2nd Line SQL Team support over 1500 SQL servers (SQL 2000, 2005) as part of a global support structure, maintaining security, availability and performance.
Senior DBA Consultant

IVIS Group

(Privately Held; Information Technology and Services industry)

July 2008 — July 2009 (1 year 1 month)

Senior DBA Consultant for SQL Server 2000 and 2005, working on-site at our primary client to enable the design, and maintenance, of the DBs supporting a high transaction volume business web-site.
DBA Consultant

IVIS Group

(Privately Held; 51-200 employees; Information Technology and Services industry)

May 2006 — July 2008 (2 years 3 months)

DBA Consultant for SQL Server 2000 and 2005, working on-site at our primary client to enable the design, and maintenance, of the DBs supporting a high transaction volume business web-site.
Data Architect

Standard Chartered

(Public Company; 10,001 or more employees; Banking industry)

May 2004 — April 2006 (2 years )

To prepare, create and manage an effective and complete data architecture, where the solutions can work together and support the business in an optimal way. This role supports the South African consumer banking operation.

KEY RESPONSIBILITIES
1. Technical DBA support
2. Architectural Strategies
3. Internal Communication
4. Production Support
5. Project Involvement
6. Mentorship
7. Standards and Guidelines
DBA Consultant

Gijima AST

(Public Company; GIJ; Information Technology and Services industry)

August 2001 — April 2004 (2 years 9 months)

During my employment at AST, on site at Sanlam, I fulfilled several roles, - Project DBA for the Millennium Program; Production DBA for the Millennium production systems (DB2 and SQL Server); Senior SQL Server DBA, primarily consulting on other SQL Server projects at the Client.

As project DBA, specifically allocated to the Millennium Project, I had key responsibilities that included ownership in the development, test, training and stand-alone SQL Server environments, and DB2 for z/OS, version 5. This included covered all aspects of DBA role, from installations of servers (for SQL Server), to implementation and roll-out of structure changes and releases (SQL and DB2), including SQL code review for standards and performance, disaster recovery processes, volumetrics estimations etc (again for SQL and DB2).

In my role as production DBA, I provided on-site and remote support for the production Sanlam SQL server environments on a rotation basis. This included issue and problem analysis and resolution of high profile/impact production SQL Server and DB2 application database incidents.

In my role as one of the senior DBA’s on site, my responsibilities included consultation to, and QA of, junior DBA’s database design and implementation, as well as enhancing the DBA team’s processes.
DBA

Sanlam

(Public Company; Financial Services industry)

July 1995 — July 2001 (6 years 1 month)

Sanlam is the second largest life insurance organization in South Africa with several million policies on book. After completing studies with their assistance in a scholarship, I entered employment with them as a database administrator.

My initial role in the organization was as an application DBA, responsible for development, test and production support of specific application databases on DB2. Early in 1996, I was moved to take on project DBA responsibilities in proof-of-concept trailblazer projects on the HPS case tools. This led to my long-term assignment, as a Project DBA, to the FINPRO programme which was the IT programme responsible for moving Sanlam’s technology away from predominantly Cobol and assembler mainframe systems. This eventually culminated in the Millennium project, where core systems were migrated to SQL Server. I retained a role as part of the production support roster for DB2 application databases.

Regan Galbraith’s Education

University of Port Elizabeth

B.Com , Computer Science, Business Management , January 1992 — June 1995

Dean's List 1992;
Distinctions in Accounting 1; Comp Sci 1; Business Management 3b;
Student Assistant for 1st Year Computer Science course in 1993;