Senior Database Administrator

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 Engineer
who will be responsible for on-premises and Cloud database infrastructure administration.

We expect the Senior Database Engineer 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

Qualifications:

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

Flexibility benefits:

• Possibility of hybrid/remote work mode,
• Flexible working hours.

Health and recreation benefits:

• 20 days of paid vacation,
• 5 days of fully paid additional wellness days,
• Medical insurance – premium package,
• Free MultiSport card.

Facility benefits:

• Modern office with new equipment,
• Panoramic view of Vitosha mountain,
• PlayStation, Billiard, Relax zone and Gym,
• Parking space/public transport card,
• Free drinks and snacks.

Community benefits:

• Teambuilding activities,
• Corporate parties,
• Football club,
• Speakers' club,
• Free admission to corporate external events,
• Possibility of joining conferences and professional fairs.

Professional training benefits:

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

Social benefits:

• Referral bonuses for specific roles,
• Paid leave upon special events.