Resume

Sign in

Sql Server Service

Location:
Bellevue, Washington, United States
Posted:
January 08, 2018

Contact this candidate

SUBBU

DEVALLA

***** ** **** ****** ******** WA-98007 (H) 425-***-**** (C) 425-***-****

ac3ydi@r.postjobfree.com

https://www.linkedin.com/in/subbu-devalla-36254013/

PROFESSIONAL SUMMARY

Site/Service Reliability Engineering for high traffic web sites and web based services serving Microsoft developer sites under a full DevOps model for agility and service delivery.

SKILLS

Windows Azure Virtualization technologies

SQL Server/SQL Azure IIS and Web servers

CDN technology PowerShell/PowerBI/Crystal Reports

Akamai solutions/implementation Networking technologies and protocols

Project & Vendor Management

WORK HISTORY

OCTOBER 2013-CURRENT

Service Engineer TechStar for Microsoft Corporation Redmond, Washington

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 volume

Customer/End user focused service delivery model based on business goals

Performance & reliability of web based sites/services to serve high traffic loads- Data Insights and telemetry using service health models for real time and proactive monitoring

Live site management and Incident management for a time-based SLA model

Capacity planning and cost optimizations for business goals

Project management for larger projects

Building process maps and support documentation for Tier1/Tier2 engineers 24x7 on call duties under a DRI model

JUNE 2011-OCTOBER 2013

Service Engineer 2 Jean Martin for Microsoft Corporation Redmond, Washington

Maintaining a strong service delivery model framework

Providing a design engineering experience and high availability scenarios for SQL server based systems

Keeping High Availability of the Servers as well as its Application Suite with a minimal downtime

Involved in SQL Server Administration implementing Always on Pre-Production and Production environment

Proactive planning and maintenance on mission critical SQL server systems to achieve a high availability environment

Providing good engineering guidelines and implementation approach with product teams

Technical project management around monitoring goals to maintain an industry level 99.7% availability

Incident Management and Live Site troubleshooting

24x7 on call duties under a DRI model

MARCH 2008-JUNE 2011

Service Engineer Tech Mahindra for Microsoft Corporation Redmond, Washington

Supporting and daily administration of MS SQL servers hosting various microsoft.com sites

Troubleshooting SQL and Windows server systems

Worked on large scale projects around database systems

Utilizing server tools and in-house monitoring tools to analyze and identify service health

Providing an effective turnaround solution and mitigation around customer facing issues

Communicating and maintaining a service level to customers and stakeholders

Systematic documentation and troubleshooting documentation for Operations guide and server architectures.

Working with the Microsoft.com Operations Center Tier 1 and 2 teams on escalations that need to be resolved based on priority levels set by the team.

24x7 on call duties under a DRI model

APRIL 2006-MARCH 2008

Software Engineer WIPRO Technologies Hyderabad, India

Database Administration for MS SQL Servers, ensuring high availability of SQL server environment

Creating business reports based on SQL server technology for business goals

Process engineering of work flow and user interaction of IT systems Support and Administration

Networking Support/Administration

Support and administration of MS Enterprise servers

Delivering and maintaining back-office and in-house financial systems

Problem synopsis and resolution

Providing an effective turnaround to critical downtime

Liaising with users on newer systematic processes and documentation

Vendor liaison in maintaining strong relations with vendors/suppliers for IT solutions delivery

24x7 on call duties under a DRI model

MAY 2005-APRIL 2006

Senior Programmer eRetail Technologies Hyderabad, India

Involved in Database design and writing complex Stored Procedures, Functions, Views, DTS packages and SQL Jobs

Involved in SQL performance testing which involved Selecting and optimizing the Index Selection. Tuning the SQL queries

Involved 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 health

Providing an effective turnaround solution and mitigation around customer facing issues

Communicating and maintaining a service level to customers and stakeholders

Systematic 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.

MAY 2004-MAY 2005

Software Engineer AVIVIE Inc. Hyderabad, India

Involved in Design and creation of Database and coding for various stored procedures and Testing

Configured, Upgraded, and documented all MS SQL Server instances that comprise the company's Windows 2000 Server

Facilitated an effective management plan to handle ongoing SQL Server performance monitoring and tuning

Synchronized database staging of pre-populated tables by developing a Data Transformation Service (DTS) plan for point-in-time synchronization of table structure and data changes

Mentored and taught back-end SQL techniques to MS ACCESS programmers who were new to SQL Server database design, SQL programming, tuning, and client server connectivity

Synchronized database staging of pre-populated tables by developing a Data Transformation Service (DTS) plan for point-in-time synchronization of table structure and Data changes

Created 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.

CERTIFICATION

Microsoft Certified Technology Specialist in SQL Server 2005

EDUCATION

Master of Science: Master of Computer Applications

University of Madras, Tamilnadu, India

Bachelor of Science: Computer Science

Andhra University, Andhra Pradesh, India



Contact this candidate