Subject Matter Expert (Support&Ops) (IN)
HCLTech
HCLTech
Seeking a skilled Oracle Database Administrator to manage and maintain robust Oracle database environments. This role involves critical tasks such as configuration, administration, and ensuring the smooth operation of databases.
You will be responsible for database upgrades, applying patches, implementing security measures, resolving issues, and optimizing performance. This position also includes providing essential support and guidance to development teams and other support personnel.
The daily focus will be on monitoring the production environment, ensuring optimal system performance, and guaranteeing data protection and recoverability. Familiarity with Exadata is a significant advantage for this role.
Key responsibilities include installing, configuring, tuning, patching, refreshing, and upgrading database environments using various utilities. You will set up and monitor standby databases, conduct DR drills, implement backup and recovery techniques, and diagnose/correct performance problems.
Manage database users, roles, profiles, permissions, and security. Generate and publish database health check reports and perform regular maintenance activities. Monitor space management, user activities, and resource utilization, demonstrating the ability to independently administer databases.
Apply new technologies and processes quickly, leveraging strong logical and analytical skills. Collaborate effectively with team members and stakeholders, maintaining good communication. Ensure a deep understanding of Oracle database concepts across on-premises and cloud platforms, with a required understanding of Unix operating systems.
Proficiency in performance tuning, query optimization, and client/server connectivity is essential. Experience in writing shell scripts and general system administration tasks is also required. Develop and maintain Oracle high availability environments like RAC and Dataguard, along with production support and database administration.
A strong candidate will possess proven experience managing diverse database configurations and Oracle database skills, complemented by Unix operating system knowledge. You should have a good understanding of the architecture and configuration of the latest Oracle versions.
Experience with patching, cloning, security, backup and recovery procedures, node management, replication setup, and DR-drill activities is crucial. Demonstrable expertise in performance tuning, query optimization, and client/server connectivity is expected.
Additional requirements include experience with shell scripting, general system administration, setting up Oracle high availability solutions (RAC, Dataguard), and managing Oracle databases across various cloud environments. Experience in identifying and resolving performance issues, planning optimal backup and recovery solutions, and proficiency with Oracle utilities like RAC, ASM, RMAN, Dataguard, and Datapump are necessary.
Solid understanding of SQL and PLSQL procedures, functions, and triggers is vital. You should be adept at guiding development teams in SQL statement optimization and managing code deployments as part of change management. The ability to perform Oracle database file recovery in various scenarios, analyze SQL, tune parameters, optimize SGA, and utilize tools like AWR/ADDM/OEM, especially leveraging Exadata's capabilities, is expected. Strong troubleshooting, problem-solving, and interpersonal skills are essential. Experience managing high-performance Oracle databases on Exadata, including storage cells, compute nodes, Infiniband, and Oracle Enterprise Manager (OEM), is highly desirable. Basic Shareplex knowledge is also needed.
HCLTech
IT Consulting