The Role
Designs, modernizes, and maintains complex relational, dimensional, and NoSQL databases for mission-critical digital platforms. Responsibilities include schema evolution, high availability, indexing, memory and caching optimization, query performance analysis, and execution-plan tuning. The role may also support database sharding, distributed clustering, partitioning, compression, data lake integration, data lineage, quality controls, CDC, and streaming pipelines.
Summary Generated by Built In
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
Skills Required
- 15+ years of industry experience designing, creating, maintaining, and modernizing complex databases for digital platforms.
- Experience designing complex relational OLTP and dimensional OLAP data models across diverse data ecosystems.
- Specialization in a prominent RDBMS such as Oracle or Microsoft SQL Server, and NoSQL databases such as MongoDB.
- Ability to manage version-controlled schema evolution without downtime for high-availability, mission-critical systems.
- Ability to design performance-oriented databases using clustered, non-clustered, and partial indexes, memory buffers, caching layers, and CPU priorities.
- Ability to use database profiling tools, analyze execution plans, and rewrite inefficient queries to eliminate performance bottlenecks.
- Exposure to scaling and load balancing, including database sharding and distributed clustering for high read/write volumes.
- Experience optimizing storage through table partitioning, data compression, and advanced sharding techniques.
- Experience designing architectures that blend data lakes with relational capabilities and integrate databases with big data ecosystems.
- Knowledge of data lineage, data quality controls, change data capture, and streaming pipelines.
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Truviq Systems is a Hyderabad-based technology and IT services company that helps enterprises modernize operations through intelligent automation, AI-driven decisioning, workflow orchestration, and digital transformation. Its capabilities include BPM and Pega consulting, enterprise architecture, software solutions, robotic process automation, DevOps, mobile development, and healthcare workflow automation spanning prior authorization, claims and appeals, and care management for US and European markets.
.jpeg)
