Nigel Dalley
Weymouth,United Kingdom
Summary
I am a seasoned DBA and database developer with two decades of experience across SQL Server, Oracle, MySQL, and Informix. My career has been defined by a strong track record in relational database design and data warehouse methodologies. Leveraging these skills, I have successfully managed complex data from legacy systems and executed seamless migrations across diverse platforms and database environments. My DBA responsibilities include query optimization, backup / restore strategies, general database health checks including performance tuning, query optimization to ensure optimal performance, reducing bottlenecks and preventing downtime whilst maintaining data integrity.
Overview
20
20
years of professional experience
2
2
years of post-secondary education
Work history
DBA / SQL Developer
Toolstream Limited
Yeovil, Somerset
2017.07 - 2025.12
- Migrating data from various legacy systems to different database platforms.
- Developing and maintaining SQL Server database systems for on-premise and Azure managed instances.
- Developing and maintaining database architectures, ensuring optimal performance and data integrity.
- Backup strategies for automated backup and recovery processes.
- Query optimization and performance tuning.
- Regular database health checks including rebuilding indexes, views and database security.
- Business reporting using various platforms, including SSIS, SSRS, Power BI and SQL.
- Developing and maintaining SQL-based integrations between critical business applications (ERP, PIM and websites)
DBA Developer
Conduent
Poole
2012.06 - 2017.07
- Responsible for designing, developing, and maintaining client databases in a MySQL environment.
- Working within a team of Oracle DBAs, I was responsible for a 5TB Oracle Data Warehouse (Oracle 11g) and daily ETL routines.
- Sole DBA for SQL Server databases.
- Analyzing raw datasets from clients and producing insightful datasets.
DBA (SQL Server and Oracle)
Weymouth and Portland Borough Council
Weymouth
2005.10 - 2012.06
- Maintenance of SQL Server Databases (2000, 2005 and 2008)
- Performance tuning and query optimization.
- Backup / restore strategies.
- Management of GIS Oracle database including back-up strategies and performance optimization.
Education
HND - Information Technology
University of Gloucestershire
1993.09 - 1995.06
Skills
- Database Management - Experienced
- Troubleshooting - Experienced
- Performance Tuning - Experienced
- Data Modeling - Experienced
- SQL Queries - Experienced
- ETL Processes - Experienced
- Business Reporting (SSIS, SSRS) - Experienced
References
References available upon request
Hobbies
Astronomy, sciences, technology, cricket, football, tennis and gardening.
Courses
Querying Microsoft SQL Server 2012/2014, Microsoft (Pass) March 2018
Timeline
DBA / SQL Developer
Toolstream Limited
2017.07 - 2025.12
DBA Developer
Conduent
2012.06 - 2017.07
DBA (SQL Server and Oracle)
Weymouth and Portland Borough Council
2005.10 - 2012.06
HND - Information Technology
University of Gloucestershire
1993.09 - 1995.06