Biv - Db Dev Chn

Job Title: BIV - DB Dev CHN
Location: Chennai

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.

Hybrid Working

Please discuss the detail of the working pattern options for the role with the hiring manager.

Introduction:
The hiring team are responsible for building the strategic R&A Wholesale Credit Risk platform used for internal risk management and regulatory reporting across Barclays International.

What will you be doing?
- Key specific accountabilities.
- Understanding the overall purpose of the project and contribute in design, development, testing and maintenance of SQL Server database objects.
- Develop, support and improve existing SQL Server database objects and processes.
- Involvement in troubleshooting, performance checks of the database objects, analysing and rectifying issues within existing objects.
- Involve in test phases and work towards early resolution of defects and ensuring permanent fix.
- Design, Develop and Implement Change Requests (CR) from Business
- Adherence to Barclays policies and standards
- Support live implementation, Provide warranty support, Service transition, BAU support.
- Excellent communication and consulting skills Ability to work independently.
- Working closely with global development team members in other regions, participating in and contributing to technical discussions.
- Communicate effectively with the local development manager and team.
- Responding promptly to requests from the RTB support team in order to resolve user queries and handle technical issues that are out of scope for the support staff.
- Making technical updates to reduce the manual support overhead for the system.
- Working with BAs and Team Leads to understand the functional scope of project work, questioning decisions and collaborating with end-users to ensure that business needs are met on a timely basis.
- Drafting initial design proposals for reviews by team leads and architects, and contributing to detailed technical specifications where appropriate.
- Following good processes and practices, as defined by the team standards; ensuring that documentation is complete, comprehensive and signed off.
- Implement and test technical solutions from specifications to both new and existing systems.
- Ensuring code written meets the predefined company and department standards
- Involvement in peer reviews with more senior team members in order to provide constructive feedback
- Liaising with a test team to provide support during SIT, QA and UAT test phases
- Diagnosis and resolution of defects found during SIT, QA and UAT test phases
- Supporting regression testing.
- Following established process and practices with regards to source code management and audit controls.
- Writing release plans and coordinating release walkthroughs with the environment managers and RTB teams.
- Acting as a point of contact for support team, investigating and resolving issues found in production following minor releases.
- Providing on-call support for minor releases.

What we’re looking for:

- Very Strong Knowledge in writing SQL and T SQL (views, stored procs, triggers, compex queries etc) using MS SQL Server (preferably) or any other database
- Able to handle end to end process including dev (MSSQL), testing, releases using CI/CD and prod support as needed
- Experience in tuning and enhancing SQL Queries for the optimal performance
- Business intelligence experience working with large data sets and data warehouses
- General understanding of the full Agile methodologies
- Hands on experience with Git or other source code control tools
- Knowledge on implementing CI/CD pipeli