| Click here to unsubscribe if you no longer wish to receive our emails |
Job Details
Title: MYSQL developer with Oracle PL/SQL,
Location: New York City, NY
Duration: Contract
Skills: Query Optimizer, Execution Plans & Indexes, UNIX Shell Scripting, AWS S3
Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, AWS S3
Job Duties:
· Work with Commerce team, Business Analysts, System Analyst to review existing Database Schema
· Converting of existing complex oracle procedure into MYSQL function to achieve the same functionalities
· Creating and executing scripts to handle seasonal auto renew end to end in optimize way
· Must have good understanding to tracking/fixing the data
· Reviewing/Creating optimal queries for business use cases in MYSQL
· Must have knowledge too extract the large data set and export it into cloud
· Must have experience in creating automated scripts in UNIX to publish the data in cloud
Requirements:
· MYSQL and Oracle PL/SQL: 09+ years (Must have Oracle and MYSQL experience)
· Good knowledge of Oracle performance related features such as Query Optimizer, Execution Plans & Indexes
· Good knowledge of MYSQL performance related Features
· Able to convert Complex Oracle procedure in MYSQL function to achieve the functionalities
· Must have experience in database modelling, Data extraction and storage logic building, Convert the business requirement into technical solutions
· Must have Experience in writing Stored Procedures, Functions, Packages and Triggers using PL/SQL into Oracle as well as in MYSQL
· Must have experience in developing the Entity-Relationships
· Must have experience in using Oracle/MYSQL PL/SQL Collections,
· Bulking techniques, Analytical Functions, Partition utilization to increase performance Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle/MYSQL
· Desired experience in automating data loading, extraction, reports generation using UNIX Shell scripting
· Required AWS S3 knowledge to push the extracted data into cloud
· Must have excellent communication skills
| This email is generated using CONREP software. G9595 |