Walkin Drive for Oracle DBA

JOB DESCRIPTION:

Roles & Responsibilities: 

Ensuring the efficient, secure, and reliable operation of an organization's databases 

Continuously monitor database performance to identify and resolve issues proactively. Performance monitoring tools and scripts help in tracking metrics like query execution times, CPU usage, and disk I/O. 

Optimize database operations by tuning SQL queries, adjusting indexes, and configuring hardware resources. 

Continuously monitor for security vulnerabilities and apply necessary patches and updates to maintain a secure environment. 

Implement and manage comprehensive backup procedures to safeguard against data loss. Regular backups are essential for data recovery in case of hardware 

failures, data corruption, or other disasters. 

Verify the integrity of backups and periodically test restore processes to ensure they can be executed smoothly when needed. 

Manage comprehensive backup and recovery procedures to ensure quick restoration of data in case of failures. This includes regular backups, offsite storage, and disaster recovery planning. 

Develop and test disaster recovery plans to ensure the organization can recover from catastrophic data loss events. 

Oversee data import, export, and transformation processes to ensure data quality and consistency. This involves using ETL (Extract, Transform, Load) tools and processes to manage data flows between systems. 

Apply patches and updates to database software to protect against vulnerabilities and improve functionality. Regular patch management is crucial for maintaining a secure and efficient database environment.