Senior Database Administrator

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