Oracle Fusion Middleware Developer & Oracle PL/SQL

Summary: Oracle Fusion Middleware Developer & PL/SQL will be primarily responsible for design, development, maintenance, and enhancement of IT applications in Oracle Fusion Middleware platform as well as business logic in Oracle database objects. Interfaces with clients at all organizational levels and takes business requirements and delivers technical work to yield productive products for end-users., * Develop message formats and transformation logic using XML, XSLT, JSON, SQL, and PL/SQL to support inbound and outbound data feeds.

• Develop and maintain enterprise-grade business applications using Oracle and SQL Server RDBMS, ensuring data integrity, scalability, and performance across OLTP and OLAP environments.
• Deploy Oracle PL/SQL components, including packages, procedures, functions, triggers, views, and materialized views to support enterprise applications and integrations.
• Execute system analysis, ER modeling, and dimensional modeling using star and snowflake schema techniques for data warehouse and data mart solutions.
• Optimize SQL, PL/SQL, and TSQL code for performance, scalability, and reliability through query tuning, indexing strategies, execution plan analysis, and bulk operations.
• Implement Oracle features such as Oracle Scheduler, partitions, and performance-oriented indexing structures.
• Perform database modeling, schema design, normalization and denormalization, and enforcement of data integrity rules for large-scale enterprise systems.
• Conduct end-to-end performance analysis across applications, database using tools such as SQL tuning advisors, AWR reports and profiling utilities.
• Maintain database-backed service contracts, including stored procedures, views, APIs, and schema definitions for enterprise data exchange.
• Automate recurring business workflows using PL/SQL, .NET services, ETL orchestration tools, and scheduling platforms such as Autosys, Control M, and Informatica Cloud.
• Develop data migration, synchronization, and transformation solutions using SQL, PL/SQL, and ETL tools.
• Develop automation and scripting solutions using Unix Shell, PowerShell, and Batch scripting.
• Implement validation, reconciliation, error handling, and restart/recovery frameworks to ensure reliable and accurate data delivery across systems.
• Perform unit testing, integration testing, and UAT for PL/SQL code, .NET services, and ETL workflows, including creation of test cases, test data, and test logs.
• Troubleshoot runtime issues using Oracle logs, ETL monitors, .NET exception handling, job monitoring tools, and performance dashboards.
• Identify and resolve performance bottlenecks across database, ETL, and application layers using tuning strategies, caching, partitioning, pushdown optimization, and parallelism.
• Execute migration of database objects, ETL workflows across Dev, QA, UAT, and Production environments, ensuring controlled and compliant releases.
• Manage deployment automation using SQL scripts, shell/PowerShell scripts, Jenkins, Azure DevOps, GitHub Actions, and related CI/CD tools.
• Maintain version control, branching strategies, and code reviews using Git, GitHub, or SVN to ensure clean, modular, and maintainable codebases.
• Handle production support for database, ETL, and application processes, including incident analysis, root cause identification, data corrections, and timely resolution.
• Monitor system and job health using ETL monitors, database performance views, and enterprise schedulers such as Autosys, ControlM.
• Coordinate with business analysts, solution architects, and DBAs to define requirements, data models, mapping rules, and technical designs for endtoend data and application solutions.
• Prepare and maintain comprehensive technical documentation including architecture diagrams, deployment guides, interface specifications, schema definitions, and operational procedures.
• Participate in Agile ceremonies such as sprint planning, daily standups, reviews, and retrospectives, contributing to estimation, planning, and continuous improvement.
• Ensure adherence to organizational coding standards, security protocols, compliance requirements, and best practices across all development and integration activities.
• Participate in code reviews, and contribute to architectural discussions to ensure scalable and maintainable solutions.
• Contribute to solution architecture by evaluating new tools, frameworks, and technologies, and recommending improvements to enhance system performance, reliability, and scalability., * Performs planning, development, coding, testing, migration to production, and the maintenance of applications.
• Design user flows, platform architecture, software patterns, and data models to support current and long-term business needs.
• Adheres to applications standards and best practices.
• Working with IT teams, vendors to ensure project goals and milestones are achieved.
• Troubleshoot production issues and remedy these in a timely manner with minimal disruptions.
• Proven ability to support multiple projects/environments simultaneously.

• Bachelor's and/or master's degree in computer science or related discipline.
• 5 to 7 years of hands-on experience with Oracle Fusion Middleware stack including SOA, OSB, BPEL, B2B, Adaptors and Java Language development in JDeveloper.
• 8+ years in Oracle Database development and performance tuning.
• Operating systems such as Linux and Windows.
• Knowledge of SDLC activities on development projects.
• Experience with Agile methodology.
• Extensive PL/SQL programming using Oracle Database using TOAD/SQL Developer
• Develop in Oracle Fusion Middleware stack including SOA, OSB, BPEL, B2B, Adaptors and Java Language development in JDeveloper., * Strong written, oral, and interpersonal communication skills.
• Ability to conduct research into software-related issues and products.
• Ability to effectively prioritize and execute tasks in a timely manner.
• Ability to work both independently and in a team-oriented, collaborative environment.

Preferred skills:

• Knowledge on Java Application servers like Oracle WebLogic, Apache or IBM WebSphere and Internet technologies like HTML, XML, WSDL, scripting languages, Understanding of Cloud Technology and Solutions. Utility Industry knowledge

Certification:

• Training or Certification on Java Application servers, Cloud Solutions and Oracle PL/SQL Language is an added plus.