Description

You will manage and monitor Oracle application databases across production and non-production environments. You will implement, administer, and monitor assigned databases to ensure data integrity and security.

Responsibilities

• Analyze and resolve complex issues within Oracle 11/19c databases in development and production.
• Design and implement performance tuning improvements and advise developers on optimization options.
• Support cross-functional development teams to identify data relationships and constraints to optimize query performance.
• Develop tools using SQL, PL/SQL, and Linux shell scripts to support large numbers of test and development environments.

Required Skills

• 8+ years of experience implementing and managing production and non-production Oracle databases.
• In-depth knowledge of Oracle internal views, built-in functions, and architecture.
• Proficiency with Oracle 11/19c databases on Solaris and Linux systems.
• Expertise in SQL and PL/SQL for troubleshooting and fine-tuning.
• Experience with Tablespace consolidation, DBMS reorg, partition analysis, and index analysis.
• Ability to use Explain Plan to determine best-fit plans for performance improvement.
• Proficiency in Linux shell scripting.
• Experience with Erwin Modeling tool and star schema data modeling.

Key Skills

Education

Any Graduate