Job Description:

- As Database Architect you will own the logical and physical database architecture for the RegTech as a Service product
- You will design the canonical data model operational and analytical stores metadata repositories audit and lineage structures and data access patterns required across product modules
- You will work closely with product leadership regulatory SMEs solution architects data engineers backend developers AI ML engineers security DevOps and QA teams to deliver a database foundation that is performant reliable secure explainable and configurable across reports regulations and client deployments

Key Responsibilities:

- Define the end to end database architecture technology choices and design standards for operational analytical metadata audit evidence and AI ready data stores
- Design a reusable report agnostic canonical data model covering regulatory entities customers accounts transactions balances MDRMs schedules controls exceptions approvals and lineage
- Create logical and physical data models schemas keys relationships indexing partitioning retention and archival strategies for high volume regulatory and financial crime workloads
- Architect multi tenant data isolation role based access encryption masking audit logging and jurisdiction aware data residency controls aligned with Secure by Design and Privacy by Design principles
- Define ingestion change data capture API and batch data access patterns for integrating core banking general ledger reporting platforms CRM payment sanctions and external regulatory data sources




- Establish database performance engineering practices including query optimization capacity planning workload management observability backup recovery high availability and disaster recovery
- Design metadata driven configuration for report mappings validation rules thresholds regulatory changes schedule dependencies and source to report lineage
- Lead database design reviews migration planning data quality controls proof of concepts and production readiness assessments while mentoring engineers and maintaining architecture documentation

Technical Requirements:

- Minimum 7 years of experience in database architecture data architecture data engineering or enterprise scale data platform delivery including at least 6 years in an architect or technical leadership role
- Solid hands on expertise in relational database design and advanced SQL preferably PostgreSQL Microsoft SQL Server Oracle or equivalent enterprise RDBMS platforms
- Proven experience designing canonical models normalized and dimensional schemas metadata driven solutions audit stores temporal data and high volume transactional systems
- Strong knowledge of indexing partitioning query optimization concurrency data lifecycle management backup and recovery high availability and disaster recovery
- Experience designing secure cloud database solutions on Azure AWS or GCP including identity encryption secrets network isolation monitoring and cost controls




- Strong understanding of data governance lineage data quality privacy access control PII handling and regulatory grade auditability
- Ability to convert business and regulatory requirements into practical database designs and collaborate effectively with architecture engineering security and functional teams

Additional Responsibilities:

- Experience in banking regulatory reporting AML KYC transaction monitoring risk compliance finance or other data intensive regulated platforms
- Exposure to Azure SQL Azure Database for PostgreSQL Cosmos DB Databricks Snowflake BigQuery cloud data lakes or lakehouse architectures
- Working knowledge of NoSQL graph and vector technologies such as Cosmos DB MongoDB Neo4j pgvector Pinecone Weaviate or Milvus with judgment on when each is appropriate
- Experience with Python PySpark dbt Airflow Kafka schema registries data catalogues CDC tools and automated database deployment using CI CD and infrastructure as code
- Familiarity with MDRM driven regulatory data XBRL XML outputs source to report reconciliation controls evidence AI RAG retrieval patterns and human review workflows

Preferred Skills:

Technology->AI-Generative AI->Generative AI - Basic->open-source models (meta llama 2),Technology->Virtualization->Database Virtualization

Skills: Kafka, Microsoft Sql Server, Backup And Recovery, High Availability, Data Quality, Gcp, Query Optimization, Data Governance, Pyspark, Advanced Sql, Access Control, Indexing, dbt, Privacy, Relational Database Design, Disaster Recovery, Azure, Airflow, Oracle, Aws, Partitioning, Postgresql, Python

Experience: 0.00-0.00 Years

📌 Database Architect –RegTech-as-a-Service Product (Pune)
🏢 Infosys
📍 Pune