• Provide day-to-day operational support for mission-critical SQL database environments supporting state agency legacy systems. • Monitor database health, performance, availability, and capacity. • Perform routine maintenance, patching, backups, restores, and disaster recovery support. • Troubleshoot and resolve database-related issues in coordination with application and infrastructure teams. • Ensure database environments meet established service levels and operational requirements. • Support current-state assessments by documenting existing database architectures, configurations, and data flows. • Inventory databases, schemas, jobs, integrations, and dependencies across legacy systems. • Identify technical debt, performance constraints, risks, and operational challenges within the database environment. • Provide subject matter expertise related to legacy system data structures and usage patterns. • Contribute database-related input to modernization planning and future-state discussions. • Support analysis of database migration, modernization, or replacement options. • Assist in defining database-related technical requirements, assumptions, and constraints for future-state solutions. • Provide operational insights to ensure future designs are supportable, secure, and maintainable.

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