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
