Database Administrator

An IT company is looking for a Database Administrator to join a team developing and delivering cloud databases for clients.

Responsibilities:

- Ensuring uptime and high performance of database clusters.

- Automating infrastructure interactions through the development of Ansible playbooks.

- Work on customer tasks from architectural consulting and migration review to disaster recovery.

- Configuring and maintaining replication, clustering and backup mechanisms.

- Finding performance bottlenecks and providing recommendations to developers.

- Monitoring of database servers and their status.

- Providing and monitoring the status of database backups.

- Updates and patch-management of PostgreSQL.

Requirements:

- Experience in PostgreSQL database administration from 5 years, knowledge of Postgresql system structure, knowledge of PostgreSQL configurations, experience in operating large (1TB+) highly loaded PostgreSQL databases running 24x7.

- Knowledge of OC Linux at administrator level in typical tasks (Debian/Ubuntu/Redhat/Centos).

- Experience in writing Ansible-playbooks.

- Understanding of virtualization stack.

- Excellent knowledge of SQL, experience in optimizing SQL queries, functions and stored procedures.

- Knowledge of PL/pgSQL.

- Configuring and monitoring database replication.

- Identifying performance issues and optimizing database tuning.

- Understanding of the principles of working with transactions and locks in PostgreSQL.

- Knowledge of English - intermediate.

Soft skills :

- Ability to work in a team, high level of self-organization and responsibility.

- Ability to communicate with customers, ability to explain how the task was realized.

- Leading the task at the customer on a turnkey basis, including communication with the customer and other DBAs in the company.

- Ability to decompose a large task into stages and ability to delegate typical tasks to lower ranked employees.

Would be a plus:

- Experience migrating to PostgreSQL from other RDBMS.

- Experience working with Patroni.

- Experience with PostgreSQL cloud databases from different providers (Yandex, Amazon, Google, MS Azure, etc.).

- Experience with virtualization.

- Experience with Docker and Kubernetes.

- Experience with PL/PostgreSQL programming.

- Shelll programming for automation tasks.

- Ability to use DBMS monitoring tools: statistics collector, dynamic tracing, DBMS log analysis.

- Experience in working with monitoring systems applied to databases.

- Knowledge of Perl/Python for solving automation and administration tasks.