Azure Data Sql
Resume:
Sravani Gattupalli
*******.****@*****.***
www.linkedin.com/in/sravani-gattupalli-sg-5033a8142/
Professional Summary:
Experienced Azure Data Engineer with a proven track record in designing, implementing, and managing data solutions on Microsoft Azure. Possesses deep expertise in Azure data services including Azure SQL Database, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, and Azure HDInsight. Skilled in building scalable data pipelines, data modeling, ETL processes, and optimizing performance for big data workloads. Adept at collaborating with cross-functional teams to deliver innovative data solutions that drive business insights and decision-making.
Technical Expertise:
Azure Data Services: Azure SQL Database, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Azure HDInsight, Azure Cosmos DB
Data Warehousing: Data Lake Storage, Azure SQL Data Warehouse
ETL Tools: Azure Data Factory
Data Visualization: Power BI, Tableau
Programming Languages: SQL, Python, Scala
DevOps: Azure DevOps, Git, Jira
Cloud Platforms: Microsoft Azure,Kafka
Education:
B. Tech (CS&IT) from JNT University, India.
Accomplishments:
McKinsey Accelerated management program for Asian leadership-2022-April-October
Harvard Business School Online Management Essentials-2022
Az-900 Azure fundamentals Certified.
DP-900 Data fundamentals Certified.
ITIL V3 foundation certificate.
Certified Scrum Master
Professional Work Experience:
NJ DHS state project,(NJ):
DevOps engineer(2024-Jan)
Working DevOps engineer to migrate the legacy Oracle systems to Azure SQL server.
Design, develop, and implement solutions to deploy the applications in the cloud.
Using Terraform to design and deploy infrastructure as code.
Using Azure Kubernetes to deploy the solutions in the cloud.
Designing and implementing CDC to capture the changes in the data.
Azure DevOps to create CI/CD pipeline and plan the release in the dev/uat and prod.
Conducting code reviews before approving Jira and azure devops tasks.
Capacity planning and release planning of applications and database servers.
Creating Azure active directory groups to manage application-level security.
Modeling database and converting legacy Oracle schema to sql server.
Using SSMA for conversion of data.
Using Azure sql studio to connect the Azure sql services.
System design and implementation.
Architect and implement end-to-end data solutions on Azure for batch and real-time data processing, utilizing services such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.
Design and optimize data models and schemas for efficient storage and querying on Azure SQL Database and Azure Synapse Analytics (formerly SQL Data Warehouse).
Develop and deploy scalable ETL pipelines using Azure Data Factory to ingest data from various sources including on-premises databases, cloud storage, and third-party APIs.
Collaborate with data scientists and analysts to operationalize machine learning models and integrate them into data pipelines for predictive analytics.
Implement data security and compliance measures in accordance with industry standards and regulatory requirements, ensuring data privacy and governance.
Conduct performance tuning and optimization of data workflows and queries to improve overall system performance and reduce latency.
Configuring Azure Elastic jobs to manage batch jobs to process data files between vendors
Enlivant, Chicago, IL
Cloud Data Engineer(2017-22023 :
Collecting requirements from the Business owners and business operations leaders.
Assisted in building data pipelines for processing and transforming large datasets using Apache Spark on Azure HDInsight.
Developed scripts and workflows to automate data ingestion and processing tasks, increasing efficiency by 30%.
Conducted data analysis and visualization using Power BI to provide insights into key business metrics and trends.
Contributed to the documentation of data processes, workflows, and best practices for knowledge sharing within the team.
Collaborating with stakeholders and cross-functional teams to plan and prepare the project deliverables.
Modernization of existing applications to cloud servers and Re-Architect, and re-design them based on new cloud solutions.
Migrating legacy DB systems to Azure cloud services.
Refactored and rearchitected legacy cold fusion applications in .net framework 4.5.
Using Azure data factory migrated on-prem Datawarehouse to Azure Datawarehouse.
Migrated Oracle 11.1 version BI dashboards and reports to Power BI Cloud version
Integrated Power BI reports with Microsoft 365 office accounts.
Experience in working with Power BI Desktop, Power BI Service, Power Automate (Flow), PowerVirtualAgents, and Security
Strong experience in developing different Visual Reports, KPIs, and Dashboards using Power BI Desktop.
Using Terraform to orchestrate Infrastructure services in azure.
Data modeling with Snowflake and Erwin tool
Expertise in Power Query to extract data from multiple sources, transform data, and develop the Visuals.
Customize azure services to match the requirements.
Install, configure and maintain applications and services on cloud.
Experience in Optimization of the Power BI data model and visualizations.
Experience in designing Star schemas, and Snowflake schemas for Data Marts and Data Warehouses.
Consolidated different source systems by using ADF-applied ETL/ELT process and created org-level dashboards and reports level dashboards and reports.
Worked on data factory editor to create linked services, tables, data sets, and pipelines by specifying JSON definitions for these artifacts.
Built a solution using Azure-managed services to store simple and Blob storage to archive on-premises data to clouds.
Architecting, designing, and securing elastic storage in Azure: Blob, queue, File, Disk, Azure Backup, Azure Site Recovery (ASR)
Writing stored procedures and building ETL solutions to ingest data into the Datawarehouse server
Architecting and designing Azure Database Solutions: Azure SQL DB, Azure MySQL, SQL Datawarehouse, Cosmos DB, Redis Cache, Data Factory
Azure container services, professional in Docker, Kubernetes
Azure Monitoring and Management solutions: Azure Analytics, Application Insights, Automation, Backup, Site Recovery, Azure Monitor, Automation and Control
Using version control tools like GitHub and Azure DevOps for Continuous Integration and Continuous development (CI/CD)
Used Jira boards and tickets for project management.
Environment: SQL Server 2016,2014, 2012, and 2008, SSIS, SSRS, Power BI, T-SQL, Azure, PowerShell, Python, Terraform,Azure DevOps Engineer, .Net framework, Azure DBA, Service Now, ITSM Framework, Azure data factory, Kfka,cdc
Infosys Technologies, Hyderabad, INDIA
Senior Data Consultant (08/2015 to 05/2017)
Client -British Petroleum
Expertise in Database Administration on Production Servers with server configuration, performance tuning, and maintenance with outstanding troubleshooting capabilities.
Direct experience with global teams and supported L3 incident management teams.
Expertise in T-SQL writing stored procedures, views, triggers, and functions.
Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
Creating SP/functions and triggers and ETL packages to build data warehousing projects.
Used power shell and angular JS to build internal applications to automate the monitoring and shift left the tickets.
Keen analysis of missing/unused indexes and implemented/automated the rebuild online indexes.
Worked extensively on Clustering and server consolidation.
Strong experience in Troubleshooting production issues.
SSRS installation and migration.
Worked on configuring SQL Server with minimum privileged and role-based access.
Managed multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
Quarterly DR Maintenance.
Experience in implementing TDE at the Database level.
Knowledge of the Hadoop framework and Experience in tidal job configurations.
Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
Used Git and Jira for Item management.
Service now is used for production issues tracking.
Secondary DBA support for Oracle Database 12c Release 2
Migrating sql servers AWS
Tech Mahindra, Hyderabad, INDIA
SQL Server DBA (03/2011 to 07/2015) :
Client - Microsoft
Installing SQL Server 2000, 2005, 2008 and 2012.
Upgraded the SQL Servers to 2012 and configured Always-on.
Installed SQL 2012 for Azure environment and configured DB.
Upgrading SQL Server from 2000, 2005 and 2008 to its higher versions.
Configured Transactional replication and management.
Configured Database Mirroring and creating DB snapshots periodically.
Job Monitoring: Monitoring daily scheduled jobs, working on alerts on job failures.
Configuring and monitoring Log-shipping in the production servers.
Managing SQL server security.
Performance Issues: Using SQL profiles and tuning advisor for advice on queries and stored procedures performance.
Using Clustering as DR option.
Backups up and Restore SQL Databases.
Using SQL performance monitor to troubleshoot high IO and CPU utilization issues at SQL server level.
Working with update, insert script to update production data on daily basis to correct the data.
Writing stored procedures which will call jobs to process the user data.
Screening stored procedures to understand the conditions and logic which in return, is used to calculate the benefits to users.
Optimize existing SQL queries to speed up response time, tuning of database parameters, memory & cache.
Monitoring the system performance and alerts using SCOM on daily basis.
Creating linked servers to make the database available to Engineering teams.
Participating in quarterly/yearly maintenance activities on production servers like certificate renewals, password resetting of service accounts etc. database parameters
Highly skilled in creating knowledge bases and mentoring team on technical issues daily.
Wipro Technologies, Hyderabad, INDIA
SQL Server DBA (05/2007 to 07/2009)
Client - Microsoft
Performed SQL Server DBA role with 16x5 support to the SQL Server standalone and cluster environments including Production and UAT servers.
Responsible for installation and configuration of SQL server 2005, 2008 databases on Windows 2003 and 2008 servers.
Implementing stand-by servers and Log shipping.
Based on the business need, all three replication models were created on different applications.
Configuring high availability using DB Mirroring and managing on daily basis.
Backup/Restore the production DBs with scheduled jobs and scripting.
Inserting/Updating production data as part of deployments.
Writing stored procedures and joins to read the data.
Using SQL Profiler to troubleshoot application issues.
Query tuning and performance monitoring.
Troubleshooting blocking and deadlock issues as and when occurs.
Deploying UAT and Production boxes with latest releases.
Updating production and UAT servers with latest service packs and security patches.
Contact this candidate