Database Engineer (PostgreSQL/MySQL, high-load) (Python)

⚡️ На крупное промышленное предприятие г. Карачева требуется администратор баз данных отдела информационных технологий⚡️

Полный день ⏰ Стабильные выплаты два раза в месяц

Выплата квартальной премии и 13-й зп по итогам работы Общества.

Мы предлагаем:

1️⃣ Официальное трудоустройство

2️⃣ Полный соц. пакет (оплачиваемые отпуска, больничные, спец. одежда, путевки в оздоровительные детские лагеря, новогодние подарки детям и т.д.)

3️⃣ Отсрочка от призыва на военную службу по мобилизации

4️⃣ Доставка сотрудников корпоративным транспортом по маршруту Брянск - Карачев - Брянск

5️⃣ Столовая на территории завода с вкусными обедами

6️⃣ Собственный тренажерный зал для работников завода

7️⃣ Участие в спортивных и культурных мероприятиях (секция бокса, футбола и настольного тенниса; участие в ГТО и турслёте и т.д.)

Обязанности:

✏️ Развёртывание СУБД на серверах, применение обновлений безопасности, миграция на новые мажорные версии;

✏️ Отслеживание выпусков новых версий и исправления ошибок СУБД и соответствующего ПО, планирование и выполнение работ по обновлению СУБД и ПО;

✏️ Настройка параметров СУБД под конкретное серверное оборудование;

✏️ Оптимизация производительности БД: анализ выполнения запросов, работа с индексами, настройка параметров СУБД. Оптимизация распределения вычислительных и сетевых ресурсов, взаимодействующих с БД;

✏️ Наблюдение за событиями СУБД, нагрузкой вычислительных ресурсов, устранение ошибок, анализ предупреждений. Выявление и устранение взаимных блокировок и долгих транзакций;

✏️ Ведение эксплуатационной и технологической документации, подготовка отчётов о функционировании БД;

✏️ Разработка стратегии резервного копирования, планирование и выполнение работ по резервному копированию, оперативному восстановлению данных из резервных копий, разработка процедур и скриптов для резервного копирования и восстановления данных, учёт резервных копий;

✏️ Управление учётными записями пользователей и приложений, разграничение прав доступа.

Требования:

1️⃣ Высшее техническое (профильное) образование. Приветствуется наличие профессиональных сертификатов;

2️⃣ Опыт работы в должности администрирования конкретной СУБД не менее 2-х лет;

3️⃣ Глубокие знания СУБД (Microsoft SQL, PostgreSQL, MySQL);

4️⃣ Знания языка запросов SQL на уровне проектирования сложных запросов, оптимизации медленных запросов, знание процедурных расширений (PL/pgSQL, T-SQL);

5️⃣ Администрирование ОС Windows / Linux на уровне настройки ядра под требования БД, написания скриптов автоматизации (bash, python);

6️⃣ Знание методов резервного копирования, умение стратегического планирования резервного копирования и проверки резервных копий;

7️⃣ Опыт работы с системами мониторинга (Zabbix, Grafna) и специализированными утилитами (pgBadger, Performance Monitor).

⚡️ Откликайся на вакансию прямо сейчас и стань частью нашего дружного коллектива! ⚡️

Cloud Services Team:

We are looking for a skilled Database Administrator with proven experience in designing, implementing, and managing large-scale, high-performance database systems. In this role, you will be responsible for ensuring the reliability, scalability, and security of mission-critical databases across multiple technologies and environments.

Challenges that await you:

• Architect and optimize database infrastructures to support large-scale, high-traffic workloads.
• Administer and maintain clusters across PostgreSQL
• Design and operate backup, recovery, and disaster recovery strategies, ensuring business continuity.
• Automate operational processes, including scaling, monitoring, and maintenance, using infrastructure-as-code (Terraform,OpenTofu, CloudFormation), Ansible, Gitlab CI
• Optimize performance at every layer: schema design, query execution, indexing, caching, and storage.
• Configure and manage replication and sharding strategies for high availability, fault tolerance, and geo-distribution.
• Ensure compliance with SOC 2, HIPAA, GDPR, and enforce database security best practices.

What makes you a great fit:

• 3+ years of hands-on experience as a DBA in production-grade, distributed environments.
• Deep knowledge of PostgreSQL
• Proven expertise in managing databases across major cloud platforms (Amazon Web Services, Google Cloud Platform, Azure, Yandex Cloud) 
• Advanced expertise in SQL query tuning, schema optimization, and indexing strategies.
• Strong experience with replication, partitioning, and clustering in high-availability systems.
• Proficiency in backup, restore, and failover mechanisms in multi-AZ and multi-region setups.
• Skills in automation and scripting (Python, Bash, Go).
• Familiarity with Kubernetes-based deployments(example operator Zalando for PG,Strimzi Kafka) and modern observability stacks (Prometheus, Datadog, AWS CloudWatch).
• B1 or higher English level for effective communication with an international team

Your bonus skills:

• Experience with IaC tools (Terraform, OpenTofu, CloudFormation).

Our ways of working:

• Innovative Spirit: A commitment to creativity and groundbreaking solutions
• Honest Feedback: valuing open, transparent communication
• Supportive Team: a strong, collaborative community
• Celebrating Achievements: recognizing our wins together
• High-Tech Environment: a team full of smart and revolutionary people who date to challenge the status quo of incumbent finances

Our benefits:

• Relocation support to Mexico, Serbia, Cyprus, Spain, Kazakhstan, Georgia with full visa & permit support to the employee and family
• Flexible work from one of our offices or remote
• Healthcare Coverage
• Education Budget: Language lessons, professional training and certifications
• Wellness Budget: Mental health and fitness activity reimbursements
• Vacation policy: 20 days of annual leave and paid sick leave

About the Managed Postgres team

The Managed Postgres team is building a high-performance, reliable PostgreSQL service within ClickHouse Cloud. We give developers a familiar PostgreSQL experience, remove operational burden, and connect transactional Postgres workloads with real-time analytics in ClickHouse. The team owns provisioning, high availability, backup and recovery, upgrades, observability, performance, security, and developer experience.

About the role

We are looking for an Engineering Manager to lead the team building and operating ClickHouse Managed Postgres. You will combine people leadership, technical direction, product thinking, and operational ownership while maintaining the reliability customers expect.

You will report directly to Kaushik Iska, who leads the Managed Postgres organization. You will partner closely with Product, Design, Infrastructure, Security, Support, and engineering teams across ClickHouse.

What you will do

• Lead, coach, and grow a high-performing team through clear expectations, feedback, development, and direct performance management.

• Own outcomes across provisioning, fleet management, failover, point-in-time recovery, upgrades, observability, performance, and security.

• Turn customer and business needs into a multi-quarter roadmap with incremental milestones.

• Guide architecture and help senior engineers make explicit, sound tradeoffs.

• Raise operational quality across SLOs, on-call, incidents, maintenance, and automation.

• Work directly with customers and turn recurring pain into product improvements.

• Align dependencies, surface risks early, and keep execution predictable across a distributed organization.

• Hire the right mix of PostgreSQL, systems, infrastructure, reliability, and product engineering talent while fostering ownership and clear technical debate.

What you bring

• 8+ years in software engineering, including 3+ years managing engineers in infrastructure, databases, or developer platforms.

• Experience building and operating a customer-facing stateful service with demanding availability, durability, security, and performance requirements.

• Working knowledge of PostgreSQL or managed relational databases, including replication, WAL, high availability, recovery, upgrades, observability, or performance diagnosis.

• Technical credibility to engage deeply in architecture and incidents without owning daily implementation.

• A record of hiring, coaching, developing, and retaining engineers, including senior ICs.

• Strong execution judgment across ambiguity, parallel workstreams, risk, and long-term system health.

• A customer mindset, strong Product partnership, clear communication, and distributed-team leadership.

Nice to have

• Managed PostgreSQL, relational database, or cloud control-plane leadership

• PostgreSQL internals, extensions, replication, storage, performance, or database reliability depth

• AWS, GCP, Azure, Kubernetes, infrastructure as code, or multi-region experience

• Experience taking infrastructure from early adoption through general availability

• Open-source, technical writing, speaking, startup, or founder experience

Why this role

• Shape a strategic product at the intersection of PostgreSQL and ClickHouse.

• Lead a technical team where correctness, performance, reliability, and developer experience all matter.

• Influence the product, roadmap, operating model, and customer outcomes.

Perks

• Flexible work environment - ClickHouse is a globally distributed company and remote-friendly. We currently operate in over 25 countries.

• Healthcare - Employer contributions towards your healthcare.

• Equity in the company - Every new team member who joins our company receives stock options.

• Time off - Flexible time off in the US, generous entitlement in other countries.

• A USD$500 Home office setup if you’re a remote employee.

• Global Gatherings – We believe in the power of in-person connection and offer opportunities to engage with colleagues at company-wide offsites.

Culture - We All Shape It

As part of a rapidly scaling start-up, you will be instrumental in shaping our culture.

Are you interested in finding out more about our culture? Learn more about our values here. Check out our blog posts or follow us on LinkedIn to find out more about what’s happening at ClickHouse.

Equal Opportunity & Privacy

ClickHouse provides equal employment opportunities to all employees and applicants and prohibits discrimination and harassment of any type based on factors such as race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Please see here for our Privacy Statement.