Data Platform Engineer (SQL Server DBA & Data Architect)

Employment Type

Full-Time

Location - Noida

Job Summary

We are seeking an experienced Data Platform Engineer to design, build, administer, and optimize the organization's enterprise data platform. This role combines SQL Server Database Administration, Data Architecture, and Data Engineering to deliver a secure, scalable, high-performance data ecosystem that supports business operations, analytics, and AI initiatives.

The successful candidate will lead SQL Server consolidation and migration projects, design enterprise data architectures, develop modern data warehouses, build automated ETL/ELT pipelines, and support Microsoft Power BI and Microsoft Fabric implementations.

Key ResponsibilitiesSQL Server Database Administration

Install, configure, upgrade, and maintain Microsoft SQL Server environments.

Monitor database performance, availability, and security.

Design and implement backup, recovery, and disaster recovery strategies.

Configure High Availability (Always On Availability Groups, Failover Clustering, Log Shipping, Replication).

Optimize SQL queries, indexes, stored procedures, and database performance.

Manage SQL Agent Jobs, Maintenance Plans, Linked Servers, and database security.

Perform capacity planning and storage optimization.

Monitor database health and resolve production issues.

Implement database security, auditing, and compliance controls.

Database Consolidation & Migration

Assess existing SQL Server environments.

Lead migration and consolidation of multiple SQL Server instances into optimized enterprise platforms.

Develop migration strategies, cutover plans, rollback plans, and validation procedures.

Migrate databases, logins, SQL Agent jobs, linked servers, SSIS packages, and security configurations.

Minimize downtime during migration activities.

Produce migration documentation and technical reports.

Data Architecture

Design conceptual, logical, and physical data models.

Define enterprise data architecture standards.

Design scalable data warehouse and data lake solutions.

Develop Master Data Management (MDM) strategies.

Define data governance, metadata, and data quality standards.

Establish data lifecycle, archival, and retention policies.

Ensure data security and regulatory compliance.

Design hybrid cloud and on-premises data architectures.

Data Engineering

Develop ETL/ELT pipelines using SQL Server Integration Services (SSIS), Azure Data Factory,



or Microsoft Fabric.

Build automated data integration pipelines from ERP, CRM, WMS, POS, APIs, and external systems.

Design and maintain enterprise data warehouses and data marts.

Implement data transformation, cleansing, and validation processes.

Develop reusable data ingestion and processing frameworks.

Optimize data processing performance.

Support real-time and batch data integration requirements.

Business Intelligence & Analytics

Build optimized datasets for Power BI.

Design semantic models and reporting structures.

Optimize Power BI refresh performance.

Support dashboard developers and business analysts.

Develop enterprise KPI data models.

Ensure high-quality reporting datasets.

Microsoft Fabric & Azure

Design and implement contemporary Microsoft data platforms.

Work with Microsoft Fabric Data Factory, Lakehouse, Warehouse, and Real-Time Intelligence.

Configure Azure SQL Database and Azure SQL Managed Instance.

Integrate on-premises SQL Server with Microsoft Azure services.

Support cloud migration initiatives.

Performance Optimization

Monitor database and query performance.

Tune indexes, execution plans, and resource utilization.

Optimize ETL execution times.

Improve reporting performance.

Conduct capacity planning and infrastructure optimization.

Documentation & Standards

Create architecture diagrams.

Maintain database documentation and data dictionaries.

Document ETL processes and technical standards.

Develop operational procedures and best practices.

Maintain disaster recovery and migration documentation.

Collaboration

Work closely with Product Managers, Business Analysts, Developers, Infrastructure Engineers, and BI teams.

Participate in solution design workshops.

Support production deployments.

Mentor junior database administrators and data engineers.

Technical SkillsDatabases

Microsoft SQL Server (2016/2019/2022)

Azure SQL Database

Azure SQL Managed Instance

PostgreSQL (Preferred)

MySQL (Preferred)

SQL Technologies

T-SQL

SQL Server Management Studio (SSMS)

SQL Server Agent

SQL Profiler

Extended Events





Database Migration Assistant (DMA)

Data Engineering

SSIS

Azure Data Factory

Microsoft Fabric Data Factory

ETL / ELT Development

Data Warehousing

Data Lakes

Data Marts

Business Intelligence

Power BI

DAX

Power Query

SSRS

Cloud

Microsoft Azure

Microsoft Fabric

Azure Storage

Azure Synapse Analytics

Programming

SQL

Python (Preferred)

PowerShell

Git

DevOps & Tools

Azure DevOps

Visual Studio

Jira

Required Experience

5+ years of experience in Microsoft SQL Server Administration.

3+ years of experience in Data Engineering.

3+ years of experience in Data Architecture.

Proven experience with SQL Server consolidation and migration projects.

Experience designing enterprise data warehouses.

Experience supporting Microsoft Power BI environments.

Experience with Microsoft Fabric and Azure data services is highly desirable.

Education

Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.

Preferred Certifications

Microsoft Certified: Azure Database Administrator Associate

Microsoft Certified: Azure Data Engineer Associate

Microsoft Certified: Fabric Analytics Engineer Associate

Microsoft Certified: Azure Solutions Architect Expert

Core Competencies

SQL Server Administration

Enterprise Data Architecture

Data Engineering

Database Performance Tuning

Data Modelling

ETL/ELT Development

Data Warehousing

High Availability & Disaster Recovery

Database Security

Problem Solving

Analytical Thinking

Communication & Stakeholder Management

Technical Documentation

Team Collaboration

Key Deliverables

Secure and highly available SQL Server environment.

Successful migration and consolidation of SQL Server instances.

Enterprise data architecture and standards.

High-performance data warehouse and data platform.

Automated ETL/ELT pipelines.

Optimized Power BI datasets and reporting models.

Microsoft Fabric-ready data platform.

Database monitoring and maintenance framework.

Disaster recovery and backup strategy.

Comprehensive technical and operational documentation.

This profile is well suited for organizations that want a single senior owner of the Microsoft data platform, covering database administration, architecture, data engineering, and analytics enablement. It also aligns well with projects involving SQL Server consolidation, Power BI, and future adoption of Microsoft Fabric.

📌 Data Platform Engineer (SQL Server DBA & Data Architect) (Noida)
🏢 Growz
📍 Noida