$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
SQL Server DBA
LUSALE SILWAMBA
,
Loughborough, United Kingdom
Experience
Other titles
Skills
I'm offering
I have been working with SQL Server as a developer and administrator for over 19 years. I have both private and public sector experience. I am adaptable and can fit into different organisational cultures with ease.
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2019 - ?
temp
Data Platform Engineer
unknown.
(Contract)
• Work with the DevOps team to promote Infrastructure-as-code agenda
• Investigate the use of Puppet Enterprise for SQL Server configuration management
• Responsible for the integrity, availability and confidentiality of the organisation's data assets and the platforms that
host them
• Management and Administration of business-critical data platforms.
• Data Platform monitoring and reporting using Spotlight and bespoke tools
• Backup, Recovery & High Availability planning & implementation.
• Backup routines implemented using DBATools, Pester PowerShell modules and executed via a Jenkin's job
• All backup test restores are automated using PowerShell
• Management of large databases
• SQL Server 2019 Big Data Cluster (BDC)
• Installation and administration of SQL Server 2019 Big Data Cluster on-premise
• Customise deployment using JSON patch files
• Active directory security configuration, endpoint dns names, resource replicas, pod
placement, persistent storage configuration, port numbers
• Design configuration templates
• Automate deployment using PowerShell and azdata
• Implement database maintenance solution
• Support deployment of applications on Big Data Cluster
• Requirements and High-Level Design of SQL Server Infrastructure Management Tool
• Define SQL Server Instance as Code
• Use code to automate SQL Server installation and configuration
• Puppet Enterprise software met most of the requirements
• Installation of Puppet Master on a Linux server and Puppet agents on SQL Server boxes
• Permissions Management and Information Security design in adherence with ISO27001 standards.
• Defining non-functional requirements and data management strategy for new developments & enhancements.
• Installation and management of Microsoft Big Data Cluster on Kubernetes
• Formulation of standard SQL build, design and implementation of SQL instance configuration management
• Use Puppet, PowerShell, PowerShell DSC for SQL instance provisioning
• Use Puppet and PowerShell for SQL instance configuration management and compliance
• Work with the DevOps team to promote Infrastructure-as-code agenda
• Investigate the use of Puppet Enterprise for SQL Server configuration management
• Responsible for the integrity, availability and confidentiality of the organisation's data assets and the platforms that
host them
• Management and Administration of business-critical data platforms.
• Data Platform monitoring and reporting using Spotlight and bespoke tools
• Backup, Recovery & High Availability planning & implementation.
• Backup routines implemented using DBATools, Pester PowerShell modules and executed via a Jenkin's job
• All backup test restores are automated using PowerShell
• Management of large databases
• SQL Server 2019 Big Data Cluster (BDC)
• Installation and administration of SQL Server 2019 Big Data Cluster on-premise
• Customise deployment using JSON patch files
• Active directory security configuration, endpoint dns names, resource replicas, pod
placement, persistent storage configuration, port numbers
• Design configuration templates
• Automate deployment using PowerShell and azdata
• Implement database maintenance solution
• Support deployment of applications on Big Data Cluster
• Requirements and High-Level Design of SQL Server Infrastructure Management Tool
• Define SQL Server Instance as Code
• Use code to automate SQL Server installation and configuration
• Puppet Enterprise software met most of the requirements
• Installation of Puppet Master on a Linux server and Puppet agents on SQL Server boxes
• Permissions Management and Information Security design in adherence with ISO27001 standards.
• Defining non-functional requirements and data management strategy for new developments & enhancements.
• Installation and management of Microsoft Big Data Cluster on Kubernetes
• Formulation of standard SQL build, design and implementation of SQL instance configuration management
• Use Puppet, PowerShell, PowerShell DSC for SQL instance provisioning
• Use Puppet and PowerShell for SQL instance configuration management and compliance
Backup, Test, Compliance, Security, ISO27001, Implementation, Support, Infrastructure, Monitoring, PowerShell, Configuration Management, Software, Storage, Organization, Server, Enterprise, Formulation, Deployment, Sql, Linux, Administration, SQL Server, JSON, Big Data, Active Directory, DevOps, Design, Data management, Database, Kubernetes, Information Security, Linux server, DNS, Management
2019 - 2019
freelance
SQL BI DBA Consultant
unknown.
(Contract)
• Integrating Azure Microsoft Dynamics data into the Data Warehouse on premise
• Upgrading SQL to version SQL Server 2014 on all Dental practice sites (more than 600 sites)
• Architecting and developing the Enterprise Data Warehouse (EDW) database solution
• Supporting and administration of SQL Server BI stack infrastructure and all site SQL instances
• Managing backups and reviewing the backup policy
• Investigating SQL related performance issues
• Implementing security best practices
• Responsible for ensuring SQL data is GDPR compliant across all data domains
• Architecting the SQL data GDPR framework
• Setting up transactional replication for all new dental practices acquired by {my}dentist
• Integrating Azure Microsoft Dynamics data into the Data Warehouse on premise
• Upgrading SQL to version SQL Server 2014 on all Dental practice sites (more than 600 sites)
• Architecting and developing the Enterprise Data Warehouse (EDW) database solution
• Supporting and administration of SQL Server BI stack infrastructure and all site SQL instances
• Managing backups and reviewing the backup policy
• Investigating SQL related performance issues
• Implementing security best practices
• Responsible for ensuring SQL data is GDPR compliant across all data domains
• Architecting the SQL data GDPR framework
• Setting up transactional replication for all new dental practices acquired by {my}dentist
Sql, Administration, SQL Server, Azure, Database, Data Warehouse, GDpr, Security, Infrastructure, Backup, BEE, Server, Enterprise, Framework, Sql server 2014, UP
2018 - 2019
temp
Production DBA (Contract)
unknown.
• Responsible for day to day availability of all database servers ensuring high performance and availability of the databases that support the business systems in a true 24/7 environment.
• Responsible for QA of all UAT and Production database releases ensuring bet365 standards are followed
• Use Jira for management of all QA issues
• Use bet365 SQL Standards to check all SQL code
• Use 'Beyond Compare' utility tool to compare different versions of SQL code
• Use Git as a code repository
• Use 'SQL Sentry Execution Plan Analyzer' to analyze and evaluate query plans
• Carrying out performance reviews of new SQL code such as Stored Procedures, Functions, Views and Triggers
• Deployment of fit for purpose code to UAT and Live, driving all requests through the process to completion - end to end ownership.
• Following and improving internal processes to ensure accurate and consistent database processes are carried out for
production database requests with support for operational deployments, business intelligence and analytical reporting
requirements
• Responsible for QA of all UAT and Production database releases ensuring bet365 standards are followed
• Use Jira for management of all QA issues
• Use bet365 SQL Standards to check all SQL code
• Use 'Beyond Compare' utility tool to compare different versions of SQL code
• Use Git as a code repository
• Use 'SQL Sentry Execution Plan Analyzer' to analyze and evaluate query plans
• Carrying out performance reviews of new SQL code such as Stored Procedures, Functions, Views and Triggers
• Deployment of fit for purpose code to UAT and Live, driving all requests through the process to completion - end to end ownership.
• Following and improving internal processes to ensure accurate and consistent database processes are carried out for
production database requests with support for operational deployments, business intelligence and analytical reporting
requirements
Sql, Git, Business Intelligence, Jira, Deployment, Database, Management, Stored procedures, QA, Support, Production, Processes
2018 - 2018
freelance
GDPR DBA Consultant
Instant Cash Loan Ltd.
(Contract)
• Responsible for ensuring SQL data is GDPR compliant across all data domains
• Architecting the SQL data GDPR framework
• Implementation of the SQL data GDPR framework
• Producing data classification reports for all databases
• Carrying out vulnerability checks for all tier 1 and tier 2 SQL databases
• Establish database owners
• Implementing database security best practice
• Review of the data obfuscation process
• Using T-SQL and PowerShell to automate processes
• Conducting meetings with stakeholder of the wider GDPR project
• Weekly meetings to discuss progress and blockers
• Engaging third party software suppliers
• Data deletion to comply with GDPR
• Architect data deletion process
• Review the data deletion code
• Carrying out an inventory and consolidation of SQL Server instances and databases
• Carrying out SQL Server instance and database security audit
• Op Manager database migration using existing probe databases
• Act as an escalation point for SQL production Incidents and Problems
• Writing business cases for GDPR sub projects
• SQL Server consolidation
• SQL Server upgrades from SQL Server 2008 to SQL Server 2017
• Responsible for ensuring SQL data is GDPR compliant across all data domains
• Architecting the SQL data GDPR framework
• Implementation of the SQL data GDPR framework
• Producing data classification reports for all databases
• Carrying out vulnerability checks for all tier 1 and tier 2 SQL databases
• Establish database owners
• Implementing database security best practice
• Review of the data obfuscation process
• Using T-SQL and PowerShell to automate processes
• Conducting meetings with stakeholder of the wider GDPR project
• Weekly meetings to discuss progress and blockers
• Engaging third party software suppliers
• Data deletion to comply with GDPR
• Architect data deletion process
• Review the data deletion code
• Carrying out an inventory and consolidation of SQL Server instances and databases
• Carrying out SQL Server instance and database security audit
• Op Manager database migration using existing probe databases
• Act as an escalation point for SQL production Incidents and Problems
• Writing business cases for GDPR sub projects
• SQL Server consolidation
• SQL Server upgrades from SQL Server 2008 to SQL Server 2017
Implementation, Manager, Processes, Sql server 2008, Framework, Audit, Production, Server, Software, Business cases, Sql, Security, PowerShell, T-SQL, GDpr, Database, Audit, SQL Server, Writing
2017 - 2018
freelance
SQL Data Migration DBA Consultant
Solicitors Regulation Authority.
(Contract)
• Working with developers, data analysts, testers, data architects and business analysts to migrate CRM, document and finance data from legacy systems to new Azure systems (cloud-based systems)
• Legacy databases are SQL Server 2008R2 and Oracle 8i data sources
• SQL Server 2016 is a standard on all cloud SQL Servers
• Use SQL Server Migration Assistant (SSMA) for Oracle
• Designing a method of getting copies of legacy data from a third-party data centre to the SRA cloud environment
• Address SRA's business requirements such as security and application downtime
• Comply with SRA's Managed Services contractual obligations
• Coordinate legacy data movement exercises
• Produce data movement schedules
• Carry out Proof of Concepts
• Setting up Visual Studio Team Services (VSTS) to manage data migration code
• VSTS is a cloud equivalent of Team Foundation Server (TFS)
• Use Redgate Source control to connect data migration databases to VSTS
• Installing SQL Server 2016 on cloud SQL boxes
• Use mount points to install system databases, user databases on separate disk volumes
• Use Active Directory to manage the security of SQL server
• Administering SQL Servers
• Use Ola Hallengren maintenance solution for SQL optimisations and backups
• Performance monitoring
• Optimise the SQL environment for changing workloads
• Database, SQL script performance tuning
• Patching SQL instances with cumulative updates (CUs)
• Designing a software release management process
• Deploying SSIS packages to the cloud
• Deploying staging databases
• Deploying SQL jobs and other automation software
• Producing Legacy physical data models
• Building staging database instances
• Building staging databases, schemas, and table definitions
• Working with developers, data analysts, testers, data architects and business analysts to migrate CRM, document and finance data from legacy systems to new Azure systems (cloud-based systems)
• Legacy databases are SQL Server 2008R2 and Oracle 8i data sources
• SQL Server 2016 is a standard on all cloud SQL Servers
• Use SQL Server Migration Assistant (SSMA) for Oracle
• Designing a method of getting copies of legacy data from a third-party data centre to the SRA cloud environment
• Address SRA's business requirements such as security and application downtime
• Comply with SRA's Managed Services contractual obligations
• Coordinate legacy data movement exercises
• Produce data movement schedules
• Carry out Proof of Concepts
• Setting up Visual Studio Team Services (VSTS) to manage data migration code
• VSTS is a cloud equivalent of Team Foundation Server (TFS)
• Use Redgate Source control to connect data migration databases to VSTS
• Installing SQL Server 2016 on cloud SQL boxes
• Use mount points to install system databases, user databases on separate disk volumes
• Use Active Directory to manage the security of SQL server
• Administering SQL Servers
• Use Ola Hallengren maintenance solution for SQL optimisations and backups
• Performance monitoring
• Optimise the SQL environment for changing workloads
• Database, SQL script performance tuning
• Patching SQL instances with cumulative updates (CUs)
• Designing a software release management process
• Deploying SSIS packages to the cloud
• Deploying staging databases
• Deploying SQL jobs and other automation software
• Producing Legacy physical data models
• Building staging database instances
• Building staging databases, schemas, and table definitions
Security, VSTS, UP, Sql server 2016, Tuning, Team Foundation Server, Visual studio team services, Server, Software, Monitoring, TFS, Ssis, Sql, Visual Studio, Management, Finance, Cloud, Database, Automation, Active Directory, Azure, Oracle, SQL Server, CRM
2017 - 2017
temp
SQL BI DBA/Data Warehouse Developer
unknown.
(Contract)
• Setting up transactional replication for all new dental practices acquired by {my}dentist
• Suggested a cheaper SQL licensing model saving the business significant sums of money
• Improved the processing time of a Dentist pay batch from 10hrs to 1hr
• {my}dentist has 674 transactional replication topologies set up between 674 site SQL instances and a central data
warehouse SQL instance
• Maintaining and supporting transactional replication for all 674 dental practices
• Monitoring replication across the SQL estate
• Enhancing automation of the replication environment
• Engaging Carestream during replication-breaking upgrades
• Influencing Carestream database development practices
• Set up Central Management Server (CMS) to aid the administration of 674 site SQL instances using PowerShell
scripting
• Created databases on all site SQL instances using a single script
• Set up a database maintenance plan on all site SQL instances
• Set up new application users on all site SQL instances using a suite of scripts
• Developed a PowerShell monitoring tool to carry out health checks of all 674 site SQL Servers
• Responsible for creating all database structures required to support the data warehouse development.
• Engaging the business to capture reporting requirements
• Architecting and developing the Enterprise Data Warehouse (EDW) database solution
• Supporting and administration of SQL Server BI stack infrastructure and all site SQL instances
• Managing backups and reviewing the backup policy
• Investigating SQL related performance issues
• Implementing security best practices
• Leading the BI DBA team
• Implementing Self-service BI
• Installing Power BI Desktop application for Business Analysts to use
• Giving Business Analysts access to databases
• Mentoring members of the BI team
• Investigating and piloting advanced analytics using artificial intelligence capabilities (Machine Learning) of SQL
Server 2017
• Setting up transactional replication for all new dental practices acquired by {my}dentist
• Suggested a cheaper SQL licensing model saving the business significant sums of money
• Improved the processing time of a Dentist pay batch from 10hrs to 1hr
• {my}dentist has 674 transactional replication topologies set up between 674 site SQL instances and a central data
warehouse SQL instance
• Maintaining and supporting transactional replication for all 674 dental practices
• Monitoring replication across the SQL estate
• Enhancing automation of the replication environment
• Engaging Carestream during replication-breaking upgrades
• Influencing Carestream database development practices
• Set up Central Management Server (CMS) to aid the administration of 674 site SQL instances using PowerShell
scripting
• Created databases on all site SQL instances using a single script
• Set up a database maintenance plan on all site SQL instances
• Set up new application users on all site SQL instances using a suite of scripts
• Developed a PowerShell monitoring tool to carry out health checks of all 674 site SQL Servers
• Responsible for creating all database structures required to support the data warehouse development.
• Engaging the business to capture reporting requirements
• Architecting and developing the Enterprise Data Warehouse (EDW) database solution
• Supporting and administration of SQL Server BI stack infrastructure and all site SQL instances
• Managing backups and reviewing the backup policy
• Investigating SQL related performance issues
• Implementing security best practices
• Leading the BI DBA team
• Implementing Self-service BI
• Installing Power BI Desktop application for Business Analysts to use
• Giving Business Analysts access to databases
• Mentoring members of the BI team
• Investigating and piloting advanced analytics using artificial intelligence capabilities (Machine Learning) of SQL
Server 2017
Service, UP, Processing, Enterprise, Power, Server, BEE, Health, Backup, Development, Monitoring, Advanced Analytics, Infrastructure, Support, Developer, Security, Sql, Analytics, PowerShell, Management, Data Warehouse, Database, Automation, Mentoring, Scripting, Artificial Intelligence, Power BI, CMS, SQL Server, Machine learning, Administration
2017 - 2017
freelance
SQL BI DBA Consultant
Greencore Group.
(Contract)
• Working with solution architecture and development teams in building, expanding and enhancing the database
structures needed to support a multi-site operational data warehouse using Kimball methodology
• Responsible for creating all database structures required to support the operational data warehouse software
development.
• Use SQL Server 2016
• Use columnstore indexes for analytics processes and relational indexes for transactional processes
• Helping developers develop the most efficient code possible.
• Building automation-compatible change scripts deployed aggressively in development, test and live environments.
• Devised deployment process and documented the same using MS Visio
• Devised database development process and documented the same using MS Visio
• Using new T-SQL language statements such as 'CREATE OR ALTER' for patch scripts
• Supporting and administration of SQL Server BI stack infrastructure
• Managing backups and reviewing the backup policy
• Investigating SQL related performance issues
• Implementing security best practices
• Creating Columnstore indexes on all large tables to aid with analytics
• Working with Cognos developers to tune reports that are performing poorly
• Writing SQL best practice document for all developers to use
• Using TFS in the cloud for database version control
• Working with solution architecture and development teams in building, expanding and enhancing the database
structures needed to support a multi-site operational data warehouse using Kimball methodology
• Responsible for creating all database structures required to support the operational data warehouse software
development.
• Use SQL Server 2016
• Use columnstore indexes for analytics processes and relational indexes for transactional processes
• Helping developers develop the most efficient code possible.
• Building automation-compatible change scripts deployed aggressively in development, test and live environments.
• Devised deployment process and documented the same using MS Visio
• Devised database development process and documented the same using MS Visio
• Using new T-SQL language statements such as 'CREATE OR ALTER' for patch scripts
• Supporting and administration of SQL Server BI stack infrastructure
• Managing backups and reviewing the backup policy
• Investigating SQL related performance issues
• Implementing security best practices
• Creating Columnstore indexes on all large tables to aid with analytics
• Working with Cognos developers to tune reports that are performing poorly
• Writing SQL best practice document for all developers to use
• Using TFS in the cloud for database version control
Architecture, Processes, Sql server 2016, Kimball, Performing, Server, BEE, Software, Backup, Development, Infrastructure, Support, TFS, Security, Sql, Test, Analytics, T-SQL, Visio, Solution architecture, Cloud, Data Warehouse, Database, Automation, Deployment, SQL Server, Writing, Administration
2016 - 2017
freelance
SQL DBA Consultant (Contract)
Ladbrokes Coral.
Supporting and administration of SQL Server BI stack infrastructure
• Managing backups and reviewing the backup policy
• Investigating SQL related performance issues
• Helped the migration of key database applications to SQL Server 2016 enterprise edition
• Created Clustered Columnstore indexes on all large tables
• The affected tables had a record count of between 20 million and 8 billion
• Partitioned large tables to improve housekeeping tasks such as index updates and rebuilds
• Devised a process to partition live table
• There was a requirement to avoid any disruption to the business
• Split table partitions using both existing and new partition schemes on tables with record count ranging from 20 million
to 8 billion
• Devised a process to partition live table
• There was a requirement to avoid any disruption to the business
• Managing backups and reviewing the backup policy
• Investigating SQL related performance issues
• Helped the migration of key database applications to SQL Server 2016 enterprise edition
• Created Clustered Columnstore indexes on all large tables
• The affected tables had a record count of between 20 million and 8 billion
• Partitioned large tables to improve housekeeping tasks such as index updates and rebuilds
• Devised a process to partition live table
• There was a requirement to avoid any disruption to the business
• Split table partitions using both existing and new partition schemes on tables with record count ranging from 20 million
to 8 billion
• Devised a process to partition live table
• There was a requirement to avoid any disruption to the business
Sql, Administration, SQL Server, Database, Infrastructure, Backup, BEE, Server, Enterprise, Sql server 2016
2015 - 2016
freelance
SQL DBA Consultant (Contract)
Computacenter (UK) Ltd.
Supporting and administration of SQL Server database infrastructures complying with ITIL service management
processes for Computacenter customers such as Schroders Plc, VISA, YBS, Channel 4, NFU Mutual, Unison, Hays,
Lehman Brothers, Morrisons, Direct Line Group, TradeTeam.
• Lead SQL DBA for NFU Mutual
• SQL Server Subject Matter Expert on a range of projects such as the ones listed below:
• SharePoint installations and upgrades using database mirroring,
• Cyber Security Project
• PIP Project,
• Calabrio Telephony system using AlwaysOn cluster,
• Fixed Income Analytics Database refreshes on an AlwaysOn cluster,
• Charles River Infrastructure Upgrade,
• Office 0365 Implementation with database mirroring,
• Attending Technical and Business Change Advisory Board (CAB) meetings
• Approving and reviewing Changes
• Reviewing SQL infrastructure architectural designs
• Contributing to SQL infrastructure architectural standards and SQL best practices
• Suggesting service improvements to SQL infrastructure
• Carrying out proactive work to achieve outcomes such as the ones below:
• Automated daily checks
• Reduced Out-of-hours Call Outs
• Reduced Remedy Incidents
• Progressing BAU tasks
• Resolving SQL Incidents particularly P1s for all Computacenter customers
• Investigating SQL Problems for all Computacenter customers
• Mentoring and coaching members of the SQL Database team
processes for Computacenter customers such as Schroders Plc, VISA, YBS, Channel 4, NFU Mutual, Unison, Hays,
Lehman Brothers, Morrisons, Direct Line Group, TradeTeam.
• Lead SQL DBA for NFU Mutual
• SQL Server Subject Matter Expert on a range of projects such as the ones listed below:
• SharePoint installations and upgrades using database mirroring,
• Cyber Security Project
• PIP Project,
• Calabrio Telephony system using AlwaysOn cluster,
• Fixed Income Analytics Database refreshes on an AlwaysOn cluster,
• Charles River Infrastructure Upgrade,
• Office 0365 Implementation with database mirroring,
• Attending Technical and Business Change Advisory Board (CAB) meetings
• Approving and reviewing Changes
• Reviewing SQL infrastructure architectural designs
• Contributing to SQL infrastructure architectural standards and SQL best practices
• Suggesting service improvements to SQL infrastructure
• Carrying out proactive work to achieve outcomes such as the ones below:
• Automated daily checks
• Reduced Out-of-hours Call Outs
• Reduced Remedy Incidents
• Progressing BAU tasks
• Resolving SQL Incidents particularly P1s for all Computacenter customers
• Investigating SQL Problems for all Computacenter customers
• Mentoring and coaching members of the SQL Database team
Service Management, Processes, Server, Office, Advisory board, Infrastructure, Remedy, Implementation, PLC, Security, Service, Sql, Analytics, Management, Database, Mentoring, SharePoint, ITIL, SQL Server, Administration, Coaching
2015 - 2015
temp
Development DBA (Contract)
Next Plc.
Working with the development team in building, expanding and enhancing the database structures needed to support a
large epos platform
• Responsible for creating all database structures required to support epos software development.
• Helping developers understand data structures, and databases, to help develop the most efficient code possible.
• Building automation-compatible change scripts deployed aggressively in development, test and live environments.
• Defining and maintaining data retention policies for databases used in the applications to support the programme of work.
• Developing till and store server data synchronization routines using SSIS.
• Responsible for formulating, maintaining and enforcing SQL standards.
large epos platform
• Responsible for creating all database structures required to support epos software development.
• Helping developers understand data structures, and databases, to help develop the most efficient code possible.
• Building automation-compatible change scripts deployed aggressively in development, test and live environments.
• Defining and maintaining data retention policies for databases used in the applications to support the programme of work.
• Developing till and store server data synchronization routines using SSIS.
• Responsible for formulating, maintaining and enforcing SQL standards.
Sql, Software development, Automation, Database, Test, Ssis, Support, Retention, Development, Software, Server
2013 - 2015
job
Projects DBA
Sainsbury's Plc.
Working closely with a team of Database Administrators in delivering projects into IT Operations adhering to agreed
architectural & security standards.
• Reducing costs of the operation through service improvements making Sainsbury's service best value in class.
• Representing the team on project delivery and taking ownership for the implementation of the solution
• Undertaking all work professionally when assigned ensuring that the work is delivered to plan and budget
• Dealing with complex issues and problems and resolving them quickly. This may involve fixing a production problem
or implementing a new solution.
• Ensuring solutions are continually improved to remove complexity and risk.
• Owning a supplier relationship on a technology ensuring that Sainsbury's get good visibility of product roadmaps and direction and receive appropriate technical input from the supplier
• Undertaking assessments of solutions to ensure that they meet the standards that are set
• Contributing to the technology roadmaps and strategy ensuring designs are operable
• Forming great relationships with internal teams & 3rd parties in order to deliver success
• Coaching and mentoring other technical resources
• Ensuring that the service being delivered is fit for purpose, challenging solutions and highlighting issues along the project life cycle.
• Taking a lead in implementing tasks, carrying out risk analysis, drawing up regression plans and ensuring
configurations are done to best practice.
• Ensuring security policies and processes are defined and adhered to
• Producing all necessary documentation when undertaking work.
• Ensuring Asset Management procedures are applied (hardware and software)
• Ensuring activity time is recorded promptly, accurately and in the appropriate way, maintaining 80% capitalisation
• Recommending and implementing changes to policies and processes used through the infrastructure team
architectural & security standards.
• Reducing costs of the operation through service improvements making Sainsbury's service best value in class.
• Representing the team on project delivery and taking ownership for the implementation of the solution
• Undertaking all work professionally when assigned ensuring that the work is delivered to plan and budget
• Dealing with complex issues and problems and resolving them quickly. This may involve fixing a production problem
or implementing a new solution.
• Ensuring solutions are continually improved to remove complexity and risk.
• Owning a supplier relationship on a technology ensuring that Sainsbury's get good visibility of product roadmaps and direction and receive appropriate technical input from the supplier
• Undertaking assessments of solutions to ensure that they meet the standards that are set
• Contributing to the technology roadmaps and strategy ensuring designs are operable
• Forming great relationships with internal teams & 3rd parties in order to deliver success
• Coaching and mentoring other technical resources
• Ensuring that the service being delivered is fit for purpose, challenging solutions and highlighting issues along the project life cycle.
• Taking a lead in implementing tasks, carrying out risk analysis, drawing up regression plans and ensuring
configurations are done to best practice.
• Ensuring security policies and processes are defined and adhered to
• Producing all necessary documentation when undertaking work.
• Ensuring Asset Management procedures are applied (hardware and software)
• Ensuring activity time is recorded promptly, accurately and in the appropriate way, maintaining 80% capitalisation
• Recommending and implementing changes to policies and processes used through the infrastructure team
It, UP, Processes, Direction, Production, Risk analysis, Software, Hardware, Infrastructure, Implementation, Coaching, Security, Technology, Service, Management, Asset Management, Database, Mentoring, Budget, Operations
2011 - 2012
job
Senior Production DBA
Healthcare at Home Ltd.
Administration of the production and development SQL server environments.
• Monitoring all production SQL servers to ensure baseline parameters for database performance and backups
are met.
• Automation of repeatable tasks such as backups and restores.
• Use of litespeed database backup and restore technology to cope with high volume of data and speed up
database backup and recovery.
• Providing database support for all applications running on Microsoft SQL Server.
• Analysing performance indicators such as systems response times, number of transactions per second to ensure that all
systems are operating efficiently
• Implemented Quest PA for tuning and performance analysis.
• Developed SQL trace templates for different types of performance problems
• Maintaining and setting up new replication environments
• Supporting a peer to peer replication topology between two physical sites
• Acting on change requests and follow ITIL standards adopted by the IT department.
• Working closely with the Applications and Development team to deliver the database components of IT solutions.
• Documentation of all SQL Server configurations, DBA processes and disaster recovery procedures.
• Regular testing of database disaster recovery procedures
• Working on semi automating the disaster recovery process to reduce recovery time.
• Support the Reports team with data queries and issues.
• Wrote log-shipping routines to load additional reporting databases for ad hoc real time reporting.
• Helping to phase out Crystal reports in favour of SQL Server Reporting Services
• Implementing and supporting database clustering for business-critical systems such as MS Dynamics CRM.
• Supervising the junior members of the team and delegating appropriate tasks to them.
• Supervise junior DBAs to perform installations, upgrades, patches across multiple servers and environments
• Helping with the administration of BizTalk clustered servers and BizTalk databases.
• Collaborate with the IT Infrastructure on capacity planning and business critical maintenance work
• Monitoring all production SQL servers to ensure baseline parameters for database performance and backups
are met.
• Automation of repeatable tasks such as backups and restores.
• Use of litespeed database backup and restore technology to cope with high volume of data and speed up
database backup and recovery.
• Providing database support for all applications running on Microsoft SQL Server.
• Analysing performance indicators such as systems response times, number of transactions per second to ensure that all
systems are operating efficiently
• Implemented Quest PA for tuning and performance analysis.
• Developed SQL trace templates for different types of performance problems
• Maintaining and setting up new replication environments
• Supporting a peer to peer replication topology between two physical sites
• Acting on change requests and follow ITIL standards adopted by the IT department.
• Working closely with the Applications and Development team to deliver the database components of IT solutions.
• Documentation of all SQL Server configurations, DBA processes and disaster recovery procedures.
• Regular testing of database disaster recovery procedures
• Working on semi automating the disaster recovery process to reduce recovery time.
• Support the Reports team with data queries and issues.
• Wrote log-shipping routines to load additional reporting databases for ad hoc real time reporting.
• Helping to phase out Crystal reports in favour of SQL Server Reporting Services
• Implementing and supporting database clustering for business-critical systems such as MS Dynamics CRM.
• Supervising the junior members of the team and delegating appropriate tasks to them.
• Supervise junior DBAs to perform installations, upgrades, patches across multiple servers and environments
• Helping with the administration of BizTalk clustered servers and BizTalk databases.
• Collaborate with the IT Infrastructure on capacity planning and business critical maintenance work
Support, UP, Processes, ON, Tuning, Dynamics CRM, Production, Server, Backup, Development, BizTalk, Testing, Monitoring, Infrastructure, Sql, It, Shipping, Technology, Microsoft SQL Server, Database, Microsoft SQL, It infrastructure, Automation, ITIL, SQL Server, CRM, Administration
2007 - 2011
job
DBA Manager
Miranda Technologies.
• Leading and growing the Database Management team.
• Provided technical oversight for over 50 customer-site DBAs and site Engineers.
• Forged strong relations with on site DBAs by visiting sites to discuss and resolve persistent database performance
problems and other related issues.
• Responsible for formulating and enforcing best database design practices with the help of the Development Manager.
• Managed SQL database administration tasks and assignments for over 100 customers spread across all continents.
• Successfully led the team in setting up database maintenance plans for over 80% of our customers as part of the database optimisation and backup effort. Database performance incidents reduced by over 50%.
• Automated repeatable tasks such as Maintenance plans using SQL jobs and notifications/alerts.
• Installing, configuring, administering and securing customers' database production servers.
• Revised the data security policy to recommend a single SQL server access point for each application/service
and an elaborate functional security written in the application layer.
• Troubleshooting and resolving database performance issues using tools such as SQL Profiler (SQL trace), query
execution plans (QEP), trace flags, blocked process reports, deadlock graphs, Dynamic Management Views (DMVs),
Activity monitor and Performance monitor (Perfmon).
• Improved the turn-around time for complex database performance problems from months to weeks by
implementing semi-automated SQL server-side tracing and manipulating trace results in SQL tables.
• Developed SQL trace templates for different types of performance problems
• Implementing and supporting high availability SQL Server solutions that include replication, mirroring and clustering.
• Pioneered strategic change to company policy on database availability to recommend mirroring with a witness
server for all SQL Server 2005 and 2008 installations as a cheaper but effective alternative to clustering.
• Managing and reviewing Omnibus database change request process with particular input from the development teams.
• Spearheaded and improved the turn-around time to prepare SQL patch scripts required for software bug fixes
from weeks to hours by encouraging developers to follow best practices.
• Managing the process of upgrading databases to latest versions and solving related problems such as collation conflicts.
• Proactively reduced the number of database failed upgrades from 1 in 3 to zero by instituting upgrade
simulations, stringent testing measures and documenting solutions to all encountered problems.
• Creating and reviewing scripts, stored procedures so that they are optimised for performance before they are included
in new database releases.
• Quality-testing new database versions in collaboration with the QA team.
• Providing database related training to colleagues and customers.
• Interactively conducted annual professional development training for NRK's DBA team and on demand
training for its Workflow system super-users. Received resounding positive feedback
• Responsible for researching new database technologies and managing the implementation of useful technologies.
• Replication is now used at two customer sites and database mirroring is the de facto standard for our new iTX
product line.
• Designing and implementing Workflow system solutions using Omnibus tools, SQL database and bespoke software.
• Provided technical oversight for over 50 customer-site DBAs and site Engineers.
• Forged strong relations with on site DBAs by visiting sites to discuss and resolve persistent database performance
problems and other related issues.
• Responsible for formulating and enforcing best database design practices with the help of the Development Manager.
• Managed SQL database administration tasks and assignments for over 100 customers spread across all continents.
• Successfully led the team in setting up database maintenance plans for over 80% of our customers as part of the database optimisation and backup effort. Database performance incidents reduced by over 50%.
• Automated repeatable tasks such as Maintenance plans using SQL jobs and notifications/alerts.
• Installing, configuring, administering and securing customers' database production servers.
• Revised the data security policy to recommend a single SQL server access point for each application/service
and an elaborate functional security written in the application layer.
• Troubleshooting and resolving database performance issues using tools such as SQL Profiler (SQL trace), query
execution plans (QEP), trace flags, blocked process reports, deadlock graphs, Dynamic Management Views (DMVs),
Activity monitor and Performance monitor (Perfmon).
• Improved the turn-around time for complex database performance problems from months to weeks by
implementing semi-automated SQL server-side tracing and manipulating trace results in SQL tables.
• Developed SQL trace templates for different types of performance problems
• Implementing and supporting high availability SQL Server solutions that include replication, mirroring and clustering.
• Pioneered strategic change to company policy on database availability to recommend mirroring with a witness
server for all SQL Server 2005 and 2008 installations as a cheaper but effective alternative to clustering.
• Managing and reviewing Omnibus database change request process with particular input from the development teams.
• Spearheaded and improved the turn-around time to prepare SQL patch scripts required for software bug fixes
from weeks to hours by encouraging developers to follow best practices.
• Managing the process of upgrading databases to latest versions and solving related problems such as collation conflicts.
• Proactively reduced the number of database failed upgrades from 1 in 3 to zero by instituting upgrade
simulations, stringent testing measures and documenting solutions to all encountered problems.
• Creating and reviewing scripts, stored procedures so that they are optimised for performance before they are included
in new database releases.
• Quality-testing new database versions in collaboration with the QA team.
• Providing database related training to colleagues and customers.
• Interactively conducted annual professional development training for NRK's DBA team and on demand
training for its Workflow system super-users. Received resounding positive feedback
• Responsible for researching new database technologies and managing the implementation of useful technologies.
• Replication is now used at two customer sites and database mirroring is the de facto standard for our new iTX
product line.
• Designing and implementing Workflow system solutions using Omnibus tools, SQL database and bespoke software.
Workflow, SQL Server 2005 and 2008, SQL Server 2005, LED, Manager, UP, Production, Turn-around, Server, Software, Backup, Development, Testing, Implementation, Design, Security, Service, QA, Stored procedures, Management, Database administration, Optimization, Database design, Database, Training, SQL Server, Administration, Sql
2001 - 2007
job
Software Engineer
ESiT Limited.
• Worked with industry-standard databases such as SQL Server, Oracle, Microsoft Access and MySQL.
• Participated in all aspects of the software lifecycle.
• Participated in all aspects of the software lifecycle.
Mysql, Sql, SQL Server, Oracle, Software, Server
My education
University of Manchester
MSc, Business and IT Requirements for Contact Centres (Minor in Government)
MSc, Business and IT Requirements for Contact Centres (Minor in Government)
Salford University
Somecollege, Computer Science
Somecollege, Computer Science
UMIST
Bachelors, Chemical Engineering
Bachelors, Chemical Engineering
Mpelembe Secondary School
Secondary, Chemistry
Secondary, Chemistry
LUSALE's reviews
LUSALE has not received any reviews on Worksome.
Contact LUSALE SILWAMBA
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to LUSALE directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark