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* |
- Strong 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 |
