Syntricate Technologies
PLSQL Developer with AWS & Informatica @ Irvine, CA (Onsite)
Syntricate Technologies, San Francisco, California, United States, 94199
Position : PLSQL Developer with AWS & Informatica
Location : Irvine, CA (Onsite)
Duration : W2 / C2C Contract
Experience : 9+ Years
Job 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. PL/SQL
If you are interested, Please share your
resume
with below basic details: Basic Details:
Current Location with Zip Code: Work Authorization Status & Expiry: LinkedIn URL: Employer details :
Regards, Ashish Rastogi Technical Recruiter | Syntricate Technologies Inc. Direct : 781-552-4336 Email : ashish.r@syntricatetechnologies.com | Web: www.syntricatetechnologies.com
We're hiring! connect with us on LinkedIn and visit our Jobs Portal
Minority Business Enterprise (MBE) Certified | E-Verified Corporation | Equal Employment Opportunity (EEO) Employer
This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this e-mail from your system. You have received this email as we have your email address shared by you or from one of our data sources or from our member(s) or subscriber(s) list. If you do not want to receive any further emails or updates, please reply and request to unsubscribe.
Job 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. PL/SQL
If you are interested, Please share your
resume
with below basic details: Basic Details:
Current Location with Zip Code: Work Authorization Status & Expiry: LinkedIn URL: Employer details :
Regards, Ashish Rastogi Technical Recruiter | Syntricate Technologies Inc. Direct : 781-552-4336 Email : ashish.r@syntricatetechnologies.com | Web: www.syntricatetechnologies.com
We're hiring! connect with us on LinkedIn and visit our Jobs Portal
Minority Business Enterprise (MBE) Certified | E-Verified Corporation | Equal Employment Opportunity (EEO) Employer
This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this e-mail from your system. You have received this email as we have your email address shared by you or from one of our data sources or from our member(s) or subscriber(s) list. If you do not want to receive any further emails or updates, please reply and request to unsubscribe.