Traffic Manager Database Engineer

MURALI JILLELLAMUDI

London 078******** *********@*****.***

Professional Qualifications:

Microsoft® Certified Solutions Associate: Cloud Platform

MCTS in SQL SERVER 2005 and SQL SERVER 2008

MCSA: SQL Server 2012

Microsoft Certified: Azure Data Engineer Associate (Part-I)

Summary of Skills:

Hands-On practice in defining cloud architecture, design and implementation of large applications, infrastructure and Big Data in Azure Cloud.

Implement CI/CD multistage pipelines using Azure Devops, VSTS, Jenkins, Ansible, Agile, Scrum

Architected and implemented various cloud native solutions using Azure SQL, ADF, Azure Databricks, HDInsight, Kafka Streams, Cosmos DB, ADLS Gen 2, Redis Cache, Data Ware Housing/ Azure Synapse Analytics.

On-Prem Data Platform experience using SQL Server 2016, SSRS, SSIS, SSAS, PowerBI, SQL Profiler, Performance tuning

Develop and Deploy Infrastructure as a Code (IaC), PaaS/SaaS using Terraform/ARM Templates/PowerShell/ Bash Scripts/Python.

Implement highly available and disaster recovery solutions using Azure App Gateway, App Services, WAF, Traffic Manager, Load Balancers, Azure Site Recovery, Azure Backups and Availability Groups/Sets, In compliance with SLA and OLA

Develop and implement monitoring and logging using App Insights, Log Analytics, Azure Monitor, Azure Logic Apps

Performance Monitoring/Tuning and Cost Optimisation.

Security best practices using Azure Security Centre, NSG, Azure Firewall, Azure AD, PIM, MFA, Conditional Access Policies, RBAC.

Microservices and application deployments using Azure Kubernetes Service, docker Containers and APIM using Helm Charts.

Automation using Automation Accounts, maintenance plans, creating Jobs, Alerts

Hands-on experience in Database HA DR High Availability Disaster Recovery techniques like Always On, DB Mirroring, Log Shipping, Replication and Clustering Active - Passive and Active- Active.

Colibri Digital Azure DevOps / Big Data Engineer Nov’20 – Aug 21

Responsible to Design, Architect and implementation/delivery of data engineering services and solutions using Cosmos DB, Azure SQL, ADF, Azure Databricks, ADLS Gen 2 for multiple clients.

Data Platform implementation and automation using Azure Devops, ARM Templates, Terraform and PowerShell.

Producing various terraform modules to create multiple resources in Azure and AWS example Managed Apache Airflow in AWS, Kinesis, EMR, Fargate

Implemented Data Warehouse Development/Engineering using Azure Synapse Analytics.

Tyl By NatWest Cloud Data/ Devops Engineer Nov’18 – Sept’20

Delivered data engineering solutions using Azure SQL, ADF, Databricks, HDInsight.

Designed and implementation of Data Ingestion solution and process for secure bank data

Setting up SQL Managed Instances/ Azure SQL Databases / Azure SQL DW Databases using ARM Templates and Terraform

Implemented CI/CD for infrastructure and applications using Azure Devops.

Setting up and maintenance of ADF, Databricks, Cosmos DB, HDInsight using ARM Templates and Terraform

Designed, Developed and Deployed solutions leading technical migration, data integration and consolidation activities from traditional to cloud data structures using ETL data load scripts, automation, data copy Jobs using PowerShell and Azure Data Factory.

Supporting and Responsible for platform availability, latency, performance, efficiency, change management, monitoring, emergency response, and capacity planning as part of Site Reliability Engineering team.

My role involves deploying and supporting microservices in Azure Kubernetes Service.

Implemented Kafka producer and consumer applications on Kafka cluster setup with help of Zookeeper and knowledge on partition of Kafka messages and setting up the replication factors in Kafka Cluster.

Experience in transporting and processing real-time stream data using Kafka topics, K-SQL (Familiar with storm.)

Implemented OLAP multi-dimensional cube functionality using Azure SQLDW.

Wrote Spark transformations and actions using Spark SQL in Scala and PySpark.

Extensive usage of Cosmos DB for unstructured data handling and Azure Redis Cache for in-memory data store

Maintain and monitoring the HDInsight Clusters, troubleshoot the issues using AMBARI.

Experience with configuring Azure API Management platform, API's, Operations, policies.

ASOS Azure Engineer July’18 To Oct ‘18

Deployed, Configure and Maintain IaaS and PaaS workloads on Azure cloud

Managing day to day activity and Troubleshoot Azure related issues and engage internal teams and vendor for issue resolution

Automate deployment and troubleshoot mechanisms for quick service using Terraform and ARM Templates.

Participating daily in scrums and proposing solutions to technical issues

Hands-on experience in configuring various cloud resources like virtual machines, storage accounts, Azure SQL, Document DB

Supporting and Maintenance Azure Functions and Logic Apps.

Using Power shell to write, debug scripts to automate the processes and do migration of VM, involving copying and creating of VHDS.

Implement CI/CD based application development methodology using tools like Jenkins/TFS/PowerShell.

World Pay Cloud Database Engineer Feb ’17 To June’18

Defined cloud strategy, roadmap and business case for cloud adoption by assessing and analysing on premise applications

Develop PowerShell scripts and ARM templates to automate the provisioning and deployment process.

Implement highly available and disaster recovery solutions in Azure to meet the customer SLA requirements

Perform application and database migrations as necessary to support projects.

“Hands on” database SME who can work in a large enterprise across multiple IT teams and drive results

Automation of Azure Operations including setting up of CI/CD pipelines using VSTS and GitHub, ARM Templates using PowerShell, tools like Jenkins/TFS.

Deployed .Net applications and Java apps using TFS/Teamcity/NuGet for Build/Test and Octopus Deploy for deployment

Deployment of end-to-end cloud solutions utilizing a variety of PaaS/IaaS technologies & supporting middleware/data tier technology stacks such as message queues, web/worker roles, database engines, enterprise search and accompanying monitoring solutions

Supporting Clustering, Mirroring, Always-On, replication and log shipping for both resilience and disaster recovering.

Written various maintenance, monitoring & alerting scripts using T-SQL, PowerShell, SSIS & SSRS

Analysed performance problems and fine-tuning databases for better performance and concurrency (table partitioning, database encryption, compression, query and index optimisations, isolation levels)

Automation for the routine DBA jobs like database backups, consistency checks, handling maintenance jobs, alerts etc. on Production and Pre-production environments.

Migration of SQL Databases in AZURE to Azure SQL/Managed Instances/VM’s.

Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage.

Experience working with SQL Database Migration Wizard, SQLAzure DWH and Azure SQL Database Preview v12.

Bank of England Cloud & Infrastructure Engineer / DBA May ’15 To Nov’ 16

Manage, support, monitor and maintain database technology and infrastructure, adhering to the architectural guidelines and policies in ON-PREMISE and CLOUD.

Install, maintain and upgrade of databases

Proactive and reactive performance tuning and optimisation, analysis, monitoring, troubleshooting and resolution of escalated Level 2 and Level3 issues

Supporting DEV, UAT, PROD environments hosted on Physical and VMWare

Supporting SQL Server BI Stack (SSIS, SSRS, SSAS).

Experience in deploying SQL Databases in AZURE.

Provided cloud computing services in IaaS and various other cloud services

Migrations from On-Prem to Azure Cloud as IaaS and PaaS Services

Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage.

Used SQL Database Migration Wizard, Azure Classic Portal from SQL Server Cloud migrations.

Vodafone SQL Server DBA / Cloud admin July’13 To May’15

Manage, monitor & maintain the core SQL Server infrastructure in the production, pre-production and development environment.

Designing data feeds to include data Integration, import and export of data, development and support of external interfaces; SSIS package implementation, deployment and SQL Server job scheduling.

Creation of SSIS packages to perform a variety of tasks, including data loading and transforming, sending / receiving files to / from FTP/SFTP servers and generating email notifications.

Implementing and monitoring High availability and Disaster recovery strategies including Always On, Database mirroring, Log shipping, and Replication.

Resolving database incidents using Incident management process using remedy / ServiceNow

Updating changes on Production using Change management process.

Assist in application database design, development and support including schema design, database code development and performance tuning.

Migrating and upgrading legacy systems.

2nd and 3rd line Production Support and BAU operations.

SQL Performance tuning and Optimisation

Supporting DEV, UAT environments hosted on Hyper-V

Supporting SQL Server BI Stack (SSIS, SSRS, SSAS)

Previous Experiences:

Company

Role

Period

BT

SQL DBA and SME

Mar’11 To June’13

Fujitsu

DBA

Oct’10 to Mar’11

James Hay

SQL DBA and SME

May ’10 to Oct’10

Cable and Wireless

SQL Server DBA

Sep’08 To May’10

KPMG

SQL Server DBA

Oct’07 To Sep’08

Vertex

SQL Server DBA

Sep’00 To Sep’07

Contact this candidate