Database developer \ Administration of PostgreSQL in MODUS X

We are currently looking for a Database developer \ PostgreSQL administration

This position requires:

Expert knowledge of PostgreSQL, Mysql administration.

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, data schema design, query optimization, SQL / plpgsql / plpyhton / plperl stored functions, administration (Linux)

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

Optimization of queries, query plan analysis, work with indexes;

Development of procedures 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 plans recovery (DRP) >

Position functions:

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

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< /li>

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.
>
• Creation and maintenance of scripts for automation of administration and monitoring tasks
• Creation of recovery plans (DRP).
• Experience in deploying and configuring AWS RDS for PostgreSQL in mission critical applications
• Experience of on-going performance analysis and working with the development team to optimize queries and database structure
• Experience of planning DB resources in AWS
• Experience of monitoring AWS RDS for PostgreSQL databases and enabling standard incidents that arise

We offer:

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