Shimento, Inc.
Website:
shimento.com
Job details:
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
Click on Apply to know more.
