Database Administrator (Contract)
· Responsibility for the effective management, data integrity and performance of the companies Reporting and SQL Server environments
· Carry out reporting and data related requests as part of the BAU and individual project streams
· Database administration and maintenance tasks including capacity planning, security and integrity planning, index generation, performance tuning (including ETL and stored procedures) and any other associated administration processes
· Troubleshooting failures of implemented processes, including those designed and implemented by other Developers or external resources
· Ensure adherence to Change Management practices, including source and version controls
· Ensure related documentation is informative and kept up to date
· Work with IT Infrastructure and Operations teams to ensure backup, business interruption and disaster recovery plans are developed, tested and maintained for SQL Server environments
· Work with third parties to deploy changes to data structures and content
· Effective management of own workload
· Provide consultancy to colleagues (team, departmental and project) regarding Reporting, SQL, ETL and database development, automation of monitoring and housekeeping tasks and SQL server upgrade planning
· Experience of GIT source control would be useful
· Knowledge of Azure PAAS and Azure Availability groups
· Experience of data migration from On Premise to Azure