Description

Key Responsibilities

Design, develop, test, and maintain Oracle database applications and solutions.

Develop and optimize PL/SQL packages, procedures, functions, triggers, and complex SQL queries.

Perform database performance tuning, troubleshooting, and optimization activities.

Design and manage database objects, tables, indexes, and related structures.

Implement and maintain business rules within Oracle applications.

Develop and support system-to-system integrations with third-party platforms using Service-Oriented Architecture (SOA).

Create and maintain technical specifications, architecture documentation, and system design documents.

Develop automation and support scripts using shell scripting and Python where applicable.

Collaborate with business stakeholders, architects, and development teams to deliver scalable and reliable solutions.

Participate in code reviews, testing activities, and production support efforts.

Required Qualifications

Minimum 5 years of hands-on experience working with Oracle 12c or higher.

Minimum 5 years of experience in PL/SQL application development.

Strong experience with:

PL/SQL programming

Functions and Stored Procedures

Table Design and Data Management

Query Optimization and Performance Tuning

Business Rule Implementation

Minimum 5 years of experience performing system-to-system integrations with third-party vendors using Service-Oriented Architecture (SOA).

Minimum 3 years of experience with shell scripting; Python scripting experience is preferred.

Minimum 3 years of experience creating and maintaining:

Technical Specifications

Architecture Documentation

System Design Documentation

Key Skills

Education

Bachelor's degree