MS SQL SME

Role: MS SQL SME Job Type: Permanent Location: London (Hybrid) Are you passionate about making a significant impact by maintaining the MS SQL databases servers including security, back-up, reporting and recovery procedures? Do you have skills on Capacity Planning & Database refreshes from production backup to Stage, test and Development environments? Join us as a MS SQL SME. Careers at TCS: It means more TCS is a purpose-led transformation company, built on belief. We do not just help businesses to transform through technology. We support them in making a meaningful difference to the people and communities they serve - our clients include some of the biggest brands in the UK and worldwide. For you, it means more to make an impact that matters, through challenging projects which demand ambitious innovation and thought leadership. Be part of an exciting team where you will be challenged every day. Work closely with the range of teams within the business to bring products to life. Work with customers and identify opportunities to support their strategy and improve their processes across functions. The Role As a MS SQL SME with in-depth technical knowledge and understanding Customer business and criticality. Key responsibilities: Experience in SQL Failover Cluster Installation, Configuration, Maintenance & Administration of Microsoft SQL Server Experience with SQL Server database encryption; Knowledge in SSRS, SSIS and SSAS installation and support Need to have hands-on experience supporting all the SQL Server HADR like Mirroring, replication, log shipping, always on, clustering. Providing access rights in database level, objects level as per requirement. Capacity Planning & Database refreshes from production backup to Stage, test and Development environments. Implemented CDC, Table level Partitioning & Archiving Historical Records MS SQL Server Security Policy Review & Implementing TDE & Column Level Encryption at SQL Server Level. Performing DR drill activity to Perform Sanity Checks on DR setup for Logshipping, Database Mirroring & Availability Groups Experience in configuring linked servers between SQL to Oracle, DB2, MYSQL DB's and vice-versa Need to know on how to create Incidents, change request, Service request and perform the RCA for problem ticket. Your Profile Key skills/knowledge/experience: Hands-on experience supporting SQL Server from version 2008 R2 onwards and installation on the latest SQL version, upgrading & migrating SQL Server. Have hands-on experience supporting all the SQL Server versions, Strong analytical skills for problem solving database related issues, Troubleshooting & Performance tuning. Rewards & Benefits: TCS is consistently voted a Top Employer in the UK and globally. Our competitive salary packages feature pension, health care, life assurance, laptop, phone, access to extensive training resources and discounts within the larger Tata network. Diversity, Inclusion & Wellbeing At TCS, we believe in building and sustaining a culture of equity and belonging where everyone can thrive. Our diversity motto is ‘Inclusion without Exception’. You’ll find a welcoming culture and many internal volunteering and social networks to join. Our diversity, inclusion and social activities involve 12 employee networks including LGBTQ & Allies, mental health, disability & neurodiversity inclusion and many more, as well as health & wellness initiatives and sports events (we even sponsor the London Marathon). We are open to all and treat applications equally, regardless of ethnicity, disability, gender identity, gender reassignment, age, sexual orientation, or beliefs. If you are an applicant who needs a reasonable accommodation due to Disability or Neurodiverse Condition to complete an employment application, or during any phase of the hiring process, please contact us at vs.mohanatcs.com with the subject line: “Reasonable Accommodation Request”. Due to the high volume of applications, we will be unable to contact each applicant individually on the status of their application. If you have not received a direct response within 30 days, then it should be deemed unsuccessful on this occasion. Application Process 1. Online application > 2. Technical assessment > 3. Technical discussion > 4. Managerial discussion > 5. HR discussion. Join us and do more of what matters. Apply online now.