Oracle DBA

Senior Database Engineer – 7 to 12 yearsShift Time: 2:30 pm to 11:30 pmOracle 19c DBA who can support us at least until noon CSTproficient in RAC & ASM & Clusterware, 19c Multitenant and OEM Administration, etc.

Primary Responsibilities

The Offshore Senior Database Engineer has the primary focus on:Monitoring Database health / performance (RAC, Non-RAC and Data Guard Instance).Review Quarterly Database Patching requirement/steps and execute the patch process.Review Quarterly OEM Patching requirement/steps and execute the patch process.Monitor and take appropriate action proactively on night jobs, i.e., RMAN backups and Data Purging, etc.The overall technical support of the Oracle database, shutdown/startup database, issue troubleshooting, incident, alert and responding to requests from DevOps and other IT teams.Performs Database/Query monitoring, ongoing performance tuning and optimization activitiesPosition RequirementsMust have 7+ years of experience focused on Oracle DBA Administration in medium to large corporate environments, 3+ years of Oracle 19c administration (multitenant PDB/CDB, Oracle ASM, Oracle Cluster ware, Data Guard, Oracle Single Instance and Patching process).Installation and configuration for OEM13c for database monitoring and management.At least 5 years’ experience performance tuning both instance and SQL statement level tuning, good understanding of SQL Profile and query optimization. Ability to identify the culprit with tool (i.e., OEM) and without tool (query from Oracle dictionary).At least 5 years’ experience with backup and recovery procedures using RMAN.System knowledge and experience with Unix/Linux Operating Systems.Working knowledge of scripting programing (Shell, Python), GitHub, and Automation tools (AWX or Ansible) is a plus but not required.

Knowledge, Skills & Abilities

Must be a creative problem-solver, flexible, and proactive.Very good people skills, plus written and oral communication skills.Take responsibility, plan and structure all tasks (technical or non-technical) assigned as part of job role to ensure a business efficient service is delivered to customers.Key Performance IndicatorsAbility to manage multiple assignments (i.e., database/cluster patching, OEM management and troubleshooting) comfortably.Attentive to operational process (i.e. incident management, pickup/resolve/close timely, using SN monitoring tool to proactively monitor database platform, Change Management, etc.).Attentive to Agile process (i.e. story management, pick up/development/implementation and close timely).