1) Implement, administer, manage, and monitor the assigned application databases in production & non-production environments.
2) Monitor database performance. Design and implement performance tuning improvements and advise developers on tuning options.
3) Ensure that data integrity and data security is maintained.
4) Installation, configuration, upgrade, instance tuning, SQL tuning, backup and recovery and maintenance of Oracle databases in Dev and Production.
5) Create database objects and wrote PL/SQL packages, procedures, functions, triggers and SQL queries in support for Developers and Data warehouse operations.
6) Perform other tasks related to Oracle database administration