Job Description :
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: 8+ 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
· Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, AWS S3
· 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