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,