• Monitor database performance and implement tuning strategies. • Ensure data integrity, backups, and disaster recovery readiness. • Collaborate with development teams on schema design, query optimization, and data modeling (OLTP/OLAP). • Support database security and access controls in compliance with DoD standards. • Maintain documentation and change control procedures. • Lead database upgrades and migrations. • Automate routine tasks (backups, patching, user provisioning) with versioned scripting and CI/CD. • Participate in on-call rotation, incident response, root-cause analysis, and capacity planning. • Integrate monitoring and alerting.

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