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