Position: DBA(ins)
Company: PSR
Category: SQL
Experience required: 3y
English level: upper

Salsa Labs is a premier SaaS technology company providing online organizing tools to nonprofits. The tools they create allow thousands to organize and create change across the country and across the globe. Their greatest strength lies not only within the technology they produce, but also within the greatness of their people. They pride themselves on their team of talented, driven, entrepreneurial individuals and in having a work place that values work/life balance, creativity, and innovation.

Engage: Digital engagement platform, purpose-built with everything needed to communicate, advocate, and fund a cause. Involves marketing automation, workflow management, online fundraising, multi-channel online advocacy, peer to peer campaigns & events, integration with Salesforce.

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

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


Nice To Have:

● MySQL experience

Предлагаем
● 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 =)

Обязанности
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