Description

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

This role is remote.

Responsibilities

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

Required Skills

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

Preferred Skills

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

Key Skills

Education

Any Graduate