Oracle DBA
Essential Skills/ Experience Requirement:
• Should have hands on experience in Oracle DBA in production environment in Oracle 11g – 19c, Performance tuning, OEM 13c
• Should have hands on experience in Oracle RAC installation and administration on Exadata.
• Should have experience in performance tuning
• Should have worked on Exadata
• Should have experience managing Exadata storage and tuning
• Expertise in ADG, Golden Gate, RMAN, backup
• Expertise in Incident & Problem Managements
• Experience in installation, configuration of MS SQL database, replication technology, Always on.
• Oracle Certification Exadata will be preferred
• MySQL, Mongo DB, PostgreSQL will be advantage.
Job Description:
• Setup monitoring and managing customized catalogs, reporting using OEM
• Performance tuning for MS SQL databases, backup and restoration
• Experience in managing MySQL, Mongo DB, PostgreSQL databases as L2 & L3 level support
• Hands on experience in Oracle Data guard (ADG) installation and administration
• Managing Cluster environment – Database/ASM & Grid Infrastructure Management
• Hands on experience in Oracle Data guard (ADG) installation and administration
• Handling Failover and Switch-Over activities
• Backup and recovery configurations using RMAN & backup tools like Commvault
• Perform database upgrades
• Hands on experience for Oracle database migration and tuning
• Performance tuning for Oracle database
• Respond to break/fix incident, problem, change, SRs, maintenance activity (e.g patching) within SLAs
• Assist with upgrade and migration
• Assist with new projects and T&M work
• Assist with planned application releases
• Provides 24×7 (on-call) support as per standby roster
• Manage workload and ensure assignments are completed on time and within target completion dates
• Keep clients informed at all times as to progress of assigned tasks and setting realistic expectations with regards to completion dates and status updates in a professional, concise and informative manner
• Demonstrate ownership and interest in goals by identification, escalation and resolution of issues appropriately
• Works with minimal direction from the technical lead to accomplish assigned tasks
• Keeping up to date with new & emerging technologies
• Takes ownership of highly complex or critical incidents and problems and provides resolutions in a timely manner. Engages SMEs or vendors to provide assistance to resolve more complex incidents as required.
• Provides time / resource estimates for assigned tasks
• Provides Knowledge Transfer / Mentoring
Other Requirements
• Team spirit (Team Player)
• A ‘can do’ attitude
• Methodical and structured approach to tasks and troubleshooting
• Maintains high quality supporting documentation
• Ability to work in a team and provide a high level of customer service skills
• Eager to learn and enhance skills
• Ability to resolve issues & handle conflicting priorities in a dynamic environment
• Strong communication skills, the ability to interact well in client environment and service excellence
• A positive attitude, a passion for IT and a mindset that can adapt easily to change
• Ability to multitask and prioritize current and incoming workload
• Understanding of ITIL framework
• Self-motivated with a strong customer focus and a result oriented approach with strong verbal and written communication skills.