Oracle DBA

Key Responsibilities:

• Install, configure, and maintain Oracle database systems, including clustering and high availability features such as RAC (Real Application Clusters).
• Monitor database performance, identify potential issues, and optimize system performance.
• Perform regular database backups, recovery, and data restoration operations.
• Implement database security policies and user access controls.
• Work closely with developers to design and implement database schemas, queries, and indexing strategies.
• Troubleshoot and resolve database-related issues, including performance tuning and query optimization.
• Maintain database integrity, perform routine health checks, and manage database patching and upgrades.
• Configure and manage Oracle Data Guard for disaster recovery and replication.
• Automate routine DBA tasks through scripting and toolsets.
• Collaborate with system administrators, network teams, and application developers to ensure database systems are integrated with overall IT infrastructure.
• Provide on-call support for critical production environments.
• Ensure compliance with database best practices, security protocols, and audit requirements.
• Document database processes, procedures, and configurations.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
• Proven experience as an Oracle DBA, managing large-scale databases in production environments.
• Strong knowledge of Oracle Database technologies, including Oracle 11g, 12c, 19c, and Oracle RAC.
• Proficiency in SQL and PL/SQL.
• Experience with database backup and recovery techniques, including RMAN (Recovery Manager).
• Familiarity with Oracle Cloud Infrastructure (OCI) and database-as-a-service (DBaaS) environments is a plus.
• Solid understanding of database performance tuning and query optimization.
• Strong troubleshooting and problem-solving skills.
• Experience with Oracle Enterprise Manager (OEM) and other database management tools.
• Knowledge of database security practices and user management.
• Experience with scripting languages (e.g., Shell, Perl, Python, etc.) is a plus.