PL/SQL 开发者，支持

Responsibilities:

• Liaise with Manufacturing, Engineering, QA, Planning, Shipping user/customer to gather change requirements for the corresponding systems.

• Work closely with other IT functional teams to deliver user/customer IT requests in a timely manner.

• Analyze, design and create functional requirement document for the change request.

• Develop program codes to fulfill the change requests.
• Conduct system and user acceptance test to confirm the change meets user requirements.

• Deploy the system change.

• Troubleshoot and resolve issues arising from the corresponding system and the interfaces to other
• systems.

• Put in place monitoring tools and alerts for application scheduled jobs.

• Perform root cause analysis and remedy for major incidents to prevent future occurrences.

• Setup new application environments for Production and Development.

• Undertake application related upgrades and patch updates.

• Work with System and Database Administrator to develop scripts for periodic data archiving and housekeeping.

• Implement high availability configuration for application, where required.

• Provide relevant system and user documentation.

Requirements:

• 3 - 5 year of experience.

• Key Skill set: AWS Redshift, Postgres, SQL Server

• Good knowledge on complex database objects like Stored Procedures, Functions, Packages, Cursors and Triggers using SQL and PL/SQL.

• Good understanding of Joins (Outer, Left / Right Outer Join, Self, Inner, Cross Join).

• Hands on Experience in handling errors with Exceptions.

• Working knowledge in migrating database objects from on premise to AWS cloud DB and make them work in AWS cloud DB.

• Hands on Experience with data import /export mechanism from one DB to another.

Originally posted on Himalayas