Postgres DBA Tech Lead

Spotware Systems is seeking an experienced Postgres DBA Tech Lead to join our dynamic team in Limassol. This role involves leading a team specializing in PostgreSQL database administration.

Responsibilities

  • Development and administration of PostgreSQL databases.
  • Database performance monitoring and PostgreSQL query optimization.
  • Identifying and resolving database performance bottlenecks.
  • Management and support of backup and recovery procedures.
  • Installation and maintenance of database servers, replication, and client environments.
  • Ensuring high availability and fault tolerance of systems.
  • Collaborating with other departments to prioritize and align project requirements.
  • Leading a team of database administrators, task allocation, and performance monitoring.
  • Implementing and overseeing database administration processes to improve team efficiency.
  • Risk management in projects and quick resolution of emerging issues.
  • Using automation tools for managing database tasks (Jenkins, Ansible, Liquibase, Python).

Requirements

  • Ability to design and implement complex algorithms.
  • Intuitive understanding of dataflows and background computing involved in data processing.
  • Good knowledge of SQL and PLPGSQL.
  • Good understanding of SQL execution plans and ways to tweak them.
  • Good knowledge of Linux, bash and scripting in general.
  • 3+ years of experience in database administration and/or development.
  • Some programming background will be a plus.
  • Basic operating knowledge of PostgreSQL DB.
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, security issues, etc.
  • Good knowledge of PostgreSQL backup and recovery (WAL Archiving, Point-in-Time Recovery).
  • Experience in database deployment.
  • B1+ English language level.

Conditions

  • Competitive remuneration.
  • Private medical insurance.
  • Relocation package (if applicable), including work permit arrangements.
  • Welcome baby bonus.
  • Birthday voucher.
  • Fully equipped office with daily fruits, pizza on Thursdays and snacks on Fridays.
  • Opportunities for professional growth.
  • Friendly working environment.

Vacancy Application Form