Database Administrator
Description
The DBA team is integral to the Software Architecture group, responsible for designing, testing, planning, implementing, protecting, operating, managing, and maintaining enterprise databases. The team is based in Brazil and collaborates closely with the Business, Engineering, DevOps, and SRE teams in Brazil and USA.
Responsibilities
- 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.
- Implementing database changes to improve performance, developing sharding and indexing policies, and running performance tests to validate recommendations.
- 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.
- 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.
- Determining, enforcing, and documenting database policies, procedures, and standards to ensure consistency and best practices across the organization.
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 knowledge on writing and troubleshooting SQL scripts, written in pure SQL or PostgreSQL's PL/PgSQL.
- 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.
## Plus Items
- 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 GitHub tools.
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!
