SQL Database Administrator

**Brennan. Where true performance thrives.**
At Brennan, we believe that _how_ technology is delivered is every bit as important as _what_ the technology is. We focus on creating real and relevant value for customers with solutions that fit their specific needs and always reflect their true interests.
It’s a claim backed by our **True Performance System** - a way of working engineered to get us closer, and deliver better, for our customers and their actual experience of technology.

**Why join Brennan**
True performance for our customers starts with a true belief in our people.
It’s why we’ve structured our business to help our teams, and their talents, shine bright. It's why we’ve created a workplace where people of all backgrounds, beliefs and experiences are welcomed and empowered. And it’s why we’ve built an organisation where real innovation makes a genuine impact and generates true rewards for our team members.

**True rewards**
In addition to competitive remuneration, Brennan offers extensive benefits, including:

- Training and certification bonuses
- Culture Awards that recognise excellence
- Brennan Daredevils - our annual, all-expenses paid trip awarded to our top performers and outstanding contributors
- Vibrant, fun social activities
- Discounted hardware and software
- An environment that embraces learning and development

**The Role**

The Database Administrator operates on incidents, alerts and client projects as well as providing level 2 support to the VDBA Support team to support clients. A Database Administrator will monitor client database operational functions and statistics, report issues and potential impacts to the business and provide solutions to optimise performance.

**Role Responsibilities**
- Receiving and handling requests for support following agreed procedures.
- Responding to requests for support by providing information to enable incident resolution and promptly allocating unresolved calls as appropriate.
- Monitor and optimize performance by tracking resource usage (CPU, memory, I/O) with tools like Performance Monitor, Extended Events, and Azure Monitor, addressing slow-running queries with indexing and schema refinements, and leveraging Azure SQL Intelligent Insights for automated tuning.
- Develop and maintain backup and recovery processes, including full/differential/transaction log backups on-premises and point-in-time backups in Azure SQL, automating jobs with SQL Agent or Azure Automation, and regularly testing restore procedures to validate data integrity.
- Enforce security and compliance by configuring user access and permissions (least privilege model) and implementing encryption.
- Perform routine maintenance and capacity planning through index rebuilds/reorganizations, integrity checks (DBCC CHECKDB), monitoring data growth (DTUs, vCores), and automating tasks with SQL scripts, Azure Logic Apps, or Azure Automation.
- Coordinate and implement database changes by reviewing schema modifications, releases, and data migrations, assessing risks, creating rollback plans, adhering to change control processes.
- Provide guidance, documentation, and on-call support by advising stakeholders on design and best practices, maintaining clear records of configurations and procedures (including Azure resources), and participating in on-call rotations to address critical incidents.

**Key Competencies**
- Minimum 7+ years’ experience in a MS SQL Support and / or delivery role
- Proven experience across multiple Microsoft SQL Server environments
- Data Analytics skills favourably considered
- Preferred experience in Microsoft SQL Server to Current Version
- Preferred Microsoft Technology Associate (MTA) certification to MCSE or equivalent Level
- Azure Experience viewed favourably
- Previous experience in a similar support DBA role
- Strong client focus
- Strong communication skills to build and maintain positive relationships with team members and clients
- Ability to prioritise tasks, demonstrate initiative and meet deadlines

**Brennan**is an equal opportunity employer.