Primary Skills core Oracle DBA functions , Oracle Golden Gate Data Replication, DB installation, configuration, upgrade, maintenance, patching,migration and security
Description Required Skills/Experience:
Must have 8 years of experience with core Oracle DBA functions with 11g/12c.
Mandatory to have expertise on Oracle Golden Gate Data Replication (installation, configuration,upgradation and monitoring).
Must have experience in following areas:
DB installation, configuration, upgrade, maintenance, patching,migration and security.
Oracle Real Application Clusters (RAC), Oracle Data Guard, ASM.
RMAN backups, restores and disaster recovery plan processes and procedures.
Supporting critical production databases.
Good experience with one or more scripting platforms: Shell Scripting, Perl/Python, SQL,Ansible
Database performance analysis and tuning skills at the application and database layers.Should have strong skills in analyzing AWR,ADDM,ASH,hang analyze , SQL tracing , wait events, system state dump , library cache dump ,oswatcher logs.
Strong Hands-on SQL performance tuning.
Good understanding of OS,Storage and SAN technology.
Excellent verbal communication and technical documentation skills and willing to work in late shift and off-hours as and when needed.
Desired Skills / Experience:
Experience in building, deploying, troubleshooting, and supporting databases running in AWS
Good hands-on experience with Amazon Web Services ( e.g EC2, RDS, S3 etc).
Experience or knowledge at least one of the non Oracle databases in Postgres, Mysql, MSSQL
Knowledge of Exadata architecture and administration.
Hands on Oracle Enterprise Manager Grid Control 12c/13c.