Porto, Porto District, Portugal
3 months ago

Job Overview

Job Type
Full-Time
Pay
Not disclosed

Job description

Location:
Porto, Porto District, Portugal
Work arrangement:
On-site

Role Summary

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

Responsibilities

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.

Requirements

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.

Benefits

  • 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
  • Flexible working hours

Health and recreation benefits

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

Facility benefits

  • Modern office with new equipment
  • PlayStation, table football, and musical instruments in the office
  • Parking spaces/transport reimbursement
  • 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
  • Personal branding development support

Professional training benefits

  • Local language courses for foreign employees
  • Unlimited access to self-learning platforms
  • Certification opportunities
  • Mentorship Program

Social benefits

  • Parental bonus
  • Pension plan
  • Referral bonus
  • Blood donation paid leave

About the Company

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.

Role:
Senior Database Administrator
Industry Type:
Information Technology And Services
Job Type:
Full-Time

More jobs at Devexperts

Similar Database Administrator jobs at other companies