Fayetteville Public Works Commission

Analyst

• Provide day-to-day support for Oracle Utilities C2M/CCS applications
• Troubleshoot, analyze, and resolve system and application issues
• Configure and maintain application functionality
• Support integrations, APIs, batch processes, and interface monitoring
• Execute system, integration, and user acceptance testing (UAT)
• Assist with upgrades, patches, and change management processes
• Develop and maintain system documentation and knowledgebase materials
• Partner with business users to gather requirements and implement solutions
• Generate reports and support data extraction using queries
• Support customer service, billing, and meter-to-cash processes
• Perform extended computer-based work in an office-based role

Oracle Application Analyst – C2M/CCS

Database Administrator

• Administer, maintain, and support Oracle databases across on-premise and DBaaS environments
• Perform database installation, upgrades, patching, backups, and recovery
• Monitor database performance and tune systems to ensure optimal operation
• Manage data replication, refreshes, and overall configuration management
• Create and optimize complex queries, reports, and data extracts
• Maintain database integrity, security, and availability standards
• Develop and manage backup and recovery strategies using RMAN
• Implement and maintain disaster recovery (DR) and high availability (HA) solutions
• Proactively monitor systems and resolve issues in alignment with service level agreements (SLAs)
• Troubleshoot and resolve complex database issues across multiple environments
• Manage and escalate Oracle Service Requests (SRs) with Oracle Support as needed
• Support production and non-production environments, including change management activities
• Participate in system upgrades, testing, and technical design discussions
• Partner with IT teams and business stakeholders to gather and document technical requirements
• Contribute to performance optimization, system enhancements, and technical projects
• Maintain documentation aligned with system lifecycle, standards, and best practices
• Communicate with users and stakeholders regarding system performance and issue resolution

Oracle Application Analyst – C2M/CCS

Senior Oracle Database Administrator