Number of Openings*

1

Approved ECMS RQ# *

535473

Duration of contract*

12 months

Total Yrs. of Experience*

9+

Relevant Yrs. of experience*

6+

Detailed JD *(Roles and Responsibilities)

Oracle PLSQL Lead Developer

- Act as the escalation point for resolving complex technical issues and provide guidance to the team.
- Collaborate with architects to understand requirements and ensure alignment with technical solutions.
- Oracle database setup and configuration, ensuring scalability, security, and high availability.
- Configure Oracle databases and components (e.g., RAC, Data Guard, ASM, Oracle Grid Infrastructure).
- Analyze and document the existing SingleStore architecture, Oracle database setup and configuration, ensuring scalability, security, and high availability.
- Provide technical assistance to configure Oracle databases and components (e.g., RAC, Data Guard, ASM, Oracle Grid Infrastructure).
- Provide technical assistance to implement database security policies, including access control, encryption, and auditing.
- Optimize database performance through partitioning, sharding,



and query tuning techniques.
- Troubleshooting and debugging the PL/SQL code level issues with a basic understanding of Python.
- Perform unit testing to validate data integrity and consistency

Mandatory skills*
- Robust fundamentals in SQL with joins, analytical functions, DB objects like stored proc, functions, cursors, triggers, exception handling, packages
- Data loading with SQL loader
- Table partitioning, indexing
- Query tuning

Desired skills*
- Python / Core Java
- Data profiling, data validation, pipeline creation (Data Engineering)

Domain*

HiTech

Approx. vendor billing rate* (INR/Month)

Excluding service tax

Max 12,000 INR/day

Work Location*

Bangalore – adhere to 2-3 days client WFO

Background check process to be followed: *

Before onboarding / After onboarding: *

BGV Agency: *

Post onboarding

Mode of Interview: Telephonic/Face to Face/Skype Interview*

Video call in MS Teams. Minimum 2 rounds excluding internal screening

📌 Lead Oracle PLSQL Developer (Bengaluru)
🏢 Clifyx
📍 Bengaluru