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

Gates Corporation

Empresa verificada

Tlahuac, México

hace 2 semanas

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.

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.
Collaboration with Application Development teams to support Oracle databases (11g,12c,18c,19c).
Performing capacity monitoring and short and longterm capacity planning in collaboration with development resources, 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.
Require leading DB upgrades as per the Gates Oracle roadmap.
Installation, configuration, customization, maintenance, and performance tuning of SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2019 including SSIS, SSAS and SSRS.
SQL version migration, patching and security management.
Monitor database server capacity/performance and make infrastructure and architecture recommendations to management for necessary changes/updates.
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 processes for system monitoring, storage management, backup, and recovery.
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.
Represent the DBA team, architect the solution, and lead the projects as per the business needs.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

List the essential functions that are core to this position and represent at least 5% of the incumbent's time. Other duties may be assigned beyond the core functions listed below._

- _

1

45%
2
45%

Provide SQL DBA support to development and production environments and other interface systems using SQL server databases.3*

%Drives continuous improvement throughout the business and IT organization by promoting best practices, standardized business processes and systems.

4

%Perform any other duties assigned by hierarchical supervisor.

SUPERVISORY RESPONSIBILITIES:

***
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.
Good to have oracle certifications on OCI, AWS, OCP.

***
REQUIRED SKILLS:

5-7 years' experience working on Oracle/MS SQL database technologies.
At least 5 years' Experience on SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2019 a plus Good exposure on Installation, Configuration of database Cluster, Replication, Log shipping AND Mirroring
Minimum 2 years' experience working on Oracle Multitenant architecture.
Prior experience on working with Cloud platforms Oracle cloud infrastructure (OCI) or AWS
Hands on experience with shell scripting, OEM, WEBLOGIC, Discoverer
Good handson experience in working with Operating Systems (Unix, Linux, Windows)
Proven experience with performance tuning, capacity planning, disaster recovery planning 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.
Proven ability to work through SRs with Oracle Corporation technical support
Expert in setting up SQL Server high availability features for 24/7 production environment and troubleshooting database sizing and capacity planning.
Expertise in Troubleshooting and performance monitoring Database server Expertise in T-SQL and writing efficient and highly performing SQL Statements
Expertise in SQL Server Internals and complete understanding of software development lifecycle
Ability to work within Global IT and business team.
Excellent verbal and written communication and interpersonal skills