Systems Engineer II

About the role

The Systems Engineer
II for Database operations is a is an individual contributor role and theperson is expected to work on incident, problem, and change request to supportthe database platforms across public and private cloud. Systems Engineering isa core capability for Tesco Technology, and this position is critical forshaping the engineering culture as we grow. The role will be serving as a coremember of an agile team that support the Database Platform Availability andfuture automations in Tesco. This role is also providing operational assistanceand guidance for SQL Server and PostgreSQL platform including monitoring, management,disaster recovery, security compliance/auditing, performance, Backup/Recovery andhigh availability.

You will be responsible for

As a Systems Engineer II for Database platform, I will:

Owning the
accountability of database support and administration effectively, efficientlyand independently

Plan/perform tasks
related to installation and configuration, performance tuning, backup,recovery, security, patching, upgrades and high availability

Resolve moderate to
complex (P1 and P2) incidents and problems effectively in a timely manner

Providing 24X7
production support as needed and available for escalations

Accountable for
performing root cause analysis, long term fix, service improvements andproviding technical solutions

Accountable 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 informeddecisions

Working in a cross-cultural
team and communicate effectively with team and stake holders

Mentoring and
guiding junior team members

Automation experience in the database support
structure

Good team player and
willingness to explore and learn new areas/technologies.

Flexible to work in shifts.

Focussed on delivering
scalable performant database platforms that underpin our customer data servicesin a dynamic and fast-moving agile engineering environment.

Experience with
different types of enterprise application databases (PostgreSQL a must)

Familiar with
developing in a Cloud environment (AWS RDS, DMS & DevOps highly desirable).

Proficient using SQL
to interrogate, analyse and report on customer data and interactions on livesystems and in testing environments.

Proficient using
PostgreSQL PL/pgSQL

You will need

I should have hands-on experience in

Expertise in
managing multiple MS SQL2008/R2/2012/2014/2016/2017/2019 and PostgreSQL RDBMSon medium to large systems

Good knowledge of
Windows OS and its related commands

Good knowledge of
T-SQL and query tuning

High availability
features Mirroring, replication and clustering

Good analytical
skills

Ability to work with
Cloud (IaaS & PaaS), Cloud technologies

Good team player and
willingness to explore and learn new areas/technologies

Work as a subject
matter expert

Train and
technically scale up team members

Performing tasks
related to installation and configuration, performance tuning, backup,recovery, security, patching, upgrades and high availability.

Good knowledge on
backend programming.

Good exposure on
skills like Terraform, Ansible, Git, Jenkins.

Qualifications:

Graduation/Post
Graduation.

Minimum 8-15 years
of technology experience.

Whats 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

At Tesco, inclusion is at the heart of everything we do. We believe in treating everyone fairly and with respect, valuing individuality and uniqueness to create a true sense of belonging. Diversity and inclusion are deeply embedded in our valueswe treat people how they want to be treated. Our goal is for all colleagues to feel they can be themselves at work, and we are committed to helping them thrive. Across the Tesco group, we are building an inclusive workplace that actively celebrates the cultures, personalities, and preferences of our colleagues, who in turn contribute to the success of our business and reflect the diversity of the communities we serve.At Tesco Bengaluru, we are proud to be a Disability Confident Committed Employer, highlighting our commitment to creating a supportive environment for individuals with disabilities. We are dedicated to offering equal opportunities for all candidates and encourage applicants with disabilities to apply. Our recruitment process is fully accessible, and we are happy to provide reasonable adjustments during interviews. If you need any accommodations to participate in the recruitment process, please let us know. We are here to ensure that everyone has the chance to succeed.We also believe in fostering a work environment where you can excel both professionally and personally. Our hybrid model allows you to work flexiblyspend 60% of your week collaborating in person with colleagues at our office locations or local sites, and the rest of the time working remotely. We understand that everyone's life journey is unique, whether you are starting your career, pursuing passions, or navigating life changes, and we are here to support you. Flexibility is a core part of our culture, and we encourage open conversations about how we can best accommodate your needs, so talk to us throughout your application process on the support required.