PLSQL Developer with unix script

Role & responsibilities

• Design, develop, test, and maintain complex PL/SQL packages, procedures, functions, triggers, and views.
• Develop and optimize SQL queries for performance and scalability.
• Create and maintain Unix Shell Scripts for job automation, batch processing, and application support.
• Analyze and troubleshoot production incidents related to database and application performance.
• Perform database tuning and query optimization.
• Work with development, testing, and production support teams for application deployments.
• Manage data migrations, ETL processes, and database upgrades.
• Develop and maintain scheduling jobs using tools such as Cron, Autosys, or Control-M.
• Conduct root cause analysis and implement permanent resolutions for recurring issues.
• Ensure adherence to coding standards, security guidelines, and best practices.

Preferred candidate profile