Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in hyderabad
>
Alp Consulting Ltd.
>
Oracle PLSQL Lead

Oracle PLSQL Lead

Alp Consulting Ltd.

6 - 9 years

7 - 12 Lacs

hyderabad

Posted:7 hours ago| Platform:

Apply

Skills Required

supply chain performance tuning linux coding xml control-m oracle unix shell scripting monitoring sql

Work Mode

Work from Office

Job Type

Full Time

Job Description

Opportunity with one of Alp Consultancy's most fortuned client which is into large-scale supply chain data collection and doing extremely excellent in IT Monopoly !

We are looking for a technical lead with 8+ Yrs exp who should have Coordinated with team in understanding the business requirements and delivering the deliverables to the business users. Design, develop, and support PL/SQL, ETL processes for loading data from external as well as internal systems using SQL Loader and External tables. Roles and Responsibilities:

Should have hands on experience and be able to guide the team of developers

Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.

Extensively worked on creating database objects including tables, indexes, views, sequences, packages.

Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.

Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.

Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance.

Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language) .

Interacted with Business Analysts and Users for gathering and analyzing the Business Report requirements.

Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users.

Analysis (Business and Technical) of existing system with objective of improving & optimizing the system performance.

Handled a project where it involved building a process for BEx Team. Required Skills:

Should have sound experience with calling API thru PLSQL procedures and able to debug API code & test API utilizing Postman

Should have good exposure to Linux/Unix, Shell Scripting & XML

Good experience in using WinSCP & Putty

Knowledge or experience with scheduling tools like Control-M

Good understanding on Ansible script (YAML creation) & Monitoring jobs

Flexible working hours (able to work in shifts, if needed)

Must have hands on experience in coding and be able to guide the team of developers.

Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer.

Generated SQL scripts for data validation, data conversion and manipulation and materialized the views for remote instances.

Location:Chennai and Hyderabad

More Jobs at Alp Consulting Ltd.

Java Specialist

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Staffing Lead (BFSI)

Hyderabad, Telangana, India

Experience: Not specified

Salary: Not disclosed

Human Resources Business Partner

Noida, Uttar Pradesh, India

4 - 6 yrs

Salary: Not disclosed

Senior Lead Software Engineer

Pune, Maharashtra, India

8.0 - 8.0 yrs

Salary: Not disclosed

Medical Sales Representative

Hyderabad, Telangana, India

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.

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.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Alp Consulting Ltd.

Login to

Please Verify Your Phone or Email

Confirm Action

Oracle PLSQL Lead