Experience
3 - 7 yrs
Job Location
Bengaluru, India
Vacancy
1
Designation
Plsql Developer
Job Type
ONSITE
Job Description
- 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)