Oracle Developer

HCL Singapore Pte Ltd; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

HCL Singapore Pte Ltd is seeking an experienced Oracle PL/SQL developer to join the Singapore-based team supporting a major Asset Servicing programme. The role focuses on developing the corporate action processing system using Oracle 12c PL/SQL, building database scripts, and producing technical specifications and documentation.

You will work in an Agile environment, coordinate with global teams, and contribute to unit and integration testing, with strong emphasis on performance tuning and

Qualifications

• Bachelor's degree in engineering/computer science or related field.
• 6-8 years of experience in Asset Servicing domain.
• Strong Oracle 12c SQL & PL/SQL design and development.
• Expertise in database performance tuning.
• Experience in XMLDB, JSON processing and Advanced Queues.
• Experience with MQ middleware.
• Excellent verbal and written communication.
• Strong time management and coordination with co-located teams.
• Ability to adopt a fact-based approach to issue resolution.
• Experience in Agile development.

Responsibilities

• Develop and enhance the corporate action processing system using Oracle 12c PL/SQL.
• Handle development of supporting Oracle database and shell scripts.
• Produce detailed technical analysis, robust design and development.
• Produce Technical Specifications from business analysis.
• Live support of corporate action processing system; investigate and liaise with users.
• Adhere to programming standards; conduct unit and integration tests.
• Peer reviews of code; promote knowledge sharing within global team.
• Maintain application documentation.

Skills

Oracle 12c SQL & PL/SQL

Database performance tuning

XMLDB/JSON processing/Advanced Queues

MQ middleware

Communication skills

Agile development

Corporate Actions knowledge

Time management

Education

Bachelor's degree in Engineering/Computer Science/Information Technology

Tools

MQ

Git

Job description

We are looking for an experienced Oracle PL /SQL developer to join the existing team based in Singapore, supporting a significant programme of work in the Asset Servicing domain.

Responsibilities

• 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
• Ability to adopt a fact-based approach to issue resolution
• Ability to prioritize, be flexible and respond to changing environments
• Experience in working in Agile development environment
• 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