Oracle Exadata Administrator

Doyensys is a Management and Information Technology consulting services company based out of Dallas, TX. With 200+ employees globally, we support customers around the globe to solve their business and technology challenges. Great culture, excellent benefits , consistant growth are some of the attributes of Doyensys. We look for great talents to join our thriving team. Why settle for less?

Job Requirement

• Project Role: Oracle Exadata administrator.
• Project Role Description: The Oracle Exadata Administrator specialized in Patching of Exadata, PCA, and ZFS plays a crucial role in ensuring the smooth and efficient operation of Oracle Exadata Database Machine, Private Cloud Appliance (PCA), and Zettabyte File System (ZFS) environments. This role focuses on managing and executing patching activities across these systems, ensuring they are up-to-date, secure, and optimized for performance.

• Work Experience: 10+ years
• Work Location: Chennai, Immediate, General shift (IST), Work from Office

Technical Expertise

Must-Have Skills:

Oracle Exadata Expertise: In-depth knowledge and hands-on experience with Oracle Exadata Database Machine, including understanding its architecture, components, and functionalities.

Patching Procedures: Proficiency in executing patching procedures for Oracle Exadata, Private Cloud Appliance (PCA), and Zettabyte File System (ZFS), including applying various types of patches, such as bundle patches, one-off patches, firmware updates, and security patches.

Patching Tools: Familiarity with patching tools and utilities specific to Oracle Exadata, such as OPatch, Oracle Clusterware stack, and Oracle Enterprise Manager (OEM).

Oracle Clusterware and ASM: Strong understanding and practical experience with Oracle Clusterware and Automatic Storage Management (ASM) components as they relate to Exadata patching.

Troubleshooting Skills: Excellent problem-solving and troubleshooting abilities to identify and resolve patching-related issues, such as conflicts, failures, or performance degradation.

Documentation and Inventory Management: Ability to develop and maintain patching scripts, automation tools, and documentation to streamline patching processes. Skill in monitoring and tracking patch versions to maintain an accurate inventory of applied patches and associated configurations.

Collaboration and Communication: Strong collaboration and communication skills to work effectively with cross-functional teams, including Database Administrators (DBAs), System Administrators, vendors, and stakeholders. Ability to coordinate patching activities and communicate patching schedules, progress, and potential impacts.

Pre-Patching and Post-Patching Procedures: Proficiency in conducting pre-patching checks, compatibility assessments, and necessary prerequisites verification. Skill in performing post-patching validations to ensure the successful application of patches and system stability.

Oracle Certifications: Relevant Oracle certifications, such as Oracle Certified Professional (OCP) or Oracle Certified Expert (OCE) in Oracle Exadata, would be advantageous and demonstrate expertise in Oracle technologies.

Good To Have Skills:

Performance Tuning: Proficiency in performance tuning techniques specific to Oracle Exadata, PCA, and ZFS environments. This includes optimizing SQL queries, diagnosing and resolving performance bottlenecks, and fine-tuning Exadata configurations for optimal database performance.

Backup and Recovery: Experience in implementing backup and recovery strategies for Oracle Exadata, PCA, and ZFS systems. Familiarity with Oracle Recovery Manager (RMAN) and knowledge of various backup and recovery methods, including full, incremental, and point-in-time recovery.

Security: Understanding of security practices and methodologies relevant to Oracle Exadata, PCA, and ZFS environments. Knowledge of Oracle Advanced Security features, encryption techniques, access controls, and security auditing.

High Availability: Familiarity with high availability solutions and technologies for Oracle Exadata, PCA, and ZFS. Experience in configuring and managing Oracle Data Guard, Oracle GoldenGate, or other replication and failover mechanisms to ensure continuous availability and disaster recovery.

Automation and Scripting: Proficiency in scripting languages (e.g., Shell scripting, Python, Perl) to automate patching processes, monitor system health, and perform routine maintenance tasks. Experience with configuration management tools like Ansible or Puppet is a plus.

Capacity Planning: Understanding of capacity planning methodologies to forecast resource requirements for Oracle Exadata, PCA, and ZFS systems. Ability to analyze performance metrics, identify capacity constraints, and make recommendations for resource allocation and scalability.

Monitoring and Troubleshooting Tools: Familiarity with monitoring and diagnostic tools specific to Oracle Exadata, PCA, and ZFS environments. Knowledge of Oracle Enterprise Manager (OEM), ExaWatcher, or similar tools to proactively monitor system health, diagnose issues, and perform root cause analysis.

Database Upgrades: Experience in planning and executing Oracle database upgrades within Exadata environments. Knowledge of Oracle Database upgrade methods, best practices, and version compatibility considerations.

Knowledge Sharing and Documentation: Ability to document procedures, guidelines, and best practices related to patching, maintenance, and administration of Oracle Exadata, PCA, and ZFS systems. Willingness to share knowledge with team members and contribute to the development of internal documentation and training materials.

Key Responsibilities:

1. Patching Execution:

Perform patching activities for Oracle Exadata Database Machine, including Exadata storage servers, database servers, InfiniBand switches, and associated components.

Execute patching procedures according to established guidelines, ensuring adherence to patching schedules and minimizing system downtime.

Apply various types of patches, including bundle patches, one-off patches, firmware updates, and security patches.

Coordinate patching activities with other teams, such as Database Administrators (DBAs) and System Administrators, to ensure smooth execution and minimal impact on production systems.

2. Patch Management and Documentation:

Develop and maintain patching scripts, automation tools, and documentation to streamline patching processes and ensure consistency.

Monitor and track patch versions, maintaining an accurate inventory of applied patches and their associated configurations.

Stay up to date with Oracle's patching recommendations, advisories, and best practices, incorporating them into the patching strategy.

3. Troubleshooting and Issue Resolution:

Troubleshoot and resolve patching-related issues, such as conflicts, failures, or performance degradation.

Collaborate with vendors, support teams, and internal stakeholders to escalate and resolve complex patching challenges.

Conduct root cause analysis for patching failures and implement corrective measures to prevent recurrence.

4. Pre-Patching and Post-Patching Activities:

Perform pre-patching checks, including compatibility assessments, and ensure necessary prerequisites are met before patching.

Conduct post-patching validations to verify the successful application of patches and validate system stability and functionality.

5. Collaboration and Communication:

Collaborate closely with cross-functional teams, including DBAs, System Administrators, and Application Owners, to schedule and coordinate patching activities.

Communicate patching schedules, progress, and any potential impacts to stakeholders, ensuring transparency and managing expectations.