Job Description

Requirements:

• Degree in Information Technology or Computer Science
• Oracle Certified Associate (OCA) - Oracle Database 12c or 19c - Required
• Oracle Certified Professional (OCP) - Oracle Database 12c or 19c - Advantage
• 5+ years of experience as an Oracle Database Administrator (DBA) in large enterprise environments
• Strong working knowledge of Oracle versions 12c, 19c, and/or 21c
• ITIL Practitioner (V3) / ITIL Specialist (V4)
• Hands-on experience with:

• Oracle RAC (Real Application Clusters)
• Oracle Data Guard (disaster recovery and high availability)
• Oracle RMAN (backup and recovery)
• Oracle Enterprise Manager (OEM)
• PL/SQL development (packages, triggers, procedures)
• Shell scripting for task automation
• 3+ years working in environments with complex business logic and high volumes of stored procedures
• Management of operations on virtualized and distributed infrastructures,
• Management of operations on environment with clustering, replication, load balancer
• Experience with performance tuning and advanced diagnostics (AWR, ASH, SQL Tuning Advisor)
• Exposure to functional/business workflows, ideally in logistics, supply chain, or ERP systems
• Familiarity with DevOps practices, version control, and Agile methodologies is a plus

Overall Responsibilities:

• Provide expert-level administration and support for Oracle databases (primarily 12c/19c/21c) across development, testing, and production environments.
• Act as the database specialist for the business projects using Oracle databases, with a strong focus on both infrastructure and understanding of business logic.
• Collaborate with developers, analysts, and business users to understand stored procedures, schemas, and underlying application workflows.
• Ensure high availability, performance, and security of Oracle database systems within the enterprise.
• Install, configure, patch, and upgrade Oracle database software across multiple environments (Azure and OnPrem)
• Design and implement database architecture, including tablespaces, partitions, indexes, and schemas.
• Monitor and optimize database performance using tools like AWR, ASH, and Oracle Enterprise Manager.
• Implement backup and recovery strategies using RMAN and Oracle Data Pump.
• Ensure database security, auditing, and compliance with company policies and regulations.
• Handle database replication, high availability (Oracle RAC), and disaster recovery strategies (Data Guard).
• Perform capacity planning and manage database storage across large enterprise environments.
• Automate routine DBA tasks using Shell or PL/SQL scripts.
• Realize periodical tuning of the databases to maintain I/O performances
• Analyse, interpret, and debug complex PL/SQL stored procedures, packages, and triggers.
• Work closely with application teams to align database logic with business processes.
• Understand end-to-end business workflows supported by Oracle systems, especially in the Logistics/Supply Chain domain.
• Translate functional requirements into optimized database queries or procedures.
• Participate in application development or modernization projects by providing database-level insights.

Skills Required