Postgres DBA 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, 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.