Senior Data Architect – Finance Data & OLTP

? Location: Bangalore (Hybrid/Onsite)

? Experience: 10+ Years

Role Summary

We are looking for a Data Architect with solid hands-on experience in Finance Data and OLTP systems . The ideal candidate should have personally designed and owned the transactional write-path database architecture behind a live, high-concurrency application .

This is not primarily a Data Warehouse, Analytics, Lakehouse, or ETL architecture role . We are specifically looking for someone who can demonstrate real-world ownership of transactional database design, concurrency, data integrity, auditability, and performance in Finance or other high-volume business applications.

Key Responsibilities

- Design and own OLTP database architecture for high-volume, high-concurrency applications.
- Design normalized relational schemas from scratch , including entities, relationships, constraints, indexes, and transaction boundaries.
- Architect transactional data models supporting Finance processes, financial operations, reporting, reconciliation, or other critical business workflows .
- Design and optimize MySQL, PostgreSQL, or comparable RDBMS solutions for high-throughput transactional workloads.
- Handle row-level concurrency, locking, isolation levels, deadlocks, and transaction management in production systems.
- Design strategies to manage write contention and maintain performance under high concurrent transaction volumes.
- Design audit/history tables and mechanisms to maintain traceability of transactional changes.
- Define database architecture patterns for scalability, availability, consistency, and data integrity.
- Work closely with application architects and engineering teams to ensure the database architecture supports the application's transactional write path .
- Identify and resolve database performance bottlenecks through indexing,



query optimization, partitioning, schema optimization, and appropriate database design patterns.
- Establish data architecture standards covering data integrity, governance, security, lifecycle, and auditability .
- Provide technical leadership in database architecture decisions and mentor engineering/data teams.

Mandatory Technical Skills

- 10+ years of experience in Data Architecture / Database Architecture / Data Engineering with strong architecture ownership.
- Strong hands-on OLTP / transactional database architecture experience.
- Proven experience designing normalized relational schemas from scratch .
- Strong hands-on experience with MySQL, PostgreSQL, Oracle, or another comparable RDBMS .
- Practical understanding of row-level locking, concurrency control, transaction isolation, deadlocks, and write contention .
- Experience designing audit/history tables for transactional applications.
- Strong understanding of database performance optimization, indexing, query optimization, execution plans, and transaction management.
- Experience designing databases supporting high-concurrency, high-volume production applications .
- Strong understanding of relational data modelling, referential integrity, constraints, transactions, and ACID principles.
- Strong Finance Data / Financial Domain experience is required.

Finance Data Experience Candidates should have experience working with transactional Finance data such as:

- Financial transactions and accounting data
- Payments / settlements
- Reconciliation
- General Ledger / sub-ledger data
- Treasury / liquidity data
- Risk or regulatory reporting data
- Financial operations and transaction processing
- Other high-volume financial applications

#Hiring #SeniorDataArchitect #DataArchitect #DataEngineering #DataArchitecture #ApacheSpark #Hive #MySQL #PostgreSQL #ETL #SQL #DataModeling #FinTech #BangaloreJobs #TechJobsIndia

📌 Data Architect-Finance Data (Bengaluru)
🏢 ShimentoX Technologies
📍 Bengaluru