Position: Middle Postgres DBA (Bulgaria, Hungary, Poland, Romania) 4929
Company: Exadel
Category: SQL
Experience required: 2y
English level: intermediate

**Bulgaria, Hungary, Poland, Romania
We’re looking for an experienced Middle Postgres DBA to join our friendly team!**

**About Our Customer:**
The leading provider of vehicle lifecycle solutions enables the companies that build, insure, repair, and replace vehicles to power the next generation of transportation. The company delivers advanced mobile, artificial intelligence, and connected car technologies through its platform. It connects a network of 350+ insurance companies, 24,000+ repair facilities, OEMs, parts suppliers, and third-party data and service providers. The customer’s collective solutions inform decision-making, enhance productivity, and help clients deliver faster and better experiences for end consumers.

**About Our Project:**
For now, it is a fixed-time assignment related to the DB modernization.
The projected length is June-October 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 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:**
2+ years working experience with AWS RDS instances
Proficiency with PostgreSQL
Expertize with analyzing query plans, tuning stored procedures, troubleshooting locks, and long running queries.
Expert 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

**Nice to have:**
Basic Oracle experience
Oracle/SQL to Postgres migration experience
Skills 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