Job description

Database Environment Management:

• Plan, implement, test, and maintain in-house database environments.
• Setup and configure database engines for development, testing, and production environments.
• Provide 24x7 support for day-to-day database activities, ensuring speedy resolution or escalation of operational incidents/problems.

Monitoring and Optimization:

• Conduct proactive monitoring activities to prevent incidents and maximize database availability.
• Perform regular performance tuning of the database, including table structure and index optimization.
• Develop and implement scripts for database task scheduling, monitoring, and maintenance.

Reporting and Analysis:

• Generate weekly reports on database status for analysis and forecasting usage, including tablespace,disk space, and table rows.
• Utilize Oracle Enterprise Manager (OEM) 12c cloud for comprehensive monitoring and management.

Backup and Recovery:

• Manage database backup and restore operations to ensure data integrity and availability.