PL-SQL Developer at Irvine, California, USA |
Email: [email protected] |
From: vinod Kumar, itechus [email protected] Reply to: [email protected] Hi, We have the below job Opportunity for you, please go through the job description and let me know your interest. Role: PL/SQL Developer Duration: Long Term Location: Los Angeles And Irvine, CA JD: Role Description: Database 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. Keywords: golang procedural language California PL-SQL Developer [email protected] |
[email protected] View all |
Tue Oct 15 21:07:00 UTC 2024 |