Oracle SQL PL/SQL Developer

Oracle SQL PL/SQL Developer


Location: Charlotte, NC/Hybrid
Duration: 11-12 Months with possible contract to hire



Description:

Position Summary:
This role involves design, Developer and review all the Database changes in the bank.
s a Database Engineer he/she will apply industry accepted design and development practices for perform all the database related changes like DB design, normalization, SQL/ PL-SQL using Agile Methodology


Primary Skill- Oracle SQL / PLSQL
Secondary Skill-MS SQL Server
Tertiary Skill- Performance Tuning and Capacity Monitoring Engineer



Required Qualifications:
-Expert-level proficiency in latest Oracle Database version.
-Proficiency in TOAD and similar tools
-Experience in OEM
-Strong Experience in SQL and PL/ SQL programming
-Proven experience in Database Design and Data modeling (ER Diagram and Normalization)
-Strong understanding of Oracle architecture, memory structure and background processes.
-Strong analytical and problem solving skills
-Excellent communication and leadership capabilities.
-Hands-on experience in performance tuning, including -
-Query Optimization
-Indexing strategies
-Use of AWR, ASH and Explain plan, etc.



Desired Qualifications
-Worked in financial domain.
-Knowledge of shell scripting, python for automation database tasks.
-Familiarity with DevOps practice and tools like Jenkins, GIT and Datical.
-Exposure to MS SQL server and MongoDB
-Knowledge of data security, encryption and compliance standards



Qualification:

Must Have:

Technical:
Toad
MS SQL Server
Oracle SQL / PLSQL


Technology Specialist Skillset: Yes|MemSQL