DBA Lisboa

DBA
Lisboa
Lisboa, Lisboa, Portugal

We are looking for an experienced Postgre
SQL DBA to manage and scale our
- critical database infrastructure. With our rapid business growth, we need a skilled professional to ensure the performance, reliability, and scalability of our Postgre
SQL databases.

Key Responsibilities

• Administer and optimize Postgre
  SQL 14+ databases.
• Manage a multi-terabyte Postgre
  SQL database running on physical hardware.
• Handle backups, restores, replication, and disaster recovery strategies.
• Support and optimize complex database structures, including triggers, stored procedures, and partitioning.
• Troubleshoot production performance issues quickly and effectively.
• Conduct performance tuning for a
  - OLTP transaction database handling 100M+ transactions per day.
• Set up monitoring and alerts for disk space, CPU usage, and IO contention.
• Ensure database security through
  - based and
  - grained access control.
• Work with Postgre
  SQL operators on Kubernetes for database management.
• Take initiative in identifying and resolving database issues proactively.

Upcoming Projects

• Migrate Postgre
  SQL 14 to Postgre
  SQL 16.
• Transition
  - premise Postgre
  SQL to AWS.
• Optimize and migrate large historical tables (billions of rows) through partitioning and purging.

Required Skills & Experience

• Extensive Postgre
  SQL administration experience (v14+).
• Strong Linux expertise, particularly Debian, for production servers.
• Hands-on experience with performance tuning,
  - transaction OLTP databases, and replication techniques.
• Advanced security knowledge and experience implementing access controls.
• Experience with Kubernetes-based Postgre
  SQL deployments.
• Self-motivated
  - solver with the ability to take initiative.

If you're passionate about database performance and scalability, we'd love to hear from you! Apply now and help us build a rock-solid Postgre
SQL infrastructure.