Senior Database Administrator

Devexperts LLC; Porto; Presencial; EUR 50 000 - 70 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Flexible work mode

Fully paid wellness days

Medical insurance

Fitness reimbursement

Modern office equipment

Free drinks and snacks

Teambuilding activities

Free admission to external events

Resumo da oferta

Devexperts LLC in Porto, Portugal, is seeking a qualified Senior Database Administrator responsible for administering on-premises and Cloud database infrastructures. The successful candidate will ensure high availability and performance while working collaboratively across teams.

The ideal applicant will possess extensive experience in PostgreSQL administration, including high-availability setups and performance tuning. The role offers flexibility with the option for hybrid or remote work mode and a comprehensive benefits package.

Qualificações

• 5+ years of experience administering PostgreSQL in production environments.
• Proven experience with high-availability PostgreSQL architectures.
• Hands-on experience with Amazon RDS and Aurora PostgreSQL.

Responsabilidades

• Ensure database availability and performance meet service levels.
• Design and manage database subsystems including clustering.
• Conduct root cause analysis and remediation for production incidents.

Conhecimentos

PostgreSQL administration

High-availability architectures using Patroni

Amazon RDS for PostgreSQL

Backup and recovery strategies

Performance monitoring and optimization

Automation with Ansible

Linux operating systems

Formação académica

Bachelor's degree in Computer Science or related field

Ferramentas

pgBackRest

Barman

Zabbix

ClickHouse

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 ressources 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