DB Developer

Requirements:

  • 2+ years of hands-on Postgres DB developer experience and within all layers (RDBMS, ETL, OLAP, BI).
  • Bachelor’s Degree in Computer Science or equivalent
  • 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)

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

Responsibilities:

As a DB Developer you will:

  • 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
  • Help the backend team use database efficiently
  • Monitor and tune sql queries in OLTP and OLAP databases
  • Monitor performance of all PostgreSQL instances
  • 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
  • Apply all knowledge to help the team during big events with high load in realtime
  • Have a lot of fun

Scope:

  • Own all DB aspects, 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 developers 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

Will be a plus: 

  •  MySQL experience

Working conditions:

  • 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.)







    About

    Location: Kyiv
    Type: Full-time

    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