Description

You will define technical standards and design the multi-level architecture for a large-scale software system.

This role is on-site.

Responsibilities

• Design complex relational databases using use cases, business requirements, and flow diagrams.
• Implement Integrated Justice Portal standards related to database development.
• Develop, maintain, and deploy batch processes supporting Gun Safety business functions.
• Write complex, efficient SQL queries and stored procedures for data extraction.
• Provide ongoing support for production applications, including monitoring and performance tuning.

Required Skills

• 84+ months experience creating Views, Triggers, stored procedures, functions, and writing SQL in Oracle (12c or higher).
• 84+ months experience using data modeling tools like ERWIN for logical/physical modeling in Oracle (12c or higher).
• 84+ months experience developing complex ETL processes using shell scripts (Korn, Bash, Power Shell), SQL, and PL/SQL.
• 84+ months experience optimizing SQL queries and debugging PL/SQL objects.
• 60+ months experience developing Korn shell and Bash shell scripts in a Linux environment.
• Proficiency in SDLC methodologies through analysis, design, testing, implementation, and maintenance.
• Expert ability to provide technical guidance to large teams.

Key Skills

Education

Any Graduate