PL/SQL Developer

Job Role : IBM Sterling OMS Solution Architect

Experience : 15+ Years

Notice period : Immediate

Location : Trivandrum / Kochi / Remote

Note : OMS & Retail domain Experience is mandatory

Job Description :

As a Software Architect – IBM Sterling OMS, you will lead the design and delivery of high-quality enterprise-class OMS solutions and play a crucial role in guiding teams through architecture, implementation, and optimization of the Sterling platform

Mandatory Skills :

IBM Sterling OMS Architecture, Retail Domain Experience, Advanced Java, Sterling OMS Configuration & Customization, APIs (REST/WebServices), DB2/Oracle, XML/JSON, MQ Integration.

Responsibilities include :

• Define solution architecture and detailed technical design for IBM Sterling OMS initiatives across programs and projects.
• Lead and mentor development teams in designing, coding, customizing, and deploying Sterling OMS solutions.
• Translate functional requirements into scalable, resilient, and maintainable Sterling OMS architecture.
• Oversee end-to-end development for IBM OMS including design, development, deployment, debugging, and documentation.
• Ensure all OMS enhancements meet performance, scalability, and security standards aligned with stakeholder KPIs.
• Manage and evaluate technical requirements related to Sterling OMS (v10.0) including configurations, APIs, workflows, and database extensions.
• Estimate effort, cost, dependencies, and timelines for new features and architectural components.
• Provide architectural governance and conduct design and code reviews to ensure consistency with best practices.
• Lead integration architecture involving OMS and external systems (WMS, ERP, Commerce, TMS, Inventory).
• Guide OMS implementation efforts (across SL, BT, or custom OMS setups) and ensure the adoption of best practices.
• Collaborate with cross-functional IT teams across logistics, order orchestration, and fulfillment applications.]
• Drive secure, scalable, cloud-ready OMS development aligned with Agile methodologies.
• Contribute to continuous improvements through automation, reusable components, and standardized technical artifacts.

Primary Skills :

Experience :

• 15+ years of IT experience, including significant hands-on architecture and solution design experience with IBM Sterling OMS.
• Strong background in Java development at an advanced level.

Technical Skills :

• Advanced expertise in IBM Sterling Order Management System including configurations, customizations, workflows, SDF, DB extensions, and APIs.
• Strong experience with DB2 and Oracle databases, including performance tuning, indexing, and complex queries.
• Proficiency in XML, JSON, and integration patterns involving MQ, WebServices, and REST APIs.
• Experience with Linux/Unix environments (Intermediate/Advanced).
• Hands-on exposure to GCP (GKE, Artifact Registry, Compute Engine) or equivalent cloud platforms.
• Strong knowledge of Git and modern DevOps practices.

Secondary Skills :

• Experience integrating Sterling OMS with MQ, WebServices, and cloud-native components.
• Knowledge of Kubernetes and Docker for OMS deployment and troubleshooting.
• Familiarity with CI/CD pipelines using GitHub Actions, Jenkins, or similar tools.
• Strong soft skills : Self-learning, collaboration, planning, and organization. 

.Overall 5+ years of experience in application development using Java with creating and deploying microservices using the Spring Boot framework







• Strong experience in Maven.







• Good experience in unit(Junit) and integration testing.







• Experience in Microservices is a must.







Experience in designing and developing REST based services / Microservice development.







• Candidate should have good communication skills (written and verbal)







Excellent analytical and problem solving skills







Any one of these database Mongo, Maria, RMQ, Postgres, or other NoSQL servers







• Experience in AWS and CI/CD







5+ Years







Design, develop, and maintain robust, scalable, and secure backend services and APIs.







• Collaborate with frontend developers to integrate user-facing elements with server-side logic.







Write clean, efficient, and maintainable code following best practices and coding standards.







• Optimize performance and ensure high availability of backend services.







• Implement security measures to protect sensitive data and prevent vulnerabilities.







Design and manage databases, ensuring data integrity and efficient query performance.







Debug, troubleshoot, and resolve issues in production and development environments.







• Conduct code reviews and provide constructive feedback to team members.







Stay up-to-date with emerging backend technologies, frameworks, and best practices.







• Participate in Agile/Scrum ceremonies and contribute to sprint planning and estimations.

Position Overview

Oracle Apex Engineer with good experience building reports using the latest versions of Oracle Apex

and experience in Apex Upgrade. Should have a good working knowledge of Oracle

Applications(R12).

Skills

1-2 end to end implementation/development project

Strong detail, quality, and solution orientation

5+ years of experience designing and implementing technical solutions that are aligned with

business strategy

5 years of applications development experience with Oracle APEX, Oracle SQL, PL/SQL

5+ years of Oracle APEX experience

5+ years experience in Oracle Databases

5+ years experience using PL/SQL

5+ years of JavaScript, HTML, CSS, and REST services

Oracle APEX 4.2 experience is a must and ability to Upgrade to higher versions

Ability to work on SQL performance issues

Ability to think critically and solve complex issues

Ability to work independently, while engaging the customer and providing information to the team

Strong ability to communicate both verbally and in writing with internal and external teams

Ability to prioritize across multiple projects and meet deadlines

Experience adapting in a dynamic work environment

Experience working in a customer-focused environment

Ability to troubleshooting issue

Proficiency in analysis, design, development, testing, implementation, and maintenance of

applications in Oracle Application Express (APEX).

Excellent conceptual knowledge of Oracle 11g.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,

packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor,

Dynamic SQL.

Good knowledge of using PL/SQL Wrappers to protect the PL/SQL procedures and packages.

Job Description for Drools developer -

• Hands on experience in design and development in Drools rule engine (minimum 1.5 years) and Core Java
• Exceptional ability to communicate with both technical and non-technical people
• Expertise in object oriented programming
• Experience in Deploying and supporting core and advanced features
• Good exposure to SQL and/or Oracle/ MySQL,
• Candidate should be well verse with Agile processes
• Strong ability to work collaboratively across diverse groups of business and technical stakeholders is required.

Requirements:

• Retrieve Data from Databases

SSRS developers optimize SQL server queries to retrieve data efficiently and quickly. As

teams submit requests for different ways of doing things, SSRS developers work with them to find solutions that meet their needs.

• Design Data Solutions

To create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Microsoft Excel, MS SQL Server, and Tableau.

• Create and Maintain Reporting Processes

To maintain a record of the different reporting processes in place. Evolve ways & means for a more effective data management.

• Resolve IT and Data Issues
• Provide Delivery Plans and Estimates for Projects