Sql Server Service
Resume:
SUBBU
DEVALLA
***** ** **** ****** ******** WA-98007 (H) 425-***-**** (C) 425-***-****
*****.*******@*****.***
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