Senior Database Administrator

Devexperts; Porto; Presencial; EUR 45 000 - 70 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Hybrid/remote work mode

Fully paid wellness days

Medical insurance

Reimbursement of fitness costs

Modern office with new equipment

Meals and drinks in the office

Corporate teambuilding activities

Free admission to corporate events

Certification opportunities

Resumo da oferta

Devexperts in Porto is seeking a Senior Database Administrator responsible for both on-premises and Cloud database infrastructure administration. The role requires extensive experience with PostgreSQL and offers flexibility for remote or hybrid work arrangements.

The ideal candidate should have a strong background in high-availability architectures and be proficient in backup and recovery strategies. A comprehensive benefits package is also included, ensuring comfort and well-being for team members.

Qualificações

• 5+ years of hands‑on experience administering PostgreSQL in production environments.
• Experience designing, implementing, and operating high-availability PostgreSQL architectures.
• Strong expertise in backup and recovery strategies.

Responsabilidades

• Ensure database services meet agreed service levels.
• Design and manage database subsystems.
• Define and execute backup and disaster recovery procedures.

Conhecimentos

PostgreSQL administration

High-availability architectures

Amazon RDS for PostgreSQL

Backup and recovery strategies

Performance monitoring and tuning

Ansible automation

Linux operating systems

Zabbix monitoring

ClickHouse technologies

Ferramentas

pgBackRest

Barman

TimescaleDB

Descrição da oferta de emprego

Devexperts works with respected financial institutions, delivering products and tailor-made solutions for retail and brokerage houses, exchanges, and buy‑side firms. The company focuses on trading platforms and brokerage automation, complex software development projects, market data products, and IT consulting services.

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.

Additional Information

Care for the employees is one of Devexperts' core values. For the suggested position, we offer a benefits package that will guarantee the comfort of our new teammate.

Work Regime Flexibility benefits:

• Possibility of hybrid/remote work mode

Health and recreation benefits:

• Fully paid additional wellness days (3 unwell days per year)
• Medical insurance for the employees and children
• Reimbursement of fitness
• Flexpay system

Facility benefits:

• Modern office with new equipment
• PlayStation, table football, and musical instruments in the office
• Meals in the office
• Free drinks and snacks

Community benefits:

• Teambuilding activities
• Corporate parties
• Football club
• Music club
• Speakers' club
• Free admission to corporate external events
• Possibility of joining conferences and professional fairs
• Local language courses for foreign employees
• Unlimited access to self‑learning platforms
• Certification opportunities
• Parental bonus
• Pension plan
• Referral bonus
• Blood donation paid leave