Asesor Técnico Home Office - Monterrey, N.L. - Dexian México

Descripción

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 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. 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.
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
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
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.
Experience: 7+ years in database performance, troubleshooting with deep experience with SQL Server and Oracle databases
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.
Monterrey, 3 Days on site, 2 home office.
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.
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.
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.
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.