Required Skills and Qualifications:
- Experience:
- Proven experience as an Oracle DBA with a deep understanding of Oracle Database management (version 11g, 12c, 19c) in both on-premises and cloud environments.
- Strong experience working withOracle Cloud Infrastructure (OCI)and cloud-based database services.
- Skills:
- Expert knowledge in database tuning, backup, recovery, security, and troubleshooting.
- Hands-on experience with Oracle Enterprise Manager (OEM), RMAN, and SQL*Plus.
- Proficient in cloud architecture and services related to Oracle Cloud.
- Familiarity with cloud-native tools likeOracle Autonomous DatabaseandOracle Exadata Cloud Service.
- Strong scripting skills (Shell, Python, etc.) for automation and management.
- In-depth understanding of database replication, clustering, and high availability configurations.
- Experience with performance monitoring and tuning using tools likeAWR,ADDM, andASH.
- Certifications:
- Oracle Certified Professional (OCP) is highly preferred.
- Oracle Cloud certification is a plus (OCI Architect or Oracle Autonomous Database certification).
- Soft Skills:
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
- Ability to work independently and in a team environment.
- Ability to manage multiple priorities and meet deadlines.
Preferred Qualifications:
- Academics : B.Tech/B.E./MCA/M.Sc
- Experience inOracle RAC (Real Application Clusters)andData Guardconfiguration and management.
- Experience with migration strategies from on-premises Oracle environments to Oracle Cloud.
- Experience in Oracle Cloud networking and security best practices.
Key Responsibilities:
- Database Administration:Install, configure, manage, and maintain Oracle databases (Oracle 11g/12c/19c) both on-premises and in Oracle Cloud.
- Performance Tuning:Perform database performance tuning, troubleshooting, and optimization for both traditional on-premises and cloud environments.
- Backup and Recovery:Implement and manage backup and disaster recovery solutions for Oracle databases, ensuring data integrity and availability.
- Cloud Management:Utilize Oracle Cloud Infrastructure (OCI) to deploy, monitor, and manage databases, implementing best practices for high availability, scalability, and security.
- Security & Compliance:Manage database security configurations, enforce policies, and monitor for vulnerabilities. Ensure databases meet industry compliance standards.
- Capacity Planning:Monitor database capacity, performance, and system utilization. Plan for scaling databases in the cloud to meet business needs.
- Automation & Scripting:Automate routine DBA tasks such as backups, patches, and database monitoring using tools like shell scripting, Python, and Oracle Enterprise Manager.
- Troubleshooting:Provide database troubleshooting and resolution for issues related to database connectivity, performance, and security.
- Collaboration:Work with development teams to optimize SQL queries and database schemas for better application performance.
- Upgrades & Patching:Plan and execute upgrades and patches to Oracle database systems, ensuring minimal downtime and data consistency.
- Documentation & Reporting:Maintain up-to-date documentation of database environments, configurations, and procedures. Provide regular reports on database performance and security.
