Oracle Database Administrator / Architect

Job Description :

1. Installation, Administration, Configuration, Hardening, Troubleshooting issues of Oracle database on windows and Non-Windows Operating Systems.

2. Monitor the Database health and ensuring Availability of the database.

3. Installation, Configuration, Patching and up gradation of Oracle database in Windows and Non-Windows servers.

4. Implementing TDE, Data Redaction, Channel Encryption and Integrity Checksum, DB Vaulting, Key store management etc.

5. Database Architecture and Design.

6. Database Performance Tuning and Query Tuning.

7. Day to day database operations & support, backup restoration testing and monitoring.

8. Setup and maintain Oracle RAC, Golden Gate, Oracle Data Guard, and DG Broker.

9. Integrate the database with Oracle OEM or any other monitoring tools as specified by Bank on time to time.

10. Provide Inputs / Evidence for Database Review, Security Review and closure of database related audit and security points.

11. Coordinating with Application owner, Security and Risk teams to resolve the vulnerabilities.

12. Specialized Data Handling : Managing a very large database (VLDB) may require higher-level skills and additional monitoring and tuning to maintain efficiency.

13. DC / DR server configuration setup, maintenance, and capacity planning

14. Setup of Oracle In-Memory Database features.

15. Configuring DR (Standbys) databases, maintaining data guard / log shipping configurations

16. migration of Oracle database system from legacy / old Database

17. Improving database performance, Index creation, Index Optimization and query tuning tips to the development team.

18. Experience in designing and managing databases with a strong understanding of database concepts, troubleshooting skills and root cause analysis.

19. Experience in handling architectural and design considerations such as performance, scalability and availability.

20. Strong knowledge of High Availability architecture using Oracle DataGuard / FSFO, Load balancer / Net Scaler configurations, Application Continuity.

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.

22. Strong understanding of Oracle Internals and Performance Tuning fundamentals, including SQL Execution plans, wait events, Performance debugging features / tools, etc.

23. Strong exposure in Oracle RAC, ASM and Storage / Networking.

24. Strong knowledge of Linux / Unix Internals, Systems / Application Design & Architecture.

25. Expertise in working with major cloud providers (AWS, GCP, etc.) and Cloud APIs.

26. Good hands on experience in automation / scripting using Shell / Python / Go.

Mandatory Technical Skills :

1. Must have experience with Azure Cloud Infrastructure.

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.

3. Oracle DB Architecture experience in Oracle 19c,18c &12c .

4. Experience in implementing multi-tenant architectures.

5. Experience / Exposure in Oracle Enterprise Manager, RMAN, Data guard and Real Application Cluster (RAC)

6. Experience in Installation, Cloning, Maintenance / Support of Production and Development Environment.

7. Oracle DBA should have experience on 19c,18c &12cupgrade, production support, cross platform migration.

(ref : hirist.tech)