PL/SQL Developer

1. Develop, debug, and optimize PL/SQL scripts for data transformation and integration
2. Rewriting queries and PL/SQL code to improve efficiency, scalability, and response time
3.Write and maintain scripts for data extraction, transformation, and loading (ETL) between various databases and systems.
Perform data migration, ensuring data integrity during the process.
4. Perform root cause analysis and troubleshoot database issues, including application performance, errors, and system downtime.
5.Resolve database-related issues by performing recovery, patching, and upgrading.
6. Work closely with other developers, DBAs (Database Administrators), business analysts, and project managers to deliver high-quality solutions.
7. Participate in code reviews, peer programming, and provide mentoring to junior developers
8.Deep understanding of Oracle Database (version 11g, 12c, or higher), its architecture, and features like tablespaces, indexes, constraints, etc.
9.Experience working with Oracle database tools like SQL*Plus, SQL Developer, TOAD, and Oracle Enterprise Manager.