Description

You will manage and maintain mission-critical Oracle database environments.

Responsibilities

• Design, develop, and execute database scripts and processes.
• Assess and communicate the impact of required changes for the modernization project.
• Review, approve, and implement views, PL/SQL procedures, and functions.
• Maintain JJIS database environments, including production, reporting, testing, and development.

Required Skills

• Minimum 9 years managing and tuning on-prem Oracle databases (11g, 12c, or newer).
• Minimum 9 years writing, optimizing, and troubleshooting complex SQL queries, stored procedures, triggers, and modernization scripts.
• Minimum 9 years with schema management, security management, data mapping, and tools like Toad and SQL Developer.
• Minimum 5 years experience with CI/CD pipelines.
• Minimum 5 years designing and maintaining data interfaces and flat file exchange processes.
• Experience with UNIX and Shell Scripting, including CRON jobs.
• Proficiency in PL/SQL.

Preferred Skills

• Experience with applications hosted on Azure Cloud.
• Experience working within an Agile methodology.

Key Skills

Education

Any Graduate