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