Keywords
Skills
Microsoft SQL Server, SSIS, SSAS 2008, SSRS, Oracle, SQL Tuning, Replication, Powershell, Mirroring, Partitioning, Database Administration, Database Security, Database Integrity, Relational Databases
Project history
10.2013 DBA and DB Developer Contractor (SQL Server with Oracle experience)
Bet365
Production Database Administrator
0.2011 - 10.2013
All aspects of MS SQLServer DB support in a highly complex, volatile and exceptionally busy worldwide internet business.
- Day to day DB support- all aspects data and systems. 24 hour on-call and immediate response and action expected.
- Performance monitoring including QA review of all new code for performance analysis and approval (or not) prior to release
- Highly complex replication set up. Support and scripting
- MI support and use of SSIS, SSAS and SSRS
- Powershell scripting for monitoring, validations, scripting and investigation.
- Hardware and software investigations of any issues arising working closely with operations section as well as networks, infrasructure and systems sections.
- heavy use and scripting of stored procedures, triggers, server migrations and builds, patching.
- Clustered and geo-clustered environment
Gambling & Casinos
1001-5000 employees
Realex Payments
Database Architect
0.2010 - 0.2011
Database Architect (MS SqlServer) and Production support (1 man team) SQL 2008R2
Complex and high transaction database environment in which ultra fast service and response was critical.
Design and support database set up, both logical and physical. Heavy use of replication, mirroring, clustering, geo0clustering, mirroring, SSIS. Incident response, troubleshooting and solutions.
Day to day monitoring and DB management. Monitoring response and normal system management issues with proactive reports and planning.
Partitioning and archiving solutions
Developing SQL code in Procedures and triggers.
Large data imports into operating DBs with minimal impact using SSIS.
PCI regulated secure environments
System Upgrade design, POC and testing
Training of developers and operational support staff.
Code review to ensure security, adherence to standards and performance issues were not created by new code.
Information Technology and Services
51-200 employees
Banco Santander
DBA
0.1987 - 0.2010
Worked on Tandem, Oracle and SQLServer systems. Production database support on all environments. 24 on-call support.
Code development. Highly complex system migrations (takeove of Girobank by A&L Bank.. Take over of A&L by Banco Santander). Muuch coding to ensure that customer systems were not impacted and to endure data integrity (essential in banking) during migrations. Wide variety of platforms and responsibilities.
Banking
10,001+ employees
Bet365
Production Database Administrator
0.2011 - 10.2013
All aspects of MS SQLServer DB support in a highly complex, volatile and exceptionally busy worldwide internet business.
- Day to day DB support- all aspects data and systems. 24 hour on-call and immediate response and action expected.
- Performance monitoring including QA review of all new code for performance analysis and approval (or not) prior to release
- Highly complex replication set up. Support and scripting
- MI support and use of SSIS, SSAS and SSRS
- Powershell scripting for monitoring, validations, scripting and investigation.
- Hardware and software investigations of any issues arising working closely with operations section as well as networks, infrasructure and systems sections.
- heavy use and scripting of stored procedures, triggers, server migrations and builds, patching.
- Clustered and geo-clustered environment
Gambling & Casinos
1001-5000 employees
Realex Payments
Database Architect
0.2010 - 0.2011
Database Architect (MS SqlServer) and Production support (1 man team) SQL 2008R2
Complex and high transaction database environment in which ultra fast service and response was critical.
Design and support database set up, both logical and physical. Heavy use of replication, mirroring, clustering, geo0clustering, mirroring, SSIS. Incident response, troubleshooting and solutions.
Day to day monitoring and DB management. Monitoring response and normal system management issues with proactive reports and planning.
Partitioning and archiving solutions
Developing SQL code in Procedures and triggers.
Large data imports into operating DBs with minimal impact using SSIS.
PCI regulated secure environments
System Upgrade design, POC and testing
Training of developers and operational support staff.
Code review to ensure security, adherence to standards and performance issues were not created by new code.
Information Technology and Services
51-200 employees
Banco Santander
DBA
0.1987 - 0.2010
Worked on Tandem, Oracle and SQLServer systems. Production database support on all environments. 24 on-call support.
Code development. Highly complex system migrations (takeove of Girobank by A&L Bank.. Take over of A&L by Banco Santander). Muuch coding to ensure that customer systems were not impacted and to endure data integrity (essential in banking) during migrations. Wide variety of platforms and responsibilities.
Banking
10,001+ employees
Local Availability
Only available in these countries:
United Kingdom
New contractor after years working in some of the most challenging SqlServer environments in uk and Ireland
