SQL Database Administrator SQL Tuning - Connexa : Job Details

SQL Database Administrator SQL Tuning

Connexa

Job Location : London, UK

Posted on : 17/11/2024 - Valid Till : 05/01/2025

Job Description :

About the RoleWe are looking for a development-focused SQL DBA to join our IT Development team. In this role, you will provide essential support to our development teams by offering advice, guidance, and quality assurance on database-related tasks. A key part of the role will involve identifying and resolving non-performant SQL queries, ensuring smooth operations and high performance across our systems. Working closely with the Senior DBA, you will contribute to maintaining a reliable and secure SQL Server estate, ensuring it operates efficiently and securely. This is a fantastic opportunity for someone with a passion for databases and performance tuning to make a tangible impact.

Working Structure (Mostly remote)This business is based in Dartford, Kent, and is open to people mostly remote. The onsite requirement would come if there was a project, in-person meeting, or company event. They expect the onsite working requirements to be as a minimum of 2 to 3 days per month.

Main Duties* Identify and resolve poorly performing SQL queries by restructuring them, adjusting indexes, or providing alternative solutions.* Advise the development team on best practices for writing SQL queries and ensuring efficient design.* Offer guidance to development teams when designing new systems from a SQL perspective.* Assist the Senior DBA in the management and maintenance of SQL Server databases and processes.* Ensure optimal system performance, availability, and security by proactively monitoring the system's health.* Troubleshoot issues in real-time, resolving them or providing recommendations for resolution.* Help implement and control SQL security policies in collaboration with the Head of Development.* Automate routine tasks, track system issues, and document any changes to ensure smooth operations.* Carry out scheduled maintenance tasks, including those requiring out-of-hours attention.

What Are We Looking For?We are seeking a proactive and detail-oriented Application DBA who thrives in a development-focused environment. The ideal candidate should be passionate about optimising database performance and have strong communication skills to work collaboratively with development teams. Key requirements include:* Experience with SQL Server databases and processes.* Strong ability to identify and resolve poorly performing queries.* Knowledge of best practices for SQL query writing and database design.* Experience in monitoring and maintaining database performance, availability, and security.* Familiarity with implementing security policies and automating database processes.* Problem-solving skills, especially under real-time pressure.

SummaryThis is an exciting opportunity for a DBA to play a key role in optimising our database performance and providing vital support to development teams. You will work closely with the Senior DBA to ensure our SQL Server estate is secure, reliable, and performing at its best. In return, we offer a collaborative work environment that values innovation and personal growth. If you're passionate about database management and looking for a new challenge, we'd love to hear from you

Established in Didsbury, Connexa Technology Ltd is becoming one of the UK's fastest growing IT and Technology recruitment companies.

People. Technology. Connected.

Connexa Technology is acting as an Employment Agency in relation to this vacancy.

Salary : 45000 - 55000

Apply Now!

Similar Jobs ( 0)