Senior Database Administrator (PostgreSQL) (offline)

About the project:

A healthcare marketplace which allows the real-time booking of nurses to fill urgent empty shifts at American hospitals at a much lower cost. The project consists of two parts: a platform where nurses and medical facilities can match, and a subproject, which is a CRM application for temporary staff management used by hospitals.

The main part of the application includes basic features such as personal profiles, payments, and bookings. Additionally, there is multi-tenancy, which allows the application to be customized depending on the client’s requirements, for example, by adding a logo, title, different types of payments, or data lists available for other users.

Responsibilities:

Transactional DBA:

• Monitoring database performance and making necessary adjustments.
• Implementing and managing database security measures.
• Performing regular backups and ensuring data recovery plans are in place.
• Creating and optimizing SQL queries for applications.
• Troubleshooting database issues and providing resolutions.

Architect:

• Designing and reviewing system architecture for new projects.
• Conducting technology research and prototyping.
• Defining and enforcing architectural standards and guidelines.
• Collaborating with stakeholders to align technical solutions with business needs.
• Reviewing and approving system changes and upgrades.

Operational Data Engineer:

• Building and maintaining data pipelines to ensure timely and accurate data flow.
• Writing and optimizing ETL scripts to handle large datasets.
• Monitoring data quality and implementing validation checks.
• Collaborating with data scientists to understand data requirements.
• Ensuring data security and compliance with relevant regulations.
• Spending up to 25% of time on CDP (Cloud Data Platform)/warehouse tasks.

Requirements:

• 4+ years of relevant experience in a similar role
• 4+ years of PostgreSQL, Pg/SQL development experience
• Query performance analyzing and tuning
• Proficiency in using tools such as Git, DBT, Jira, and Agile methodologies
• Experience with design, development, and maintenance of reporting and data warehouse databases a plus
• Familiarity with database design, documentation and coding
• Problem solving skills and ability to think algorithmically

What we offer:

Professional Growth opportunities:

• Ambitious goals and interesting projects

• We have one of the most competitive software development academy in Ukraine — Binary Studio Academy. It’s a free online initiative that offers intensive training to participants. As a member of our team, you’ll have the opportunity to enroll as a coach or lecturer in the academy and hone your leadership and project management skills!

• Regular & transparent performance and salary review based on results of work

• Mentorship and Personal Development Plans for everyone in the company by request

• Regular educational events from our internal experts (you can be one of them)

• Possibility for both vertical or horizontal growth

Benefits program:

• Paid vacation, paid sick leaves, 10 Public holidays, additional days off

• Educational budget and support in receiving certificates/attending conferences, etc.

• English lessons

Comfortable Working conditions:

• Flexible working hours

• Amortization program or provision of required equipment

Community:

• Various corporate events (psychological training, based on employees’ needs to care about mental health, New Year celebration, team buildings, etc)

• Celebration of important personal and project milestones (project successes, B-days, anniversaries, marriage, childbirth)

• Support of team members during russian aggression (evacuation, safe accommodation in Western Ukraine, financial support for those who joined Armed Forces, donations, etc.)