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
- 4+ year experience as Database Developer
- 2+ years of hands-on Postgres DB or Oracle 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)
- Nice to have MySQL experience
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
- 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
- Have a lot of fun
The 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
We Offer
- Full-time position
- Work in a friendly and professional team
- Paid sick leave
- 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 =)