09 Sep
|
Clifyx
|
Bengaluru
Number of Openings*
3
Approved ECMS RQ# *
535474
Duration of contract*
12 months
Total Yrs. of Experience*
5+
Relevant Yrs. of experience*
5+
Detailed JD *(Roles and Responsibilities)
- Oracle database setup and configuration, ensuring scalability, security, and high availability.
o 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*
- Solid 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 11,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
📌 Mid-level Oracle PLSQL Developer (Bengaluru)
🏢 Clifyx
📍 Bengaluru