Nielsen Brandbank’s database estate consists of SQL Server databases in several different environments, hosted in Microsoft Azure. The Database Administrator will be responsible for providing support for multiple Database platforms across different environments. Areas of focus will consist of: maintaining performance; incident investigation; configuration and administration; integrity and high-availability.
Kindly submit your resume in English
Job Description
. Contribute to the SQL Database roadmap and strategy for the adoption of cloud technologies.
· Maintain the integrity and performance of all Database platforms across all environments through regular maintenance and monitoring.
· Ensure Backup procedures are in place and available for Disaster Recovery procedures.
· Maintain the high-availability and disaster recovery (HADR) systems including performing failover and failback.
· Provide administration and support for areas surrounding Security, SQL Agent Jobs, SSIS Packages.
· Provide consultancy and code reviews to other areas of the IT department regarding Database design and performance whilst adhering to industry-standard best practices and community recommendations.
· Support and deliver Database related code deployments across all platforms and environments for other IT teams.
· Ensuring adherence to Principle of Least Privilege with regards to security and access permissions in all environments.
· Provide continual performance tuning and optimisation ideas/solution with relevant information/understanding to support them.
· Govern and control Database Source Control policies and adherence.
· Responsible for providing regular Database environment refreshes.
· Working on Projects ranging from small to medium relating to Database platforms.
· Create, maintain and improve upon all Database documentation and processes.
· Provide very occasional Database support outside of normal working hours.