Database Engineer

Role overview

Key responsibilities

• Design and maintain database schemas, data models and structures for application and reporting needs.
• Develop and optimise SQL queries, stored procedures, functions and indexing strategies.
• Monitor performance, troubleshoot bottlenecks and plan capacity.
• Build and maintain data integration, migration and ETL/ELT processes across sources.
• Implement data validation, integrity and reconciliation controls.
• Configure and test backups, restoration, replication and disaster recovery.
• Manage access, permissions, encryption and audit logging with security teams.
• Support deployments, version upgrades, patching and controlled schema changes.
• Work with developers and analysts on transactional systems, reporting and analytics.
• Maintain documentation and automate routine administration and monitoring.

Qualifications and experience

• Bachelor’s degree in computer science, information technology, engineering or a related discipline.
• At least 5 years of hands-on database engineering, development or administration experience.
• Strong expertise in relational databases such as Microsoft SQL Server, PostgreSQL or MySQL.
• Advanced SQL, including query tuning, indexing, execution plans and transaction management.
• Experience with database migration, integration and production support.
• Knowledge of backup and recovery, high availability, access control and data security.
• Experience with cloud-hosted and/or on-premises databases.
• Strong troubleshooting, documentation and collaboration skills.

Preferred experience

• Data warehouses, dimensional modelling and analytical workloads are preferred.
• NoSQL databases and scripting with Python, PowerShell or similar tools are preferred.
• Supporting multi-tenant enterprise platforms and large datasets is preferred.
• Relevant database or cloud certifications are preferred.