Oracle DBA

JD 

Key Responsibilities

Database Management:

• Install, configure, upgrade, and manage Oracle databases across development, testing, and production environments.

• Monitor database performance, implement performance tuning, and optimize queries.

Backup & Recovery:

• Design and implement backup and recovery strategies using RMAN or other tools.

• Manage disaster recovery plans and ensure database availability and resilience.

Database Security:

• Implement database security policies, including user management, access controls, and encryption.

• Perform audits to ensure compliance with security standards.

Performance Tuning & Optimization:

• Identify and resolve performance bottlenecks.

• Optimize database queries, indexes, and configurations for efficient operations.

Troubleshooting:

• Handle database incidents, root cause analysis, and problem resolution.

• Provide support for database issues and ensure minimal downtime.

Patching & Updates:

• Apply database patches and updates as required.

• Maintain database software and hardware compatibility.

Documentation:

• Prepare and maintain detailed documentation for database conf igurations, processes, and procedures.

• Provide knowledge transfer and training to other team members.

• .

• Technical Skills:

o Proficiency in Oracle 11g/12c/19c database administration.

o Hands-on experience with Oracle RAC, ASM, and Data Guard.

o Strong knowledge of SQL and PL/SQL programming.

o Expertise in tools like RMAN, OEM, and database performance monitoring utilities.

• Other Skills:

o Familiarity with Linux/Unix operating systems.

o Strong analytical and problem-solving skills.

o Excellent communication and teamwork abilities.

Preferred Skills:

• Experience with cloud-based Oracle solutions such as Oracle Cloud Infrastructure (OCI).

• Knowledge of other database technologies like MySQL, PostgreSQL, or SQL Server.

• Certification in Oracle Database Administration is a plus.