Oracle PL SQL Professional

Photon

6 - 9 years

5 - 9 Lacs

bengaluru

Posted:3 weeks ago| Platform:

Apply

Skills Required

sql plsql devops sql performance tuning oracle hibernate job description jquery apache tomcat spring java git asp.net j2ee mysql mvc c# rest performance tuning maven microsoft azure javascript sql server angular sql optimization agile aws

Work Mode

Work from Office

Job Type

Full Time

Job Description

The Value You Deliver

Must have

Good to have

An Oracle PL/SQL Professional is primarily responsible for the design, development, and maintenance of database applications using Oracle's PL/SQL programming language. This role involves a blend of technical expertise in database management and programming skills.

Key Responsibilities:

PL/SQL Development:
Designing, developing, and maintaining complex PL/SQL packages, procedures, functions, triggers, and scripts for various database applications.
SQL Optimization:
Writing and optimizing complex SQL queries for performance, scalability, and efficiency.
Database Object Management:
Creating and maintaining database objects such as tables, views, indexes, sequences, synonyms, and materialized views.
Data Modeling and Design:
Participating in the design and implementation of data models and database structures, ensuring data integrity and security.
Troubleshooting and Support:
Debugging, testing, and troubleshooting PL/SQL code and database-related issues to ensure smooth operation and resolve production or development problems.
Collaboration:
Working closely with application developers, business analysts, and other stakeholders to understand requirements, integrate database solutions, and deliver high-quality solutions.
ETL Operations:
Developing and maintaining data extraction, transformation, and loading (ETL) scripts or routines as needed.
Documentation:
Creating and maintaining comprehensive technical documentation for developed code, processes, and database designs.
Code Review and Best Practices:
Participating in code reviews, adhering to coding best practices, and contributing to the establishment of coding standards.
Performance Tuning:
Identifying, investigating, and resolving database performance issues, including capacity and scalability concerns.

More Jobs at Photon

Backend Java Developer

Chennai, Bengaluru, Hyderabad

8 - 12 yrs

INR 8 - 17 Lacs

Java Developer + Angular

Chennai, Bengaluru

4 - 9 yrs

INR 0 - 0 Lacs

Full Stack Developer

Chennai, Bengaluru

6 - 10 yrs

INR 16 - 19 Lacs

SDET Engineer

Chennai

7 - 12 yrs

INR 11 - 12 Lacs

Delivery Manger/Delivery Head

Chennai

14 - 24 yrs

INR 27 - 42 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps 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.