Senior Developer – Merchandise, Supply Chain

Jobtailor; Philippines; On-site; PHP 1,000,000 - 1,800,000; Full time

Job summary

Jobtailor in the Philippines seeks an experienced Oracle Developer to design and implement robust Oracle database solutions. You will craft data models, schemas, and database objects while engaging in the SDLC to deliver PL/SQL code, stored procedures, and packages.

You will optimize performance, ensure data integrity, and collaborate with cross-functional teams to integrate Oracle databases with various systems. Mentorship and lead project participation are expected traits.

Qualifications

• 8–10 years of experience as an Oracle Developer with a track record of successful database projects.
• Strong Oracle Retail experience.
• Expertise in PL/SQL, SQL, and database design principles.
• Expertise in Oracle Forms and Oracle Reports.
• Experience with Oracle Database and DB2 technologies.
• Experience in APEX and Shell Scripts.
• Familiarity with Pro*C.
• Experience implementing DevOps for Database Deployment (CI/CD).
• Knowledge of Order Management System and related integrations.

Responsibilities

• Design and implement Oracle database solutions including data models, schemas and database objects.
• Participate in SDLC: requirements gathering, development, testing and deployment of PL/SQL code, stored procedures, triggers and packages.
• Optimize database performance through tuning of SQL scripts, indexing and data structure improvements.
• Collaborate with cross-functional teams to integrate Oracle databases with various systems and applications.
• Ensure data integrity and smooth information flow between systems.
• Provide technical guidance and mentorship to junior developers and conduct code/architecture reviews.
• Identify and resolve complex database issues, performance bottlenecks, and data inconsistencies.
• Create and maintain thorough documentation for database designs and processes.
• Lead projects and actively participate to ensure timely delivery, coordinating with delivery leads and stakeholders.
• Stay informed about industry trends and best practices for Oracle database development.
• Maintain a safe working environment for team members and contractors.

Skills

PL/SQL

SQL

Oracle Forms

Oracle Reports

Oracle Database

DB2 Technologies

APEX

Shell Scripts

Pro*C

Database Performance Tuning

Tools

Workato

Kafka

Automic

Job description

• Responsible for designing and implementing Oracle database solutions including creating data models, schemas, and database objects.
• Participate in SDLC such as requirements gathering, development, testing, and deployment of Oracle PL/SQL code, stored procedures, triggers, and packages.
• Optimize database performance through tuning of SQL scripts, indexing, and improving the data structure.
• Collaborate closely with teams across different functions to effectively integrate Oracle databases with various systems and applications.
• Ensure the integrity of the data and a smooth flow of information between systems.
• Provide technical guidance and mentorship to junior developers and other team members such as conducting reviews on the code, architecture and design to ensure that best practices and standards are followed.
• Identify and resolve complex database issues, performance bottlenecks, and data inconsistencies.
• Create and maintain detailed documentation for database designs, processes, and procedures.
• Taking the lead and actively participating in various projects to ensure their successful and timely delivery.
• Work closely with delivery leads/managers and stakeholders to understand requirements and provide solutions that align with the business needs.
• Stay informed about the latest industry trends, advancements in technologies, and best practices for Oracle database development.
• Maintain a safe working environment for team members, contractors and visitors, and ensure that others are not put at risk.

Requirements

• Minimum of 8-10 years of experience as an Oracle Developer with a strong record of successful database projects
• Strong Oracle Retail experience
• Expertise in PL/SQL, SQL, and database design principles
• Expertise in Oracle Forms, Reports
• Expertise in Oracle database and DB2 technologies
• Experience in APEX
• Experience in Shell Scripts
• Knowledgeable in Pro*C
• Experience in implementing DevOps for Database Deployment (CI/CD for Automated Deployment of Database scripts)
• Knowledge of Order Management System
• Familiarity with Workato, Kafka, Automic

Core Competencies

Demonstrates extensive expertise in Oracle Database Development, including PL/SQL, SQL, and database design principles, while providing technical guidance and mentorship to junior developers. Proven ability to optimize database performance and implement DevOps practices for automated deployment.

Highest-signal resume keywords

• Oracle Database Development
• PL/SQL Expertise
• Database Design Principles
• DevOps for Database Deployment
• Oracle Retail Experience

ATS Optimization Keywords

Hard Skills

• PL/SQL
• SQL
• Oracle Forms
• Oracle Reports
• Oracle Database
• DB2 Technologies
• APEX
• Shell Scripts
• Pro*C
• Database Performance Tuning

Soft Skills

• Technical Guidance
• Mentorship
• Collaboration
• Problem Solving
• Communication

Industry Keywords

• SDLC
• Data Models
• Database Objects
• Data Integrity
• Order Management System

Tools & Technologies

• Workato
• Kafka
• Automic