Requirements and Responsibilities
· Monitors and ensures the day-to-day administration and maintenance of Oracle customer production databases, ensuring
· that the databases are available, performing properly and safe.
· Performs installations, upgrades and patching, backup and recovery, performance tuning, security, monitoring and
· configuration.
· Responds to and recovers crashed databases at customer sites and minimizes downtime by recovering it as near to the
· crash time as possible.
· Develops and reviews database designs to ensure table normalizations are maintained, standards are met and proper
· constraints are in place to ensure data integrity is not compromised.
· Collaborates with team members and confers with managers when needed regarding problems with and capabilities of
· customer databases.
· Develops customer database reorganizations using PL/SQL scripts to maintain database integrity.
· Migrates all current customer databases over to the new releases based on schedules.
· Monitors and implements advanced security features at customer sites to protect data against cyber hacks.
· Conducts annual version roll over in preparation for coding of the new version cycle.
Source link