Senior Database Engineer with Strong Admin Skills (PostgreSQL & Oracle)
Project description
Join our Development Center in Bucharest, and become a member of our open-minded, progressive and professional team. In this role you will be working on projects for one our world famous clients. You will have a chance to grow your technical and soft skills, and build a thorough expertise of the industry of our client. On top of attractive salary and benefits package, Luxoft will invest into your professional training, and allow you to grow your professional career.
Responsibilities
- We are seeking an experienced and proactive Database Engineer with Admin Skills to join our technology team. The successful candidate will be responsible for the management, optimization, and migration of our Client's application database schemas. This role is essential in ensuring the performance, reliability, and scalability of our Client's database environment, as they 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 Client's DevOps and application development teams. Key Responsibilities:
- Database and Schema Management: o Oversee the administration of approximately 6 database schemas on Oracle databases, ensuring their stability and performance. o Manage the lifecycle of database schemas, including the provisioning of new schemas and the orderly decommissioning of obsolete ones.
- Cloud Migration: o Take part in leading and execution on the planned migration of our Client's database environment from Oracle to Cloud SQL for PostgreSQL. o Develop and implement migration strategies, ensuring data integrity and minimal downtime.
- Change and Release Management: o Supervise and review all changes made to database schemas, including the analysis of change and rollback scripts, utilizing tools like Liquibase. o Collaborate with the DevOps team to integrate and improve the schema update process within our Client's CI/CD pipelines.
- Analysis and Optimization: o Conduct regular analysis of database usage patterns to identify and propose optimization opportunities, such as the creation of indexes, partitions, views, and constraints. o Proactively analyze and identify discrepancies between different database schemas, proposing and implementing changes for alignment and standardization. o Recommend and implement schema and query changes to enhance database performance.
- Collaboration and Process Improvement: o Work closely with application development teams to provide expert guidance on database best practices. o Partner with the DevOps team to streamline and automate the deployment and management of database changes.
SKILLS
Must have
- Proven experience as a Database Administrator, Database Engineer, or in a similar role.
- Strong proficiency in managing PostgreSQL databases.
- Demonstrable experience with database migration projects, preferably from Oracle to a cloud-based solution like PostgreSQL.
- Hands-on experience with cloud database services (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.
Nice to have
• Experience with Java and Hibernate • Experience working in an Agile development environment.
