• Experience in designing and implementing large-scale database solutions.
• Well versed with Oracle database versions 11g,12c & 19c across multiple platforms.
• Solution design for database upgrade, migrations, and DR Solution.
• Plan for database design in terms of scalability, performance, high availability, disaster recovery and security
• Need to have hands-on experience with Oracle CDB/PDB Architecture and should be well versed with activities like PDB cloning, PDB Plug/Unplug.
• Need to be aware of Database security practices including TDE, Network Encryption, DB vault, redaction. etc.
• Experience with Design and Implementation for Oracle RAC including Oracle Extended RAC for Disaster Recovery is a must.
• Need to have a solid understanding for disaster recovery best practices for Oracle.
• Experience with Database backup/recovery using RMAN and need to have knowledge of working with MML backup tools.
• Experience with Oracle Active data guard and DG broker is mandatorily required.
• Hands-on experience with Oracle database upgrades, database migrations (same and cross platform) are required.
• Familiarity with different database migration strategies is required.
• Experience of collaborating with application teams and other stakeholders so that the database architecture meets their requirements while also ensuring scalability and performance required
• Needs to understand server, storage, virtualization, backup, and network technologies.
• Experience with Cloud, Golden Gate and Exadata is an added advantage.
• Define database deployment standards; automation for mundane tasks; advice for backup strategies.
• Develop database architectural strategies at the modeling, design, and implementation stages to address business or industry requirements.
• Develop and document database architectures.
• Responsible and expertise in Oracle Database Administration experience with configuration, load balancing, backup/recovery, sizing and space management, RAC, PL/SQL tuning, diagnostics and performance management .
• Need to have a detailed understanding of pros and cons of RAC, RAC One Node, Single Tenancy and Multitenancy.
• Need to understand Oracle licensing for Standalone, RAC, Data guard.
