Project description

We are seeking a skilled and proactive Database Engineer to join the team. Reporting to the Team Lead the Database Engineer will be responsible for the design, implementation, maintenance, and performance of our database systems, which support global geoscience data products and services as part of a SaaS offering. This role requires a strong focus on building and maintaining ETL workflows, database replication, and synchronisation.
Successful candidates will be evidently enthusiastic and motivated people who we can train up in our processes and ultimately play a key role in quality assurance initiatives across different stakeholder groups.

Responsibilities

Database Architecture and Development

Database design and modelling, including schema design and relationship modelling

Write and optimize stored procedures, views, and functions for performance

Proficient in ETL and related tools

Experience with database replication and synchronisation

Database Management & Maintenance

Administer, monitor, and optimize SQL Server and/or PostgreSQL databases.

Perform regular database backups, recovery testing, and disaster recovery planning alongside DevOps team members

Ensure high availability and performance of database systems.

Data Integrity & Security

Implement and maintain database security protocols, including access controls and encryption alongside DevOps team members to ensure alignment with SOC2 standards

Monitor for potential vulnerabilities and apply patches and updates as needed.

Development Support

Collaborate with data engineers, developers, and business stakeholders to support data workflows, data delivery and application development.

Performance Tuning & Troubleshooting

Apply monitoring and logging tools to identify and remediate issues

Monitor system health and respond to alerts and incidents alongside DevOps team members

Documentation & Compliance

Maintain comprehensive documentation of database configurations, processes, and procedures.

Ensure compliance with internal data governance and external regulatory requirements.

Skills

Must have

Proven experience as a Database Engineer, Architect, or DBA, ideally in a scientific or data-intensive environment.

Strong knowledge of relational database systems (e.g., SQL Server, PostgreSQL).

Extensive experience in designing and building relational databases

Excellent problem-solving and communication skills.

Nice to have

Experience with AWS cloud-based database solutions.

Experience with Databases as Code

Understanding of data lifecycle management and SOC2 security standards.

Familiarity with geoscience disciplines, geospatial data and GIS tools (e.g., ArcGIS, QGIS) is advantageous.

Scripting and automation (e.g., PowerShell, Python).

Experience with Gitlab.

Knowledge of Spotfire data visualization platform or alternative dashboard solutions.

Awareness of Agile delivery methodologies.

Languages

English: B2 Upper Intermediate