Kiran V

Senior Data Engineering and SQL Server professional with 15+ years of experience spanning Microsoft Azure, SQL Server development and administration, ETL/ELT, data-platform migration, database performance engineering, BI and production support. Strong hands-on exposure to Azure Data Factory, Azure Data Lake, Azure SQL Database, Azure Databricks, Power BI, Terraform and enterprise database operations. Experienced in designing complex SQL solutions, optimizing workloads, implementing DR/HA capabilities, supporting migrations and operating large SQL Server estates.

Modernizing the profile with applied AI/GenAI knowledge, including Claude and AI-assisted engineering.

Senior SQL Server Developer & Data Engineer at Tata Consultancy Services (TCS) (2010-08 – Present)

• Lead data engineering and SQL Server development activities across Azure data-platform environments, supporting ETL, database engineering, reporting and production operations.
• Develop and support end-to-end ETL pipelines using Azure Data Factory; work with Azure SQL Database, Azure Data Lake and Azure Databricks for data processing and analytics.
• Design, develop and optimize complex T-SQL/SQL solutions, stored procedures, functions, triggers, partitioned tables and indexes to improve application and data-processing performance.
• Support database migration, version upgrades, disaster recovery, backup/recovery, replication, Always On, failover and security/hardening activities.
• Manage and support 30+ SQL Server environments with database sizes ranging from approximately 25 GB to 2.5 TB; perform monitoring, tuning, patching and incident/change support.
• Partner with application and reporting teams to deliver BI solutions using Power BI and SSRS, and to troubleshoot data, connectivity and production issues.
• Develop and maintain full lifecycle ETL pipelines using Azure Data Factory.
• Work with Azure SQL Database, Azure Data Lake, Azure Databricks, Azure SQL DW, HDInsight and related Azure data-platform services.
• Design data-processing and reporting solutions that integrate SQL, ETL and BI components.
• Support migration of on-premises SQL Server workloads to Azure IaaS/PaaS environments.
• Use Terraform for Infrastructure as Code and Dynatrace/Datadog for monitoring and operational visibility.
• Develop SSIS packages and SSRS reports and support enterprise BI requirements.
• Lead creation and maintenance of databases across development, test and production environments.
• Perform backup/recovery, disk-space management, DR drills, patch management, version upgrades and server decommissioning.
• Configure and maintain clustering, replication, Always On, failover and other high-availability/disaster-recovery capabilities.
• Review SQL Server and Windows event logs, backup status, incidents and change requests against SLA expectations.
• Improve query response time through execution-plan analysis, indexing, partitioning and SQL tuning.
• Handle database migration issues including mapping logins, users and jobs to target environments.
• Apply security controls including permissions, encryption, master keys/certificates and SQL hardening.
• Create procedures, functions, triggers, packages, materialized views, table functions, cursors and dynamic SQL solutions.
• Create partitioned tables and indexes and optimize SQL/PLSQL by analyzing execution plans.
• Develop data-loading, error-handling and logging routines and integrate procedures into ETL processes.
• Use Oracle utilities and facilities including SQL*Loader, SQL*Plus and Import/Export where required.

SQL Developer at APOnline Pvt. Ltd. / TCS Retainer (2006 – 2010)

• SQL Developer / Database Engineer supporting SQL Server environments, ETL development, database objects, performance tuning and application data requirements.
• Developed PL/SQL packages, procedures, functions, triggers, materialized views and data-loading/error-handling routines; optimized SQL using execution plans and tuning techniques.

B.Tech in Computer Science & Information Technology – JNTU University (2006)