Primary Tasks:
- Perform an initial database health check, identifying any database vulnerabilities and deficiencies.
- Configure, automate, and maintain a reliable database backup solution using Oracle’s RMAN backup utility
- Setup monitoring services that alerts me (and others if necessary) when a database or server event has occurred that needs to be addressed
- Perform routine, weekly database maintenance to ensure the health of the database.
- Perform database recovery and emergency troubleshooting.
- Diagnose and repair performance problems within the database.
- Apply critical patch updates to the database each quarter
- Perform minor version upgrades (ex: 11.2.0.1 to 11.2.0.2)
- Perform major version upgrades (ex: 10g to 11g)
- Answer database related questions in support of developers and system administrators so they can better perform their jobs.
Additional Tasks:
- Provide database design support
- Installation and setup of a new Oracle database
- Installation and setup of standby databases for disaster recovery
- Major schema modifications to existing databases
- Data migration between Oracle databases or from other commercial databases (SQL Serever, MS Access, MySQL, flat file, etc…) to Oracle
- SQL and PL/SQL Tuning
No comments:
Post a Comment