15+ Years of industry experience in
designing, creating, maintaining and modernization of complex databases for
digital platforms.

Requirements

Must Have:

- Experience in designing complex relational (OLTP) &
dimensional (OLAP) data models across diverse data ecosystems

- Specialization in one of the prominent RDBMS (Oracle, Microsoft
SQL Server etc.) & NoSQL(Mongo DB)

- Manage version -controlled schema evolutions without causing
downtime, to support high availability for mission critical systems like
corporate payment channels

- Ability to conceive and design performance oriented databases
using clustered, non -clustered, and partial indexes, in addition to
knowledge of configuring memory buffers, caching layers, and CPU
priorities for maximum throughput.

- Ability to use database profiling tools to analyze execution




plans and rewrite inefficient queries to remove performance bottlenecks.


Nice to Have(May become required in
long -term):

- Scaling & Load Balance implementation exposure with
knowledge of database sharding and distributed clustering to handle
massive read/write volumes.

- Optimize storage using DB techniques such as table
partitioning, data compression, and advanced sharding techniques

- Experience/knowledge of designing up-to-date architectures blending
data lakes with relational capabilities and integrating database systems
with big data ecosystems

- Implementation knowledge of data lineage, data quality
controls, CDC & streaming pipelines will be an added advantage

​