Oracle DBA - Scripting

About ProArch:

Founded in 2006, ProArch began as a tight-knit team of business-minded IT professionals passionate about delivering exceptional cloud-based technology solutions. Today, we’ve grown into a global force spread across US, UK and India into multidisciplinary experts spanning cloud, infrastructure, data analytics, cybersecurity, compliance, and software development. Organizations turn to ProArch for forward-thinking guidance, seamless implementation, and dependable ongoing support partnering with us to reach every milestone on the path to their vision.

Our services consist of specific practice areas that are methodically designed to complement and enhance each other's effectiveness. This interconnected approach removes roadblocks and drives rapid growth and financial stability. Many of our clients leverage the full scope of our services, creating a supply chain of value that impacts the entire organization from IT to customer experience.

At our core, we believe in the power of technology to transform. We’re passionate about inspiring innovation that shapes our people, our clients, our partners, and the communities we serve.

About Role :

ProArch, is 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.

Key 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.).
• Strong knowledge of RMAN, Oracle Enterprise Manager (OEM), and SQL*Plus.
• Familiarity with database security, patching, and performance tuning.
• Experience with Python or tools for advanced automation.
• Exposure to cloud-based Oracle environments (OCI, Azure).
• Understanding of licensing and consolidation best practices for multitenant databases.

Please Note

• Shift timings 6PM to 3 AM , need to be available for extended work hours and stretch during weekends.
• This is permanent work from home opportunity
• We are looking for immediate joiners.

Life @ ProArch

• At ProArch, we believe our people are the key to our success. That’s why we foster an environment where every employee—known proudly as a ProArchian—can grow, thrive, and make a meaningful impact.
• We empower employees to develop at their own pace through Career Pathways, a clear and supportive guide to professional progression.
• Our culture is one of positivity, inclusivity, and respect. Titles don’t define how we treat each other—every ProArchian is valued equally, and collaboration across roles and teams is the norm.
• We understand that great work starts with balance. That’s why we prioritize work-life harmony, offering flexible work schedules and encouraging time for what matters most.
• Beyond the workplace, ProArchians actively give back—organizing volunteer efforts and charitable initiatives that empower the communities we call home.
• And because we know that extraordinary efforts deserve recognition, we celebrate those who go above and beyond with appreciation programs.
• At ProArch, we’re not just using technology to transform businesses—we’re using it to create a better experience for our people, our clients, and our communities.