PostgreSQL Developer (with 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 to join our technology team. The successful candidate will be responsible for the migration and optimization 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-premises Oracle databases to a cloud-based PostgreSQL infrastructure. The ideal candidate will have a strong background in working with the database, 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:

Cloud Migration:

• Take a significant part of the planned migration of our Client's database environment from Oracle to Cloud SQL for PostgreSQL.
• Develop and implement migration strategies, ensuring data integrity and minimal downtime.

Collaboration and Process Improvement:

• Employ a range of techniques to analyze problems and evaluate multiple solutions against engineering, business & strategic criteria.
• Collaborate to achieve consensus on topics and issues and contribute to communities

Identify and resolve barriers to business deliveries implementing solutions which iteratively deliver value.

• Design solutions using common design patterns with a range of design tools & techniques.
• Conduct peer reviews to ensure designs are fit for purpose, extensible & re-usable.
• Deliver end-to-end first-class engineering solutions across a range of technology platforms.
• Improve delivery standards, working practices, tools & solutions and driving adoption of automation tools.
• Ensure stable and reliable production environments and high-quality service delivery to customers.
• Investigate production incidents & lead remediation, analyze services & components.
• Design & build solutions which are secure & controlled.
• Investigate & report on issues and potential risk events within designs and solutions

Skills

Must have

• Excellent technical skills in PostgreSQL.
• Strong understanding of relational databases.
• Ability to design and develop application/components including packages, store procedures, functions, triggers.
• Experience in working with Oracle SQL and PL/SQL.
• Proficiency in scripting languages such as Python or Shell scripting.
• Proficiency in data modelling and database design.
• Open to learn Google Cloud technologies.
• Data analysis general skills.
• Analytical thinker experienced in a range of problem-solving techniques & approaches.
• Team player who shares and collaborates, a keen listener and quick learner.
• Communicates clearly and influences using coherent, fact and benefit-based proposals.
• Enables experimentation and fast learning approaches to creating business solutions.
• Understands key elements of security, risk & control

Nice to have

• Experience in banking projects.
• Experience with Agile development environment.

Languages

English: B2