Sarvesh Singh

Sarvesh Singh

Assistant Revenue Officer

Followers of Sarvesh Singh920 followers
location of Sarvesh SinghPangbourne, England, United Kingdom

Connect with Sarvesh Singh to Send Message

Connect

Connect with Sarvesh Singh to Send Message

Connect
  • Timeline

  • About me

    Technical Advisor at Microsoft

  • Education

    • Highbury College

      -
      HNC computing
    • 70-533 Implementing Microsoft Azure Infrastructure Solutions Certification

      2014 -
      70-533 Implementing Microsoft Azure Infrastructure Solutions Certification Date Oct 2014 – Present
    • MCSE - SQL 2012 Data Platform

      2014 -
      MCSE - SQL 2012 Data Platform
    • MCTS, MCITP SQL Server 2008 Administration

      2010 - 2011
      Microsoft Online Exam
    • SFS College

      1997 - 2001
      E; S.F.S; BSc commerce; Physics; Maths, Electronics
    • Nagpur University

      1997 - 2000
      BSc Physics, Maths, Electronics
  • Experience

    • INLAND REVENUE

      Sept 2003 - Jan 2004
      Assistant Revenue Officer

      Job Responsibilities:Maintaining Database in SQL, inputting & updating data in ExcelSearch for taxpayers with outstanding payments using SQL queries.Calculate interests and daily penalties.Writing letters to the taxpayers, answering phone calls and performing general office duties.

    • Southampton City College

      Feb 2004 - Nov 2004
      Flex IT Instructor

      Job Responsibilities:Planning, delivering, and assessing Key Skills, New CLAIT, CLAIT PLUS, and ECDL curriculum at levels 1, 2 and 3. Marking, updating and writing resources for students.Provide induction for students interested in the courses on offer through PowerPoint presentations, one-to-one discussion, and question and answer sessions.

    • Birmingham and Solihull Connexions

      Nov 2004 - Nov 2006
      Data Analyst

      Job Responsibilities: Identify the technical developments required for the effective running of the database, scope the changes and follow through with the provider to delivery.To collect and import information into the client database and to ensure the successful electronic transfer of information through DTS.Produce data corrective SQL scripts and stored procedures in line with system functionality and business requirements.Troubleshooting, Installing, and monitoring database application.Designing and delivering backup/restore databases and data warehousing to ensure effective running of the system.To support the Organisation to quality check/cleanse data and identify recording, system and training issues.Schedule batch files/Reports and create indexes to improve the performance of the database application.To prepare reports using MS Excel, MS Access and Crystal Reports for the Connexions Service management team and other agencies as required.To monitor and follow up the production of management reports to ensure that all necessary deadlines are achieved.Provide 1st line helpdesk support to the users from initial request through to resolution. Show less

    • Veolia Environmental Services

      Nov 2006 - Jan 2007
      Assistant System Support Engineer

      Job Responsibilities:Assist with the roll-out of dedicated computer based systems within the Veolia UK Energy Recovery Group by co-ordination of the site/company project teams, bringing site-specific benefits and ensuring compliance with the Group project objectives.Assist the Systems Support Engineer with regard to development and application of the SQL system as agreed by the steering group and in consultation with site management. Produce reports in Access, Excel or Crystal as required by the staff.Import data of different formats into SQL Database.Ensure that Energy Recovery Facility staff receives adequate day to day support to maintain high quality and availability of the systems.Provide training to all staff across different sites. Show less

    • CDC Software

      Jul 2007 - Oct 2010
      Technical consultant

      Key Responsibilities • Monitored and tuned database configurations to ensure that appropriate performance and service levels were maintained, installed, maintained and configured database software on required hardware platforms, tested and evaluated new software releases, also provided guidance in the design of data structures to maintain system performance and compliance with application requirements. • Implemented scheduled backups for ‘Production Databases’ using appropriate tools, maintained an awareness of developments and trends in database technology and provided recommendations as to their potential use, installed and upgraded CDC software, both remotely and on-site, also produced reports for the customers as and when requested.• Managed SQL Server Security, provided training to the customers across various sites, created, tested and implemented stored procedures, triggers and queries for new implementations, aided the development of new strategies and plans for future growth, also performed ‘Data Management Tasks; import and export, SSIS, data partitions and maintained indexes.Key Achievements • Constructed support office in Bangalore, which involved training and shaping new staff members on key SQL features, including mirroring, log shipping, security, integration of application with databases, as well as application training, supporting the organisation’s strategic objectives of improving personal and professional development of key staff members. Show less

    • Coeo

      Sept 2010 - Jan 2015
      Database Administrator

      Key Responsibilities • Managed and advised on backup strategies and other aspects of database management, performance tuned complex queries, implemented and supported high availability and disaster recovery technologies for SQL Server, supported multiple geographically dispersed customers running mission critical SQL Server solutions, also oversaw data warehouses using SSIS and SSAS.• Administered the design, scalability and growth of database infrastructure, liaised with external customers and sponsors, implemented, operated, tuned and troubleshot enterprise SQL server databases, patched Windows Cluster and SQL Server instances, worked with failover clustering, mirroring, replication, log shipping and Always On, also supervised the resolution of complex SQL Server problems.Key Achievements • Spearheaded and resolved a myriad of critical issues brought forward by customers at meetings and SQL conferences, ranging from system down and high replication latency, to performance tuning, which resulted developing positive relationships with new and existing customers, significantly improving customer retention and satisfaction levels, whilst sustaining a positive reputation for the company. Show less

    • Lebara

      Jan 2015 - Mar 2015
      Senior DBA

      • Upgrade SQL 2005 and SQL 2008 environment to SQL 2012• Migrate SSIS packages to SQL 2012• Train Junior DBAs on performance tuning and AlwaysOn

    • Vodafone

      Apr 2015 - Aug 2018
      Senior SQL Server DBA

      • Implementing high availability and disaster recovery solution using ‘Always On’, monitoring jobs and recommending enhancements required to improve performance, performance tuning on the SQL servers, installing and customising the SQL database management warehouse for monitoring and reporting on SQL server status, also maintaining and customising a central control console that is geared towards business demands. • Maintaining log audit and documenting all the activities on SQL servers, upgrading SQL 2005 and SQL 2008 R2 to SQL 2012, SQL 2014 and SQL 2016, managing over 200 hundred databases across 50 instances; ranging from few hundred gigabytes to terabytes within the VMware environment, also providing inputs on RAID configuration and assisting in implementing cluster environment for high availability. • Identifying bottlenecks, carrying out ‘Software Installation Service’ packs upgrades to keep in-line with the industry standards, identifying bottlenecks on disk subsystem, providing fixes and maintaining logs on all database faults and failures, ensuring performance, availability, and security of Oracle and MySQL database instances, also orchestrating upgrades, backups, and provisioning of database instances in a 24x7 operational environment.Key Achievements • Saved company ~ £100K through cross training in Oracle and MySQL, taking over support from 3rd party support teams, as well as leading and mentoring Junior DBAs and Application Support teams, improving support delivered for various critical systems in both Oracle and MySQL.• Performance tuned the Billing process, eradicating issues experienced by end-users, whilst supporting cost control measures for organisation, reducing the organisation’s expenses. Show less

    • Microsoft

      Aug 2018 - now

      Responsibilities Include:I. Ensure my team builds the deep technical expertise, agility and excellent communication and interpersonal skills needed to support our customers effectively.II. Drive employee delivery assessment discussions as part of providing coaching, share feedback regularly and partner with engineers in operational excellence and technical development.III. Manage the different aspects of customer support delivery, including daily operations, scheduling, meetings and addressing customer feedback.IV. Foster a strong partnership between the different Azure Rapid Response Support delivery teams and its stakeholders in other parts of the business.V. Partner with global peers to ensure consistency and follow-through for global processes and coordination of resources.VI. Collaborate with fellow Engineer TAs and Service TAs from the ARR team and the PODs in the business to communicate observations and resolutions to support trends, training gaps, tool needs and other business obstacles.VII. Work closely with other ARR Technical Advisors in the different time zones in order to create a streamlined support delivery processVIII. Act as technical focal point in cooperative relationships with other companies.IX. Receive mission critical or politically hot customer issues, and manage the drive to resolution either by engaging directly or through customersX. Provide ramp activities for junior engineers, knowledge sharing, technical coaching and mentoringXI. Drive technical collaboration and engagement outside of CSS (Product Engineering teams, Services, Support, Regions)XII. Own Case management duties (technical review, triage, incoming inspection for SIE (Service Interruption Event), case progression, impact to customer wellness, reduced time to... measures)XIII. Technical interviews for new hires Show less Key Responsibilities• Trusted advisor to the customer and handle complex, repeatable, escalated cases that may become politically charged.• Providing excellent support to top 100 Azure SQL customers like Citrix, Manulife, Adobe, ASOS etc. • Help build solutions, help automate issue detection and diagnosis, to enable customers to self-resolve the issues.• Communicate with customers through a variety of channels including telephone, email and Teams Channel.• Participate in case review meetings and Triage calls to share knowledge with other engineers and develop efficient customer solutions.• Identify and report both software bugs and customer feedback to the product team.• Mentor and train engineers not only on the technical side of things but also soft skills.• Work closely with CSS Engineers, product team from different technologies and across different regions to help resolve customer issue quickly.Key Achievements Excellent customer feedback. I am highlighting few examples from the CSAT report below:The Support engineer provided the needed information & expectations were met.The support engineer is very professional and helpfulInputs given by Sarvesh is valuable and it helps improve performanceIt was a nice experience working with Sarvesh Show less

      • Technical Advisor

        Jun 2020 - now
      • Azure DB Support Engineer

        Aug 2018 - Jun 2020
  • Licenses & Certifications

    • 70-533 Implementing Microsoft Azure Infrastructure Solutions

      Oct 2014
    • MCSE - SQL 2012 Data Platform

      Aug 2014
    • 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

      Jun 2011
    • AWS Certified Solutions Architect - Associate

      AWS
      Feb 2018
    • AWS Certified Solutions Architect - Associate

      AWS
      Feb 2018
      View certificate certificate
    • Developing Your Leadership Philosophy

      LinkedIn
      May 2022
      View certificate certificate
    • How to Handle Poor Performers

      LinkedIn
      May 2022
      View certificate certificate
    • Management Excellence at Microsoft: Model, Coach, Care

      LinkedIn
      May 2022
      View certificate certificate
    • Improving Your Listening Skills

      LinkedIn
      May 2022
      View certificate certificate
    • Learning to Be Assertive

      LinkedIn
      May 2022
      View certificate certificate