Oracle Database Administrator Lead

• 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.

• 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.

• 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.

• 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.

UST