ORACLE DBA

Talent Groups; United States; On-site; USD 110,000 - 150,000; Full time

Job summary

Talent Groups is seeking an experienced Oracle Database Administrator to provide end-to-end support across Production, UAT, and Development environments. The role involves designing and maintaining Oracle databases, performing upgrades, patching, migrations, and ensuring high availability with RAC and Data Guard.

You will collaborate with development teams on schema changes and security compliance. Key tasks include query optimization, backup and recovery planning, incident triage, on-call

Qualifications

• Experience with Oracle DB deployment, maintenance, and upgrades.
• Ability to design and implement disaster recovery and backup strategies.
• Strong collaboration with app teams for schema changes and code reviews.

Responsibilities

• Provide end-to-end Oracle DB support across Production, UAT, and Development.
• Design, implement, monitor, and maintain Oracle databases and components.
• Perform installations, upgrades, patching, migrations, and tech refreshes.

Skills

SQL optimization

Performance tuning

DR planning

On-call support

Dev collaboration

Tools

RMAN

Oracle RAC

Data Guard

Shell scripting

Python

Job description

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.