A motivated and versatile Database Administrator/Developer and Data Engineer with a career covering analysis, design, development, migration, transformation and administration. Consistently expanding and developing specialist expertise and easily adapting to new environments and technologies. Methodical and well organised with proven planning and organisation skills. They can achieve set objectives to tight deadlines and possess proven problem solving ability. They have excellent client facing skills and can communicate at any level with both technical and non-technical personnel. Dependable and able to manage complex challenges through to completion, either independently or as part of a team.
Key skills:
- SQL Server 7 to 2019
- SSIS (SQL Server Integration Services)
- SSRS (SQL Server Reporting Services)
- Azure SQL,
- Azure Data Lake
- Azure Data Factory
- CockroachDB
- Power BI
- Docker, Docker Compose
- Jupyter Notebook
- TSQL, PowerShell, Python, JSON
- Monitoring systems
- Data Analysis, transformation and cleansing
- Data & Database Migration
- High Availability & Disaster Recovery
- JIRA / GitHub
Key Achievements:
- Migrated numerous business critical databases and DTS packages from SQL Server 2000 to SQL Server 2005.
- Configured transactional replication form over a hundred and fifty nationwide severs to a central server.
- Designed and implemented complex statistical drilldown reports using Reporting Services which reduced the weekly production time down from five hours to minutes.
- Implemented automated monthly capacity planning reports using Reporting Services alleviating the workload of the helpdesk staff.
- Consolidated, upgraded, migrated dozens of nationally distributed SQL Servers to HP Polyserve data centres.
- Service engineered, documented and implemented database mirroring within Shell worldwide.
- Performance tuned stored procedures reducing the response time from 1 minute 38 seconds to just 2 seconds.
Qualifications:
- MSCE Data Platform / Data Management and Analytics
- MCSA SQL Server 2012/2014
- MCITP SQL Server 2005 Database Administrator
- MCITP SQL Server 2005 Database Developer
- HNC Computing
- NVQ Management Level 3