• Responsibility for planning, operating and further developing our database landscape with a focus on PostgreSQL and Oracle. • Ensuring high performance, availability and security as well as extensive automation. • Administration, configuration and upgrades of PostgreSQL and Oracle databases, including backup & recovery. • Performance analysis and optimization (e.g., execution plans, indexing, bloat & lock management, wait events). • Design and operation of high-availability and replication solutions (PostgreSQL: Streaming Replication/Patroni; Oracle: Data Guard/HAS). • Patching, security measures (e.g., TDE, hardening, auditing) and conducting recovery tests. • Monitoring, capacity and storage management, as well as SLA and health reporting. • Automation using Shell/Python/Ansible and creation of reliable documentation (runbooks, playbooks, post-mortems).

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description The Oracle Subject Matter Expert (SME) is responsible for providing deep functional and technical expertise across Oracle Fusion Cloud applications. This role partners closely with business stakeholders, IT teams, and external vendors to design, configure, support, and optimize solutions that align with business objectives. The SME serves as a trusted advisor, ensuring system stability and continuous improvement across various Oracle modules, all while prioritizing best practices and future proofing of the Cennox ERP. - Serve as the primary subject matter expert for Oracle Fusion Cloud modules (e.g., Financials, SCM, CX, OFSC, EPM, EDM, FDI, OCI or OIC). - Support new project implementations, brainstorming sessions, and quarterly releases. - Translate business requirements into functional designs, configurations, and system solutions. - Collaborate with business users to optimize processes and improve system adoption. - Work with technical teams on integrations, reports, conversions, and extensions (REST APIs, BIP, OTBI, FBDI). - Ensure solutions align with Oracle’s best practices, security standards, and compliance requirements. - Create and maintain functional documentation, process flows, and training materials. - Support testing activities including unit, system, integration, and user acceptance testing (UAT). - Act as a liaison between business stakeholders, IT, and Oracle support. Qualifications - Strong hands-on experience with Oracle Fusion Cloud applications. - In-depth knowledge of at least one module (Financials, SCM, CX, OFSC, EPM, EDM) but must also have a working knowledge of all other modules. - Experience with Setup and Configuration settings along with functional setups. - High level knowledge of Oracle integration tools and technologies (REST/SOAP APIs, BIP, FDI, OTBI, FBDI). - Ability to gather, understand, and promote end-to-end business processes. - Ability to analyze complex problems and deliver practical solutions. - Excellent communication skills with the ability to explain technical concepts to non-technical stakeholders. - Experience supporting dev/test/production environments. - Familiarity with Oracle quarterly release cycles and impact analysis. - Strong documentation and organizational skills. Requirements - Experience with Oracle Fusion Cloud in a medium or large-scale environment. - Exposure to Oracle PaaS tools (OIC, VBCS, OCI). - Prior experience leading or supporting Oracle Fusion Cloud implementations and enhancements. - Experience working in regulated or compliance-driven environments. - Ability to mentor junior team members while acting as the SME.

• Install Oracle, Postgres database and troubleshoot various issues related to database patching. • Perform production database health check. • Detect potential issues that may impact production database operation and resolve the issues. • Performs database support for both production and development environments, including the installation of databases, back-ups, replication, restores, patches, and upgrades. • Ability to configure replication as a part of disaster recovery process. • Identify and resolve database issues that impact application performance. • All other duties and responsibilities as assigned. • Strong command of Oracle, Oracle server tools and Oracle Data Guard. • Advanced knowledge of database security, backup and recovery, performance monitoring and tuning standards. • Understanding of relational and dimensional data modelling. • Develop processes for optimizing database security. • Create and manage database reports, visualizations, and dashboards. • Create automation for repeating database tasks. • Be available for on-call support as needed.

• Administer, operate, and optimize production databases including Couchbase, PostgreSQL, DynamoDB, DocumentDB, Cosmos DB, and Snowflake. • Manage Couchbase clusters, including XDCR replication configuration, monitoring, and troubleshooting. • Perform database installations, upgrades, patching, and configuration management across cloud and on-prem environments. • Monitor database health, performance, and resource utilization across multi-cloud infrastructure. • Optimize query performance through indexing strategies, query tuning, and execution plan analysis. • Plan and manage database scaling strategies, including vertical and horizontal scaling, sharding, and capacity planning. • Implement and manage database security controls, including access management, encryption, and compliance requirements. • Design and maintain comprehensive backup strategies with appropriate retention policies. • Implement and validate restore procedures to meet defined RTO/RPO objectives. • Develop and maintain point-in-time recovery (PITR) capabilities. • Execute disaster recovery drills and document outcomes and improvements. • Participate in a 24/7 on-call rotation supporting mission-critical database systems. • Lead database-related incident response efforts, including outage resolution and performance degradation. • Perform root cause analysis and implement corrective and preventative actions. • Troubleshoot complex production issues such as replication lag, memory pressure, connection limits, and deadlocks. • Coordinate closely with application and infrastructure teams during critical incidents. • Implement and maintain monitoring and alerting using tools such as Datadog, CloudWatch, Azure Monitor, and database-native solutions. • Create and manage dashboards for database KPIs and SLAs. • Configure intelligent alerting with appropriate thresholds and escalation paths. • Automate routine operational tasks using Python, Bash, PowerShell, AWS CLI, and cloud-native tooling. • Lead and support database migration initiatives across cloud providers and platforms. • Plan and execute database upgrades and migrations with minimal downtime. • Support new database implementations and data architecture initiatives. • Validate data integrity and reconciliation during migrations. • Develop and maintain runbooks, SOPs, and Architecture Decision Records (ADRs). • Document database configurations, schemas, and topology. • Implement database security best practices including IAM roles, network isolation, secrets management, and encryption. • Manage credentials using AWS Secrets Manager and Azure Key Vault. • Ensure compliance with data residency, privacy, and regulatory requirements. • Participate in security audits, vulnerability assessments, and remediation efforts. • Partner closely with Data Engineering, DevOps, and application teams. • Provide database expertise and guidance across engineering teams. • Communicate database status, incidents, and maintenance activities to stakeholders. • Mentor junior DBAs and engineers on database best practices.