Oracle Database Developer (PLSQL)

Citi

8 - 12 years

0 Lacs

pune maharashtra

Posted:1 week ago| Platform: Shine logo

Apply

Skills Required

oracle plsql data modeling stored procedures triggers views materialized views performance optimization database design indexing sql loader troubleshooting integration testing user acceptance testing performance testing jira bitbucket communication skills performance tuning complex sql writing basic dba skills functions packages sql analytical skills partition strategies advanced plsql bulk operations oracle database awraddm reports analysis devops exposure cicd pipelines rlm process

Work Mode

On-site

Job Type

Full Time

Job Description

Role Overview: You should have 8-12 years of relevant experience as a Database Developer with expertise in PLSQL. Your main responsibilities will include writing complex SQL queries, advanced P/SQL development, performance tuning, data modeling, and working on database objects like stored procedures, functions, packages, triggers, views, and materialized views. Key Responsibilities: - Must-have skills include proficiency in Oracle, PLSQL, complex SQL writing, and basic DBA skills - Advanced P/SQL development involving collections, materialized views, partitioning, etc. - Performance tuning skills for optimizing query performance - Understanding of relational database concepts and strong SQL analytical skills - Experience in data modeling concepts and performance optimization - Identifying data quality issues and root causes - Hands-on experience with indexing and partition strategies - Knowledge of Advanced PL/SQL, bulk operations, and SQL Loader - Exposure to analyzing Oracle Database AWR/ADDM reports and troubleshooting database performance issues - Assisting in integration, user acceptance, and performance testing - Reviewing and analyzing test case results to ensure functionality meets documented requirements - Familiarity with Jira, Bitbucket, and DevOps exposure for CI/CD pipelines and RLM process - Ability to work independently and as part of a team with strong communication skills - Performance tuning expertise Qualifications Required: - Bachelors degree/University degree or equivalent experience Additional Details: - The company is committed to providing reasonable accommodations for individuals with disabilities in using search tools and applying for career opportunities. Please review the company's Accessibility at Citi statement and the EEO Policy Statement along with the Know Your Rights poster for more information.,

More Jobs at Citi

Third Party Risk Management Intermediate Analyst – C11 (Hybrid) CHENNAI

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Applications Development Sr Programmer Analyst - C12 - Pune/CHENNAI

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Ops Accounting Analyst 1 - C09 - CHENNAI

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Senior QA Analyst with Cypress framework- C11 -Chennai

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

SVP - Reporting & Visualization

Bengaluru, Karnataka

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.