Data Architect-Finance Data

Senior Data Architect – Finance Data & OLTP

Location: Bangalore (Hybrid/Onsite)

Experience: 10+ Years

Role Summary

We are looking for a Data Architect with strong 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