ORACLE DBA

Job Description :

• Provide end-to-end database support for business-critical applications in Production, UAT, and Development environments.
• Design, implement, monitor, and maintain Oracle databases and lated application database components.
• Perform database installations, upgrades, patching, migrations, and technology refresh activities.
• Analyze and optimize SQL queries, stored procedures, packages, functions, and execution plans.
• Troubleshoot database performance issues, locking, blocking, deadlocks, and application-related incidents.
• Support application deployments, release management activities, and change implementation processes.
• Configure and maintain database backup, recovery, and disaster recovery solutions.
• Monitor database health, capacity utilization, and proactively address performance bottlenecks.
• Collaborate with application development teams on database design, schema changes, and code reviews.
• Implement database security standards, user access controls, encryption, and compliance requirements.
• Perform root cause analysis (RCA) for production issues and recommend preventive measures.
• Support high availability environments using RAC, Data Guard, Replication, or equivalent technologies.
• Develop and maintain database operational documentation, runbooks, and standard operating procedures.
• Participate in on-call support and critical production incidents.
• Prepare reports from DB upon Business requirements for data analysis and Monthly Metrics generations.
• Install, configure, upgrade, patch, and maintain Oracle Database environments (11g, 12c, 19c, 21c).
• Monitor database performance, availability, and capacity planning.
• Perform database backup, recovery, and disaster recovery using RMAN.
• Configure and administer Oracle RAC, ASM, and Data Guard environments.
• Troubleshoot database performance issues and optimize SQL queries.
• Implement database security, auditing, and access controls.
• Manage production, UAT, and development database environments.
• Perform database migration, refresh, cloning, and upgrade activities.
• Automate routine DBA tasks using Shell Scripts, Python, or PL/SQL.