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.
*supervisory responsibilities*:
*
*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.
- good to have oracle certifications on oci, aws, ocp.
*
*required skills*:
- 5-7 years' experience working on oracle/ms sql database technologies.
- at least 5 years' experience on sql server 2000, 2005, 2008, 2012, 2014, 2016, 2019 a plus good exposure on installation, configuration of database cluster, replication, log shipping and mirroring
- minimum 2 years' experience working on oracle multi-tenant architecture.
- prior experience on working with cloud platforms oracle cloud infrastructure (oci) or aws
- hands on experience with shell scripting, oem, weblogic, discoverer
- good hands-on experience in working with operating systems (unix, linux, windows)
- proven experience with performance tuning, capacity planning, disaster recovery planning 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.
- proven ability to work through srs with oracle corporation technical support
- expert in setting up sql server high availability features for 24/7 production environment and troubleshooting database sizing and capacity planning.
- expertise in troubleshooting and performance monitoring database server expertise in t-sql and writing efficient and highly performing sql statements
- expertise in sql server internals and complete understanding of software development lifecycle
- ability to work within global it and business team.
- excellent verbal and written communication and interpersonal skills