* Database Development: Design, develop, and maintain complex PL/SQL procedures, functions, packages, and triggers to support application development.

* Query Optimization: Analyze and optimize existing SQL queries and PL/SQL code to ensure the best possible performance of applications.

* Data Integrity: Ensure data accuracy and consistency by writing and maintaining scripts that manage data migrations, transformations, and validations.

* Troubleshooting: Debug and troubleshoot issues related to database performance, including slow-running queries, locking problems, and application-specific database issues.

* Collaboration: Work closely with software developers, testers, and business analysts to integrate database components with front-end and middleware applications.

* Performance Tuning: Perform database tuning, indexing strategies, and provide recommendations for optimizing database performance.

* Documentation: Maintain clear documentation of code, processes, and database architecture for both current and future development.

* Compliance & Security: Adhere to company policies on data privacy, security, and compliance, ensuring all database developments meet these standards.

* Version Control: Utilize version control systems to manage changes and updates to database code.

* Support: Provide ongoing support for database-related issues, including bug fixes, enhancements, and performance monitoring.

* Innovation: Proactively suggest improvements in database procedures, and technologies to support the evolving needs of the software development division.

Key Performances Indicators

* Timeliness and quality of PL/SQL deliverables.

* Performance and stability of database operations.

* Successful collaboration with software developers and cross-functional teams.

* Accuracy and consistency of data within supported applications.