Overview

Database Administrator (7069) at Cromwell Tools ExportPurpose Of Role: Working as part of an in-house DBA team, the primary objective is to oversee and maintain all aspects of Cromwell’s database estate. This encompasses our on-prem UK and Global business operations and supporting a steady migration into cloud hosted solutions. This role further consists of supplemental data engineering duties in support of data and process management. To be successful in this role, hands on experience with PostgreSQL is essential. An ability with ETL and Integration technology is a distinct advantage.Responsibilities

Database Management: Manage and maintain the organization''s databases, ensuring their availability, security, integrity, and performance.Backup and Recovery: Implement and manage backup and recovery processes to protect data against loss or corruption.Security: Enforce database security policies and access controls to protect sensitive data from unauthorized access.Performance Tuning: Monitor database performance and optimize SQL queries, indexes, and configurations for improved efficiency.High Availability and Disaster Recovery: Implement strategies for high availability and disaster recovery to minimize downtime and ensure business continuity.Patch Management: Apply database patches and updates to address security vulnerabilities and improve stability.Capacity Planning: Forecast database growth and plan for additional capacity requirements to accommodate future data needs.ETL Development: Develop and maintain Extract, Transform, Load (ETL) processes to integrate data from various sources into the organization''s data warehouse and lake.Data Pipeline Development: Build data pipelines to automate the flow of data between systems, ensuring reliability, scalability, and efficiency.Required Skills and Experience

Previous commercial experience as a DBA in a multi-tech database environment.Proven track record in managing large deployments, DR and HA database environments.A good understanding and hands-on experience of Linux OS (Red Hat).Extensive experience of PostgreSQL with HA and DR configurations and SQL code development/support.Experience with Pipeline and ETL tools such as Snap Logic, Talend or MuleSoft is useful.Ability to handle data in various formats (CSV, XML and JSON) and familiarity with API integration and data mapping.About Cromwell

Cromwell has been around for over 50 years, supplying an unrivalled choice of cutting tools, power tools, hand tools and safety equipment into all industries, professions and trades. We offer next day delivery or collection from our nationwide branch network, supported by an overnight UK logistics operation. Our team of over 1500 people are proud to be keeping industry working.We’re all individuals, yet we’re very much one united team. We treat everyone fairly – regardless of gender, sexual orientation, background, age or disability – and give everyone opportunities for new and varied experiences. Inclusion means not just accepting people for who they are, but showing respect and making adjustments to help people and remove all barriers; it’s about creating a culture where everyone is respected, empowered and able to realise their full potential.Cromwell is committed to being an Equal Opportunity Employer . We welcome applications from all suitably qualified candidates, regardless of their race, gender, disability, religion/belief, sexual orientation, or age. We are also committed to offering applicants from the armed forces community (current and past) an interview if they meet the minimum requirements for the role.

#J-18808-Ljbffr