Afroze Mohammed

Senior Data Engineer and Data Platform professional with 18+ years of experience designing, building, optimizing, and supporting enterprise data pipelines, database platforms, ETL workflows, reporting solutions, and production data services. Hands-on expertise in SQL, T-SQL, Python, SSIS, Databricks, Microsoft SQL Server, Azure SQL Managed Instance, AWS data services, data modeling, transformation, data quality, performance tuning, and production troubleshooting. Proven record managing a 120+ database environment, improving key workload execution time by up to 50%, and leading a zero-unplanned-downtime migration of 30+ databases to Azure SQL Managed Instance.

Brings strong ownership of reliable, scalable data delivery; data architecture documentation; technical standards; code reviews; and cross-functional partnership with engineering, analytics, product, and business teams.

Independent Database Consultant at SCALE for TARS, LLC (2025-12 – Present)

• Lead data-engineering and database-platform consulting across concurrent client engagements, delivering pipeline and integration improvements, SQL optimization, schema design, data transformation, and production-reliability initiatives.
• Partner with engineering, analytics, product, and business stakeholders to define data requirements and deliver scalable, maintainable data solutions.
• Own end-to-end delivery from requirements analysis and solution design through implementation, validation, documentation, troubleshooting, and production support.
• Develop SQL, Python, and PowerShell solutions to automate validation, operational work, data-quality checks, and recurring troubleshooting activities.
• Assess solution options and support proof-of-concept efforts for data-platform, integration, and reporting needs.

Senior SQL Server Database Administrator / Data Engineer at Heidelberg Materials US, Inc. (2016-03 – 2025-04)

• Owned and supported a multi-server enterprise data platform spanning 120+ databases across Development, QA, UAT, and Production, powering critical applications, reporting workloads, analytics, and operational data services.
• Designed SSIS package and pipeline architectures for enterprise data ingestion, transformation, integration, data movement, and reporting needs.
• Worked with Databricks environments to support scalable data-processing, transformation, data-quality validation, integration, and downstream reporting workloads.
• Developed and optimized SQL/T-SQL database objects—including tables, indexes, views, stored procedures, functions, and triggers—to support transactional applications, ETL workflows, reporting, and downstream consumers.
• Supported Oracle-sourced data integration pipelines and SQL Server ETL processes; investigated data-access, data-movement, and data-quality issues across source and target systems.
• Led migration of 30+ on-premises SQL Server databases to Azure SQL Managed Instance, completing compatibility assessment, testing, production cutover, and post-migration validation with zero unplanned downtime.
• Improved key workload execution times by up to 50% through execution-plan analysis, Query Store, DMVs, wait statistics, Extended Events, targeted indexing, and SQL/T-SQL optimization.
• Used Python and PowerShell scripting to support data validation, database/data-platform automation, monitoring, troubleshooting, and recurring operational tasks.
• Supported AWS-based data and database environments using Amazon S3 and RDS for data storage, database operations, integration, access management, monitoring, and backup support.
• Monitored pipeline and database health using SolarWinds DPA, CloudWatch, Query Store, DMVs, Extended Events, SQL Server Profiler, and operational analysis; mitigated production issues and implemented root-cause remediation.
• Created data-flow diagrams, source-to-target mappings, ETL specifications, data dictionaries, SOPs, runbooks, and technical documentation to support reliable delivery and stakeholder understanding.
• Partnered with application engineers, analysts, and business teams to improve data reliability, interpretability, and availability for analytical and operational needs.
• Mentored junior DBAs, developers, analysts, and data engineers; participated in design and code reviews and established practical data and database standards.
• Built and maintained 15+ Tableau dashboards and reporting workflows over three years, enabling self-service reporting for finance, operations, and executives while reducing ad hoc reporting requests by 30%.

Senior SQL Server DBA at Data Transformation Corporation (2007-08 – 2015-07)

• Administered enterprise SQL Server environments supporting high-volume production applications, reporting platforms, SSIS ETL workflows, and data-warehouse workloads.
• Developed and supported SQL-based data-processing and reporting solutions; diagnosed job, integration, and data-processing failures and improved reliability for operational and management users.
• Improved long-running query performance by approximately 35% through execution-plan analysis, indexing improvements, T-SQL optimization, and resolution of blocking and deadlock issues.
• Managed SQL Server Agent jobs, backups, alerts, integrity checks, and maintenance plans to provide proactive platform and job-health management.
• Coordinated upgrades and infrastructure refreshes, validating changes in lower environments to reduce production risk and support controlled deployments.
• Documented standard procedures and recurring issue resolutions, improving knowledge sharing and operational consistency.

Master of Science in Computer Science – City University of New York

Bachelor of Engineering in Electronics – Osmania University