Database Administrator

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 MHE 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 MHE policy. Serve as a technical database resource on development teams as required.