Senior Database Engineer ETL

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 optimise 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.

• Mandatory Skills Description:

  • 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 Skills Description:

  • 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