Senior Database Administrator (PostgreSQL, Ansible, Terraform)
Brak informacji o wynagrodzeniu
SeniorFull-time
#315783·Dodano 11 miesięcy temu·33
Źródło: Capital.comTech Stack / Keywords
PostgreSQLAnsibleTerraformAWSMySQLSecurityDNSDatabases
Firma i stanowisko
We are a leading trading platform that is ambitiously expanding globally. Our top-rated products have won prestigious industry awards for cutting-edge technology and seamless client experience. We are continuously seeking talented individuals to join our growing team.
Wymagania
- Bachelor's degree in Computer Science, Information Technology, or 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 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
- Production experience with ClickHouse or MongoDB
Obowiązki
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
- Participate in on-call rotation for critical database issues
- Collaborate with development, operations, and data science teams on database-related projects and initiatives
Oferta
- Competitive salary
- Work-life harmony with hybrid work model
- Generous annual leave policy
- Employee referral program
- Comprehensive health and pension benefits including medical insurance and pension plans
- 30 extra days to work remotely from anywhere in the world (with some restrictions)
- Two additional paid volunteer days per year
Elastyczne godziny
Płatny urlop
Opieka zdrowotna
Pakiet relokacyjny
Płatne święta
Inne informacje
Applicable for Poland: Our company has an Internal Reporting Procedure available from Human Resources upon request. Violations may be reported under the terms specified therein.
Capital.com
19 aktywnych ofert