Senior Database Developer

India

3 months ago
Save Job

Summary

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 activities Position Requirements Must 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 Indicators Ability 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).

How strong is your resume?

Upload your resume and get feedback from our expert to help land this job

People also searched: