PLSQL,AWS,Informatica - Diverse Lynx
Irvine, CA
About the Job
| Role name: | Developer |
|---|---|
| Role Description: | Roles and Responsibilities: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. |
| Competencies: | PL/SQL |
| Experience (Years): | 6-8 |
| Essential Skills: | Roles and Responsibilities: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. |
| Desirable Skills: | Roles and Responsibilities: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. |
| Country: | United States |
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Source : Diverse Lynx
