We are building the platform, which supports various information gathering and processing across the bank. The PMC application, Price Master Central (PMC) is a global reference data management application - responsible for sourcing securities/Pricing data from market vendors and internal sources and providing it to downstream clients after applying client specific rules.

Excellent understanding on Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes, Table statistics using Oracle 19c and 23ai.

Experience in designing, architecting and implement resilient database solutions.

Should be able to help in finding current performance bottlenecks and provide solutions to improve performance

Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions.

Working knowledge of Linux Redhat, File System, Cluster Management(RAC) and Oracle ASM & ACFS.

System analysis and design skill with knowledge of data flow diagrams, data dictionary techniques, case tools, Entity relation Modeling, design Technique etc

Database Design Skill including normalization theory, STAR Schema Design and Data Modeling tool with proven experience of Process, Data flow and forward/reverse engineering of logical/physical RDBMS layout

Experience of working in a team that delivers a high availability service.

Experience with building Database warehouse Solution.

Extensive experience with Database compression and purging techniques.

Experience with MSSQL, mongoDB and postgres will be an added advantage.

Experience in enabling Advance Database compression techniques for better performance and storage savings.

Good understanding and working knowledge on java, spring.

Should be familiar with container technology like K8