Sr Oracle DBA

Oracle Exadata Database Administrator (DBA)Should have a working experience of 10 years plus on production Oracle Databases.Should have a working experience on Exadata including tuning, patching, maintenance, and troubleshooting.Should have a working experience of Oracle Golden Gate, troubleshooting Golden Gate issues.Should have following skills as DBA: Oracle 19c Multitenant databases.Oracle RAC experience- Performance tuning Expertise- Backup & recovery aspects.The DBA is responsible for maintaining highly visible production databases.Responsibilities include designing, installing, upgrading, patching, tuning, monitoring, and troubleshooting databases with high transaction rates.Capacity planning, SQL analysis, schema revisions, security administration, and user account maintenance are also required tasks. Immediate participation in an active on-call rotation is required.Candidate must be capable of providing off-hours support to avoid impacting database availability during normal business hours.Excellent understanding, installing, administering, and working knowledge of Oracle 12c through 19c databases.Experience in configuring and managing Oracle RAC, Clusterware, Grid infrastructure, Oracle ASM, OEM, and GoldenGate.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.Professional level of experience on Oracle SQL queries troubleshooting, debugging stored procedures, identifying blocking sessions in backend, complex joins, etc.Experience with DataGuard setup and management.Experience in defining security standards and supporting security audits.Experience with Ansible, Unix Shell Scripting, for automation.Experience working with the development/QA 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.Working knowledge on Exadata and RHEL platforms.Strong experience in Oracle Core Database administration and monitoring including exposure to Performance of Exadata.Experience with Oracle Enterprise Manager (OEM).