Position: Database administrator
Company: PSR Company
Category: SQL
Experience required: 3y
English level: upper
Published: 2021-06-01T00:00:00+03:00

**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

**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 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

**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 =)

**COMPANY**:
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.