An experienced Oracle DBA with deep technical expertise in installing, configuring, upgrading, migrating and managing production databases. Ideally should have 4-10 years of hands-on experience as a DBA managing production environments.
Must have skills
Good Conceptual knowledge of Oracle RDBMS internals, Backup & Recovery using RMAN, performance tuning, logical and physical design of database.
Experience working in an enterprise environment and supporting critical production databases and applications.
Experience in installing, configuring, upgrading and administering different versions of Oracle Database.
Strong experience with RAC and ASM Administration is required.
Strong understanding of Oracle Database Security concepts.
Must have the ability to upgrade and migrate databases from one platform to another using various tools like Oracle Data Pump, RMAN and TTS/XTTX and execute migrations using such tools.
Experience working with Data Guard and Active Data Guard.
Hands-on experience with Oracle Enterprise Manager.
Must be familiar with day-to-day operations such as monitoring, performance tuning and making recommendations after generating AWR and ADDR reports.
Troubleshooting Memory related errors with Oracle 12c and Patching with RAC and Non RAC.
Provide support for Oracle database environments that include problem identification, reporting, tracking, analysis, and resolution.
Strong shell scripting knowledge.
Good knowledge of PL/SQL.