Db Admin. IT - Tlahuac, México - Gates Corporation

Gates Corporation
Gates Corporation
Empresa verificada
Tlahuac, México

hace 1 mes

Rodrigo Fernández

Publicado por:

Rodrigo Fernández

Reclutador de talento para beBee


Descripción
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.


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 longterm 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, 201
  • 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.

Más ofertas de trabajo de Gates Corporation