Epicareer Might not Working Properly
Learn More
T

PL SQL Developer

Salary undisclosed

Apply on

Availability Status

This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.


Original
Simplified

Position: PLSQL Developer

Responsibilities:

  • Performing initial data migration, subsequent delta migrations and validating the data been converted.
  • Extracting data from different data sources Oracle, Access databases and Excel spreadsheets, transformed and mapped nonstandard data to standard codes for data integrity and loaded the target Oracle database.
  • Ability to script using python to extract the data from different data sources.
  • Loading data from flat files into Oracle tables using SQLLDR.
  • Performing Data integrity, validation and testing on the data migrated.
  • Creating Shell Scripts for invoking SQL scripts to refresh data from remote databases using DB link and scheduled them using Crontab.
  • Automating the migration process using shell scripts to run whenever required.
  • Creating and Converting Complex database objects like Stored Procedures, Functions, Packages, Triggers and exception handling from MySQL to Oracle.
  • Trouble shooting performance issues using Explain Plan, Indexes, Optimizing, and tuning PLSQL subprograms to reduce the loading process.
  • Partitioning large tables and creating local and global indexes for improving performance. Maintained users, roles and privileges for database objects.

Job Type: Full-time

Pay: RM13,500.00 - RM15,000.00 per month

Experience:

  • PLSQL Development: 3 years (Required)
  • data migration: 3 years (Preferred)
  • Python: 3 years (Required)
  • SQLLDR: 3 years (Preferred)