Database administrator (DBA) Greenplum

Responsibilites:

• Support and administration of Greenplum databases, including installation, configuration and updating;
• Ensuring high availability, performance and reliability of Greenplum databases;
• Ensuring data integrity in the database;
• Configuring and managing replication, backup and data recovery;
• Monitoring the status of the database, identifying and eliminating performance bottlenecks;
• Managing users, roles and setting up security policies to protect data;
• Operational support and resolution of incidents related to the Greenplum database;
• Analysis of the causes of failures and problems, development of proposals for their elimination and prevention;
• Optimizing complex queries and database performance;
• Collaborate with development and analytics teams to ensure effective use of the database;
• Planning and implementation of routine maintenance and database updating;
• Maintaining technical documentation and reports on incidents, settings and work performed.

Requirements:

• University degree in information technology, computer science or related discipline;
• At least 3 years of experience working with Greenplum or other MPP systems;
• Knowledge of Greenplum architecture, including configuration and optimization of workloads;
• Experience in administering big data and distributed systems;
• Experience in optimizing complex queries;
• Linux/UNIX administration skills, command line knowledge and scripting (Bash);
• Experience in tuning and monitoring database performance;
• Understanding of networking principles and data security;
• Experience with version control systems (Git);
• Excellent analytical skills and problem solving ability;
• Ability to work autonomously and organize processes from scratch;
• Experience in developing and supporting technical documentation;
• Responsibility and attention to detail.

Nice to have:

• Experience with big data and analytical platforms;
• Experience with automation tools for configuration management and application deployment (Ansible);
• Basic knowledge of Apache Airflow.