PL/SQL Developer
Job Title: PL/SQL Developer
Duration: 4-month contract
Location: 100% remote
Job Type: Contract W2
Top Skills' Details
• Must have domain experience in supporting the HR & Payroll domain
• New and Existing development/enhancements for PL/SQL
• Unix Development
Job Description
• Experience in designing, developing, testing, and implementing complex database programs using Oracle PL/SQL, UNIX. Worked on the Oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views including materialized views, db_links, sequences, cursors, transactions, dynamic SQL queries, exception handling.
• Experience in managing production support activities, debugging / fixing Oracle objects.
• Experience in data mapping / conversion / transformation/integration activities according to third-party (vendor) requirements and integration of legacy applications/tools with the vendor tools.
• Optimizing performance of existing Oracle code, Oracle queries, stored procedures, packages, functions using explain plan.
• Development of UNIX Shell Scripts for loading Oracle tables from data files using SQL LOADER and automating UNIX scripts through UNIX CRON JOBS.
• Experience in creating UNIT Test plans and working closely with QA teams and reviewing test plans.
Additional Skills & Qualifications
• Aerospace / defense / manufacturing experience +1
Job Title: PL/SQL Developer
Duration: 4-month contract
Location: 100% remote
Job Type: Contract W2
Top Skills' Details
• Must have domain experience in supporting the HR & Payroll domain
• New and Existing development/enhancements for PL/SQL
• Unix Development
Job Description
• Experience in designing, developing, testing, and implementing complex database programs using Oracle PL/SQL, UNIX. Worked on the Oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views including materialized views, db_links, sequences, cursors, transactions, dynamic SQL queries, exception handling.
• Experience in managing production support activities, debugging / fixing Oracle objects.
• Experience in data mapping / conversion / transformation/integration activities according to third-party (vendor) requirements and integration of legacy applications/tools with the vendor tools.
• Optimizing performance of existing Oracle code, Oracle queries, stored procedures, packages, functions using explain plan.
• Development of UNIX Shell Scripts for loading Oracle tables from data files using SQL LOADER and automating UNIX scripts through UNIX CRON JOBS.
• Experience in creating UNIT Test plans and working closely with QA teams and reviewing test plans.
Additional Skills & Qualifications
• Aerospace / defense / manufacturing experience +1
