Description

You will administer and manage application databases across production and non-production environments.

This role is on-site.

Responsibilities

• Implement, administer, manage, and monitor assigned application databases to ensure data integrity and security.
• Design and implement performance tuning improvements for large, complex initiatives.
• Support cross-functional development teams to optimize application and query performance by analyzing data relationships.
• Develop tools using SQL, PL/SQL, and Linux shell scripts for database support.

Required Skills

• 8+ years of experience implementing and managing application databases.
• Advanced knowledge and expertise in developing and optimizing Oracle SQL and PL/SQL code.
• In-depth knowledge of Oracle internal views, built-in functions, and architecture.
• Experience using Explain Plan to determine optimal query plans.
• Proven ability to analyze and resolve complex issues in Oracle 11/19c databases.
• Advanced knowledge monitoring, troubleshooting, and fine-tuning SQL/PL/SQL on Oracle systems running on Solaris/Linux.
• Experience with CI/CD workflows and automation orchestrators like Jenkins.
• Hands-on experience with Oracle SQL Developer and Erwin Modeling tool.

Preferred Skills

• Familiarity with Agile methodology and large development projects.

Key Skills

Education

Any Graduate