Senior Database Administrator

Summary

Join Trustly's DBA team in Brazil and contribute to the stability, scalability, and performance of our databases. Collaborate with software architects, engineers, and other teams to ensure robust and efficient database systems. The role involves database administration, performance improvement, backup and recovery, security, and collaboration. You will contribute to database strategy, innovation, and documentation. Trustly offers a remote-first culture, allowing you to work from anywhere in Brazil, along with various benefits and perks.

Requirements

• Proven experience in database design, implementation, troubleshooting, and maintenance, particularly in high availability environments
• Strong to medium knowledge and hands-on experience with PostgreSQL administration and performance tuning
• Solid understanding of SQL and Business Intelligence concepts
• Strong command-line skills in Unix environments, essential for administering PostgreSQL databases, including familiarity with shell scripting for automation of routine tasks
• Excellent analytical skills, capable of monitoring database performance and evaluating complex information from various sources
• Great communication skills, able to effectively communicate with managers, developers, and other stakeholders
• Keen attention to detail to understand complex systems and recognize how minor errors can lead to major problems
• Strong problem-solving skills to quickly and effectively resolve issues as they arise
• Commitment to continuous learning and development, fostering a culture of innovation and operational excellence

Responsibilities

• Perform regular maintenance tasks
• Tune database settings for optimal performance
• Tackle complex database challenges
• Monitor database performance to ensure fast query responses
• Implement advanced backup and recovery strategies
• Formulate comprehensive disaster recovery plans
• Ensure robust security measures
• Implement database changes to improve performance
• Develop sharding and indexing policies
• Run performance tests to validate recommendations
• Enhance team effectiveness through strategic collaboration with software architects, system administrators, engineers, and data analysts
• Prepare and present statistical information for internal and external use
• Contribute significantly to database strategy
• Innovate in areas of database architecture and security
• Set standards for data protection and performance optimization
• Proactively make recommendations for system improvements
• Determine, enforce, and document database policies, procedures, and standards to ensure consistency and best practices across the organization

Preferred Qualifications

• Experience in deploying and managing PostgreSQL instances using Amazon RDS, including configuring read replicas, automated backups, and snapshots
• Knowledge of using Amazon Aurora for relational database solutions, leveraging its high performance and availability features
• Proficiency in containerizing PostgreSQL using Docker, managing container lifecycles, and orchestrating containers using Docker Compose
• Experience with Kubernetes for deploying, scaling, and managing PostgreSQL in containerized environments. Knowledge of using Helm charts for PostgreSQL deployments and ensuring high availability and resilience within Kubernetes clusters
• Knowledge of using Amazon Redshift for data warehousing solutions, including ETL processes, performance tuning, and managing large datasets
• Experience with Amazon Database Migration Service (DMS) for migrating databases to AWS with minimal downtime
• Fluency in English

Benefits

• Bradesco health and dental plan, for you and your dependents, with no co-payment cost
• Life insurance with differentiated coverage
• Meal voucher and supermarket voucher
• Home Office Allowance
• Wellhub - Platform that gives access to spaces for physical activities and online classes
• Trustly Club - Discount at educational institutions and partner stores
• English Program - Online group classes with a private teacher
• Extended maternity and paternity leave
• Birthday Off
• Flexible hours/Home Office - our culture is remote-first! You can work in every city in Brazil
• Welcome Kit - We work with Apple equipment (Macbook Pro, iPhone) and we send many more treats! Spoiler alert: Equipment can be purchased by you according to internal criteria!
• Annual premium - As a member of our team, you are eligible to receive an annual bonus, at the company's discretion, based on the achievement of our KPIs and individual performance
• Referral Program - If you refer a candidate and we hire the person, you will receive a reward for that!