Position: PostgreSQL DBA
Category: SQL
English level: intermediate
Years of experience: 10


Installing PostgreSQL on the virtual servers and Kubernetes.
Tuning PostgreSQL for performance.
Deploying of high available PostgreSQL cluster with the automated failover Patroni.
Configuring physical streaming replication.
Creating backup plans and restore procedures.
Configuring access to remote databases.   
Analyzing slow queries and improving query performance.
Migrating databases from MySQL, MS SQL to PostgreSQL.
Data loading from external sources (CSV, TXT files).
Creating stored procedures and triggers.
Monitoring Postgres databases with Prometheus + Grafana.
Automating tasks with Ansible.
I couldn't do boring routine tasks.