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,