This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are seeking an experienced and proactive Database Engineer to join our technology team. The successful candidate will be responsible for the management, optimization, and migration of our application database schemas. This role is essential in ensuring the performance, reliability, and scalability of our database environment as we transition from on-premise Oracle databases to a cloud-based PostgreSQL infrastructure. The ideal candidate will have a strong background in database administration, a deep understanding of cloud database technologies, and a collaborative mindset to work effectively with our DevOps and application development teams.
Job Responsibility:
Oversee the administration of approximately 24 application schemas on Oracle databases, ensuring their stability and performance
Manage the lifecycle of database schemas, including the provisioning of new schemas and the orderly decommissioning of obsolete ones
Lead and execute the planned migration of our database environment from Oracle to Cloud SQL for PostgreSQL
Develop and implement migration strategies, ensuring data integrity and minimal downtime
Supervise and review all changes made to database schemas, including the analysis of change and rollback scripts, utilizing tools like Liquibase
Collaborate with the DevOps team to integrate and improve the schema update process within our CI/CD pipelines
Conduct regular analysis of database usage patterns to identify and propose optimization opportunities, such as the creation of indexes, partitions,views, and constraints
Proactively analyze and identify discrepancies between different database schemas, proposing and implementing changes for alignment and standardization
Recommend and implement schema and query changes to enhance database performance
Work closely with application development teams to provide expert guidance on database best practices
Partner with the DevOps team to streamline and automate the deployment and management of database changes
Requirements:
Bachelor’s degree in Computer Science, Engineering, or related field
At least 5 years of experience as a Database Administrator, Database Engineer, or in a similar role
Strong proficiency in managing Oracle databases
Demonstrable experience with database migration projects, preferably from Oracle to a cloud-based solution like PostgreSQL
Hands-on experience with cloud database services (e.g., Google Cloud SQL, AWS RDS, Azure Database for PostgreSQL)
Experience with database change management tools such as Liquibase
Solid understanding of SQL and procedural database languages (e.g., PL/SQL, PL/pgSQL)
Experience with database performance tuning and optimization techniques
Familiarity with DevOps principles and practices related to database management
Excellent analytical and problem-solving skills
Strong communication and collaboration abilities in English
Nice to have:
Experience with Java and Hibernate
Experience with Infrastructure as Code (IaC) tools like Terraform
Experience working in an Agile development environment
What we offer:
Smooth integration and a supportive mentor
Pick your working style: choose from Remote, Hybrid or Office work opportunities
Projects have different working hours to suit your needs
Sponsored certifications, trainings and top e-learning platforms
Private Health Insurance
Individual coaching sessions or accredited Coaching School