DBA Admin IT - Oracle/SQL server DBA role is part of the Gates Mexico Team & will be handling support to Oracle ERP application databases, Oracle core databases & SQL server databases by taking care of DBA operational task during MST timings.
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 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 minimal 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.
#LI-MC1
#J-18808-Ljbffr