Interesting Job Opportunity: Oracle Database Administrator/Architect

Job Description
• Installation, Administration, Configuration, Hardening, Troubleshooting issues of Oracle database on windows and Non-Windows Operating Systems.
• Monitor the Database health and ensuring Availability of the database.
• Installation, Configuration, Patching and up gradation of Oracle database in Windows and Non-Windows servers.
• Implementing TDE, Data Redaction, Channel Encryption and Integrity Checksum, DB Vaulting, Key store management etc.
• Database Architecture and Design.
• Database Performance Tuning and Query Tuning.
• Day to day database operations support, backup restoration testing and monitoring.
• Setup and maintain Oracle RAC, Golden Gate, Oracle Data Guard, and DG Broker.
• Integrate the database with Oracle OEM or any other monitoring tools as specified by Bank on time to time.
• Provide Inputs/Evidence for Database Review, Security Review and closure of database related audit and security points.
• Coordinating with Application owner, Security and Risk teams to resolve the vulnerabilities.
• Specialized Data Handling: Managing a very large database (VLDB) may require higher-level skills and additional monitoring and tuning to maintain efficiency.
• DC/DR server configuration setup, maintenance, and capacity planning
• Setup of Oracle In-Memory Database features.
• Configuring DR (Standbys) databases, maintaining data guard / log shipping configurations
• migration of Oracle database system from legacy/ old Database
• Improving database performance, Index creation, Index Optimization and query tuning tips to the development team.
• Experience in designing and managing databases with a strong understanding of database concepts, troubleshooting skills and root cause analysis.
• Experience in handling architectural and design considerations such as performance, scalability and availability.
• Strong knowledge of High Availability architecture using Oracle DataGuard/FSFO, Load balancer / Net Scaler configurations, Application Continuity.
• 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.
• Strong understanding of Oracle Internals and Performance Tuning fundamentals, including SQL Execution plans, wait events, Performance debugging features/tools, etc.
• Strong exposure in Oracle RAC, ASM and Storage/Networking.
• Strong knowledge of Linux/Unix Internals, Systems/Application Design Architecture.
• Expertise in working with major cloud providers (AWS, GCP, etc.) and Cloud APIs.
• Good hands on experience in automation/scripting using Shell/Python/Go.

Mandatory Technical Skills
• Must have experience with Azure Cloud Infrastructure.
• 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.
• Oracle DB Architecture experience in Oracle 1+c,18c 12c .
• Experience in implementing multi-tenant architectures.
• Experience/Exposure in Oracle Enterprise Manager, RMAN, Data guard and Real Application Cluster (RAC)
• Experience in Installation, Cloning, Maintenance/Support of Production and Development Environment.
• Oracle DBA should have experience on 1+c,18c 12cupgrade, production support, cross platform migration.

(ref:hirist.tech) Read more