Responsibilities:
Database Administration:
- Install, configure, and maintain Oracle databases across development, test, and production environments.
- Monitor database performance, identify bottlenecks, and implement tuning measures to ensure optimal performance.
- Apply patches, updates, and upgrades to maintain database health and security.
Backup and Recovery:
- Implement and manage backup and recovery strategies to ensure data integrity and availability.
- Perform database restores and disaster recovery operations as needed.
Security and Compliance:
- Manage database security, including user roles, privileges, and access controls.
- Ensure compliance with company policies and industry standards for data protection and security.
Performance Monitoring and Optimization:
- Monitor database performance metrics using tools such as Oracle Enterprise Manager (OEM).
- Perform SQL query tuning, indexing, and optimization to enhance database efficiency.
Support and Troubleshooting:
- Provide support for database-related incidents and outages.
- Troubleshoot and resolve database issues, including performance, connectivity, and availability problems.
- Collaborate with development, QA, and operations teams to support application deployments and upgrades.
Documentation and Process Improvement:
- Maintain accurate documentation of database configurations, procedures, and policies.
- Identify opportunities for process improvements, automation, and standardization.
