About The Role

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.

Collaboration:

- 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.

- Location

: Monterrey, Mexico OR Sao Paulo, Brazil (hybrid)

- 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 general 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.

📌 Sr. DBA Consultant (Monterrey)
🏢 Mary Kay de México
📍 Monterrey