Systems Engineer II

About the roleThe Systems Engineer II for Database operations is a technical role and person is expected to work on incident, problem, and change request to support the database platforms across public and private cloud. Systems Engineering is a core capability for Tesco Technology, and this position is critical for shaping the engineering culture as we grow. The role will be serving as a core member of an agile team that support the Database Platform Availability and future automations in Tesco. This role is also providing operational assistance and guidance for SQL Server platform including monitoring, management, disaster recovery, security compliance/auditing, performance, Backup/Recovery.You will be responsible for Support and Administer database instances effectively, efficiently, and independently.Discover and implement new technologies that improve functionality, availability, cost efficiency, and security for Tesco's Database Platforms.Collaborate with other teams across all of Tesco Technology and vendors to ensure service and project delivery.Resolve moderate to complex (P1, P2 and P3) incidents and problems effectively in a timely manner.Providing 24X7 production support and available for escalationsResponsible for performing root cause analysis and long-term fix.Responsible for implementation of medium to complex components of a project module, change request.Responsible for providing trend analysis to management team to enable them to make informed decisions.Working in a cross-cultural team and communicate effectively.Automation experience in the database support structureGood team player and willingness to explore and learn new areas/technologies.Basic knowledge of Windows OS and its related commandsGood analytical skillsFlexible to work in shifts.You will needMinimum 8 yrs experience in SQL Server database administrationOwning the accountability of database support and administration effectively, efficiently and independentlyPlan/perform tasks related to installation and configuration, performance tuning, backup, recovery, security, patching, upgrades and high availabilityResolve moderate to complex (P1 and P2) incidents and problems effectively in a timely mannerProviding 24X7 production support as needed and available for escalationsAccountable for performing root cause analysis, long term fix, service improvements and providing technical solutionsAccountable for design and implementation of medium to complex components of a project module, change requests.Responsible for providing trend analysis to management team to enable them to make informed decisionsWorking in a cross cultural team and communicate effectively with team and stake holdersMentoring and guiding junior team membersExpertise in managing multiple MS SQL2008/R2/2012/2014/2016/2017/2019 RDBMS on medium to large systemsGood knowledge of Windows OS and its related commandsGood knowledge of T-SQL and query tuningHigh availability features – Mirroring, replication and clusteringGood analytical skillsAutomation experience in the database support structureAbility to work with Cloud (IaaS & PaaS), Cloud technologiesGood team player and willingness to explore and learn new areas/technologiesWork as a subject matter expertTrain and technically scale up team membersWhats in it for you? At Tesco, we are committed to providing the best for you.As a result, our colleagues enjoy a unique, differentiated, market- competitive reward package, based on the current industry practices, for all the work they put into serving our customers, communities and planet a little better every day.Our Tesco Rewards framework consists of pillars - Fixed Pay, Incentives, and Benefits.Total Rewards offered at Tesco is determined by four principles -simple, fair, competitive, and sustainable.Salary - Your fixed pay is the guaranteed pay as per your contract of employment.Leave & Time-off - Colleagues are entitled to 30 days of leave (18 days of Earned Leave, 12 days of Casual/Sick Leave) and 10 national and festival holidays, as per the company's policy.Making Retirement Tension-FreeSalary - In addition to Statutory retirement beneets, Tesco enables colleagues to participate in voluntary programmes like NPS and VPF.Health is Wealth - Tesco promotes programmes that support a culture of health and wellness including insurance for colleagues and their family. Our medical insurance provides coverage for dependents including parents or in-laws.Mental Wellbeing - We offer mental health support through self-help tools, community groups, ally networks, face-to-face counselling, and more for both colleagues and dependents.Financial Wellbeing - Through our financial literacy partner, we offer one-to-one financial coaching at discounted rates, as well as salary advances on earned wages upon request.Save As You Earn (SAYE) - Our SAYE programme allows colleagues to transition from being employees to Tesco shareholders through a structured 3-year savings plan.Physical Wellbeing - Our green campus promotes physical wellbeing with facilities that include a cricket pitch, football field, badminton and volleyball courts, along with indoor games, encouraging a healthier lifestyle.About Us Tesco in Bengaluru is a multi-disciplinary team serving our customers, communities, and planet a little better every day across markets. Our goal is to create a sustainable competitive advantage for Tesco by standardising processes, delivering cost savings, enabling agility through technological solutions, and empowering our colleagues to do even more for our customers. With cross-functional expertise, a wide network of teams, and strong governance, we reduce complexity, thereby offering high-quality services for our customers.Tesco in Bengaluru, established in 2004 to enable standardisation and build centralised capabilities and competencies, makes the experience better for our millions of customers worldwide and simpler for over 3,30,000 colleaguesTesco TechnologyToday, our Technology team consists of over 5,000 experts spread across the UK, Poland, Hungary, the Czech Republic, and India. In India, our Technology division includes teams dedicated to Engineering, Product, Programme, Service Desk and Operations, Systems Engineering, Security & Capability, Data Science, and other roles.At Tesco, our retail platform comprises a wide array of capabilities, value propositions, and products, essential for crafting exceptional retail experiences for our customers and colleagues across all channels and markets. This platform encompasses all aspects of our operations – from identifying and authenticating customers, managing products, pricing, promoting, enabling customers to discover products, facilitating payment, and ensuring delivery. By developing a comprehensive Retail Platform, we ensure that as customer touchpoints and devices evolve, we can consistently deliver seamless experiences. This adaptability allows us to respond flexibly without the need to overhaul our technology, thanks to the creation of capabilities we have built.