Job
Description
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. Monitor database performance and tune SQL queries, indexes, and configurations. Utilize Oracle Enterprise Manager (OEM) and other tools to analyze and improve database performance. Experience on Goldengate, Oracle enterprise manager. 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 tests to ensure compliance with recovery objectives. Implement database security measures, including user management, roles, privileges, and encryption. Regularly apply patches and updates to address vulnerabilities and maintain compliance. Perform audits and ensure adherence to security policies and standards. Diagnose and resolve database-related issues, including connectivity, performance, and corruption problems. Provide support for database operations in 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 application integration. Review PL/SQL code for performance and adherence to best practices. Support the development of stored procedures, triggers, and views. Set up and manage monitoring tools to track database health, performance, and usage. Automate routine database maintenance tasks using shell scripts or tools like Ansible. Maintain detailed documentation of database configurations, procedures, and best practices. Generate regular reports on database health, performance, and capacity planning. Expertise in Oracle Database Administration, including RAC, ASM, and Data Guard. Proficiency with Oracle tools such as RMAN, OEM, and SQL*Plus. Strong knowledge of PL/SQL programming and SQL query optimization. Experience with database backup, recovery, and disaster recovery planning. Familiarity with partitioning, materialized views, and indexing strategies. Knowledge of database security, auditing, and encryption techniques.
