Lead Oracle PLSQL 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* 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)