Oracle Database Administrator

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.