Primary responsibilities:
- Maintain and enhance Oracle Utilities products (MDM, CCB, C2M, CCS) ensuring high availability and optimal performance.
- Manage and update maintenance objects, tables, and their properties across OUAF products.
- Develop, optimize, and troubleshoot complex SQL queries and procedures to support system functionality.
- Enhance database performance by optimizing queries and processes.
- Design and implement Java programs, including batch jobs and algorithms, to meet business requirements.
- Develop and maintain plug-in scripts, service scripts, business services, zones, UIs, and BOs in the OUAF framework.
- Configure and manage integration components such as external systems, external applications, outbound message types, and IWS.
- Ensure seamless integration with other systems and applications.
- Implement and monitor business processes such as IMD processing, commands (RC, DC, ODR), usage transactions, MDS setup, billing, and post-billing activities.
- Analyze and resolve issues in batch, application, and server logs efficiently.
- Configure, execute, and monitor batches for creating, processing, and reprocessing records in IMD, usage transactions, events, sync, activities, billing, payments, collections, and ILM.
- Analyze and understand the end-to-end functional processes of Oracle Utilities applications.
- Assess the impact of new processes or changes to existing workflows, ensuring minimal disruption.
- Oversee the execution and maintenance of key batch processes, ensuring data accuracy and consistency.
- Troubleshoot batch failures and guide the reprocessing of impacted data.
- Manage table partitioning and ILM activities to ensure efficient data archiving and retrieval.
- Collaborate with customers to gather requirements, provide solutions, and resolve issues effectively.
- Serve as a trusted advisor for production system support and enhancements.
- Proactively support production systems, identifying and addressing potential issues before they escalate.
- Lead root cause analysis for production incidents and implement corrective actions.
- Identify opportunities for process improvement and system optimization.
- Ensure compliance with best practices and organizational standards in system management.
Required Skills/Qualifications:
Technical:
- Having 8- 10 years of experience with a minimum of 5 recent years of experience in MDM, CCB, C2M, CCS.
- Good understanding of tables and maintenance objects and their properties for any OUAF product (MDM, CCB, C2M, CCS etc.).
- Strong Oracle SQL knowledge of writing complex queries and procedures.
- Strong SQL knowledge to optimize the query.
- Good knowledge of Java to create a Java program (batch and algorithms) and to analyze various jars programs.
- Good OUAF knowledge to create plug-in scripts, service scripts, business services, zones, UI, BO, Mos, etc.
- Should be able to configure external system, external application, outbound message type, IWS, and other integration components.
- End-to-end knowledge of major business processes like IMD processing, various commands (like RC, DC, ODR, and others), Usage transactions, MDS setup, billing and post-billing processing, and others.
- For processes mentioned in the above point, one should know all batches for creating, processing, and reprocessing the records even though they are not used.
- Good analytical skills to analyze the batch/app/server logs.
Functional:
- Good understanding of almost all functional processes of the application, limitations, and pros and cons.
- Good understanding to understand the impact of new processes and changes in existing processes.
- End-to-end understanding of main batches, how they pick data and process the data along with its impact of failure and reprocessing–
- IMD Batches
- Usage Transaction batches
- Event batches
- Sync batches
- Activity batches
- Billing batches
- Payment batches
- Collection process batches
- ILM batches
- High-level understanding of table partition, ILM activities, and archiving process.
- Experience in customer handling
- Experience of working in a production system
- Good if having experience in providing support on any project on a production system.