DB Architect:
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 modern 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
