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)
Similar Jobs