Data Architect Sql Server

Laxmana Rao Golconda

Email : *********.*@*****.***

Mobile : 943-***-****

SUMMARY

Seasoned Tech Lead / Data Architect with over 18 years of experience in the IT industry, specializing in data engineering, cloud data platforms, and enterprise-scale architecture.

Expert in Snowflake data warehouse development on Azure and AWS platforms.

Proficient in DBT, Apache Airflow, and orchestration of modern data pipelines.

Over 15 years of hands-on experience with SQL Server and PostgreSQL in both development and administration roles, including database design, performance tuning, and ETL processes.

Adept at writing complex SQL queries, optimizing performance, and automating deployments using PowerShell, Python, and Jenkins.

Strong working knowledge of Spark, PySpark, Kubernetes, Pandas, NumPy, and Power BI.

Deep understanding of data lifecycle management and usage across large-scale business environments.

Proven ability to design and implement scalable, reusable, and interoperable data models that support enterprise-wide analytics.

Experienced in conducting stakeholder workshops to gather requirements and lead technical design discussions.

Successfully led and executed large-scale migrations, including 18 TB of critical data to AWS S3.

Managed cross-regional teams (AMER, EMEA, APAC) and ensured seamless coordination across delivery cycles.

Known for resolving complex production issues, maintaining database performance, and leading CI/CD implementations for cloud-based data platforms.

Certifications:

Microsoft Certified: Microsoft Azure Fundamentals AZ-900 (2023)

Work Experience Details

State Street, USA March 2021 – May 2025

Role: Tech Lead / Snowflake Architect

Key Responsibilities:

Designed and implemented ingestion framework to migrate data from Azure ADLS to Snowflake using Snowpipe, Streams, and Tasks.

Developed Python services to process multi-tab Excel files triggered via Azure Event Grid.

Built a rules engine framework enabling customizable client-specific business logic for Data Marts.

Engineered various DBT models, macros, and pre-hooks for optimized data mart consumption in Snowflake.

Reduced Snowflake credit usage through efficient DBT workflow design.

Established secure data shares to facilitate consumption reporting for ADP team.

Delivered consumer-facing APIs for third-party data delivery.

Automated report generation workflows; implemented UDFs and stored procedures for complex logic.

Applied CI/CD methodologies (SchemaChange, GitHub, Jenkins) for seamless deployments.

Coordinated source-to-target mappings with source system teams.

Performed SQL tuning and optimization using Snowflake Query Profiles.

Collaborated closely with Scrum Masters, Data Modeling, QA, and DevOps teams to ensure timely data integration delivery.

Technologies: Snowflake, Azure Event Hub, Event Grid, ADLS, Blob Storage, Cosmos DB, DBT, Python, GitHub, Kubernetes, RTC, Jenkins, JIRA

Thomson Reuters, Hyderabad April 2012 – March 2021

Designation: Lead Database Engineer

Key Responsibilities:

Led multiple database design and migration initiatives, including On-Prem to AWS.

Configured HA/DR for AWS EC2 and RDS environments across AMER, EMEA, and APAC.

Created and managed DMS tasks, CloudWatch alerts, and full SQL Server stack (SSIS, SSRS).

Enabled Unicode support and collation adjustments; implemented TDE and DR strategies.

Deployed scripts using PowerShell and Python; automated object deployments across environments.

Piloted PostgreSQL and MongoDB initiatives.

Key Projects:

AWS Migration: Migrated 15,000+ databases and 10TB of file shares using Robocopy and scheduled tasks.

ONESOURCE Workflow Manager: Streamlined tax processes through SQL Server-based design and automation.

Technologies: SQL Server (2005–2016), AWS (EC2, RDS, HA&DR(Patter 3), Route 53, NLB ), FSx, PowerShell, Python

GENPACT, Hyderabad Aug 2011 – March 2012

Designation: Consultant (Lead Role)

Organization: Infinite Computer Solutions (at GENPACT)

Duration: Jan 2007 – Aug 2011

Designation: Team Lead

Key Projects:

ProfIT: Designed modules including OMS, Pricing, Contract Management, and Billing in SQL Server.

OMS: Handled revenue projection and pricing system development.

RecruIT: Automated the recruitment process, including CV tracking and interview workflows.

Responsibilities:

Requirement gathering and implementation.

Designed and maintained SQL/T-SQL code, Stored Procedures, Views, and DTS packages.

Technologies: SQL Server 2000/2005, SSIS, SSRS, ASP 3.0

Education

B.E. in Mechanical Engineering (Production Specialization), First Class CBIT, Osmania University, Hyderabad.

Skills

Cloud Computing: Azure Data Factory, Azure Databricks, Azure Blob Storage, Azure Data Lake, Azure DevOps

Big Data Technologies: Hadoop, HDFS, Hive, Spark

Programming and Scripting: Python (Advanced), Scala (Intermediate), SQL (Expert), PowerShell (Intermediate)

Data Modelling & ETL Tools: SSIS, SSRS, SQL Server Data Tools

RDBM Technologies: Microsoft SQL Server

NoSQL Technologies: PostgreSQL

Cloud Platforms: AWS, Azure

Trainings & Workshops Attended

Big Data (Hadoop) Fundamentals

Project Management and Leadership

Team Building & Conflict Resolution

Client Negotiation & Stakeholder Management

Assertive Communication & Feedback Skills

Mentoring and Coaching for Team Development

Other Achievements & Strengths

Conducts regular training sessions on:

Database Concepts

Data Modelling

Query Optimization Techniques

Performance Tuning Best Practices

Contact this candidate