Description

Key Skills: Oracle Database, Shell Scripting, RMAN, Multitenant Architecture, Database Administration, Performance Monitoring, Backup Recovery, Automation, PDB Management, CDB Management

Good to Have Skills: Experience with Oracle's Container Database and Pluggable Database architecture, expertise in disaster recovery planning, knowledge of database security compliance, proficiency in tablespace monitoring and user role management across multiple database instances.

Roles & Responsibilities:

• Design, build, and maintain Shell scripts to automate daily DBA tasks in multitenant environments including backups, health checks, patching, and provisioning.
• Automate PDB-level operations such as creation, cloning, unplug/plug operations, refreshes, and performance monitoring across multiple database instances.
• Implement comprehensive backup and recovery strategies using RMAN with automated scheduling and detailed logging capabilities.
• Manage and monitor CDB and PDB performance, storage utilization, and security compliance across all database environments.
• Develop automation solutions for startup/shutdown procedures, tablespace monitoring, and user/role management across all PDBs in the environment.
• Maintain clear and comprehensive documentation for automation scripts and establish standard operating procedures for database operations.
• Ensure high availability, disaster recovery readiness, and regulatory compliance in multitenant database setups

Key Skills

Education

Any Graduate