Oracle DBA & Cloud Infrastructure Specialist

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 with Oracle 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 like Oracle Autonomous Database and Oracle 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 like AWR , ADDM , and ASH .
• 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 in Oracle RAC (Real Application Clusters) and Data Guard configuration 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.