.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 long-term 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*5%drives continuous improvement throughout the business and it organization by promoting best practices, standardized business processes and systems.
*4*5%perform any other duties assigned by hierarchical supervisor