Hi, Guys
We got a new job opening detail
company name Barclays
location : Pune, Maharashtra
description : Job Title: DB2 L3 DBA
Location: 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:
To provide database SME technical lead role on DB2 L3 DBA in the bank. Person should have commanding capabilities to resolve MIM/Triage issues, work on RCA’s and provide service stability and service improvement.
As an experienced Database Administrator, they will
Manage and support DB2 database systems
design and develop the databases and related infrastructure
deliver database and infrastructure changes
contribute to the strategy, architecture and future direction
Implementing and driving automation opportunities in DB2 database area in various categories. L3 DBA will strive towards reducing noise in database area. Resource will work towards creating more capacity in database area.
The role requires an ability to work independently and as part of a team. Note that L3 support includes an element of on call on a rota basis.
What will you be doing?
The resource will be working supporting database Operations as SME and will continue to support databases primarily for DB2. Resource should be SME who can contribute individually and should have capabilities to share knowledge within the team to enhance team capabilities.
Resource will be responsible for implementing and driving automation opportunities in DB2 database area in various categories. L3 DBA will strive towards reducing noise in database area. Resource will work towards creating more capacity in database area.
Take responsibility for completing tasks, focusing on requirements and planning to meet client needs, which the job holder helps to identify, advise and recommend technical solutions based on experience and Industry knowledge
Role is expected to have a talent where he will contribute during the MIM/Triage or emergencies that require technical knowhow and wit to overcome issues on immediate grounds
Provide robust engineering support for DB2
React quickly to resolve production issues at all times of the day
Take ownership of issues / enhancements and see them through to a suitable conclusion
Work with application teams to understand their requirements / issues and deliver solutions for them
Understand timescales and priorities and balance these to ensure deliveries
Provide L3 support as part of 24*7 cover – including weekends
Handle Incident, change and problem Management practices
Improve knowledge of the systems processes and technologies, infrastructure and service development processes, both current and emerging technology
Interface with other areas sharing technical knowledge and expertise and resolving issues as necessary
Support the implementation of strategy and policy issues by involvement in change and/or advise to other technical areas and makes recommendations to improve procedures and working
What we’re looking for:
Candidate should have very good experience in DB2 database administration and very good capabilities to lead and implement various automation solutions in database area. The candidate should have understanding and working experience on:
DB2 advanced Database Administration.
Performance Tuning, Query Optimization and other related monitoring and troubleshooting.
DB2 replication strategies practical experience and awareness.
Installation, Upgradation and configuration of DB2 products.
DB2 User and Access Management.
DB backup – Restore and Recovery knowledge.
Very good practical experience of DB2 Utilities like Load/Explain/Reorg/Runstats/db2top/db2advis/backup/etc.
Fine-Tune Configurations- DB2 for performance improvements.
Should have knowledge of performing health checks to monitor
Identify slow queries
Indexes
Reorg and run stats
CPU/Memory usage
Lock timeouts and deadlocks
Maintenance required -during release/outage etc.
DB2 backup configuration.
DB2 database recovery techniques.
Configuring and monitoring Automation agent.
Event, Incident, change and problem management.
Disaster Recovery knowhow for DB2, DB2.
Database support – production and test.
Monitoring & alerting.
Database authentication mechanism.
Database migration across from DB2 to DB2 and DB2 to other technologies.
Database maintenance.
Data movement utilities – Export & Import.
Logical access management.
Database audit & compliance.
Open to learn other database technologies.
Skills that will help you in the role:
Technology graduate
DB2 database administration with experience of at least more than 7-8 years. Very good experience of leading and driving the various database solutions in DB2 dB area which has led to capacity creation or immense customer satisfaction and savings. Roles with leadership accountabilities should be present with candidate.
Database risk and governance.
Strong analytical skills.
Desirable skills/Preferred Qualifications:
Bachelor in engineering/Technology or MCA
DB2 administration
Shell scripting.
Very good troubleshooting and Performance tuning skills.
Candidate with experience on other technologies like MongoDB as well will be added advantage.
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.