databases to ensure optimal performance, security, and reliability. You will be responsible for maintaining the company's database systems, performing database backups and recovery, and providing technical support to end-users.
The DBA will also work closely with other IT & Business Intelligence colleagues to ensure that the database environment is in line with our goals and objectives.
What that means day-to-day:
- Manage and maintain the company's databases, including monitoring their performance and security.
- Design and implement database backup and recovery strategies to ensure data protection and disaster recovery.
- Troubleshoot and resolve database-related issues and work with end-users to resolve application level problems.
- Perform database tuning and optimization to ensure the highest levels of performance.
- Authoring and revising SQL statements (queries, stored procedures, triggers, etc.). Leveraging AI assistance wherever possible.
- Manage database security, including creating and maintaining user accounts, assigning roles and privileges, and monitoring access logs.
- Work closely with other IT staff to ensure that database environments are aligned with organisational goals and objectives.
- Develop and maintain database documentation, including data dictionaries, data flow diagrams, and system diagrams.
- Stay up to date with emerging database technologies and industry trends.
What you’ll need to be successful:
Essential
- Minimum of 5 years of experience as a DBA or in a similar role.
- Experience with database administration tools such as Oracle, MySQL, and SQL Server.
- Experience with database backup and recovery strategies, including point-in-time recovery and full system backups.
- Experience with cloud-based database technologies such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud , Platform (GCP)
- Experience with database tuning and optimisation, including index creation, query optimisation, and storage allocation.
- Understanding of database security principles, including authentication, authorisation, and encryption.
- Strong problem-solving and analytical skills.
- Ability to work well in a team environment. ·
Desirable
- Knowledge of database automation tools such as Puppet, Chef, or Ansible
- Familiarity with Big Data technologies such as Hadoop, Apache Spark, or NoSQL databases
- Understanding of data warehousing schemas designs and concepts · Understanding of Business Intelligence (BI) concepts and tools (PowerBI, Tableau, etc.)
- Knowledge of scripting languages such as Python, Perl, or PowerShell
- Experience with data migration and integration tools such as SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI), AWS Glue, AppFlow, etc.
- Experience using AI assisted SQL coding tools (i.e. Copilot or others)
What you’ll get in return:
>🩺 Comprehensive medical and dental coverage
- A response to your application within 15 working days
- An interview process consisting of:
- An initial discovery call with the recruiter
- A first stage interview via Microsoft Teams
- Additional interview with the stakeholders you’ll be working with closely in the role
