Senior Database Engineer (offline)

Fully remote, long-term cooperation. The Database Engineer must be adept at working alongside colleagues with varying backgrounds and technical expertise.

Details
Project description: data platform for communities across the USA to help leaders and decision-makers answer their Pressing Questions. With a five-year goal of serving 100 communities, the client can support data-driven decision-making among governments, business, and nonprofits, leading to better outcomes among a range of critical community organizations. Communities have pressing questions and the team and approach develop actionable insights and communicates them clearly by using advanced visualizations. A community data platform is an essential community service.

Requirements
database engineering experience. This includes at least 1 year of experience developing PostgreSQL solutions in an enterprise environment;
Experience with Linux-based cloud computing systems (AWS);
Ability to design and organize a data warehouse for efficiency and scalability;
Knowledge of normalization and denormalization techniques such as dimensional modelling and NoSQL paradigms preferred;
Know how to create Airflow DAGs to create ELT and ETL processes, perform web scraping, and other data management tasks;
Expert level scripting of regular processes using Python (Object Oriented and Functional) and SQL;
Ability to productionize Jupyter Notebook and R scripts written by data science colleagues into Airflow DAGs;
Proficiency with managing database user groups;
Demonstrated ability to work effectively with multiple managers simultaneously to meet business timelines;
Awareness of emerging technologies and approaches in IT to keep the company at the forefront of innovation;
Conversational English to answer technical questions posed by ETL team members.

Would be a plus
Maintain cloud infrastructure on AWS and DigitalOcean;
Maintaining SSL Certifications and manage web servers, including Apache, Nginx, and Node deployments;
Troubleshooting user issues with OpenVPN/FreeIPA (LDAP Authentication).

Responsibility
The Database Engineer will be responsible for organizing and improving a growing data warehouse for a fast-paced organization;
To support various teams to create scalable solutions to answer pressing questions across multiple communities in the United States;
To work directly with ETL developers, data scientists, and dashboard developers to advise the storage process from raw data to actionable insight;
A strong foundation in data storage principles and design is mandatory.

About GeeksForLess

Our company has come a long way from the small projects implementation to the level of established trust relationships with the world's IT Leaders. We are proud of our highly professional teams of developers located in in Mykolaiv, Lviv, Kyiv(Ukraine), Krakow (Poland) and Clark Freeport Zone, Angeles City, Philippines.

We constantly invest in the comfort of our employees:
- During the quarantine period, since March 2020, we all work remotely.
- We offer Medical Insurance coverage (Covid-19 treatment is included).
- Each employee is equipped with all the necessary work equipment (laptops, monitors, headphones, and chairs).
- We provide paid 15 vacation days and paid public holidays and reimburse non-used paid vacation days in cash equivalent at the end of the year.
- We cover courses and certifications that support professional development and conduct online courses and internships at the company level.
- Referral bonus system for each employee, who recommends their talented friend to join us.
- We prepare gifts for employees and their children for holidays.
- A variety of sports and thematic challenges with the opportunity to receive corporate gifts if you participate.
- Free online CrossFit training three times a week and other sports activities for all our employees.
- Thematic meetings and corporate parties with employees.
- We provide constant assistance with PE and tax handling.

Company website:
http://geeksforless.club

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