DatabaseAdministrator(Contract)
Responsibilityfor the effective management data integrity and performance of thecompanies Reporting and SQL Serverenvironments
Carry outreporting and data related requests as part of the BAU andindividual projectstreams
Databaseadministration and maintenance tasks including capacity planningsecurity and integrity planning index generation performance tuning(including ETL and stored procedures) and any other associatedadministrationprocesses
Troubleshootingfailures of implemented processes including those designed andimplemented by other Developers or externalresources
Ensure adherenceto Change Management practices including source and versioncontrols
Ensure relateddocumentation is informative and kept up todate
Work with ITInfrastructure and Operations teams to ensure backup businessinterruption and disaster recovery plans are developed tested andmaintained for SQL Serverenvironments
Work with thirdparties to deploy changes to data structures andcontent
Effectivemanagement of ownworkload
Provideconsultancy to colleagues (team departmental and project) regardingReporting SQL ETL and database development automation of monitoringand housekeeping tasks and SQL server upgradeplanning
Experience ofGIT source control would beuseful
Knowledge ofAzure PAAS and Azure Availabilitygroups
Experience ofdata migration from On Premise to Azure