Position: Strong Associate Postgres DBA (only HU, PL, BG, RO)
Company: Exadel
Experience required: 1y
Category: SQL
English level: intermediate
Published: 2023-06-01T00:00:00+03:00

We’re looking for a strong Associate Postgres DBA to join our friendly team!

Work at Exadel - Who We Are: 
Since 1998, Exadel has been engineering its products and custom software for clients of all sizes. Headquartered in Walnut Creek, California, Exadel has 2,800+ employees in development centers across America, Europe, and Asia. Our people drive Exadel’s success and are at the core of our values.

About Our Customer:
The сustomer is a leading provider of vehicle lifecycle solutions, enabling 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, connecting a vibrant network of 350+ insurance companies, 24,000+ repair facilities, OEMs, hundreds of parts suppliers, and dozens of third-party data and service providers. The customer's collective set of solutions inform decision-making, enhance productivity, and help clients deliver faster and better experiences for end consumers. 


The сustomer’s company was ranked #17 in the Top 100 Digital Companies in Chicago in 2020 by Built in Chicago, an online community for digital technology entrepreneurs in Chicago, and was named one of Forbes best mid-sized companies to work for in 2019 – an important accolade and retention tool for the 2,600+ full-time company employees (alongside 350 dedicated contractors).

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

Advantages of Working with Exadel:

Transparent Career Roadmap
The HR manager accompanies each employee on their first steps in the company and assists them in achieving future professional goals
Exadel is a global company with 30+ offices in 15+ countries. Employees have the chance to discover new places to live and work, and can transfer to any location that has an Exadel production office. The HR manager and the Global Mobility specialist accompany the employee and assist throughout the relocation process
Your career growth is in your hands, so each Exadeller decides when to level up and initiate performance assessments. The management team supports career planning and the discovery of new tech stacks and languages

Learning & Development Opportunities
Each Exadeller is given a $1,000 yearly budget for self-education, which includes certifications, training sessions, meetups, conferences, and educational materials
Employees participate actively and benefit from the knowledge-sharing environment across seven practice units: Digital Marketing Technologies, Content Marketing, AI, QA, QAA, Agile, and DevOps
Employees can find recordings from meetups and trainings on Exadel’s Internal Learning System

Work & Life Balance
Each Exadeller is in charge of managing their workflow independently without being micromanaged at every step; it is, however, important that an employee always attends meetings, logs their time, and meets deadlines
Operating from the office, or remotely, depends on which mode the employee prefers. Hybrid or remote mode staff will receive the necessary equipment before their first working day. For those who prefer to work in-office, the office network  offers up-to-date equipment, good facilities, and a warm collaborative environment
The team meets at two annual team-building events across locations; in addition there are team events such as Pizza Days, Programmer’s Day, informal meetups, board game parties, and sports initiatives

Employee Perks & Bonuses
The Exadel referral program covers all regions and involves recognition for hired recommended professionals. Depending on the location and the position, an employee receives a monetary bonus for recommending a candidate to Exadel who ends up being hired
Employees collect coins for numerous project activities, exchanging them for products or services of their choice available on the Exadel store
Volunteers for mentoring, interviewing, performing assessments, and participation in community meet-ups, get additional monetary bonuses
Location-dependent, Exadellers can access benefit platforms with vouchers for online stores, medical insurance reimbursement, sports membership fees, vacations, and childbirth bonuses