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 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, 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
