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
