This role originally including database administration for the SIG UK estate and has widened to include other aspects of SIG infrastructure projects, including Azure migrations and an allocation of time to Group projects including CyberArk and Rapid7. Key technologies: Microsoft SQL Server, Microsoft Azure platform, CyberArk.

This position was as a lead DBA covering client accounts in both project and support roles. The work involved many SQL Server estates with high availability demands. All usual DBA tasks were involved, from investigating project requirements, through SQL installation, security management and configuration, into in-depth performance analysis, testing, support and remediations. I was called upon to offer consultancy on SQL Server to other areas of the business and for client projects. As SQL Server technology lead my role included engaging with the architecture teams to advise on the best solutions for both new and existing clients, and to provide guidance and direction for issues escalated to me and participation in regular environment audits and DR Test planning and execution. Client estate sizes varied from single-server up to hundreds of SQL Server instances, for which I was a core developer of the automated management scripting suite used to increase the number of instances the DBA team could manage. I was the database sector lead for the manufacturing sector, which involved assigning projects to a small team of DBAs. Key technologies: Microsoft SQL Server, Windows & Veritas clustering, Always On High Availability and DR, Windows Server, SQL Server Reporting Services and more. Some PostgreSQL. As a SQL Server technology lead my role included engaging with the architecture teams to advise on the best SQL Server solutions for both new and existing clients, as well as providing guidance and direction for issues escalated to me by other DBAs. Estate sizes varied from single-server up to hundreds of SQL Server instances, for which I was a core developer of the automated management scripting suite used to increase the number of instances that the DBA team could manage.Key technologies: Microsoft SQL Server, Windows & Veritas clustering, AlwaysOn HADR, Windows Server, SQL Server Reporting Services and more.I held SC clearance for this position.

This position was as a DBA working on the company’s MySql core databases, both live and development. The duties included day-to-day DBA tasks, as well as production of code for extraction of MI and other data.

This short contract was network support covering post-migration issues on a large Windows 2000 network.Key technologies: Windows 2000, Outlook, Office, Networking, Email (Exchange server)

This contract involved database administration for the IT department’s live servers. The principle environment was a set of clustered SQL 2000 servers, along with a number of other SQL servers, all of which must be maintained. One of the main tasks was data migration from Oracle systems into the SQL environment. Other tasks included all the usual DBA elements, such as database design, database upgrades, security testing and hardening, and the testing and planning of future technology solutions. Also I was involved in the testing and fixing of database performance issues using the SQL profiler and query planning tools. The project also involved creating a documentation system for the servers, based around Excel using VB and a sql server database.Key technologies: SQL Server 2000, Windows Server, t-sql, DTS, log shipping, database administration (installation, security, backups, scripted upgrades), data migration, reporting using Microsoft Excel and VBA.

This position was as a DBA and a database developer supporting nine SQL Server 2000 servers in a role that is split between administration of the servers and producing SQL queries for the financial management reports. The set up was SQL server 2000 on a Windows Server 2000 network. My responsibilities included query writing and tuning, database creation, back ups and maintenance, DTS package creation, data transfers, replication, user accounts and security and so on. I was also responsible for providing output to managers in the form of Excel or Access driven reports, and for helping others to improve their SQL code. The DBA side of this role also covered the administration of the separate windows 2000 network on which the sql servers sat.Approximately 70% of this role was live database and network administration and support work, the remainder being primarily database coding.Key technologies: SQL Server 2000 (Installation, security, backups, schema management, coding), Windows 2000 Server, T-sql, stored procedures, DTS, O/S installs, hardware builds, Microsoft Excel VBA, Access, and ASP/HTML for reporting.

I was working at Pearson on a project responsible for the creation of the statistics that form the school league tables for the UK. As a database developer I produced and maintained Transact SQL code and stored procedures for the SQL Server 2000 databases, as well as doing other DBA type tasks such as creating and running DTS packages, database maintenance tasks, any other database work that is needed such as for management reports or new database requirements, and exporting or producing MI in Excel and Access, either directly accessing the data from SQL Server using VBA procedures or exporting into Excel using DTS.Key technologies : Sql Server 2000, ad-hoc code writing, database analysis, stored procedures, reports using Excel and Access.

This role involved ASP development for web pages for an online learning system (www.direct-ed.com), along with development and maintenance of the SQL Server 7 databases.I was using the following skills and software, amongst others –• Sql Server 7 and 2000 – Database design, administration and programming. Stored procedures, T-SQL, some performance tuning.• Web programming – ASP (VBScript), Javascript, HTML, CSS. Using hand-coded scripts as well as design environments such as Dreamweaver Ultradev and Microsoft Interdev.• Internet Anywhere email package and various 3rd party components to create a custom web based email system.

As part of a small team I worked on both the business and technical sides of a business to business marketplace web site. The site itself used Win2k / IIS and ASP technology with a SQL server 2000 database. A linux system was also used for LDAP. I both developed and administrated these systems.Key skills used : • ASP (VBScript), JavaScript, IPWorks Component, Microsoft Visual InterDev• MSSQL Server 2000 (Database design and programming using stored procedures), Dreamweaver, HTML• Linux, OpenLdap, NT Network administraion / VPN.

Scapa Tapes is a manufacturer of Industrial technical tapes. As well as selling their own branded tape they also produce some of the tape that is used by 3M and other manufacturers. They run a Windows NT based network, which is European wide, running across a wan with the central site in Dunstable and BDCs in 6 other sites. As part of the Development / 3rd line support team, my major projects whilst at Scapa Tapes were the implementation of a company-wide Intranet and supporting the NT network and email servers. Using the Microsoft IIS and SiteServer platforms, with a SQL server database I was responsible for many of the ASP and JavaScript Intranet pages, bringing the Intranet through prototype stage to a live system. As well as the Intranet, I also carried out 3rd line server support for the NT servers on the Scapa Tapes wan. This included a number of Exchange server site moves, as well as more general NT and Exchange work. I was also involved in a site migration and NT roll-out for the Scapa Group head office, as well as heading the anti-virus software project, and providing user support when required.Key skills – Windows NT 4 & 2000 (In wan environment), IIS (4 & 5), Site Server, SQL Server MS Exchange 5.5 (Multi-site & server), Raptor Firewall, Mimesweeper ASP, (D)HTML, (Dreamweaver 3, JavaScript, etc)Software deployment and maintenance Network Associates Anti-Virus, IE, DriveImage, etc.