Software Developer

CYBERVAULT INNOVATIONS AND TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

CYBERVAULT INNOVATIONS AND TECHNOLOGIES PTE. LTD. is seeking a Senior Oracle Database Developer in Singapore to lead complex database projects and guide best practices.

You will work with Oracle 19c/12c/11g, develop SQL/PLSQL, perform tuning, design schemas, manage data migrations, and enforce security while supporting the full SDLC from analysis to maintenance. This role demands deep hands-on expertise and the ability to optimize large-volume datasets in a fast-paced environment.

Qualifications

• 10+ years development experience with Oracle Database versions 9i/10g/11g/12c.
• Experience across the SDLC from analysis, design, development, testing to maintenance.

Skills

Oracle Database

SQL / PL/SQL

Performance Tuning

Database Design

Data Migration

Database Security

SDLC Knowledge

Education

B.Tech / B.E. in CSE

Electronics and Communication Engineering (ECE)

Electrical and Electronics Engineering (EEE)

Job description

Responsibilities and Requirements:

1. Oracle Database

• Strong hands-on experience with Oracle 19c/12c/11g.
• Knowledge of tables, views, indexes, sequences, synonyms, constraints and database objects.

2. SQL & PL/SQL

• Advanced SQL queries, joins, subqueries, CTEs and analytical functions.
• Development of Procedures, Functions, Packages, Cursors and Triggers.
• Dynamic SQL and exception handling.

3. Performance Tuning

• SQL query optimization and execution-plan analysis.
• Index optimization and statistics management.
• Troubleshooting slow-running queries and database performance issues.

4. Database Design

• Database schema design and normalization.
• Primary/foreign keys, relationships and constraints.
• Understanding of ER diagrams and data modelling.

5. Data Management & Migration

• Data migration, bulk data processing and data validation.
• Experience with Oracle Data Pump (EXPDP/IMPDP) and SQL*Loader.
• Handling large-volume datasets.

6. Database Troubleshooting

• Identification and resolution of Oracle errors.
• Knowledge of locks, blocking sessions, deadlocks and transaction management.
• Debugging and maintenance of PL/SQL code.

7. Database Security

• User and role management.
• GRANT/REVOKE privileges and basic database security concepts.

Education

UG:B.Tech / B.E. in Computer Science and Engineering (CSE), Electronics and Communication Engineering (ECE), Electrical and Electronics Engineering (EEE)

Experience

• 10+ years development experience with Oracle Database version 9i /10g / 11g /12c
• Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance.