Principal Database Consultant
CurrentFrom 2017 - 2021, I was based at SBV as the Lead Database Engineer. From 2021 February - 2022 February, Lead DBA at OUTsurance for Ascent.From 2022 March - Current, Lead DBA at Tracker for Ascent.Database design and implementation.Data management.Database objects creation.Database integrity and consistency checking.Designing and implementing MS SQL Server database server consolidation.Database administration, maintenance, and monitoring.Database code tuning and optimisations.Performance tuning.Monitoring and troubleshooting database activity.Database performance auditing, database tuning and stabilization.Designing backup strategies.Database backups and restores.Creating and monitoring scheduled jobs.Configuring database mail and notifications.Managing and creating user logins, database access and database security.Database development and integration.Data transfer/exchange (import/export) using DTS, BCP & Integration Services.Planning and implementing database migration and upgrades.Planning & implementing disaster recovery.Database high availability (log shipping, replication, mirroring, clustering, AlwaysOn).Undertaking AlwaysOn failovers and monitoring.Project management for the software and database migration projects.Detail the business process for data modelling and mapping.DBA team management.Mentoring and training of DBA interns. Work well under pressure.Problem-solving ability.Excellent organising skills.Good verbal, written communications skills.Work well in a team and good team leader.Taking initiatives.