24 feb
Gates
Álvaro Obregón
Are you inspired by challenging the status quo? Do you thrive in collaborative environments that drive results? If so, Gates could be for you.
Let's simplify it: think belts and hoses, found in motorcycles, conveyor belts, cars, tractors, and even 3D printers. Because why not do it all?
- In this role, the DBA will manage and maintain multiple Oracle databases (11.2.x, 12c, 18c, 19c) and SQL Server databases (2000, 2005, 2008, 2012, 2014, 2016, 2019), as well as various integrated third-party systems. This position serves as a DBA representative, providing essential support to cross-functional teams and ensuring smooth operation of database environments.
- The role reports internally to the Gates ERP Technical Services Lead based in the US.
- WHAT TO EXPECT
As an innovation leader, we are looking for ambitious, forward-thinking, and open-minded individuals to join our global team. Located in our Mexico City office, you will be working in a hybrid environment.
You'll be working with global, cross-functional teams.
This is an exciting opportunity for you because you'll be managing critical database systems.
You'll be optimizing the performance of Oracle and SQL Server databases.
Your goal will be to ensure data integrity, high availability, and security.
Your role is vital to Gates because database efficiency is key to our success.
**Key Responsibilities**:
- Administering and optimizing Oracle and SQL Server databases.
- Developing SQL scripts for performance tuning and troubleshooting.
- Implementing security protocols to safeguard sensitive data.
- Collaborating with IT and business teams to ensure seamless operations.
- Monitoring and managing backup/recovery systems for database continuity.
**ESSENTIAL DUTIES AND RESPONSIBILITIES**:
- Execute database administration tasks in a safe, recoverable, and efficient manner to ensure optimal performance across all database environments.
- Provide comprehensive support for development and production environments on Oracle (11g, 12c, 18c, 19c) and SQL Server databases (2000, 2005, 2008, 2012, 2014, 2016, 2019), including SSIS, SSAS, and SSRS.
- Conduct capacity monitoring and planning, working closely with infrastructure teams, system administrators, and architects to address both short
- and long-term needs.
- Architect and implement permanent solutions for critical issues, including RMAN, Data Guard, and database refresh/cloning processes.
- Proficient in scripting, including Shell scripting, PowerShell, and SQL performance analysis using OEM 13c, to automate tasks and enhance database management.
- Manage database upgrades,
SQL version migrations, patching, and cloning to ensure smooth transitions and mínimal downtime.
- Perform optimization, administration, and maintenance, such as table and index partitioning, indexing, normalization, synchronization, and job monitoring.
- Establish and uphold database change management standards, including the movement of changes from development to QA and production environments.
- Develop, implement, and test database backup and disaster recovery strategies to ensure robust data protection.
- Design and enforce comprehensive database security protocols to maintain integrity and consistency across environments.
- Create and maintain detailed documentation of the production environment to support ongoing operations and compliance.
- Demonstrate the ability to lead projects independently with mínimal supervision, ensuring timely and effective outcomes.
**QUALIFICATIONS/REQUIRED SKILLS**:
To successfully perform this role, an individual must be capable of meeting each essential duty. The following requirements outline the knowledge, skills, and abilities necessary:
**Education**: Bachelor's degree in Computer Science, Information Technology, or a related field.
**Database Experience**:
- 5+ years supporting production environments with Oracle databases (11g, 12c, 18c, 19c) and SQL Server (2000, 2005, 2008, 2012, 2014, 2016, 2019).
- At least 2 years working with Oracle Multi-tenant architecture.
- Hands-on experience with Unix, Linux, and Windows operating systems.
Completion of at least one major end-to-end database upgrade.
**Certifications**: Oracle/SQL certifications are a plus.
**Development Skills**:
Experience in.NET development is beneficial.
**Technical Proficiency**:
- Strong in Oracle/MS SQL database technologies.
- Expertise in SQL Server internals and a comprehensive understanding of the software development lifecycle.
- Proven experience with performance tuning, capacity planning, disaster recovery, and testing.
- ** Storage Management**: Knowledge of array-level storage snapshots and issue resolution.
- ** Problem Solving**: Demonstrated ability to tackle complex issues across different areas.
- ** Compliance and Security**: Ability to support security and SOX audit reporting with insights and recommendations.
- ** Change Management**: Skilled in maintaining and deploying code and patches across multip
Muestra tus habilidades a la empresa, rellenar el formulario y deja un toque personal en la carta, ayudará el reclutador en la elección del candidato.