Barclays—Senior PostgreSQL SRE

Job description

Description: Job Description Purpose of the role To apply software engineering techniques, automation, and best practices in incident response, to ensure the reliability, availability, and scalability of the systems, platforms, and technology through them. Accountabilities - Availability, performance, and scalability of systems and services through proactive monitoring, maintenance, and capacity planning. - Resolution, analysis and response to system outages and disruptions, and implement measures to prevent similar incidents from recurring. - Development of tools and scripts to automate operational processes, reducing manual workload, increasing efficiency, and improving system resilience. - Monitoring and optimisation of system performance and resource usage, identify and address bottlenecks, and implement best practices for performance tuning. - Collaboration with development teams to integrate best practices for reliability, scalability, and performance into the software development lifecycle, and work closely with other teams to ensure smooth and efficient operations. - Stay informed of industry technology trends and innovations, and actively contribute to the organization's technology communities to foster a culture of technical excellence and growth. Vice President Expectations - To contribute or set strategy, drive requirements and make recommendations for change. Plan resources, budgets, and policies; manage and maintain policies/ processes; deliver continuous improvements and escalate breaches of policies/procedures.. - If managing a team, they define jobs and responsibilities, planning for the department’s future needs and operations, counselling employees on performance and contributing to employee pay decisions/changes. They may also lead a number of specialists to influence the operations of a department, in alignment with strategic as well as tactical priorities, while balancing short and long term goals and ensuring that budgets and schedules meet corporate requirements.. - If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others.. - OR for an individual contributor, they will be a subject matter expert within own discipline and will guide technical direction. They will lead collaborative, multi-year assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will train, guide and coach less experienced specialists and provide information affecting long term profits, organisational risks and strategic decisions.. - Advise key stakeholders, including functional leadership teams and senior management on functional and cross functional areas of impact and alignment. - Manage and mitigate risks through assessment, in support of the control and governance agenda. - Demonstrate leadership and accountability for managing risk and strengthening controls in relation to the work your team does. - Demonstrate comprehensive understanding of the organisation functions to contribute to achieving the goals of the business. - Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategies. - Create solutions based on sophisticated analytical thought comparing and selecting complex alternatives. In-depth analysis with interpretative thinking will be required to define problems and develop innovative solutions. - Adopt and include the outcomes of extensive research in problem solving processes. - Seek out, build and maintain trusting relationships and partnerships with internal and external stakeholders in order to accomplish key business objectives, using influencing and negotiating skills to achieve outcomes. All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset – to Empower, Challenge and Drive – the operating manual for how we behave. Join us as a Senior PostgreSQL SRE. At Barclays, we don’t just adapt to the future, we create it. As a Senior PostgreSQL SRE you will support the organisation, achieve its strategic objectives by the identification of business requirements and solutions that address business problems and opportunities. To be a successful Senior PostgreSQL SRE you should have experience with: - Proven experience as a Principal Level Database Administrator, with a focus on PostgreSQL and similar database technologies such as Oracle or MS-SQL. - Proven track record of implementing and leading SRE practices across large organizations or complex teams. - More than ten years of professional experience and expert-level knowledge of telemetry, monitoring, and platform observability tooling (e.g., ESAAS, Grafana, Prometheus,) with experience in customizing and scaling these solutions. - Leadership role in implementing modern DevOps and SRE practices in enterprise environments. - Proven expertise in SQL query optimization and database performance tuning at scale. - Experience with DevOps automation tools such as Code versioning (git), JIRA, Ansible, Containers and Kubernetes (OpenShift), database CI/CD tools and their implementation. - Experience in implementing PostgreSQL Container patterns on Kubernetes with the help of a PostgreSQL operator or a Helm charts. - Recognized as a PostgreSQL subject matter expert, serving as the highest level of technical escalation for complex database issues. - Proven experience in designing and executing database migration strategies at enterprise-scale. - Exceptional collaboration skills with executives and cross-functional teams. - Extensive experience working with large, distributed, high-performance, high-availability databases with 24/7 uptime Additional relevant skills given below are highly valued: - This role requires extensive knowledge and working experience in Technology, Information, and Security domain. - Working experience in a financial environment - Cloud experience (AWS, Azure, GCP) - Experience of working on Data migration tools and softwares - Expert in system configuration management tools such as Chef, Ansible for database server configurations. - Expert expertise with scripting languages (e.g. PowerShell, Python, Bash) for automation/migration tasks - AWS Certified Database – Specialty certification is a plus. You may be assessed on key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen, strategic thinking and digital and technology, as well as job-specific technical skills. This role is based in Pune.