Senior Database Administrator (PostgreSQL, Ansible, Terraform)

Capital Com Australia limited; Warszawa; On-site; PLN 180,000 - 300,000; Full time

Benefits offered by this job

Competitive Salary

Annual Performance Bonus

Generous Time Off

Comprehensive Health & Pension Benefits

Workation Wonderland

Volunteer Days

Job summary

A leading trading platform in Poland is looking for a skilled Database Administrator to manage and optimize their database environments. Ideal candidates will possess a strong focus on PostgreSQL and MySQL, with IaC experience using Terraform and Ansible. Competitive compensation, work-life harmony, and generous time off are offered.

Qualifications

• Significant experience as a Database Administrator, focusing on PostgreSQL/MySQL.
• Proven experience with configuration management tools, preferably Ansible.
• Hands-on experience with IaC using Terraform.
• ],
• job_responsibilities_description [

Responsibilities

• Install, configure, and maintain PostgreSQL or MySQL database systems.
• Implement and manage database backups, restores, and recovery strategies.
• Design, implement, and test automated failover solutions.

Skills

PostgreSQL

MySQL

Terraform

Ansible

Bash

Python

Linux administration

Networking basics

Education

Bachelor's degree in Computer Science or IT

Tools

ClickHouse

Redshift

Microsoft SQL Server

MongoDB

Prometheus

Grafana

ClickHouse

MongoDB

Job description

Overview

We are a leading trading platform that is ambitiously expanding globally. Our top-rated products have won prestigious industry awards for their cutting-edge technology and seamless client experience. We are always in search of the best people to join our growing team.

We are seeking a highly skilled and proactive Database Administrator with a strong focus on PostgreSQL and MySQL, complemented by experience with infrastructure-as-code (IaC) using Terraform and configuration management with Ansible.

The ideal candidate will be responsible for managing, optimizing, and ensuring the high availability and security of our database environments. Experience with and implementing auto or manual failover, DNS management, and load balancing solutions is crucial. Additionally, experience with databases like ClickHouse/Redshift/Microsoft SQL Server/MongoDB is a significant plus.

Responsibilities

• Database Administration (Primary Focus: PostgreSQL and MySQL):
• Install, configure, and maintain PostgreSQL or MySQL database systems (cloud and on-premises)
• Perform database performance monitoring, alerting, and optimization
• Implement and manage database backups, restores, and recovery strategies
• Ensure database security through access controls, encryption, and regular audits
• Troubleshoot database issues and provide timely resolutions
• Plan and execute complicated database upgrades and migrations

• Infrastructure as Code (IaC) with Terraform:
• Design, implement, and manage database infrastructure using Terraform
• Automate the provisioning and management of database servers, storage, and related resources
• Maintain Terraform configurations and ensure infrastructure consistency

• Configuration Management with Ansible:
• Utilize Ansible playbooks to automate database deployments, configurations, and patching
• Ensure consistent database configurations across all environments
• Develop and maintain Ansible roles for database administration tasks

• Linux System Administration:
• Manage and maintain the underlying Linux operating systems hosting the databases
• Perform system monitoring, security hardening, and performance tuning
• Troubleshoot Linux-related issues affecting database performance and availability

• Auto Failover Implementation:
• Design, implement, and test automated failover solutions for database systems to ensure business continuity
• Implement and manage load balancing solutions for database traffic to ensure high availability and performance
• Understand and manage DNS configurations related to database accessibility and failover mechanisms
• Work with network teams to ensure proper DNS resolution for database services

• Collaboration and Documentation:
• Develop and maintain comprehensive documentation for database configurations, procedures, and disaster recovery plans for all managed database systems
• Participate in on-call rotation for critical database issues across all database technologies
• Collaborate with development, operations, and data science teams on database-related projects and initiatives

Qualifications

• Bachelor\'s degree in Computer Science, Information Technology, or a related field
• Excellent troubleshooting and problem-solving abilities
• Ability to work independently and manage multiple tasks effectively
• Strong communication and collaboration skills
• Significant experience as a Database Administrator, with a strong focus on PostgreSQL and MySQL
• Familiarity with CI/CD pipelines and routine automations
• Proven experience with configuration management tools, preferably Ansible
• Strong scripting skills (e.g., Bash, Python)
• Hands-on experience with Infrastructure as Code (IaC) using Terraform
• Experience with database monitoring tools (e.g., Prometheus, Grafana)
• Solid understanding of Linux operating systems
• Experience implementing and managing load balancing and auto-failover solutions for database systems

Preferred Qualifications

• Experience with cloud-based database services (e.g., AWS RDS, Google Cloud SQL)
• Knowledge of containerization technologies (e.g., Docker, Kubernetes) and their interaction with databases
• Knowledge of financial audit processes would be a plus
• Production ClickHouse or MongoDB experience

What you will get in return

Competitive Salary: We believe great work deserves great pay! Your skills and talents will be rewarded with a salary that makes you feel valued and motivated.

Work-Life Harmony: Join a company that genuinely cares about you - because your life outside of work matters just as much as your time on the clock. #LI-Hybrid

Annual Performance Bonus: Your hard work doesn’t go unnoticed! Celebrate your achievements with a well-deserved annual bonus tied to your performance.

Generous Time Off: Need a breather? Our annual leave policy lets you recharge and enjoy life outside of work without a worry.

Employee Referral Program: Love working here? Share the love! Bring your talented friends on board and get rewarded for growing our awesome team.

Comprehensive Health & Pension Benefits: From medical insurance to pension plans, we’ve got your back. Plus, location-specific benefits and perks!

Workation Wonderland: Live your digital nomad dreams with 30 extra days to work remotely from anywhere in the world (some restrictions apply). Adventure awaits!

Volunteer Days: Make a difference! Take two additional paid days each year to support causes you care about and give back to the community.

Be a key player at the forefront of the digital assets movement, propelling your career to new heights! Join a dynamic and rapidly expanding company that values and rewards talent, initiative, and creativity. Work alongside one of the most brilliant teams in the industry.

Applicable for Poland: Our company has an Internal Reporting Procedure. It is available from the Human Resources Department upon request [e-mail]. You may report a violation referred to in the Procedure under the terms specified therein.