Database Administrator at trustly

WHO WE ARE At Trustly, we're building a smarter, faster, and more secure financial future by revolutionizing the world of payments. As a global leader in Open Banking Payments, we are establishing Pay by Bank as the new standard at checkout, providing unparalleled freedom, speed, and ease to millions of consumers and merchants worldwide. Our Ambition: To build the world’s most disruptive payment network and redefine what the payment experience should feel like. Trustly is a global team of innovators, collaborators, and doers.  If you are driven by a strong sense of purpose and thrive in a dynamic, entrepreneurial, and high-growth environment, join us and be part of a team that’s transforming the way the world pays. What you will do: DBAs play a crucial role in ensuring the stability, scalability, and performance of our databases, working closely with software architects, engineers, DevOps, and SREs who focus on the application side. This collaboration ensures that both the databases and applications are robust, efficient, and aligned with the overall architecture. Initially focused on database administration tasks, the role emphasizes operational efficiency, evolution, and growth. The team is committed to maintaining a seamless integration between database operations and application development, fostering a clear pathway to professional growth and continuous development. Key activities of our DBA team include: • Technical Expertise and Maintenance: Help the DevOps/SRE team on performing regular maintenance tasks, tuning database settings for optimal performance, tackling complex database challenges, and monitoring database performance to ensure fast query responses. • Performance Improvement: Implementing database changes to improve performance, developing sharding and indexing policies, and running performance tests to validate recommendations. • Collaboration and Communication: Enhancing team effectiveness through strategic collaboration with software architects, system administrators, engineers, and data analysts, and preparing and presenting statistical information for internal and external use. • Strategy and Innovation: Contributing significantly to database strategy, innovating in areas of database architecture and security, setting standards for data protection and performance optimization, and proactively making recommendations for system improvements. • Documentation and Policy Development: Determining, enforcing, and documenting database policies, procedures, and standards to ensure consistency and best practices across the organization. Who you are: • Extensive Experience: Proven experience in database design, implementation, troubleshooting, and maintenance, particularly in high-availability environments. • PostgreSQL Expertise: Strong to medium knowledge and hands-on experience with PostgreSQL administration and performance tuning. • SQL and BI Proficiency: Solid understanding of SQL and Business Intelligence concepts. • SQL and Procedural SQL: Strong knowledge on writing and troubleshooting SQL scripts, written in pure SQL or PostgreSQL's PL/PgSQL • Linux/Unix Proficiency: Strong command-line skills in Unix environments, essential for administering PostgreSQL databases, including familiarity with shell scripting for automation of routine tasks. • Analytical Skills: Excellent analytical skills, capable of monitoring database performance and evaluating complex information from various sources. • Communication Skills: Great communication skills, able to effectively communicate with managers, developers, and other stakeholders. • Detail-Oriented: Keen attention to detail to understand complex systems and recognize how minor errors can lead to major problems. • Problem-Solving: Strong problem-solving skills to quickly and effectively resolve issues as they arise. • Professional Development: Commitment to continuous learning and development, fostering a culture of innovation and operational excellence. Plus Items: • AWS Solutions: • Amazon RDS for PostgreSQL: Experience in deploying and managing PostgreSQL instances using Amazon RDS, including configuring read replicas, automated backups, and snapshots. • Amazon Aurora: Knowledge of using Amazon Aurora for relational database solutions, leveraging its high performance and availability features. • Virtualization/Containerization Platforms: • Docker: Proficiency in containerizing PostgreSQL using Docker, managing container lifecycles, and orchestrating containers using Docker Compose. • Git: Experience with GitHub tools. Our perks and 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; • Monthly happy hours; • 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!; • Referral Program - If you refer a candidate and we hire the person, you will receive a reward for that! #LIRemote At Trustly, we embrace and celebrate diversity of all forms and the value it brings to our employees and customers. We are proud and committed to being an Equal Opportunity Employer and believe an open and inclusive environment enables people to do their best work.  All decisions regarding hiring, advancement, and any other aspects of employment are made solely on the basis of qualifications, merit, and business need.