Database Administrator
- Trustly
- Remote Brazil
Job Description
What you will do:
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:
