Database Administrator with DevOps skills (offline)

— 5+ years of experience in a DevOps/DBA/DBE role
— Extensive experience in SQL (Postgresql, Postgresql, & more Postgresql, and maybe some MySQL)
— Working knowledge of JSON and Postgresql JSONB extensions
— Strong operational experience in Linux/Unix environment and scripting languages like Shell, Perl, Python is required
— Strong troubleshooting skills
— At least upper-intermediate level of English, both spoken and written
— When you talk in your sleep it should be Postgresql compatible SELECT statements.

As a plus:
— Experience in horizontal database scaling, Citus Data/TimescaleDB
— Familiarity with PostGIS.
— Experience in NoSQL (MongoDB) databases.
— Experience in Airflow, Kettle, and the Pentaho PDI/PDR.

Our philosophy is that we are a small, closely-knit team and we care deeply about you:
— Competitive salary;
— Great new office space;
— Flexible working schedule, remote work possible;
— Working directly with colleagues from Silicon Valley and around the world;
— Team trips, certification and events compensation, medical insurance, sports, etc.;
— Last but not least, we are really fun to work with!

Responsibilities:
— Maintain roughly 100 custom data pipelines written in Perl, PHP, Python & Java.
— Create new data pipelines and transformations.
— Assist with data migrations and database component software updates
— Assist with cloud and bare-metal infrastructure buildout
— Build out new services such as data presentation systems (metabase, pentaho data reporter, tableau, etc)
— Work with the BI team to turn raw data into insights as efficiently as possible
— Help troubleshoot any BI tool issues such as failing jobs and reporting layer slowness
— Work with other teams to create ETLs.
— Set up integration environments and provision databases for new projects
— Develop the Dev-Ops process using CI/CD tools
— Repair failing components as needed — be available when needed
— Be given only a mallet and some small wrenches with which to work

This position involves:

— Caring for our large horizontally scaled database clusters, processes, and custom data pipelines.
— Creating queries and ETLs and improving poorly written ones.
— Optimizing the clusters to run as efficiently as possible, maintaining data consistency.
— Helping data producers and consumers to move their data efficiently and produce the results they want.
— Contributing to the planning of future growth.
— Revision control and migrating data forward through new versions of software and architectures.
— Implementation of our technologies on cloud environments (AWS, Azure, GCP) and bare metal
— Dreaming about the numbers and ways to improve the systems when asleep.
— Implementing solutions that are good enough now, while planning for better solutions in the future.
— Building tools that make others within the company more productive.

About OpenVPN

OpenVPN Technologies is a privately held company based in the Pleasanton, California, integrating a suite of leading-edge networking and software technologies. OpenVPN Technologies has designed and deployed a virtual network software that provides secure, reliable, and scalable communication services, not only fulfilling the requirements of the traditional virtual private network (VPN) market, but also addressing the demands of next wave web-scale VPN services. OpenVPN, our award-winning open source VPN product, has established itself as a de-facto standard in the open source networking space, with over 3 million downloads since inception. OpenVPN Technologies is the provider of next-generation secure and scalable communication services, implementing its business plan through strategic partnerships with key application software providers and marketing its product to SMB market place through its OpenVPN web site that is experiencing more than 250,000 new SMB users, prospects, and customers per month.

Company website:
https://openvpn.net/

DOU company page:
https://jobs.dou.ua/companies/openvpn/