Senior Database Engineer ETL

We are seeking a skilled and proactive Senior Database Engineer ETL to join the team at Luxoft. This role involves designing, implementing, maintaining, and optimizing database systems for global geoscience data products and services. Key responsibilities include building and maintaining ETL workflows, database replication, and synchronization, ensuring high availability, performance, and security of database systems, and collaborating with development and DevOps teams.

Must Have

• Design, implement, maintain, and optimize database systems.
• Build and maintain ETL workflows, database replication, and synchronization.
• Administer, monitor, and optimize SQL Server and/or PostgreSQL databases.
• Perform regular database backups, recovery testing, and disaster recovery planning.
• Implement and maintain database security protocols.
• Collaborate with data engineers, developers, and business stakeholders.
• Apply monitoring and logging tools to identify and remediate issues.
• Maintain comprehensive documentation of database configurations.
• Ensure compliance with internal data governance and external regulatory requirements.

Good 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).
• 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.

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

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

##### Other

Languages

English: B2 Upper Intermediate

Seniority

Senior