Oracle Exadata Database Administrator
Cognizant - India
Total years of experience :4 years, 7 Months
Environment : Oracle 1 1g/12c/19c, Standalone with ASM, RHEL 5/6/7, AIX, RAC, Goldengate, EXADATA
Responsibilities: (L2)
• Perform database administration tasks like health checks, backup, and day-to-day management activities
• Synchronizing production and DR databases with incremental backup.
• Basic goldengate activities including reading report file, starting stopping gg processes, re-instantiation of tables as required.
• Basic EXADATA administration for database servers.
• Coordination with application stakeholders and oracle support for exadata server patching.
• Creating work order and coordinate with oracle field engineer for required maintenance.
• Schedule monitoring crontab jobs on Linux and AIX servers to trigger mail with details.
• Creating and following up with oracle SR.
• Creating changes in service-now and performed within SLA.
• Managing tracker with frequent issues and working with problem tickets.
• Applying GRID, PSU, and Bug fixing patch to the standalone and RAC databases.
• Manage configuration, user access, data files, redo logs, table spaces, and query tuning across all databases.
• Writing shell script for space management.
• Handled performance issues for query and database slowness analyzing AWR report.
• Managing the Backup and restoring, recovering databases.
• Creating users, assigning responsibilities as a part of Security Policies for various categories of User Support.
• Dropping users and granting/removing user privileges.
• Execute data operations such as truncating or dropping tables, executing scripts.
• Refreshing schemas, tables, and databases using EXPDP, IMPDP.
• Databases decommission tasks.
• Performed RMAN database refreshes.
• Involved in collaboration with oracle support for troubleshooting issues.
• Experience in generating AWR, ASH, TFA report.
• Experience in OEM for monitoring, creating blackouts and troubleshooting in performace issues.
• Providing 24/7 support and on-calls as per the requirement.