{"schemaVersion":"jobsearcher.job.v1","id":"fc10dc3413f82814dedad559","url":"https://jobsearcher.com/jobs/fc10dc3413f82814dedad559","canonicalUrl":"https://jobsearcher.com/jobs/fc10dc3413f82814dedad559","title":"PLSQL Developer with AWS & Informatica @ Irvine, CA (Onsite)","description":"PLSQL Developer With AWS & InformaticaLocation: Irvine, CA (Onsite) Duration: W2 / C2C Contract Experience: 9+ YearsJob DescriptionDatabase Design and Development:Design and implement database structures, including tables, views, and indexes.Develop PL/SQL procedures, functions, and packages to encapsulate business logic.Performance Tuning:Optimize SQL queries and PL/SQL code for performance.Analyze and resolve performance issues using tools like Oracle Explain Plan and SQL Trace.Data Manipulation:Write complex SQL queries to retrieve, insert, update, and delete data.Use PL/SQL to automate data processing tasks.Testing and Debugging:Conduct unit testing of PL/SQL code to ensure functionality and reliability.Debug and troubleshoot PL/SQL programs, identifying and fixing issues.Documentation:Maintain comprehensive documentation of database designs, PL/SQL code, and procedures.Create user manuals and technical documentation for future reference.Collaboration:Work closely with database administrators, application developers, and business analysts to gather requirements.Participate in code reviews and provide constructive feedback to peers.Maintenance and Support:Monitor database performance and make recommendations for improvements.Provide support for production issues and assist in system upgrades.Security Management:Implement security measures to protect sensitive data and ensure compliance with regulations.Manage user roles and permissions within the database.Integration:Integrate with other systems and applications, ensuring smooth data flow and communication.Use tools and technologies such as Oracle Forms, Oracle Reports, or APEX for front-end development.Continuous Learning:Stay updated with the latest Oracle technologies and PL/SQL features.Participate in training sessions and workshops to enhance skills.If you are interested, please share your resume with below basic details:Current Location with Zip Code:Work Authorization Status & Expiry:LinkedIn URL:Employer details:Regards,Ashish Rastogi Technical Recruiter | Syntricate Technologies Inc.","company":"Syntricate Technologies","rawCompany":"syntricate technologies","city":"Irvine","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-08-25T05:38:32.741Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1251.00","title":"Computer Programmers","slug":"computer-programmers"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"PLSQL Developer with AWS & Informatica @ Irvine, CA (Onsite)","description":"PLSQL Developer With AWS & InformaticaLocation: Irvine, CA (Onsite) Duration: W2 / C2C Contract Experience: 9+ YearsJob DescriptionDatabase Design and Development:Design and implement database structures, including tables, views, and indexes.Develop PL/SQL procedures, functions, and packages to encapsulate business logic.Performance Tuning:Optimize SQL queries and PL/SQL code for performance.Analyze and resolve performance issues using tools like Oracle Explain Plan and SQL Trace.Data Manipulation:Write complex SQL queries to retrieve, insert, update, and delete data.Use PL/SQL to automate data processing tasks.Testing and Debugging:Conduct unit testing of PL/SQL code to ensure functionality and reliability.Debug and troubleshoot PL/SQL programs, identifying and fixing issues.Documentation:Maintain comprehensive documentation of database designs, PL/SQL code, and procedures.Create user manuals and technical documentation for future reference.Collaboration:Work closely with database administrators, application developers, and business analysts to gather requirements.Participate in code reviews and provide constructive feedback to peers.Maintenance and Support:Monitor database performance and make recommendations for improvements.Provide support for production issues and assist in system upgrades.Security Management:Implement security measures to protect sensitive data and ensure compliance with regulations.Manage user roles and permissions within the database.Integration:Integrate with other systems and applications, ensuring smooth data flow and communication.Use tools and technologies such as Oracle Forms, Oracle Reports, or APEX for front-end development.Continuous Learning:Stay updated with the latest Oracle technologies and PL/SQL features.Participate in training sessions and workshops to enhance skills.If you are interested, please share your resume with below basic details:Current Location with Zip Code:Work Authorization Status & Expiry:LinkedIn URL:Employer details:Regards,Ashish Rastogi Technical Recruiter | Syntricate Technologies Inc.","datePosted":"2026-08-25T05:38:32.741Z","dateModified":"2026-08-25T05:38:32.741Z","hiringOrganization":{"@type":"Organization","name":"Syntricate Technologies","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Irvine","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"fc10dc3413f82814dedad559"},"url":"https://jobsearcher.com/jobs/fc10dc3413f82814dedad559"}}