Job description
<p>Job Description :<br/><br/>1.
Installation, Administration, Configuration, Hardening, Troubleshooting issues of Oracle database on windows and Non-Windows Operating Systems.<br/><br/>2.
Monitor the Database health and ensuring Availability of the database.<br/><br/>3.
Installation, Configuration, Patching and up gradation of Oracle database in Windows and Non-Windows servers.<br/><br/>4.
Implementing TDE, Data Redaction, Channel Encryption and Integrity Checksum, DB Vaulting, Key store management etc.<br/><br/>5.
Database Architecture and Design.<br/><br/>6.
Database Performance Tuning and Query Tuning.<br/><br/>7.
Day to day database operations & support, backup restoration testing and monitoring.<br/><br/>8.
Setup and maintain Oracle RAC, Golden Gate, Oracle Data Guard, and DG Broker.<br/><br/>9.
Integrate the database with Oracle OEM or any other monitoring tools as specified by Bank on time to time.<br/><br/>10.
Provide Inputs/Evidence for Database Review, Security Review and closure of database related audit and security points.<br/><br/>11.
Coordinating with Application owner, Security and Risk teams to resolve the vulnerabilities.<br/><br/>12.
Specialized Data Handling: Managing a very large database (VLDB) may require higher-level skills and additional monitoring and tuning to maintain efficiency.<br/><br/>13.
DC/DR server configuration setup, maintenance, and capacity planning<br/><br/>14.
Setup of Oracle In-Memory Database features.<br/><br/>15.
Configuring DR (Standbys) databases, maintaining data guard / log shipping configurations<br/><br/>16.
migration of Oracle database system from legacy/ old Database<br/><br/>17.
Improving database performance, Index creation, Index Optimization and query tuning tips to the development team.<br/><br/>18.
Experience in designing and managing databases with a strong understanding of database concepts, troubleshooting skills and root cause analysis.<br/><br/>19.
Experience in handling architectural and design considerations such as performance, scalability and availability.<br/><br/>20.
Strong knowledge of High Availability architecture using Oracle DataGuard/FSFO, Load balancer / Net Scaler configurations, Application Continuity.<br/><br/>21.
Extensive experience in handling data replication using Oracle Golden Gate and/or SharePlex with hands on experience in deploying Active active Setups, Conflict Detection, Log Dump analysis, etc.<br/><br/>22.
Strong understanding of Oracle Internals and Performance Tuning fundamentals, including SQL Execution plans, wait events, Performance debugging features/tools, etc.<br/><br/>23.
Strong exposure in Oracle RAC, ASM and Storage/Networking.<br/><br/>24.
Strong knowledge of Linux/Unix Internals, Systems/Application Design & Architecture.<br/><br/>25.
Expertise in working with major cloud providers (AWS, GCP, etc.) and Cloud APIs.<br/><br/>26.
Good hands on experience in automation/scripting using Shell/Python/Go.<br/><br/>Mandatory Technical Skills :<br/><br/>1.
Must have experience with Azure Cloud Infrastructure.<br/><br/>2.
Experience in End to End Database Migration from On-Prem to Cloud Infrastructure including Virtual Network Design, routing rules, security groups, Instance creation, and database deployment.<br/><br/>3.
Oracle DB Architecture experience in Oracle 19c,18c &12c .<br/><br/>4.
Experience in implementing multi-tenant architectures.<br/><br/>5.
Experience/Exposure in Oracle Enterprise Manager, RMAN, Data guard and Real Application Cluster (RAC)<br/><br/>6.
Experience in Installation, Cloning, Maintenance/Support of Production and Development Environment.<br/><br/>7.
Oracle DBA should have experience on 19c,18c &12cupgrade, production support, cross platform migration.</p> (ref:hirist.tech)
Required Skill Profession
Computer Occupations