Strong Associate Postgres DBA (only HU, PL, BG, RO)

About Our Project:
For now, it is a fixed-time assignment related to the DB modernization.
The projected length is June-September 2023.
There is a strong possibility that a team member can be kept beyond September.
During the Project the DBA will be responsible to use AWS SCT (schema conversion tool), DMS (Data Migration system) tools & other scripts (5-10%) (Python/shell scripting) to migrate schemas and data from Oracle databases to RDS Postgres.

Project Tech Stack:
AWS SCT, DMS tools & other scripts to migrate schemas and data from Oracle databases to RDS Postgres

Project Stage:
Sourcing


Project delivery process:
Daily meetings – 4 pm CEST (30 min)
Weekly status on Mondays at 3.30 or 4 pm CEST – 30 mins
Ad hoc plannings and reviews

Requirements:
Experience in working with AWS RDS instances
Experience in PostgreSQL
Experience in analyzing query plans, tuning stored procedures, troubleshooting locks, and long-running queries.
High-level proficiency in SQL and PL/SQL
Knowledge of Custom scripting using shell script/Python.
Cloud experience (AWS preferred, but other cloud platforms also ok)
Bachelor’s degree in computer science, mathematics, or a related field
A quality-oriented mindset focused on product delivery
A strong capacity and desire to learn

Nice to have experience:
Basic Oracle experience
Oracle/SQL to Postgres migration experience
Experience in Agile and Scrum practices

English level:
Intermediate+

Responsibilities:
Use AWS SCT, DMS tools & other scripts to migrate schemas and data from Oracle databases to RDS Postgres
Planning and performing database upgrades and migrations
Handling DB object creation using AWS SCT tool
Managing replication across various databases from Oracle to Postgres using AWS DMS
Maintaining the overall health of the databases through routine maintenance and system monitoring
Setting up and maintaining redundancy and high availability
Optimizing database and query performance
Collaborate with product stakeholder teams to identify and implement functional and non-functional requirements
Be responsible for on-time delivery of high-quality software and infrastructure components
Work closely with engineering team members, architects to design, develop, and test all tiers of the application
Participate in ongoing maintenance and support including resolving any production issues/defects when needed
Ensure that the services are built and deployed in an automated fashion
Participate in open, frank discussions, especially in technical matters, while giving and accepting feedback and constructive criticism

About Exadel

For more than 20 years, Exadel has been delivering Digital Transformation services, enterprise and custom software solutions for Fortune 500 clients, including HPE, Deloitte, Home Depot and McKesson. With 20+ locations and delivery centers across the US and Europe, Exadel solves the most complex engineering problems using Agile methodologies, offering a scalable and skilled mix of multi-shore resources at the industry's most competitive price. Exadel’s digital transformation solutions and services help chart new strategies that are built upon creative thinking, cutting-edge design, and technical innovation, designed for the growing digital landscape of business.