Администратор баз данных DBA Middle

​​​​Администрирование, сопровождение и развитие баз данных PostgreSQL;

• Мониторинг производительности БД, анализ и устранение узких мест;
• Оптимизация SQL-запросов, схем данных, индексов и процессов обработки данных;
• Проектирование структуры баз данных и участие в разработке архитектуры хранения данных;
• Настройка резервного копирования (Backup) и восстановления (Recovery);
• Обеспечение высокой доступности и отказоустойчивости PostgreSQL (Streaming Replication, Failover, Cluster Solutions);
• Контроль целостности, безопасности и производительности баз данных;
• Анализ планов выполнения запросов (EXPLAIN, EXPLAIN ANALYZE);
• Настройка параметров PostgreSQL для достижения оптимальной производительности;
• Участие в миграции данных, обновлении версий PostgreSQL и сопровождении изменений;
• Автоматизация рутинных задач администрирования с использованием SQL, Bash, Python или PowerShell;
• Взаимодействие с командами разработки, DevOps и аналитиками по вопросам проектирования и эксплуатации БД;
• Подготовка технической документации по архитектуре, настройкам и регламентам сопровождения БД.

Требования:

• Опыт работы DBA PostgreSQL от 2–3 лет;
• Углубленное знание PostgreSQL (версии 12+);
• Отличное знание SQL и опыт оптимизации сложных запросов;
• Понимание принципов работы PostgreSQL: MVCC, VACUUM, Autovacuum, WAL, Checkpoint, Replication;
• Практический опыт настройки и сопровождения кластеров PostgreSQL;
• Опыт работы с резервным копированием и восстановлением данных (pg_dump, pg_basebackup, PITR);
• Знание механизмов репликации PostgreSQL (Streaming Replication, Logical Replication);
• Опыт анализа производительности БД с использованием EXPLAIN ANALYZE, pg_stat_statements и систем мониторинга;
• Понимание принципов индексирования (B-Tree, GIN, GiST, BRIN), партиционирования и оптимизации хранения данных;
• Опыт работы в Linux-среде;
• Навыки автоматизации с использованием Bash, Python или PowerShell;
• Опыт работы с Git и понимание процессов CI/CD;
• Понимание принципов информационной безопасности и разграничения доступа к данным.

Будет плюсом:

• Опыт работы с PostgreSQL в высоконагруженных системах;
• Опыт настройки Patroni, PgBouncer, HAProxy, Keepalived;
• Опыт работы с системами мониторинга (Prometheus, Grafana, Zabbix);
• Опыт администрирования Redis, ClickHouse, Greenplum или других СУБД;
• Знание Docker и Kubernetes;
• Опыт миграции данных между различными СУБД;
• Понимание принципов построения DWH и ETL-процессов;
• Опыт работы с облачными сервисами (AWS, Azure, Yandex Cloud);
• Наличие сертификатов PostgreSQL будет преимуществом.

About the Role

We are seeking an exceptional Senior Engineer – Access Entitlements to design and scale the systems that discover, normalize, and reason about who has access to what across our customers' entire data estate — on-prem file shares, Active Directory, and SaaS platforms like SharePoint, Google Workspace, and Microsoft 365. You will build the connectors, pipelines, and graph models that turn millions of raw permission grants into an accurate, queryable picture of access across billions of files and identities, powering least-privilege analysis, access certification, and risk detection for enterprise customers

What You'll Do

• Entitlement Scanning: Build and extend connectors that enumerate identities (users, groups, service accounts, computers) and resource-level permissions (ACLs, role assignments, sharing links) across on-prem and SaaS data sources, handling per-connector quirks like SID resolution, inheritance breakage, and nested group membership
• Scale & Concurrency: Design entitlement pipelines that safely parallelize across large tenants — correctly handling shared state, batching, and checkpointing so a scan of hundreds of thousands of principals and files can pause, resume, and recover without data loss or duplication
• Data Modeling: Own the mapping from raw connector output to normalized entitlement records, and from those records into our identity graph — designing node/edge structures that represent principals, resources, and access grants (including sharing links and group-inherited access) in a way that supports fast traversal at scale
• Multi-Store Architecture: Work across the full data path — Elasticsearch for search-driven access, Databricks/Delta for large-scale analytical joins, and a Neptune-backed graph for relationship queries — making deliberate tradeoffs about what gets synced where, and keeping those stores consistent as data volume grows
• Entitlement-Activity Correlation: Build the pipelines that join static entitlements against observed activity logs to answer "who can access this, and who actually does" — the core signal behind over-permission detection and access-risk scoring
• Reliability & Correctness: Instrument and test for the failure modes unique to entitlement data — partial scans, malformed ACLs, race conditions in concurrent principal writes, and inconsistent state between graph and source-of-truth stores

What You'll Bring

• 6+ years of professional software engineering experience, with meaningful time spent on identity/access systems, security data pipelines, or large-scale distributed data processing
• Strong Go, Java, or Python skills, with direct experience writing concurrent/parallel data pipelines (goroutines, worker pools, or equivalent) and reasoning about race conditions and shared state
• Experience with graph databases or graph query languages (Gremlin, Cypher, or similar) and modeling relationship-heavy data
• Familiarity with Elasticsearch/OpenSearch and at least one large-scale analytical store (Databricks, Snowflake, BigQuery, Redshift)
• Understanding of identity and access concepts — RBAC, ACLs, group membership

Bonus Skills

• Experience with Microsoft Graph API, SharePoint REST APIs, or ActiveDirectory/LDAP-based identity systems
• Familiarity with AWS Neptune, TinkerPop/Gremlin, or other graph-native databases at production scale
• Background in DSPM, CIEM, IAM governance, or data security posture tooling
• Experience designing multi-tenant systems with per-tenant data isolation across search, analytical, and graph store

Mayflower is a technology company building highload products used by millions of people worldwide. Operating at the scale of one of the world's top-50 websites, we solve complex engineering challenges and create solutions that power real-time entertainment for a global audience.

We are looking for an experienced Database Infrastructure Engineer to join our Infrastructure team. Our goal is to ensure the reliability, scalability, security and performance of high-load relational database systems. The primary focus of this role is the administration and optimization of PostgreSQL and MariaDB clusters, automation via IaC, and the development of reliable HA/DR solutions.

Job Responsibilities

• Database Cluster Management: Deploy, administer, upgrade, and scale PostgreSQL and MariaDB clusters in high-load production environments;

• High Availability & Disaster Recovery: Design and maintain HA solutions, replication topologies, failover/switchover, backup/restore , and DR plan;

• Infrastructure as Code: Fully automate provisioning and configuration management using Terraform and Ansible;

• Performance Tuning: Analyze query execution plans, optimize indexes and database parameters, investigate locking and replication lag, and tune Linux kernel parameters for specific workload profiles;

• Observability: Configure monitoring, dashboards, logging, alerting, and SLOs for database services;

• Troubleshooting: Investigate incidents, analyze logs and metrics, identify performance bottlenecks, and participate in on-call activities;

• Automation: Develop tools and scripts for routine operations, health checks, failover validation, maintenance, and database lifecycle management.

You’ll thrive here if you have

• Experience: 3+ years as a DBA, DBRE, DevOps Engineer, or System Administrator with a strong focus on production relational databases;

• Deep understanding of PostgreSQL/MariaDB architecture and internal database processes;

• Building PostgreSQL/MariaDB high-availability architectures, replication, backup and performance tools;

• Experience HA soultions for PostgreSQL (Patroni, PgBouncer), MariaDB (MaxScale, Galera);

• Experience troubleshooting replication lag, deadlocks, locking issues, and transactional workloads;

• Hands-on experience testing failover scenarios and performing recovery from backups;

• Strong SQL and query optimization skills, analyze and profiling queries.

IaC & Automation:

• Strong proficiency in Terraform, including writing reusable modules and managing state files;

• Experience writing complex Ansible roles and playbooks.

Linux:

• Deep knowledge of Linux internals, filesystems, CPU, memory, disk I/O, networking, and kernel tuning for database workloads.

Observability:

• Experience with Prometheus/VictoriaMetrics, Grafana, and the ELK stack.

Scripting:

• Proficiency in Python or Bash for automation and operational tooling.

Big Plus:

• Kafka & Debezium: Experience configuring CDC pipelines from PostgreSQL or MariaDB using Debezium and Kafka Connect;

• Kubernetes & Helm: Experience running stateful database workloads in Kubernetes, including database operators;

• Cloud Platforms: Experience with managed database services and cloud infrastructure;

• Analytical & NoSQL Databases: Knowledge of ClickHouse, MongoDB, Redis or other distributed data platforms;

• Security: Experience with database access control, TLS, secrets management, auditing, and encryption;

• Programming: Experience supporting applications written in Java, Go, Python, or similar languages.

Conditions

We know that great talent deserves great conditions, so here's what you can expect when joining us:

• EU-based employment contract and a 3-year Cyprus work visa with full support for your relocation and visa processes, including assistance for your family.

• EU passport. Opportunity to obtain an EU passport after 4 years of residence

• Full relocation package: flights to Limassol for you and your family, a company-covered apartment for the first month, and full relocation support to make your move smooth and hassle-free.

• Provident fund (Cypus): a long-term savings plan co-funded by you and the Company together (available after probation) that grows throughout your time with us in Cyprus.

• Transparent performance reviews twice a year, with bonus opportunities and salary adjustments.

• Private medical insurance for you and your family

• Corporate mobile plan (unlimited in Cyprus with roaming included)

• Mindfulness & well-being support, including psychological assistance with 50% coverage.

• 50% coverage of school and kindergarten fees for your children.

• Fully covered sports benefits, and also access to in-house electric scooters and bike rentals

• Professional growth support: language courses, conferences, training programs, and coaching.

• Peer recognition program: receive and share kudos for great work.

• A fully equipped office in Limassol’s city center, with everything you need for deep work and collaboration.

• Free breakfasts and lunches in the office and an in-house coffee bar with high-quality drinks and a health bar stocked with nutritious snacks.

• A strong engineering culture: international teams, corporate events, team buildings, and hackathons — because great work happens in great communities.

Recruitment process

• HR interview (45 minutes);

• Technical interview (1.5 hour);

• Final interview (1 hour);

• Recommendations check;

• Job Offer.