Database Architect

The Database Architect is responsible for designing, implementing, and optimizing enterprise data platforms that support high-performance transactional, analytical, and real-time workloads. This role ensures the scalability, reliability, security, and efficiency of databases across the organization while guiding engineering teams on best practices in data modeling, storage technology selection, and performance tuning.

Experience- 9 to 14 years

Responsibilities

• Database Architecture & Design

  with MS SQL, PostgreSQL and Clickhouse.
• Design scalable, secure, and highly available database architectures for OLTP, OLAP, and hybrid workloads.
• Develop logical and physical data models, ER diagrams, and schema standards aligned with business and application requirements.
• Define indexing, partitioning, clustering, and storage strategies to support performance and scalability goals.
• Establish standards for naming conventions, data normalization, and modeling best practices.

• Evaluate and recommend appropriate database technologies such as MS SQL Server, PostgreSQL, ClickHouse, and cloud-native databases.

• Define strategies when multiple database paradigms are required (RDBMS, NoSQL, columnar stores).

• Lead proof-of-concepts (POCs) to validate performance, cost, and operational efficiency.

• Analyze and optimize complex SQL queries, stored procedures, and database workloads using tools like execution plan analysis, statistics tuning, and index refactoring.

• Implement performance monitoring processes and proactively resolve bottlenecks, deadlocks, and resource contention.
• Define caching strategies and leverage in-memory features to improve read/write performance.
• Ensure data security through role-based access, encryption, auditing, and compliance with internal and regulatory requirements.
• Establish data governance standards, data retention policies, and backup/restore strategies.
• Design Disaster Recovery (DR) and high-availability architectures (Always On, replication, clustering, etc.).