Posted:2 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Key Responsibilities
  • Develop, optimize, and maintain SQL queries, PL/SQL stored procedures, functions, packages, triggers.
  • Write and optimize SQL Functions (string, number, date, conversion, aggregate), Window Functions
(RANK, DENSE_RANK, ROW_NUMBER, LEAD, LAG, SUM OVER, moving averages), and CTEs
(Common Table Expressions) for cleaner and modular queries.
  • Perform database design, normalization, indexing, and schema management.
  • Create complex queries for reporting, ETL, analytics, and dashboards.
  • Conduct performance tuning (execution plan analysis, indexing strategies, partitioning).
  • Implement data validation, constraints, and business rules at the database level.
  • Support data migration, integration, and transformation projects.
  • Collaborate with developers to design backend database logic for applications.
  • Ensure data security, compliance, and integrity in all deliverables.

Required Skills

  • Strong proficiency in SQL (DDL, DML, DCL, TCL).
  • Hands-on experience in PL/SQL programming (procedures, functions, packages, cursors, exception
handling).
  • Experience with partitioning, bulk operations, advanced PL/SQL features.
  • In-depth understanding of SQL Functions, Window Functions, and CTEs.
  • Expertise in query optimization & performance tuning.
  • Strong foundation in data modelling & relational database design.
  • Familiarity with ETL processes, reporting tools, and data migration.
Skills: sql,pl/sql,etl

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

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.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

hyderabad, telangana, india