Analista de Banco de Dados, Sênior

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Define, designs, and maintains the architecture of corporate databases, ensuring scalability, availability, and information security.

• Develop conceptual, logical, and physical data models aligned with business requirements.

• Participate in establishing standards, best practices, and data governance across the organization.

• Design solutions for data storage, integration, and processing in both on-premises and cloud environments.

• Evaluate and recommend database technologies, platforms, and tools based on project requirements.

• Ensure the integrity, consistency, and quality of stored data.

• Conduct performance analyses and propose continuous improvements in queries, indexes, partitioning, and data structures.

• Define backup strategies, disaster recovery plans, and high availability measures.

• Support development teams, data engineering, and infrastructure in implementing best practices for database usage.

• Participate in designing integration architectures among systems, Data Warehouses, Data Lakes, and analytical solutions.

• Prepare technical documentation for architecture, data models, and processes related to database management.

• Conduct capacity analyses and growth planning for data environments.

• Serve as a technical reference for multidisciplinary teams on data and corporate platform initiatives.

⛳️ Requirements

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, or related fields.

• Proficiency in Oracle.

• Proficiency in SQL Server.

• Proficiency in PostgreSQL.

• Proficiency in MySQL.

• Knowledge of non-relational databases: NoSQL, MongoDB, Cassandra, Redis, and DynamoDB.

• Expertise in data modeling.

• Conceptual, logical, and physical modeling skills.

• Dimensional modeling (Star Schema and Snowflake).

• Familiarity with Data Warehouse and Data Lake concepts.

• Advanced SQL skills.

• Experience with Procedures, Functions, and Triggers.

• Query optimization experience (Query Tuning).

• Capacity planning skills.

• Monitoring and troubleshooting expertise.

• Experience with Azure SQL Database.

• Experience with Azure PostgreSQL.

• Experience with AWS RDS.

• Experience with AWS Aurora.

• Experience with Google Cloud SQL.

🏝️ Benefits

• Flash Card with food allowance/refeeding of R$ 32.00 per day.

• Home office allowance of R$ 100.00/month.

• Flexible working hours.

• SulAmérica Health Plan.

• Bradesco Dental Plan.

• Option to include dependents.

• WellHub, TotalPass, and UniCamente, providing access to physical activities and health professionals from various fields.

• Onhappy, offering exclusive discounts on accommodations, tickets, and experiences.

• Pet Health Plan from Guapeco.

• Discounts and Rewards Club.

• Extended maternity and paternity leave.

• PLR according to the union table.

• Day-Off on Birthday.

• No Dress Code.

• Continuous Education and Training Incentive Program.

• Talent Referral Program.