Insight Global
Beachwood, OH, USA
Job Description We are seeking a highly skilled Senior Oracle PL/SQL Developer to join our team and lead the optimization and modernization of our legacy Vehicle Insurance Program (VIP) system. This system facilitates an employee benefit of providing discounted car insurance. The ideal candidate will have extensive experience in PL/SQL development, database management, and DevOps practices. Key Responsibilities: Code Optimization and Cleanup: Analyze and clean up unused functions, procedures, batch programs, and tables. Remove unnecessary loops and queries within retained functions and procedures. Optimize inefficient queries and improve overall system performance. Add comprehensive comments to the code to enhance readability and maintainability. Database Management: Create and manage a new schema in the DEV environment (VIP2) for development and testing. Ensure synchronization of data between HR and VIP databases. Implement proper fields in essential tables...