Website:
growzd.com
Job details:
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 modern 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.
Click on Apply to know more.
