Senior Database Administrator

Devexperts

Porto, Portugal

Job Description

We are looking for a Senior Database Administrator who will be responsible for on-premises and Cloud database infrastructure administration.

We expect the Senior Database Administrator to:

Ensure database services meet agreed service levels for availability, recoverability, performance, and scalability;
Design and manage database subsystems, including clustering, replication, etc.;
Define and execute backup, disaster recovery, and business continuity procedures;
Handle database compliance with industry standards, regulations, and best practices;
Establish monitoring standards, capacity planning practices, and operational metrics to proactively identify risks and trends before they impact the business;
Investigate production incidents, coordinate resolution efforts, perform root cause analysis, and drive remediation initiatives to prevent recurrence;
Work closely with Developers, Quality Assurance, and Support departments on a regular basis, assisting with Database-related requests;
Participate in an on-call rotation and serve as an escalation point for complex production issues affecting critical systems;
Apply cost reduction practices for Cloud database Infrastructure based on the resources usage and databases load profile;
Conduct deep analysis of database performance issues, implementing solutions;
Oversee data migration projects and perform risk analysis;
Drive innovation in database technologies within the project or business unit.

Qualifications

Must-have skills:

5+ years of hands-on experience administering PostgreSQL in production environments within mission-critical systems;
Proven experience designing, implementing, and operating high-availability PostgreSQL architectures using Patroni;
Hands-on experience managing Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL;
Strong expertise in backup and recovery strategies, including planning and executing Point-in-Time Recovery (PITR) using tools such as pgBackRest and Barman;
Solid understanding of PostgreSQL internals (MVCC, vacuuming, query planning, replication concepts, etc.);
Extensive experience with performance monitoring, SQL workload analysis, and database tuning, with the ability to identify bottlenecks and optimize database performance;
Experience automating database deployment, configuration management, and operational processes using Ansible;
Practical experience implementing and maintaining PostgreSQL partitioning strategies, including both native partitioning and TimescaleDB for time-series workloads;
Strong working knowledge of Linux operating systems, including system performance analysis, process management, networking fundamentals, and storage concepts relevant to database operations;
Familiarity with database monitoring and observability tools such as Zabbix, including metrics collection, alerting, and log analysis;
Exposure to column-oriented database technologies such as ClickHouse, with an understanding of their core concepts, architecture, and performance characteristics, would be a plus.