Oracle SQL PL/SQL Developer

Oracle SQL PL/SQL Developer#26-17416

Up to $65.06 per hour

Charlotte, NC

Hybrid

Job Description

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.

As 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