Durga Devalla Email & Phone Number

Greater Seattle Area

Prepared capacity and architecture plan to create the Azure Cloud environment to host migrated IaaS VMs and PaaS role instances for refactored applications and databases.Expert with Azure Automation [ PowerShell, ARM Templates, Terraform].Designed and configured Azure Virtual Networks (VNET’s), subnets, Azure network settings, DHCP address blocks, DNS settings, security policies and routing.Deploying Azure AD Connect and configure between On-premises active directory to Azure Active Directory. Azure Active Directory B2C and B2B setup and managementMigrate on-premises Web & SQL Server to Azure Cloud.Create Azure VM Templates (Azure Golden Images) after customization for Web & SQL Deploy VNET, Subnet, and NSG and provide security guidelinesAutomate the Azure infrastructure deployment through terraform & ARM templates.Setting up Azure Log analytics for all the azure components (App insights, Web Apps, VM’s & VM scale set and VNET, etc), create monitor dashboard, alerts & metricsSetting up HA & DR for web Servers and Azure SQL DatabaseConfigure Always-on SQL Cluster between on-premises SQL Servers & Azure VM & provide excellent RPO & RTO.Azure Cost Analysis and provide recommendations about resizing VM’s, SQL, storage account & disks, etc. Deploying traffic manager for end points for Web Apps. Configure Azure Site recovery for Web Servers. Deploying Azure policies for location & tags etc.

Greater Seattle Area

Design solution for various system components using Microsoft AzureDelivering cloud based solutions and migrating data from On-premises to Azure SQL DB.Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings, DHCP address blocks, DNS settings, and security policies and routing.Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer.Setting up Azure Data Synch between On-premises and AzureCreation of ARM Templates for Azure VM and it’s configuration.OMS Configuration and alert setup.Onboarding various powershell scripts and modules and creating Runbooks etc.Azure Active Directory and its configurationSQL Server Administration, implementing Always-on Pre-Production and Production environment to On-premises and IaaS.Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime

Greater Seattle Area

Service design engineering for high availability websites & web services (cloud based/hybrid model/data center hosted)Delivering cloud based solutions and implementation of web sites for high traffic and volumeCustomer/End user focused service delivery model based on business goalsPerformance & reliability of web based sites/services to serve high traffic loads- Data Insights and telemetry using service health models for real time and proactive monitoringLive site management and Incident management for a time-based SLA modelCapacity planning and cost optimizations for business goalsAnalysis, Coding, Automation and Scripting.Devised Maintenance & Evaluation of database performance by measuring metrics from Database System to fix and optimize.Highly skilled in n-tier architecture data solutions, resource scaling (On-premises and Azure Infrastructure), Service Health & Efficiency, System Telemetry.Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and securityAnalyzing exceptions to identify root cause on data quality issues raised and liaison with Operations, Finance, Risk and Technology departments to route the issue appropriatelyProject management for larger projectsBuilding process maps and support documentation for Tier1/Tier2 engineers 24x7 on call duties under a DRI model

Greater Seattle Area

Maintaining a strong service delivery model frameworkProviding a design engineering experience and high availability scenarios for SQL server based systemsKeeping High Availability of the Servers as well as its Application Suite with a minimal downtimeInvolved in SQL Server Administration implementing Always on Pre-Production and Production environmentProactive planning and maintenance on mission critical SQL server systems to achieve a high availability environmentSignificant knowledge and experience in data modeling and understanding of different data structures and their benefits and limitations in practical applications.Expert in understanding and deploying Database Best Practices/Methodologies, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.Extensive background in Service Engineering & Operations, Release Engineering, Production Support, Application Programming. Also, Well-versed with DevOps, Supply chain management, Agile, Scrum & ITIL Project models.Providing good engineering guidelines and implementation approach with product teamsTechnical project management around monitoring goals to maintain an industry level 99.7% availabilityIncident Management and Live Site troubleshooting24x7 on call duties under a DRI model

India And Uk

Database Administration for MS SQL Servers, ensuring high availability of SQL server environmentCreating business reports based on SQL server technology for business goalsProcess engineering of work flow and user interaction of IT systems Support and AdministrationNetworking Support/AdministrationProficiency in Logical and physical database design and the development of Stored Procedures, Triggers, Views, User Defined Functions (UDFs) & Data Models.Highly skilled in data and problem analysis through existing TSQL/.Net code. Developed and deployed ETL packages and OLAP Cubes through SQL Server BI Services supporting projects ranging from shorter-term strategic questions from executives, to analysis around the correlation between behavioral activities and outcomes, to longer-term predictive and prescriptive analytical questions.Support and administration of MS Enterprise serversDelivering and maintaining back-office and in-house financial systemsProblem synopsis and resolutionProviding an effective turnaround to critical downtimeLiaising with users on newer systematic processes and documentationVendor liaison in maintaining strong relations with vendors/suppliers for IT solutions delivery24x7 on call duties under a DRI model

Hyderabad Area, India

Involved in Database design and writing complex Stored Procedures, Functions, Views, DTS packages and SQL JobsInvolved in SQL performance testing which involved Selecting and optimizing the Index Selection. Tuning the SQL queriesInvolved in SQL Server Administration implementing the following concepts. SQL Replication, LOG Shipping in DEV / Test / Production environment.Utilizing server tools and in-house monitoring tools to analyze and identify service healthProviding an effective turnaround solution and mitigation around customer facing issuesCommunicating and maintaining a service level to customers and stakeholdersSystematic documentation and troubleshooting documentation for Operations guide and server architectures.Created Packages, Maintenance plans, SQL Jobs for Internal DBA Team Activities.Creation of MIS Reports using Crystal Report and Business Objects.

India

Involved in Design and creation of Database and coding for various stored procedures and TestingConfigured, Upgraded, and documented all MS SQL Server instances that comprise the company's Windows 2000 ServerFacilitated an effective management plan to handle ongoing SQL Server performance monitoring and tuningSynchronized database staging of pre-populated tables by developing a Data Transformation Service (DTS) plan for point-in-time synchronization of table structure and data changesMentored and taught back-end SQL techniques to MS ACCESS programmers who were new to SQL Server database design, SQL programming, tuning, and client server connectivitySynchronized database staging of pre-populated tables by developing a Data Transformation Service (DTS) plan for point-in-time synchronization of table structure and Data changesCreated the environment for LOG SHIPPING, Replication and Additional Server for Scheduled Backup’s and Restoration of the database Periodically through SQL Jobs with the help of SQL SERVER Agent.

Master'S Degree, Computer Science

Bachelor'S Degree, Computer Science