Sr. DBA Consultant

Mary Kay do Brasil; São Paulo; Presencial; BRL 180 000 - 240 000; Tempo integral

Resumo da oferta

Mary Kay do Brasil is seeking a highly skilled Technical Consultant to join the Data Management team. The role focuses on maintaining multi-platform database infrastructure, optimizing performance, security, and cost-efficiency across cloud environments, with opportunity to evolve into technical leadership and data strategy.

The candidate will manage and optimize SQL Server, Oracle, PostgreSQL, MySQL, and MongoDB, drive capacity planning and cloud cost optimization, and mentor peers while

Qualificações

• Bachelor's degree in Computer Science, Information Systems or related field.
• 7+ years in database performance, troubleshooting, across platforms such as SQL Server and Oracle.
• Fluent English communication (written and spoken).
• Certifications in AWS, Azure, Oracle, SQL Server or equivalent are a plus.

Responsabilidades

• Troubleshoot and optimize databases across SQL Server, Oracle, PostgreSQL, MySQL, and MongoDB.
• Monitor performance, identify bottlenecks, and optimize queries and indexes.
• Develop frameworks to identify performance issues and automate diagnostics.
• Collaborate with global teams to standardize best practices and reduce costs.
• Mentor junior team members and contribute to data strategy and architecture.

Conhecimentos

Database tuning

SQL optimization

Cloud architectures

HA/DR expertise

Automation & IaC

Formação académica

Bachelor's degree in CS/IS

Ferramentas

AWS

Azure

Oracle

SQL Server

PostgreSQL

Descrição da oferta de emprego

We are seeking a highly motivated and technically skilled Technical Consultant to join our Data Management team. This role is critical to maintaining and optimizing Mary Kay’s multi-platform database infrastructure, ensuring performance, security, and cost-efficiency across cloud environments. The position is designed to evolve into a technical leadership and data strategy role, offering long-term growth and impact.

Responsibilities:

Database Performance Troubleshooting

• Manage and optimize databases across platforms including SQL Server, Oracle, PostgreSQL, MySQL, and MongoDB.
• Monitor database performance and proactively identify and resolve availability and performance bottlenecks.
• Utilize advanced techniques to optimize SQL queries, including index tuning, query plan analysis, and performance troubleshooting.
• Lead performance tuning, right sizing, and proactive troubleshooting.
• Framework Development: Develop frameworks and tools to identify performance bottlenecks and optimize SQL Server and Oracle queries.
• Leverage in-depth knowledge of Database Engines to analyze, optimize, and enhance Database Server workloads to ensure optimal performance and efficiency.
• Collaborate with multiple teams to implement and standardize the best practices for performance enhancement.
• Collaborate with global application owners and development teams to resolve performance bottlenecks

Capacity Management

• Evaluate the database environment, report on infrastructure consumption, and provide suggestions for improving the environment and reducing costs.
• Drive cloud cost optimization initiatives and infrastructure efficiency

Security

• Ensure security, compliance, and standardization across all database systems
• Provide technical consulting for global projects and cloud-native technology adoption
• Own and evolve the architecture of cloud databases and storage, including Azure Files.
• Mentor team members and foster a collaborative, high-performance environment.

What You’ll Need To Be Successful:

• Experience: 7+ years in database performance, troubleshooting with deep experience with SQL Server and Oracle databases
• Education: Bachelor/University Degree in Computer Science, Information Systems, or a related field
• Language: Fluent reading, writing, and speaking in English. All resumes need to be submitted in English.
• Preferred Certifications: AWS certified Solutions Architect – Associate; Microsoft SQL Server professional Certificate; Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert.Oracle Certified Professional (OCP), PostgreSQL Certified Professional, or equivalent.
• Proven experience managing and optimizing databases across multiple platforms: SQL Server, Oracle, PostgreSQL, MySQL, and MongoDB.
• In-depth understanding of database internals, with a strong ability to diagnose and resolve complex performance issues.
• Proven experience in database performance troubleshooting and collaboration with developers for process improvements.
• In-depth understanding with hands on experience with high availability (HA) and disaster recovery (DR) solutions.
• Thorough understanding on how database engine work with server, storage and network components.
• Maintain a deep understanding of SQL Server and Oracle database engines, features and apply them effectively to the environment.
• Deep knowledge of cloud architecture and infrastructure and cloud database services, particularly AWS, OCI and Microsoft Azure.
• Experience with cloud cost optimization, storage architecture, and cloud-native design patterns.
• Hands-on experience with infrastructure-as-code and automation tools (e.g., Terraform, PowerShell, Azure CLI).
• Demonstrated ability to implement and maintain database security, compliance standards, and governance frameworks.
• Experience with auditing, encryption, role-based access control, and data masking.
• Strong interpersonal skills with the ability to collaborate across global teams, including application owners and developers.
• Experience in technical consulting, stakeholder engagement, and translating business needs into technical solutions.
• Demonstrated ability to mentor junior team members, lead technical discussions, and contribute to team development.
• A growth mindset with the ambition to evolve into technical leadership and data strategy roles.