Binary Studio is a custom software development agency with a focus on long-term projects. We leverage exceptional Ukrainian engineering talent to build world class solutions for tech companies.
17 липня 2024

Senior Database Administrator (PostgreSQL) (вакансія неактивна)

за кордоном, віддалено

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:

• Ambitious goals and interesting projects

• We have one of the most competitive software development academy in Ukraine — Binary Studio Academy. In 2023, it became international and attracted more than 15,000 applicants. 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.)