Capital11mo ago

Senior Database Administrator (PostgreSQL, Ansible, Terraform)

Poland·WarsawRemotesenior

DevOps & InfrastructureDatabase AdministratorData & AI

2 views0 saves0 applied

Apply Now

Quick Summary

Overview

Technical Tools

ansibleawsdockergcpgrafanakubernetesmongodbmysqlpostgresqlprometheuspythonsqlterraforma11yci-cdlinuxperformance-optimization

We are a leading trading platform that is ambitiously expanding to the four corners of the globe. Our top-rated products have won prestigious industry awards for their cutting-edge technology and seamless client experience. We deliver only the best, so we are always in search of the best people to join our ever-growing talented team.

We are seeking a highly skilled and proactive Database Administrator with a strong focus on AWS RDS 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, load balancing solutions is crucial for this role. Additionally, experience with databases like ClickHouse/Redshift/Microsoft SQL server/MongoDB is a significant plus.

Database Administration (Primary Focus: PostgreSQL and MySQL):

Provision, configure, and maintain PostgreSQL or MySQL database systems (AWS 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.

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.

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

• 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 hr@capital.com. You may report a violation referred to in the Procedure under the terms specified therein.