Job Description:
As a Senior Database Analyst, you will play a crucial role in designing, implementing, and managing our database infrastructure to ensure optimal performance, scalability, and reliability. You will collaborate closely with data engineers, data scientists, and other stakeholders to deliver robust data solutions that support our business objectives.
Key Responsibilities:
- Design, build, and maintain PostgreSQL databases to support various business applications and data projects.
- Optimize database performance through tuning, indexing, and query optimization.
- Implement and manage data replication, backup, and recovery processes to ensure data integrity and availability.
- Collaborate with data engineering and development teams to design efficient database schemas and data models.
- Develop and enforce database standards, best practices, and security protocols.
- Troubleshoot and resolve complex database issues, ensuring minimal downtime and data loss.
- Monitor database performance and implement proactive measures to ensure optimal operation.
- Participate in the design and implementation of data governance policies and procedures.
- Provide technical guidance and mentorship to junior database analysts and other team members.
- Stay current with the latest advancements in database technologies, particularly PostgreSQL, Google Cloud SQL, and AlloyDB.
Qualifications:
- Bachelor's or Master’s degree in Computer Science, Engineering, Information Technology, or a related field.
- Fluency in English, Portuguese, or Spanish
- Extensive experience working as a Database Analyst, with a strong focus on PostgreSQL.
- Certifications in Google Cloud SQL, PostgreSQL, and/or AlloyDB.
- Proficiency in database design, performance tuning, and optimization techniques.
- Strong understanding of data replication, backup, and recovery strategies.