This section is used to describe what knowledge, skills and abilities are required to perform the daily tasks.
Key Responsibilities:
Infrastructure Maintenance: Perform regular maintenance tasks such as DB backups, ensuring DB availability, Patching, indexing, user management and performance tuning for Oracle and MS SQL databases.
Monitoring: Manage space, monitor user activities, and resource utilization. Independently maintain and administer databases and create and publish database health check reports.
Database Build & Migration: Plan and execute database build & migration projects, ensuring minimal downtime and data integrity.
Performance Optimization: Monitor and optimize database performance, including query tuning and resource management.
Troubleshooting: Diagnose and resolve database-related issues promptly.
Security Management: Implement and maintain database security measures, including user access controls and encryption.
Disaster Recovery: Develop, implement and maintain disaster recovery plans and procedures.
Mandatory Skills:
· Expertise in DB administration, especially in Oracle & MS SQL 2019.
· Experience with Oracle Database versions 19c and above.
· Proficiency in SQL, PL/SQL, and scripting languages.