Job Description for ORACLE DBA(Specialist)
• Work with a team that supports large number of Oracle databases.
• Participate in management, prioritization, minor enhancements / fix activities, problem management, stability analysis, etc.
• To be proactive in nature thus identifying problems in advance and looking for continuous service improvements.
• Min 10+ years of experience in Oracle database administration in production environments on Unix, Windows and Linux OS.
• Capable of performing Database Administration tasks independently in Oracle 10g, 11g, 12c and 19c.
• Analysis of technical issues and permanent fix/solution.
• Implementation of RAC, ASM, Data Guard for database failover between Data center and DR site, perform switchover /failover activities.
• Work on the performance issues related to Clustering, Create logical diagrams to figure out the loop pools in the database designs and functionality.
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
• All above applicable to infrastructure which has standalone and RAC databases using file-system based or ASM based storage.
• Provide capacity planning and performance monitoring of our database environments.
• Support, administer and maintain production and non-production database environments.
• Implement and maintain proactive database monitoring.
• Work with engineering and application support teams to identify, triage and resolve performance issues. This requires the ability to analyze, optimize and tune complex SQL queries.
• Deploy and maintain high availability and failover technologies such as Active Data Guard, RAC.
Preferable:
• Knowledge in MSSQL/MySQL/PostgreSQL RDMS
• Solutioning towards Database requirement not limited to Oracle.
• Should have Hands on Experience in monitoring and management tools.
• Strong in preparing Knowledge Base Documents & SOP
• Good in ITIL/ITSM Process – Incident, Service Requests,