Key Responsibilities

Database Administration

Install, configure, and upgrade Oracle database software (versions 11g, 12c, 19c, or later). Manage database instances, schemas, tablespaces, and objects such as tables, indexes, and views. Plan and execute database migrations and upgrades with minimal downtime. Utilize Oracle Enterprise Manager (OEM) and other tools to analyze and enhance database performance. Manage and troubleshoot Oracle GoldenGate and Oracle Enterprise Manager environments. Identify and resolve performance bottlenecks related to storage, memory, and CPU utilization. Develop and implement robust backup and recovery strategies using RMAN. Configure and maintain high-availability solutions, including Oracle RAC and Data Guard. Conduct regular disaster recovery drills to ensure compliance with RTO and RPO objectives. Implement security measures, including user management, roles, privileges, and encryption. Regularly apply patches and updates to address vulnerabilities and maintain compliance. Perform audits to ensure adherence to organizational security policies and standards. Troubleshoot and resolve database-related issues such as connectivity, performance, and data corruption. Provide support for database operations across development, testing, and production environments. Act as the primary point of contact for database incidents and outages. Collaborate with developers to design efficient database structures and optimize integration with applications. Assist in developing stored procedures, triggers, and views for application requirements. Set up and manage monitoring tools for database health, performance, and capacity planning. Automate routine maintenance tasks using shell scripts or automation tools like Ansible. Maintain comprehensive documentation of database configurations, procedures, and best practices. Prepare and deliver regular reports on database health, performance, and capacity utilization.

Qualifications and Skills

Required Skills

Strong expertise in Oracle Database Administration, including RAC, ASM, and Data Guard. Proficiency with Oracle tools such as RMAN, OEM, and SQL*Plus. Extensive experience in database backup, recovery, and disaster recovery planning. Knowledge of partitioning, materialized views, and advanced indexing strategies. Solid understanding of database security, auditing, and encryption practices.

Preferred Skills

Experience with Oracle Exadata and Oracle Cloud Infrastructure (OCI). Proficiency in scripting languages (e.g., Bash, Python) for automation tasks. Working knowledge of Unix/Linux operating systems and shell scripting.

Education and Experience

Bachelor’s degree in Computer Science, Information Technology, or a related discipline. 9+ years of hands-on experience as an Oracle DBA in production environments. Relevant certifications such as Oracle Database Administrator Certified Professional (OCP) are highly desirable.