About The RoleWe 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 integral application owners and development teams to resolve performance bottlenecksCapacity 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 efficiencySecurity- 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 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.

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