Working as part of an in-house DBA team, the primary objective is to oversee and maintain all aspects of Cromwells database estate. This encompasses our on-prem UK & 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 & 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 & 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 & hands-on experience of Linux OS (Red hat).
* Extensive experience of PostgreSQL:
o Proven experience of HA & DR configurations.
o Excellent ability in supporting & creating SQL code.
* Useful to have experience of using Pipeline & ETL tools such as Snap Logic, Talend or MuleSoft:
o Ability to handle data in various formats (CSV, XML & JSON)
o Familiarity with API integration & 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.
Wef re all individuals, yet were 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.
Information for Recruitment Agencies
We always prefer to recruit candidates direct to our business and first, and foremost believe in promoting talent from within whenever possible.
We do not accept speculative approaches including CVs and candidate profiles sent direct to Managers, by receipt of any such email or correspondence, we do not agree to terms and conditions. Any speculative CVs will be considered our own and we will not pay any agency fees.
We have a PSL and those on this will have access to our portal to accept CVs. Should you want to be considered for our PSL, please email talentacquisition@cromwell.co.uk
#J-18808-Ljbffr