Oracel DBA (Oracle Database Administrator)

SUMMARY:
MTS's well established international client in the Warehousing and Logistics sector is looking for a skilled OCA certified Oracle DBA with 5+ years experience in large enterprise environments. Candidates must have expertise in Oracle versions 12c, 19c, and 21c, and strong knowledge of Oracle RAC, Data Guard, RMAN, OEM, and PL/SQL development.

POSITION INFO:
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

• 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.