Database - Lead

Iris Software

5 - 9 years

11 - 15 Lacs

Noida

Posted:1 day ago| Platform:

Apply

Skills Required

oracle forms plsql sql powerbuilder oracle reports python oracle sybase performance tuning data warehousing power bi dbms database administration t-sql sql server java database creation oracle dba ssrs oracle sql ssis aws sdlc unix

Work Mode

Work from Office

Job Type

Full Time

Job Description

Extensive knowledge in SQL/ PLSQL/Oracle/Oracle Forms/Oracle reports/Ms SQL/Power Builder.
Create and optimise packages, procedures, functions, Triggers, Views, cursors to develop application.
Experience in create/modifies packages, views, procedures, Triggers, Views, cursors and functions.
Create new custom Reports, Forms and modify existing Reports according to the requirement.
Involve in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, maintenance and reporting to the client.
Experience on Evaluation, Implementation and support with a skillset of Oracle, PL-SQL.
Involve in requirement gathering and coordination with users.
Hands on in Oracle version 19c and 21c
Strong coding knowledge in PLSQL (Bulk Collect, Recursion, Loops (FOR, WHILE DO), Nested blocks, Exception Handling)
Strong Coding knowledge in SQL (Analytical functions, View and Materialized Views, Sys tables and Privileges)
Good understanding of Performance tuning concepts like Access Paths, Join methods, Partitioning, etc..
Awareness about Oracle data various dictionary and their significance.
Complex Queries : Nested queries, inline views, co-related subqueries
Awareness about Hierarchical queries

Mandatory Competencies

Beh - Communication and collaboration

Database - Oracle - Oracle 12c

Database - Database Programming - PL/SQL

Database - Database Programming - SQL

More Jobs at Iris Software

Python Automation Tester with Robot Framework

Noida, Gurugram

7 - 12 yrs

INR 22 - 37 Lacs

.Net - Intern

Noida, Uttar Pradesh

Experience: Not specified

Salary: Not disclosed

ETL Tester

Pune, Delhi / NCR

5 - 8 yrs

INR 14 - 24 Lacs

Java Architect

Noida

14 - 18 yrs

INR 25 - 40 Lacs

QA Tester - Intern

Noida, Uttar Pradesh

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

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