- 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.