Job Description

MSSQL L2 DBA Pune About Barclays Barclays is a British universal bank. We are diversified by business, by different types of customers and clients, and by geography. Our businesses include consumer banking and payments operations around the world, as well as a top-tier, full service, global corporate and investment bank, all of which are supported by our service company which provides technology, operations and functional services across the Group. Risk and Control Objective Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards. Working Flexibly We\'re committed to providing a supportive and inclusive culture and environment for you to work in. This environment recognises and supports ways to balance your personal needs, alongside the professional needs of our business. Providing the opportunity for all our employees, globally to work flexibly empowers each of us to work in a way that suits our lives as well as enabling us to better service our customers\' and clients\' needs. Whether you have family commitments or you\'re a carer, or whether you need study time or wish to pursue personal interests, our approach to working flexibly is designed to help you balance your life. If you would like some flexibility then please discuss this with the hiring manager. Introduction: Role to be a technical SME and provide technical support, advice and guidance to all Barclays business areas implementing SQL Server based solutions. What will you be doing Technical engagement in Incident, Change and Problem as part of BAU Operations activities. Involve in estate wide SQL patching, Scheduled Disaster Recovery/Production Crossover exercises and estate wide remediations and rollouts Adherence to Barclays standards for change control, database security and database patterns, adhering to bank\'s governance and control procedures. Lead and define database delivery requirements for Service Improvement Unit initiatives Able to clearly communicate complex technical issues to a wide audience. Analysis of re-occurring incidents and identify service improvements where possible. Be an effective, proactive team member, influencing the behaviour of colleagues internally and across Infrastructure Services What skill we required Expert knowledge of T-SQL. Experience in configuring and all components of the MS SQL Product set (Core DB engine and SSRS, SSAS, SSIS, Replication topologies, Service Broker, Log Shipping, Database Snapshots, Database Mirroring, and experience with Always On etc.). Must have extensive experience as Production support SQL Server Database Administrator - strong experience in large, high volume and high criticality environments Database maintenance and troubleshooting. Must exhibit in-depth expertise in solving database contention problems (dead locks, blocking etc). Demonstrate expertise in performance tuning including both query and server optimization Experience of working in a highly regulated environment and the associated processes and tools. Knowledge of the ITIL framework, vocabulary and best practices Skills that will help you in the role: Strong skills in designing and delivering platforms to hosts SQL server, covering HA and DR , at Enterprise scale. Experience of working in a highly regulated environment and the associated processes and tools. Demonstrate expertise in performance tuning including both query and server optimization Understanding of Cloud Based Computing in particular AWS, RDSAzure Where will you be working Pune Be More at Barclays At Barclays, each day is about being more - as a professional, and as a person. \'Be More @ Barclays\' represents our core promise to all current and future employees. It\'s the characteristic that we want to be associated with as an employer, and at the heart of every employee experience. We empower our colleagues to Be More Globally Connected, working on international projects that improve the way millions of customers handle their finances. Be More Inspired by working alongside the most talented people in the industry, and delivering imaginative new solutions that are redefining the future of finance. Be More Impactful by having the opportunity to work on cutting-edge projects, and Be More Valued for who you are. Interested and want to know more about Barclays Visit home.barclays/who-we-are/ for more details. Purpose, Values and Mindset We deploy finance responsibly to support people and businesses, acting with empathy and integrity, championing innovation and sustainability, for the common good and the long term. Our values underpin everything we do: Respect, Integrity, Service, Excellence and Stewardship. Respect We harness the power of diversity and inclusion in our business, trust those we work with, and value everyone\'s contribution. Integrity We operate with honesty, transparency and fairness in all we do. Service We act with empathy and humility, putting the people and businesses we serve at the centre of what we do. Excellence We champion innovation, and use our energy, expertise and resources to make a positive difference. Stewardship We prize sustainability, and are passionate about leaving things better than we found them. Our Mindset shapes how we take action, living by our Values, driven by our Purpose, always with our customers and clients at the heart of what we do our Mindset is to Empower, Challenge and Drive. Empower Trust and support each other to deliver. Make decisions with those closest to the topic. Include diverse perspectives. Celebrate success and learn from failure. Challenge Question whether things can be done better. Use insights based on data to inform decisions. Be curious about how we can adapt and improve. Speak up and be open to alternative viewpoints. Drive Focus on outcomes. Deliver with pace. Be passionate and ambitious about what we do. Take personal responsibility. Actively build collaborative relationships to get things done. You must meet the following eligibility criteria: To apply, upload a copy of your updated resume on Taleo.

foundit