Position: DB Developer
Company: INSART
Experience required: 2y
Category: SQL
English level: upper
Published: 2021-03-01T00:00:00+02:00

Required skills

● 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 fastpaced
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

As a plus

● MySQL experience

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 =)

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 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 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

Project description

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