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 (México)
🏢 Mary Kay de México
📍 México