DB Admin. IT - Oracle SQL Server DBA

Gates Corporation

Ciudad de México

Presencial

MXN 929.195 - 1.486.712

Jornada completa

14 días+

Recibe más respuestas de empleadores

Envía un currículum específico para el puesto de trabajo en cuestión de minutos.

Descripción de la vacante

Gates Corporation seeks a Senior Analyst for IT Applications focusing on database administration. The role involves managing Oracle and SQL Server databases, supporting cross-functional teams, and optimizing database performance. Candidates should have significant experience and a Bachelor's degree in Computer Science.

Formación

5 to 7 years of experience with Oracle and SQL Server databases.
Hands-on experience with Unix, Linux, and Windows.

Responsabilidades

Manage Oracle and SQL Server databases.
Execute database administration tasks and optimize performance.
Develop and implement database security protocols.

Conocimientos

Database Administration

Performance Tuning

Capacity Planning

SQL Performance Analysis

Scripting

Educación

Bachelor's degree in Computer Science

Descripción del empleo

Sr Analyst, IT Applications-Business Partner (DB Admin. IT - Oracle SQL Server DBA)

Join to apply for the Sr Analyst, IT Applications-Business Partner (DB Admin. IT - Oracle SQL Server DBA) role at Gates Corporation

Sr Analyst, IT Applications-Business Partner (DB Admin. IT - Oracle SQL Server DBA)

1 day ago Be among the first 25 applicants

Join to apply for the Sr Analyst, IT Applications-Business Partner (DB Admin. IT - Oracle SQL Server DBA) role at Gates Corporation

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Gates Corporation

Talent Acquisition Analyst @ Gates Corporation | Full Recruitment Cycle Management | C&B | DEI | TM | Event Planning | Shared Services

Are you inspired by challenging the status quo? Do you thrive in collaborative environments that drive results? If so, Gates could be for you.

Gates is a leading manufacturer of application-specific fluid power and power transmission solutions. We push the boundaries of material science to engineer solutions that continually exceed customer expectations.

Let's simplify it, think belts and hoses. Found in motorcycles, conveyor belts, cars, tractors, blenders, vacuum cleaners, bicycles, & 3D printers just to name a few. Because why not do it all?

Short Description

You will manage and maintain multiple Oracle databases and SQL Server databases, 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.

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 minimal 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 minimal supervision, ensuring timely and effective outcomes

Requirements And Preferred Skills

5 to 7 years of experience supporting production environments with Oracle databases (11g, 12c, 18c, 19c) and SQL Server (2000, 2005, 2008, 2012, 2014, 2016, 2019).
Bachelor's degree in Computer Science, Information Technology, or a related field.
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.
Oracle/SQL certifications are a plus.
Experience in .NET development is beneficial.
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.
Knowledge of array-level storage snapshots and issue resolution.
Demonstrated ability to tackle complex issues across different areas.
Ability to support security and SOX audit reporting with insights and recommendations.
Skilled in maintaining and deploying code and patches across multiple environments.
Experience working effectively within global IT and business teams.
Strong diagnostic skills and sound 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 experience that enables us to solve our customers' diverse challenges of today and anticipate those of tomorrow.

WORK ENVIRONMENT

Gates is an Equal Opportunity and is committed to ensuring equal employment opportunities for all job applicants and employees. Employment decisions are based upon job-related reasons regardless of race, sex, color, religion, age, disability, pregnancy, citizenship, sexual orientation, gender identity, national origin, protected veteran status, genetic information, marital status, or any other consideration defined by law.

ARE YOU DRIVEN BY POSSIBILITY?

Seniority level