Responsibilities:
Set up and maintain Oracle databases, including user accounts and storage structures.
Continuously monitor database performance, identify bottlenecks, and tune queries and configurations to improve speed and efficiency.
Develop, implement, and manage database backup strategies to ensure data integrity and enable efficient recovery in case of failure.
Implement and maintain security policies and access controls to protect the database from unauthorized access and data breaches.
Investigate and resolve complex database issues, such as performance problems, data integrity issues, and connectivity problems.
Provide support to application developers, assisting with database design and development to meet business needs.
Create and maintain documentation for database configurations, procedures, and changes.
Offer technical expertise and guidance to team members on effective database use and best practices.
Manage cloud environments, including Oracle Cloud Control and multi-tenant database architectures. Skills:
In-depth knowledge and experience with Oracle database technologies.
Proficiency in tools and techniques for optimizing database performance and query execution.
Strong understanding of backup and restore operations and disaster recovery strategies.
Ability to write shell scripts for automation and administrative tasks.
Experience implementing and managing database security measures.