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