Job Description

IT Database Administrator
Chelmsford
Full–time
PCD310164

Job description
Kennedys is looking for a IT Database Administrator to join our IT team.

Required experience
• Proven experience managing technical and support teams in a fast-paced, high-pressure environment, with an emphasis on business-critical systems.
• A major technology provider relational database software On-Premises, a major public-cloud platform database-query languages Virtual Machine, a major public-cloud platform Managed Instance and a major public-cloud platform database-query languages Database.
• Experience of managing databases, focusing on security, performance, scaling and cost optimization.
• Implementing and maintaining backup, database integrity checks and index maintenance jobs.
• Configuring custom integrations mainly using Transactional database-query languages, function and Stored procedure.
• Familiar with Blocking, Caching and Wait Statistics methodologies when troubleshooting performance.
• Using Extended Events and Query Store.
• Analysis and assessing datasets used by business intelligence software reports.
• Ingesting data into a major technology provider Fabric using a major public-cloud platform Data Factory.

Key responsibilities
• Work as part of a team to provide adequate coverage for all critical systems across the business.
• Maintain a comprehensive understanding of the functionality provided by supported applications and their use within the organization.
• Understand software architecture for selected applications to influence database architecture and design for efficiency and reliability.
• Provide database design specifications and develop/implement solutions as required.
• Design, develop, and support bespoke database-level solutions, including interfaces, data extracts and integrations with other applications.
• Extract, transform and maintain data to support data analytics and reporting needs
• Work with internal and external teams to advise and assist in performance tuning for both internally and externally facing systems, ensuring optimal performance and user experience

IT Database Administrators are responsible for ensuring the reliability, efficiency, and security of our critical databases and applications. This role involves collaborating with various stakeholders, maintaining a thorough understanding of the software architecture, and influencing database design to support business continuity and disaster recovery strategies. This includes also managing supplier relationships and providing third-line support to colleagues and the wider business.