Senior Database Architect & Data Modeler

• Lead the design and evolution of conceptual, logical, and physical enterprise data models aligned with business, operational, and integration requirements.
• Define entities, relationships, identifiers, constraints, reference structures, integrity rules, history, and lifecycle requirements within enterprise databases.
• Review and govern database schemas and data-model changes to ensure consistency, scalability, maintainability, and alignment with application architecture.
• Define data-architecture standards, modeling conventions, naming rules, data dictionaries, and structural documentation for enterprise systems.
• Support integration architecture through source-to-target mapping, schema alignment, data transformation requirements, and cross-system data-model reconciliation.
• Coordinate with application, database operations, integration, and data teams to ensure consistent implementation of approved data architecture and models.

Qualifications:-

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
• 10+ years of experience in database design, architecture, and data modeling.
• Proven experience as a Database Architect, Data Modeler, or Senior DBA in large-scale enterprise environments.
• Strong expertise in relational database platforms (e.g., Oracle, SQL Server, PostgreSQL, MySQL).
• Hands-on experience with data modeling tools (e.g., ERwin, ER/Studio, PowerDesigner, or similar).
• Solid understanding of dimensional modeling, star/snowflake schemas, and data warehouse design.
• Experience with NoSQL databases (e.g., MongoDB, Cassandra) and modern data lake/data lakehouse architectures is a plus.
• Strong knowledge of SQL performance tuning, indexing strategies, and query optimization.
• Familiarity with data governance, data quality, and master/reference data management principles.
• Knowledge of cloud data platforms (AWS, Azure, or GCP) is an advantage.
• Excellent analytical, problem-solving, and communication skills, with the ability to present technical concepts to both technical and business stakeholders.
• Relevant certifications (e.g., Oracle Certified Architect, Microsoft Certified: Azure Database Administrator, or equivalent) are a plus.