| PL SQL Developer with AWS Informatica : CA at Remote, Remote, USA |
| Email: [email protected] |
| From: Chandra N, Siri Info [email protected] Reply to: [email protected] Role name:DeveloperRole 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/SQLExperience (Years):6-8Essential 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 StatesBranch | City | Location:TCS - Los Angeles IRVINE Irvine, CA Keywords: procedural language California PL SQL Developer with AWS Informatica : CA [email protected] |
| [email protected] View all |
| Tue Oct 15 17:11:00 UTC 2024 |