Anthony Adefolaju
IT Professional and Educational Qualifications
Hire this person
Send a job offer directly to this candidate
About
SQL DBA Management of SQL 2022, SQL 2019, SQL 2017, SQL 2016, SQL 2014 and SQL 2012 servers SQL DBA Management of Azure SQL databases and Synapse Analytics databases SQL DBA Management of Integration Services and Reporting Services
Experience
Senior Database Administrator at Vancity (2022-11 – Present)
- SQL DBA Management of SQL 2022, SQL 2019, SQL 2017, SQL 2016, SQL 2014 and SQL 2012 servers
- SQL DBA Management of Azure SQL databases and Synapse Analytics databases
- SQL DBA Management of Integration Services and Reporting Services
- Performance Monitoring and resolving problems affecting the SQL Server environment
- Developing and implementing maintenance and data recovery strategy for databases
- Developing and implementing security processes for server and database access
- SQL systems capacity planning
- Regular Disaster Recovery Testing
- Working with the various Banking Applications, Information Security, Servers, Systems and Storage
- Tracking server GDR, CU and Service Pack to form the database roadmap
Database Administrator at University of the Fraser Valley (2021-01 – 2022-11)
This role involves the management and support of the Microsoft SQL and MySQL databases environments for this university.
- SQL DBA Management of SQL 2016 and SQL 2012 servers
- SQL DBA Management of MySQL servers
- Performance Monitoring and resolving problems affecting the SQL Server environment
- Developing and implementing maintenance and data recovery strategy for databases
- Developing and implementing security processes for server and database access
- SQL systems capacity planning
- Implementing Log Shipping, Database Mirroring and replication
- Working with the various university Applications, Servers, Systems and Storage teams to form the database roadmap
Database Administrator at Insight (2020-03 – 2020-04)
This role involves the management of the production, Quality Assurance and Development SQL Server environments for a multinational Background Checking Agency.
- SQL DBA support and Management of SQL 2017, SQL 2014, SQL 2012, and SQL 2008 R2 servers
- Performance Monitoring and resolving problems affecting the SQL Server environment
- Developing and implementing maintenance and data recovery strategy
- Developing and implementing security processes for server and database access
- Management of SSRS reports
- SQL systems capacity planning
- Implementing Log Shipping, Database Mirroring and replication
Database Administrator at Sterling Backcheck Canada Corp (2019-05 – 2020-02)
This role involves the management of the production, Quality Assurance and Development SQL Server environments for a multinational Background Checking Agency.
- SQL DBA support and Management of SQL 2017, SQL 2014, SQL 2012, and SQL 2008 R2 servers
- Performance Monitoring and resolving problems affecting the SQL Server environment
- Developing and implementing maintenance and data recovery strategy
- Developing and implementing security processes for server and database access
- Management of SSRS reports
- Development of server and database performance analysis process and enhancement strategy
- Working with the application team to build the development of production systems and project management
- SQL systems capacity planning
- Implementing Log Shipping, Database Mirroring and replication
- Data Migration between various versions of SQL server
- Developing and implementing projects and packages for DTS, SSIS and SSRS
SQL Database Administrator / Developer at Data Manager Limited (2012-05 – 2018-09)
Database Management and Consultancy for multiple clients
SQL Database Administrator / Developer at Ryman (via Nigel Frank Agency) (2012-05 – 2018-09)
This role involved implementing and managing production, test as well as development SQL Server for a national stationer.
- SQL DBA support and Management of SQL 2008 R2, SQL 2014 and SQL 2016 servers
- Performance Monitoring and resolving problems affecting the SQL Server environment
- Developing and implementing backup and data recovery strategy
- Developing and implementing security processes for server and database access
- SQL Server Cluster and AlwaysOn Availability management
- Development and management of SSIS packages for various data distribution processes
- Development and management of SSRS reports
- Development of server and database performance analysis process and enhancement strategy
- Developing and implementing Disaster recovery and high availability strategies using EMC and native SQL server facilities
- Working with the application team to build the development and production SharePoint farms
- SQL DBA support for SharePoint databases
- Resolving performance problems affecting the SharePoint SQL server
- SQL systems capacity planning
- Implementing Log Shipping, Database Mirroring and replication
- Data Migration between various versions of SQL server
- Developing and implementing projects and packages for DTS, SSIS and SSRS
SQL Database Administrator / Developer at CMS (via DGH Recruitment Agency) (2012-05 – 2018-09)
This job involves implementing and managing production, test as well as development SQL Server systems in a very busy international Law firm and the successful merger of 3 firms with various multinational data centres.
- SQL DBA support and Management of SQL 2014 servers
- Performance Monitoring and resolving problems affecting the SQL Server environment
- Developing and implementing backup and data recovery strategy
- Developing and implementing security processes for server and database access
- Development and management of SSIS packages for various data distribution processes
- Development and management of SSRS reports
- Development of server and database performance analysis process and enhancement strategy
- Developing and implementing security processes
- Developing and implementing Disaster recovery and high availability strategies using EMC and native SQL server facilities
- Working with the application team to build the production systems and project management
- SQL DBA support for SharePoint databases
- SQL systems capacity planning
- Implementing Log Shipping, Database Mirroring and replication
- SQL server clustering
- Data Migration between various versions of SQL server
- Developing and implementing projects and packages for DTS, SSIS and SSRS
SQL Database Administrator / Developer at ReferAll (via Opus Recruitment Agency) (2012-05 – 2018-09)
This role involved the management of the production, test and development SQL Server environments for this Medical and Fitness records firm with a range of proprietary SQL 2014 instances and Tableau reports.
- SQL DBA support and Management of SQL 2014 servers
- Performance Monitoring and resolving problems affecting the SQL Server environment
- Developing and implementing backup and data recovery strategy
- Integration with various medical records and fitness centres for a national project
- Developing and implementing security processes for server and database access
- Development and management of SSIS packages for various data distribution processes
- Development and management of SSRS reports
- Development of server and database performance analysis process and enhancement strategy
- Working with Application Developers and support personnel
- Advanced server management automation with PowerShell
- SSIS deployment and management
- Report server management
SQL Database Administrator / Developer at Mckesson (via Disys UK LTD Agency) (2012-05 – 2018-09)
This role involved the proactive management of the production, test and development SQL Server environments for this pharmaceutical firm with a range of SQL 2014 instances and Tableau reports.
- SQL DBA support and Management of SQL 2014 servers
- Performance Monitoring and resolving problems affecting the SQL Server environment
- Deployment of management and report system with the use Policy Based Management
- Developing and implementing backup and data recovery strategy
- Developing and implementing security processes for server and database access
- Development and management of SSIS packages for various data distribution processes
Education
MS in Information Network and Computer Security – New York Institute of Technology
MSC in Computing and Information Systems – University of Greenwich
Certificate in Life Coach – Canada Coach Academy
Postgraduate Certificate in Networking Technologies and Management – Sheffield Hallam University
BA (Honours) in Language Arts
