Job Overview
We are seeking an experienced Database Administrator to join our team and provide specialist development, technical services, and support for our database management capabilities. The ideal candidate will have a strong background in MS SQL database administration, including installation, configuration, and maintenance of high-availability and performance.
Key Responsibilities
* Install, configure, and maintain MS SQL database instances ensuring high availability and performance.
* Monitor and manage database performance, replication, identifying and resolving performance bottlenecks using index tuning, DVM, and third-party monitoring tools.
* Develop, implement, and manage database clustering, maintenance plans, including automated backups and disaster recovery strategies.
* Manage security configurations, including certificate management and access control.
* Manage and optimise SSAS/SSIS/SSRS and Power BI reporting environments.
* Troubleshoot and resolve performance issues across hybrid and cloud environments, optimising configurations to enhance efficiency on Azure, AWS.
* Maintain comprehensive documentation for all database configurations, changes, and procedures for both on premises and cloud environments.
Requirements
* Experience: 7+ Years in a similar role.
* Platforms: Practical experience with Microsoft SQL Server products, including Always-On Availability Groups and Azure SQL databases.
* Programming: Strong SQL/T-SQL, PowerShell to support the SQL Server software and automate daily database management activities.
* Skills: Strong problem-solving, proactive approach to database management, and excellent communication skills.
* Azure and DevOps: Experience with DevOps processes and tools such as Azure DevOps and Git, Azure SQL Databases.
* Other: Experience with SQL Database development.
Desirable Qualifications
* Proven track record of delivering high-quality database solutions.
* Strong understanding of database architecture and design principles.
* Familiarity with continuous integration and delivery pipelines.
* Ability to work effectively in a fast-paced environment.
* Excellent analytical and problem-solving skills.