We are transitioning from an Oracle based organization and need your help to convert the current data bases into AWS and Azure based SQL instances. We are therefore looking for an experienced “hands on” SQL/Oracle DBA who will be responsible for managing databases, creating data processing products, ensuring their stability, reliability, and performance.
A collaborative, communicative approach to working with colleagues from both the development team and operational teams is essential. The role will work within the Infrastructure & Operations department, providing technical MS SQL / Oracle expertise to support the aims and objectives of the IT department.
This position would suit a SQL DBA who has familiarity with the cloud and is looking to develop their skill set within both cloud and automation. The successful DBA will possess the following skills and experience:
Experience in all aspects of database maintenance and management with versions of MS SQL Server up to 2016 and beyond, including:
Administering, managing & maintaining very large databases
Excellent performance tuning and troubleshooting skills
Support the business via a support call system, resolving logged support calls within agreed SLAs
Performing proactive monitoring of the SQL Server estate, ensuring system availability and performance, including health checks and reviews
The role will involve a diverse split between BAU & projects work, which will include working with both on-premise and Cloud based systems (mixture of vendor / internally developed)
ETL - SSIS (Data Factory preferable)
Data warehousing - SSAS (Analysis Services in Azure preferable)
SSRS & Power BI
SQL Server HA / DR
A working knowledge of Oracle would be highlight advantageous as well as cloud (Azure & AWS)
Oracle Database installation and configuration (Oracle Partitioning).
OS and Hypervisor installation and configuration (Windows, Oracle Linux & OVM).
Database and OS Patching and Upgrades.
Data Migrations and Data Replication
Oracle Performance monitoring and tuning.
System monitoring and management using OEM.
The DBA is responsible for the performance, integrity and security of the databases:
Create and maintain databases and objects such like tables, stored procs, views, triggers
Responsible for the development and improvement of our reporting capabilities
Establish the needs of users and monitor the user-access model.
Monitor the performance and manage parameters on a daily basis
Manager DR, develop and manage back-ups, construct recovery plans.
Write and optimize in-application using SQL statements
Ensure performance, security and integrity of the databases
Handle common database procedures such as upgrade, backup, recovery, migration
Profile server resource usage, and optimize as necessary
Collaborate with other team members and support other Developers
Work well with ever-changing processes to meet our client's needs and requests
The Ideal Candidate:
As well as being technically minded with an aptitude for problem-solving, is able to work on their own initiative and is confident delivering to tight deadlines. Good organisational and communication skills are essential
Holland & Barrett is one of the nation's most loved and trusted brands, known for offering quality health food, vitamins and supplements all sold by highly trained and qualified advisors.
Bucking the current trend of high street retailers, we forecast significant growth and expansion plans in the coming years, with considerable investment going into all areas of the business. We certainly embrace change and drive speed in everything we do. Every day presents a different challenge, but every day is also filled with fun, teamwork and passion to succeed and surpass every expectation.
Join us and see how far you can go…