Database developer \ Administration of PostgreSQL in DTEK, TOV, Energetichna kompaniya

We are currently looking for a Database developer \ PostgreSQL Administration

This position requires:

Expert knowledge of PostgreSQL administration , Mysql.

Preferred: MS SQL Server, Oracle, elastic search, MariaDB

Knowledge of technologies: Cloud Database, Database High Availability and Replication, Backup / Recovery and Database Export / Import

Installation, configuration, design of data schemes, query optimization SQL / plpgsql / plpyhton / plperl stored functions administration (Linux)

Writing stored procedures, functions, triggers and complex queries ( PostgreS-L);

Query optimization, query plan analysis, work with indexes;

Development of procedures for loading and uploading data to the database from various sources;

Installing updates and cross-platform migration.

Creating and maintaining scripts for automating administration and monitoring tasks.

Creating Recovery Plans (DRP).

Performance optimization.

Knowledge of server OS Windows 2016+ and Linux.

Availability of Microsoft certification will be a plus.

Job functions:

• Administration of PostgreSQL, elastic search, Mysql, MariaDB.
• DBMS installation, architecture and implementation.
• Installation of updates and cross-platform migration.
>
• Creation and maintenance of scripts for automation of administration and monitoring tasks
• Creation of recovery plans (DRP).
• Optimization performance.

Within the framework of projects, it is necessary to perform:

• AWS RDS for PostgreSQL Database Monitoring
• AWS RDS for PostgreSQL Database Maintenance and Management Tasks
• Database Performance Analysis and Close Collaboration with the development team to optimize it

Professional competences:

• Expert knowledge of PostgreSQL administration, elastic search, Mysql, MariaDB.
• Knowledge of technologies: Cloud Database, Database High Availability and Replication, Backup / Recovery and Database Export / Import.
• Installing updates and cross-platform migration.
• Creating and maintaining scripts to automate administration and monitoring tasks
• Creating recovery plans (DRP).
• Deployment and configuration experience AWS RDS for PostgreSQL in mission critical applications
• Experience of on-going performance analysis and working with the development team to optimize queries and DB structures
• Experience in planning DB resources in AWS
• Experience in monitoring AWS RDS for PostgreSQL databases and resolving standard incidents that occur

We offer:

• Official employment
• Competitive conditions and bonus program
• Corporate equipment
• Corporate health insurance program
• Psychological support program employees
• Remote or hybrid format of work in the Unit City innovation park
• Learning opportunities and professional development (online courses, classroom trainings, master classes, professional communities)