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?
He / She works on multiple Oracle databases from versions 11.2.x,12c,18c,**19c** and SQL server databases 2000, 2005, 2008, 2012, 2014, 2016, **2019** with other integrated third-party systems by representing DBA team and provide appropriate support to cross functional teams. Internally, this role will report to Gates ERP Technical Services lead in 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**:
- Other duties may be assigned beyond the core functions listed below._- Performing database administration activities in a safe, recoverable, and professional manner that ensures optimal operation of all database environments.-
- Provide development and production support on Oracle databases (11g,12c,18c,19c) and SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2019 including SSIS, SSAS and SSRS.-
- Performing capacity monitoring and short and long-term capacity planning in collaboration with infrastructure teams, system administrators and system architects.-
- Able to architect permanent solution for issues in areas like RMAN, Data guard, Refresh/cloning etc.-
- Should be able to write Shell scripts, DB performance analysis, OEM 13C, Windows power shell scripts.-
- Should be able to handle DB upgrades, SQL version migration, patching, and cloning.-
- Perform database optimization, administration, and maintenance (partitioning tables, partitioning indexes, indexing, normalization, synchronization, job monitoring, etc.).-
- Establish and enforce database change management standards including pushes from development to QA, and on to production.-
- Develop, implement, and verify database backup and disaster recovery strategies.-
- Design and implement all database security to ensure integrity and consistency among the various database regions-
- Develop and maintain documentation of the production environment.-
- Ability to lead the projects with mínimal super vision and direction.**QUALIFICATIONS**:_To_ perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required._- Bachelor's Degree in computer science, Information Technology, or equivalent.-
- At least 5+ years supporting production Oracle databases 11g,12c,18c,19c and SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2019.-
- Experience in.NET Development is added advantage.-
- Good to have Oracle/SQL certifications.**REQUIRED SKILLS**:
5+ years' experience working on Oracle/MS SQL database technologies. 3-5 yoe nth-
- Minimum 2 years' experience working on Oracle Multi-tenant architecture.-
- Good hands-on experience in working with Operating Systems (Unix, Linux, Windows)-
- Must have experience in handling at least one Major database upgrade end to end.-
- Proven experience with performance tuning, capacity planning, disaster recovery and testing.-
- Familiar with storage level snaps at array level and able to resolve issues.-
- Can demonstrate history of solving complex problems across multiple areas.-
- Support security/SOX audit reporting and provide input and recommendations.-
- Support change management including maintenance across multiple environments and deploying code and approved patches.-
- Expertise in SQL Server Internals and complete understanding of software development lifecycle.-
Ability to work within Global IT and business team.-
- Demonstrate diagnostic and troubleshooting skills and strong judgment. WHY GATES
Founded in 1911 in Denver, Colorado, Gates is publicly traded on the NYSE. While we might operate in a vast amount of time zones, we operate as "One Gates" and have a common goal of pushing the boundaries of materials science. We invest in our people, bringing real-world expe