Senior Database Administrator
- Full-time
Company Description
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.
By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply