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