He / She works on multiple Oracle databases from versions 11.2.x,12c,18c,**19c** and SQL server databases ****, ****, ****, ****, ****, ****, ******** 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 ****, ****, ****, ****, ****, ****, **** 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 ****, ****, ****, ****, ****, ****, ****.-- 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 Integral IT and business team.
-- Demonstrate diagnostic and troubleshooting skills and strong judgment.
-**#LI-MC1

📌 Db Admin. It - Oracle Sql Server Dba (Xico)
🏢 Gates
📍 Xico