Database Developer

Job Description

Job Title: Database Developer
Location: Pittsburgh, PA (Hybrid)

Duration: 6+ Months

Visa Type: USC/GC only

Need Local

Job Description:-

A financial industry leader has an exciting opportunity for a Database Developer in Pittsburgh, PA.

Responsibilities:

Leads the technical design, development and documentation of database solution.
Candidate is expected to be operating under the guidance of Tech Manager, however is expected to be self-starter and operate with an ownership mentality and interface with other teams.
Candidate must be aware of Agile Software Delivery Practice.
Will be part of the team that builds, maintains, and promotes our Enterprise Master Data platform.

Requirements:

Master’s or Bachelor’s degree in Computer Science, with strong fundamentals and problem solving skills
8+ years of experience in architecture, design, analysis, development, testing, deployment, and maintenance of highly scalable relational database services and components
In-Depth knowledge of database concepts with hands-on experience in database programming and design using SQL, PL/SQL, Stored Procedures, Functions, Triggers, and Views, etc. using Oracle 12c or better (5-7 years)
Full life-cycle development experience working in data centric applications
Solid understanding of Dimensional Data Modeling
Proficient in creating and tuning complex SQL, DB performance tuning involving AWR report, partition, etc.
Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, etc.
Experience in Change Data Capture (CDC), for example Oracle GoldenGate, is strongly preferred
Experience with information security and access control protocols
Knowledge of ETL, experience in related programming, Java, Python, etc.
Unix/Linux and Scripting, Bash, Python, etc.
Experience using version control and DevOps tools such as Git, Jenkins, etc.
Strong problem resolution skills and Critical thinking
Excellent analytical skills, written and verbal communication skills