Oracle DBA

At ProArch, we partner with businesses around the world to turn big ideas into better outcomes through IT services that span cybersecurity, cloud, data, AI, and app development. We’re 400+ team members strong across 3 countries (we call ourselves ProArchians)—and here’s what connects us all:

• A love for solving real business problems
• A belief in doing what’s right

What’s it like to work here?

• You’ll keep growing. You’ll work alongside domain experts who love to share what they know.
• You’ll be supported, heard, and trusted to make an impact.
• You’ll take on projects that touch industries, communities, and lives.
• You’ll have the time to focus on what matters most in your life outside of work.

At ProArch, you’ll be part of teams that design and deliver technology solutions solving real business challenges for our clients. With services spanning AI, Data, Application Development, Cybersecurity, Cloud & Infrastructure, and Industry Solutions, your work may involve building intelligent applications, securing business?critical systems, or supporting cloud migrations and infrastructure modernization.

Every role here contributes to shaping outcomes for global clients and driving meaningful impact. You’ll collaborate with experts across data, AI, engineering, cloud, cybersecurity, and infrastructure—solving complex problems with creativity, precision, and purpose. You’ll join a culture rooted in technology, curiosity, and continuous learning. A place where we move fast, trust you to make an impact, encourage innovation, and support your growth.

Job Description:

We are seeking a skilled and proactive Oracle DBA with deep expertise in automation and shell scripting, specifically within Oracle’s multitenant (CDB/PDB) architecture. This role focuses on optimizing and automating routine DBA operations to enhance efficiency, scalability, and reliability across multiple database instances.

Responsibilities :

• Design, build, and maintain Shell scripts to automate daily DBA tasks in multitenant environments (e.g., backups, health checks, patching, provisioning).
• Automate PDB-level operations: creation, cloning, unplug/plug, refreshes, and performance monitoring.
• Implement backup and recovery strategies using RMAN with automated scheduling and logging.
• Manage and monitor CDB and PDB performance, storage, and security.
• Develop automation for startup/shutdown, tablespace monitoring, and user/role management across all PDBs..
• Maintain clear documentation for automation scripts and standard operating procedures.
• Ensure high availability, disaster recovery readiness, and compliance in multitenant setups.

Requirements

• 5+ years of experience as an Oracle DBA with solid exposure to multitenant architecture (CDB/PDB) in Oracle 12c/19c/21c.
• Expertise in Shell scripting on Unix/Linux environments.
• Proven experience automating Oracle DBA tasks (monitoring, backups, user management, cloning, etc.).
• Experience with Python or tools for advanced automation.
• Strong knowledge of RMAN, Oracle Enterprise Manager (OEM), and SQL*Plus.
• Familiarity with database security, patching, and performance tuning.

Originally posted on Himalayas