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
Senior Database Engineer at Verizon responsible for SQL Server management and NoSQL migration. Involves production support, troubleshooting, and collaborating with application teams.
CitiRisk Credit Technology is seeking a Senior Vice President to lead architectural design and strategic implementation of software solutions. Position involves hands - on coding exceeding 50% of time.
Lead Software Engineer developing core components of high - performance applications for Morgan Stanley. Collaborating with cross - functional teams and enhancing existing components using modern Java practices.
Lead Full Stack Engineer at CoverGo managing development lifecycle and AI integration in our SaaS platform. Oversee team performance and drive innovative solutions in insurance technology.
Lead Full Stack Engineer at CoverGo overseeing development of insurance SaaS solutions. Mentoring engineering teams and collaborating with stakeholders to align technical solutions with business goals.
Software Developer at Kneat enhancing their paperless solutions through backend development and Elasticsearch proficiency. Collaborating with an Agile team in a fast - paced R&D environment.
Senior Software Developer - Backend specializing in Elasticsearch for Kneat's R&D team. Collaborating in Agile environment to enhance product suite and solve complex user problems.
Staff Backend Engineer at SafetyCulture responsible for technical direction of identity and access control systems. Leading architecture decisions and ensuring security for the cloud engineering team.
Back - end Software Engineer developing and enhancing clinical data repositories and APIs at Orion Health. Contributing to engineering best practices and mentoring junior engineers in a hybrid working environment.
Backend Developer at CI&T focusing on APIs and services for a leading Brazilian retailer. Responsible for backend solutions with a strong emphasis on security and integration.