• Administer, monitor, and maintain Oracle Database environments with high availability. • Analyze and optimize the performance of SQL and PL/SQL queries used by systems and applications. • Develop and recommend improvements to queries, procedures, and routines with a focus on performance and scalability. • Proactively monitor database performance across development, staging/QA, testing, and production environments. • Identify performance bottlenecks and implement corrective and preventive actions. • Recommend improvements to data modeling to increase efficiency, performance, and data integrity. • Perform data loads, migrations, and replications between environments using Oracle administration tools. • Assess technical impacts resulting from changes to database structures. • Manage backup policies, disaster recovery (Recovery), and service continuity. • Implement and oversee maintenance routines, updates (patches), monitoring, and capacity planning. • Define best practices for Oracle database administration and governance. • Support development teams in creating solutions that follow database best practices.

Role 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. - 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. Qualifications - 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.

• Design, implement, and manage physical database architectures and DBMS environments • Perform database optimization, capacity planning, migrations, installations, and performance tuning • Administer and maintain Oracle databases (10g, 11g, 12c, 19c) in large multi-tenant environments • Design, build, and configure Oracle database servers across Windows, Linux, and Unix-based systems • Lead and support enterprise Oracle database migrations to newer versions (19c or higher) • Ensure database performance for enterprise applications (e.g., GIS, Java, and web-based systems) • Implement and maintain database security, auditing, and compliance controls • Support both cloud-based and on-premise database environments • Configure and manage advanced Oracle features (e.g., Data Guard, RAC, TDE, OEM) • Perform backup/recovery planning and execution • Troubleshoot complex database issues and provide expert-level support • Conduct systems analysis and contribute to technical solution design • Coordinate implementation of complex systems and assist with data refresh activities • Identify, assess, and communicate technical risks and mitigation strategies • Document technical work and ensure effective knowledge transfer

• Serve as the technical Oracle Applications DBA lead for long-term Operations & Maintenance (O&M) of OCI environments, owning operational stability, performance, and continuous service improvement across the engagement lifecycle. • Lead and manage large-scale O&M activities including production support, release management, environment migrations, environment refreshes and cloning, and complex infrastructure troubleshooting. • Perform and oversee hands-on Oracle EBS Applications DBA functions including adop patching, AutoConfig, full APPL_TOP cloning, Concurrent Manager configuration and tuning, OAM, Forms/Reports administration, Workflow, and XML/BI Publisher. • Lead platform and cloud migration initiatives, including Solaris to Linux migrations onto Exadata and OCI. • Deliver Oracle Infrastructure and Cloud Data/BI solutions, ensuring operational outcomes align with client SLAs and business expectations. • Plan, schedule, and execute quarterly security patch cycles for the full Oracle stack, including CPU/RU database patches and RUP/AD/TXK, WebLogic, OHS, JDK, and APPL_TOP patches. • Design and operate centralized monitoring and alerting frameworks for high availability components. • Implement and manage OEM Cloud Control monitoring, including agent deployment and configuration, metric thresholds, incident rules. • Lead Oracle performance tuning across database and application tiers, supporting development teams with SQL and execution plan analysis. • Own disaster recovery readiness end to end, including Data Guard configuration and alerting, scheduled DR testing (switchover and failover validation). • Drive automation of routine DBA tasks through scripting and RPA to reduce manual effort. • Own ITIL-aligned Incident, Problem, and Change Management for DBA workstream. • Establish and govern deployment and change management processes for database changes. • Establish, document, and enforce SOPs and operational standards under formal document management.