PL/SQL Developer with AWS, Informatica exp Job in Irvine, CA

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:

Testing and Debugging:

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:

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: