pq sql developer

Contractual | 12+ months |
, USA
quick apply

Role: PL/SQL Developer

Location: Tampa, FL

Duration: 12+ months

Type: W2 (Full-time)

 

  • • Performing initial data migration, subsequent delta migrations, and validating the data being 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 a DB link and scheduling
  • 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.
  • • Troubleshooting performance issues using Explain Plan, Indexes, Optimizing, and tuning PL SQL subprograms to reduce the loading process.
  • • Partitioning large tables and creating local and global indexes to improve performance. Maintained users, roles, and privileges for database objects.