Oracle Developer

HCLTech; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

HCL Technologies Limited in Singapore is seeking a seasoned Oracle PL/SQL developer to enhance the corporate action processing system and support related database and shell scripts. You will contribute to robust design, technical specifications and live issue resolution.

Ideal candidates have 6–8 years in Asset Servicing, strong Oracle expertise, and proven collaboration across global teams. Excellent communication and documentation skills are essential to maintain standards and knowledge

Qualifications

• Bachelor's degree in Engineering/CS/IT or related field.
• 6–8 years in Asset Servicing domain.
• Strong Oracle 12c SQL & PL/SQL design, development and implementation.
• Expertise in database performance tuning.
• Experience with XMLDB, JSON processing and Advanced Queues in Oracle.
• Experience with MQ middleware.
• Excellent verbal and written communication skills.
• Strong time management and coordination across co-located teams.
• Strong relationship management across multiple areas of the organization.
• Understanding of Corporate Actions processing and building a corporate action processing platform.

Responsibilities

• Develop and enhance corporate action processing system using Oracle 12c PL/SQL.
• Develop supporting Oracle database and shell scripts.
• Produce detailed technical analyses and robust design and development.
• Produce technical specifications from business analysis deliverables.
• Provide live support and issue investigation in production.
• Adopt and enforce programming standards.
• Perform unit and integration testing of developed code.
• Conduct peer reviews of other developers' code.
• Maintain comprehensive application documentation.
• Promote knowledge sharing within the global development team.

Skills

Oracle 12c SQL/PLSQL

Performance tuning

XMLDB/JSON/Advanced Queues

MQ middleware

Communication skills

Time management

Relationship management

Fact-based issue resolution

Prioritization & flexibility

Corporate Actions domain knowledge

Education

Bachelor's degree in Engineering/CS/IT

Tools

Git

Cucumber

Ruby

Apache Camel

Job description

• Able to develop and enhance the corporate action processing system using Oracle 12c PL/SQL
• To handle the development of the supporting Oracle database and shell scripts
• Production of detailed technical analysis, robust design and development
• Handle the Production of Technical Specifications derived from functional specifications produced by the business analysis team
• To handle the Live support of the corporate action processing system, including investigative work, and user liaison – where required
• Definition and adherence to programming standards
• Unit and integration testing of developed code
• Peer Reviews of other developers code
• Must be able to participate in a culture of “knowledge sharing” within the development team globally
• Maintenance of application documentation.

Skills Requirement

• Bachelors degree in Engineering/Computer Science/Information Technology/related field
• 6-8 years of experience in relevant field in Asset Servicing domain
• Strong and proven track record in Oracle 12c SQL & PL/SQL design and development and implementation
• Expertise in database performance tuning
• Experience in advanced Oracle concepts like XMLDB, JSON processing and Advanced Queues
• Experience in working with middleware messaging applications like MQ
• Excellent verbal and written communication skills
• Strong time management and ability to coordinate with co-located teams to action items
• Strong internal relationship management skills – the team works across many areas of the organization, the ability to relate to people and work in ad-hoc teams is critical.
• Ability to adopt a fact-based approach to issue resolution
• Ability to prioritize, be flexible and respond to changing environments
• Good understanding of Corporate Actions processing and experience in building a corporate action processing platform

Good to Have

• Strong working knowledge of C# / Java / Apache Camel
• Knowledge of Source Control tools like Git
• Knowledge of ATDD/BDD using Cucumber and Ruby