Python Developer developing next generation tools for energy system analysis at Avaron AB. Working with Python, Linux, and modern technologies in an agile team.
About the role
- Database Engineer overseeing the management and migration of databases from Oracle to PostgreSQL cloud environment. Collaborating with DevOps and development teams to ensure performance and reliability.
Responsibilities
- Database and Schema Management: 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
- Cloud Migration: 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
- Change and Release Management: 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
- Analysis and Optimization: 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
- Collaboration and Process Improvement: 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
- Preferred Skills:
- • Experience with Java and Hibernate
- • Experience with Infrastructure as Code (IaC) tools like Terraform
- • Experience working in an Agile development environment
Benefits
- New beginnings can be a challenge. We promise a smooth integration and a supportive mentor
- Pick your working style: choose from Remote, Hybrid or Office work opportunities
- Early bird or night owl? Our projects have different working hours to suit your needs
- Nobody is born an expert. Sharpen your tech skills with our sponsored certifications, trainings and top e-learning platforms
- We want you to stay healthy! Enjoy our Private Health Insurance – it’s custom-made for you
- A clear mind is a healthy mind. Attend individual coaching sessions or go one step further by joining our accredited Coaching School
- Make the most of our epic parties or themed events – they’re lovingly designed for our people and their families
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Senior Product Engineer designing backend systems for parcelLab's post - purchase experience platform. Collaborating with Product and Design teams to ship efficient services for returns experience.
Java Backend Developer creating and improving backend systems for DelfinGroup, a fintech company in Latvia. Focused on delivering reliable code while collaborating with senior engineers.
Java Backend Developer specializing in software development for telco and media solutions at CompaxDigital. Engaging in the software lifecycle and customer collaborations.
Software Engineer creating impactful technology for personal injury law firms. In a hybrid role, you'll build and launch products impacting millions of lives.
Data Engineer designing and scaling data pipelines for tgndata to enhance pricing intelligence. Building robust data solutions while collaborating with development and data teams.
Senior .NET Developer responsible for backend development using C# and .NET in automotive projects. Collaborating with agile teams to ensure high code quality and client satisfaction.
Senior Java Developer at Diadrom developing backend solutions using Java and AWS. Collaborating in agile teams on projects within the Automotive industry.
Mid Backend Engineer responsible for designing and maintaining backend systems for market - leading automotive payment platform. Collaborating with teams to deliver high - quality software solutions.
Java Developer overseeing the development of scalable enterprise applications. Leading a team and driving innovation through best practices in a consulting firm.