DB Developer
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
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)
- 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
Responsibilities
- 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
- 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
Nice to Have
- MySQL experience
We Offer
- Full-time position
- Work in a 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 =)