DB Administrator/Developer (Kyiv/Kharkiv/remote)

Our partner is a online fundraising and marketing platform for non-profit organizations. A huge platform that gives organizations a wide range of different tools to perform their fundraising, advocacy and other campaigns.

Requirements:
- 3+ years of hands on Postgres DB administrator/developer experience within all layers (RDBMS, ETL, OLAP, BI).
- Strong understanding of Database Administration (e.g Replication, Backup/Restore strategies, Clustering, Failovering, Upgrade, Partitioning)
- Demonstrated ability to work independently and interact with customers, internal
management other tech staff
- Demonstrated expertise in rapid and accurate problem localization, troubleshooting and
resolution
- Passion for getting to the Root Cause and preventing problems from reoccurring
- Knowledge of Best Practices in database monitoring, maintenance, operation, updates, and
security.
- Experience with large schemas (100+ tables / objects) with large data sets (billions of records)
- Bachelor’s Degree in Computer Science or equivalent

Candidate must be able to:
- Demonstrate experience specifying, developing, building and maintaining highly
reliable PostgreSQL solutions
- Demonstrate project estimation, scheduling skills and experience working in an Agile
environment.
- Provide identification, diagnosis and resolution of production data problems in a fast paced setting
- Work well with sysadmins, developers and customer support
- Speak English well enough to work at times directly with top tier customers facilitated through customer support

It will be a plus:
- MySQL experience

As a DB Administrator/Developer you will:
- Monitor performance of all PostgreSQL instances
- Monitor and tune sql queries in OLTP and OLAP databases
- Provide Level 3 support for client requests
- Assist DevOps maintenance tasks
- Constantly look for and propose ways to optimize the system and accommodate the growth
- Help the backend team use database efficiently
- Work closely with backend and PM team to create data models for new functionality
- Create ETL procedures to gather data from in-house source systems and transform it for reporting purposes
- Apply all knowledge to help the team during big events with high load in realtime

Scope:
- Own all DB aspects of our SaaS platform, including Lab (Dev, QA, UAT) and Production environments
- Troubleshoot PostgreSQL stability and performance problems at all levels
(SQL and data model tuning)
- Design and implement reliability and scalability improvements
- Assist application deveopers in data modeling (DDL)
- Design and improve ETL processes to support subscription data loads, log harvesting and data mart
- Design and implement cloud (e.g. AWS RDS) solutions, where appropriate 

We offer:
- Full-time position
- Work in friendly and professional team
- Paid sick-list
- 4 weeks of paid vacation
- Medical insurance
- Corporate library
- English classes
- Corporate club (for some relax during workday)
- Corporate events (birthdays, holidays, etc.)
- Tea, coffee, milk, juice, fruits, snacks and cookies =)