Database administrator (offline)

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.

About PSR Company

PSR Company is an international IT recruitment agency founded in 2007. For more than 14 years, our recruiters have been successfully filling vacancies for our clients all over the world. Our portfolio includes more than 150 global clients including European Commission, Ernst&Young, Samsung, 3DLOOK, Rakuten, GFK, and others

During the hiring process you are usually limited by the city or country. PSR erases the boundaries for you, looking for highly qualified and motivated professionals, ready to relocate anywhere in the world.

We nurture and encourage in our team the environment that includes trust, mutual respect, and professional growth and development.

Our recruitment team includes professionals with the significant experience in IT industry. They know how and where to find a strong candidates within the shortest period of time.

Company website:
http://psrcompany.com/en/

DOU company page:
https://jobs.dou.ua/companies/professional-staff-recruitment-company/?from=djinni_job