Senior Database Administrator
Devexperts- Location
- Porto, Porto District, Portugal
- Workplace
- Hybrid
- Employment
- Full Time
- Salary
- —
Posted 3mo ago
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.
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.
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
Skills
- PostgreSQL
- RDS
- Aurora
- SQL
- Ansible
- TimescaleDB
- Linux
- Zabbix
- ClickHouse
More jobs at Devexperts
All 33Middle/Senior Java Developer
Devexperts · São Paulo, SP, Brazil · yesterday
Senior Database Administrator
Devexperts · Sofia, Sofia City Province, Bulgaria · 3d ago
Site Reliability Engineer (SRE)
Devexperts · Porto, Porto District, Portugal · 7d ago
Site Reliability Engineer (SRE)
Devexperts · Tbilisi, Tbilisi, Georgia · 7d ago
Site Reliability Engineer (SRE)
Devexperts · Sofia, Sofia City Province, Bulgaria · 7d ago
Similar roles
Automation & AI Lead (f/m/div.)
Bosch Group · Lisboa, Lisboa, Portugal · today
Global Network & Security Expert
Inetum · Lisbon, Lisbon, Portugal · today
Cloud & DevOps Engineer | Financial Services
Elevus · Lisbon, Portugal · today
DevOps Engineer (all genders)
Roland Berger · Lisbon, Lisbon, Portugal · today
Senior Site Reliability Engineer
OutSystems · Portugal · yesterday
Application Support Engineer | Securities Services
Inetum · Lisbon, Lisbon, Portugal · yesterday