Title: Senior Database Architect

Location: Pune

Exp: 8-15 Years

Job Description:
Key Responsibilities

Database Architecture & Design
- Design scalable, resilient, and high-performance database architectures for enterprise applications.
- Define database standards, best practices, and governance frameworks.
- Create logical and physical data models aligned with business and application requirements.
- Design effective database schemas, tables, relationships, indexes, constraints, views, and stored procedures.
- Establish database partitioning, sharding, and archival strategies where required.
- Ensure database solutions support scalability, maintainability, and future growth.

Database Migration & Modernization
- Lead end-to-end database migration initiatives.
- Assess legacy database environments and define migration strategies.
- Perform database migrations, including:
- Legacy databases to PostgreSQL
- Legacy databases to Microsoft SQL Server
- Microsoft SQL Server to PostgreSQL
- On-Premise to Cloud
- Cloud to Cloud




- Define migration approaches covering schema migration, data migration, validation, reconciliation, rollback planning, and cutover execution.
- Ensure data integrity, consistency, and minimal business disruption during migration activities.
- Develop migration automation frameworks and scripts where applicable.

Database Performance Engineering
- Analyze and optimize database performance.
- Identify and resolve performance bottlenecks.
- Tune queries, stored procedures, functions, execution plans, and indexing strategies.
- Conduct database health checks and performance assessments.
- Define and monitor database KPIs and SLAs.
- Support production performance troubleshooting and issue resolution.

PostgreSQL & Microsoft SQL Server Administration
- Design, implement, and support enterprise-grade PostgreSQL and Microsoft SQL Server environments.
- Configure replication, clustering, backup & recovery, failover strategies, and disaster recovery solut

📌 Senior Database Architect (Pune)
🏢 NR Consulting
📍 Pune