PostgreSQL Dev in Fondy UA

Direct message from Fondy UA to the member who posted the vacancy Natalia Davitidze Wishes for our candidate— Confident knowledge of the basics of relational databases: levels of normalization, isolation, types of indexes, data integrity support— Experience of working with the PostgreSQL DBMS for 5 years or more;— DBMS optimization skills, SQL query performance, experience in using and analyzing query plans, internal statistics, monitoring tools;—Experience in developing procedures, triggers, external scripts using any development language except SQL—Setting up replication processes: master-slave, logical, streaming—Experience in working with both OLTP and DWH—Strategy development backup, reservation, upgrade of PostgreSQL versions— The level of command of the English language is sufficient for working with technical documentation and correspondence. It will be an advantage— Experience with banking or financial systems What will be interesting to do— Development, optimization of SQL queries, development of scripts/procedures/triggers in the database PostgreSQL— Analysis of the business requirements of the company's financial department, and development of relevant SQL queries— Designing and development of the structure of new DB objects (tables, views, etc.)— Deployment, configuration of DWH, development of etl DWH filling processes Show more Show less Type of employment Full-time