Oracle Database Administrator (DBA)

We are looking for an experienced Oracle Database Administrator (DBA). Person should have at least 10 years of experience in managing Oracle databases. The Oracle DBA is responsible for the day-to-day management, performance, security, availability, and reliability of MTSP Oracle database environments.

Responsibilities

• Manage nonproduction databases (dev and UAT) which are 30TB+ in size.

- Create and maintain database instances, tablespaces, schemas, tables, indexes, and views

• Installation of HPS patches in non-production environment. Understand the dependencies and create documentation.

• Debug performance issues and work with HPS to fix them.

• Troubleshoot database issues and perform root-cause analysis.

• Knowledge of database partitioning.

• Importing DB tables from dmp files

• AWR analysis

• Performance improvement analysis

Skills

• Good knowledge of writing SQL queries.

• Experience of deployment and support of Azure services

• Experience in the Linux environment and a good understanding of its fundamentals and internals: filesystems and modern memory management, threads and processes, the user/kernel-space divide, etc.