Oracle DBA

NO H1S OR 3RD PARTIES.
The database administrator will work with a team responsible for the management of RDBMS systems supporting business systems applications. He/she will work with the database engineering team to provision, configure, patch and support RDBMS systems. This position requires solid knowledge of relational database technologies and hands-on experience building and managing enterprise RDBMS applications. Applicant should be skilled with Oracle database administration, Oracle clusterware and ASM, Oracle 19C , Database Performance Tuning, SQL tuning.

Key skills that the DBA should have -

Expertise in Oracle cloud Infrastructure administration.
Provision and support DB VM / Base systems, EXACS 9M systems in OCI.
Excellent knowledge of OS and storage aspects of Linux operating system.
Excellent knowledge and proven experience with Real Application cluster administration and patching.
Excellent knowledge of Exadata administration.
SQL Server administration experience.
Mysql / Aurora / Postgresql administrations.

Essential certifications
Oracle foundation and Associate certification in OCI.
Good to have key skills Mysql 5.6,5.7 and 8.0 , Postgresql database administration.

Job role will include

1. Review sql scripts for databases and execute them as part of production support.

2. Sound knowledge of RDBMS fundamentals and query tuning, explain plans , performance troubleshooting in Oracle.

3. Provision users , assign roles troubleshoot access.

4 .Participate on the team responsible for the administration and support functions related to RDBMS systems. Participate in root cause analysis activities. Participate in rotating 12 by 7 on-call operational support of the database systems as scheduled. Participate on teams that are responsible for "run” functions related to database architecture. Participate with diverse development and support teams to provide guidance on database issues, performance and scalability. Participate in rotating on-call support.

5.Perform support activities such as database software installation and configuration. Ensure database activities meet all security standards. Ensure data structures support the changing needs of the business. Ensure the reliability of the databases in the production environment.

6.Research and support shell scripting, aws cli , Terraform based basic coding.

7.Work closely with system, network, and SAN administrators to support highly available and scalable solutions. Provide support on database software patching and database life cycle management per company policy. Serve as a technical database resource on development teams as required.