Job
Description
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.
