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.

Create, clone and upgrade database environments to support implementation activities.

Define, implement and support database backup and recovery policies using RMAN and/or storage replication technologies.

Working knowledge of ITIL processes.

Perform database restoration and recovery in the event of a failure.

Ensure sensitive data is appropriately protected via industry standard encryption solutions.

Contribute to, and update, systems documentation as required.

Participate in providing 24x7 support on rotational basis to ensure operations of these critical systems for different customers.

Experience Required:

10 years in Database Management

Minimum 5 to 8 Implementation cycle (individual contributor)

Adoptive for 24x7 Shift Support

Excellent spoken and written English Communication.

Good attitude towards corporate environment.

Hands on experience in Operations and Support of Oracle RDBMS 11g,12c and 19C.

Team player & Mentor to the team.

Energetic, self-motivated and self-sufficient in accomplishing tasks.

Good analytical and problem solving skills.

Must Have:

Must have implemented and supported mission critical systems providing 24X7 support.

Must have excellent shell scripting skills.

Must have proven experience in tuning databases and queries.

Can drive projects to get the projects accomplished with superior results.

Must deliver winning results and take accountability for your actions.

Must be an expert in diagnosing and solving complex problems.

Must have very good oral and written communication skills and have the ability to influence others.

Must have 10+ years of Oracle database related work experience.

Must have a BS or MS in Business, Computer Sciences, Engineering or related field (an equivalent combination of related education, training and experience may be considered).

Deep understanding of Oracle DBMS 11.2,12c and 19C.

Must have a deep understanding of Oracle Grid/RAC, Oracle Partitioning, Oracle CIS Security Standards, Oracle Enterprise Manager

Must understand Oracle performance tuning techniques.

Deep understanding of database replication using the following technologies: Oracle Active Data Guard, Oracle Golden Gate related data replication products.

Significant experience with HP-UX, Linux (RHEL).

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, Change Management & Problem Management

Strong in adopting the SLA Governance.

OCA/OCP Certified.

Technical Skills:

S/he will demonstrate an in depth understanding of several products in more than one functional area involving usage, configuration, and interaction with other products.

S/he must possess a balance of very well-developed troubleshooting, technical communication and written skills along with extensive product knowledge and skills.

Candidate should have excellent technical communication skills both verbal and written.

Interpersonal Skills:

Be professional in all modes of interaction with our internal & external customers.

Be capable of making well founded decisions in high pressure situations & exercising diplomacy when operating in politically charged environments.

Actively listen and confirm problem details showing empathy for urgent situations

Utilize effective negotiation skills which will lead to satisfactory issue resolutions.

Expertia AI Technologies