Job Title : Oracle DB Admin
Location : Chennai/Bangalore/Hyderabad
Experience : 5 - 8 years
Skills : Exadata, OEM, Data guard, CDB & PDB
Job Description :
Position Summary :
Responsible for Designing, installing, upgrading, patching, tuning, monitoring and troubleshooting databases with large amounts of data (Terabytes) and high transaction rates. Capacity planning, SQL analysis, schema revisions, security administration and user account maintenance. Active on-call rotation & should be capable of providing off-hours support.
Experience :- Minimum of 7+ years hands-on experience as database administrator of Oracle RAC & Technical expertise in Exadata, OEM, Data guard, CDB & PDB
Technical Knowledge and Skills : Excellent understanding, installing, administering, and working knowledge of Oracle 12c through 19c databases.
Experience in configuring and managing Oracle RAC, Cluster ware, Grid infrastructure, Oracle ASM, OEM
Hands-on with Oracle Database migration/upgrade using different methodologies Data Pump & RMAN Transportable Tablespaces
Experience with RMAN database backup and recovery using ZFS and Data Domain.
Hands-on with CDB & PDB architecture, design and implementation
Experience with Data Guard setup and management
Hands on Experience on Exadata, Cell Storage, Compute Nodes, Real Application Cluster
Experience on reading EXAWATCHER, Exadata Health Check Reports, Performance tuning, AWR, ASH, ADDM, Explain Plan etc.
Design and Implement Patching on Exadata systems.
Design Patching Solutions on Oracle RAC and Oracle database's
Experience in defining security standards and supporting security audits.
Experience with Perl, Unix Shell Scripting, and Python for custom monitoring and automation ·
Experience working with the development team during design sessions to provide performance and scaling inputs.
Experience with troubleshooting problems relating to the Oracle database that may originate or exist in the infrastructure that supports the data store including application server, network, storage, and operating system component/layer.
Exadata feature enablement, monitoring, review, and update placement strategy. Working knowledge on Exadata 7 and above platforms.
Monitor resource utilization and Oracle Compute Unit (OCPU) enablement.
Good exposure and hands-on with Oracle ExaCC (Exadata Cloud @ Customer) architecture, managing and creating resources using cloud dashboard.
Create/manage Oracle SR and support team in issue resolution.
Strong experience in Oracle Core Database administration and monitoring including Exposure to Performance of Exadata
Experience with migration of Oracle Databases from On-premises to Oracle Exadata Cloud at Customer
Experience with Oracle Enterprise Manager (OEM).
Experience with Patch/Upgrade and release management (database, storage node, server, network, Oracle Exadata).
Develop and maintain system documentation related to your Oracle Exadata and software configuration.
Apply process and architectural improvements to continually improve the availability, capacity, and performance of database systems.
Other Skills and Requirements :
Exceptional trouble-shooting and problem-solving skills
Ability to develop, support, and communicate core database engineering policies, standards, guidelines, and procedures.
Strong critical thinking, organizational, interpersonal communication, multi-tasking and prioritizing skills
Communicate appropriately and efficiently with management, customers, and vendors.
Sustain a team-oriented, fast-paced environment.
On-call rotation is required to support a 24/7 environment and is also expected to be able to work outside business hours to support a global delivery.
