Migration Services Postgres SME

Purpose of the role

To build and maintain infrastructure platforms and products that support applications and data systems, using hardware, software, networks, and cloud computing platforms as required with the aim of ensuring that the infrastructure is reliable, scalable, and secure.  Ensure the reliability, availability, and scalability of the systems, platforms, and technology through the application of software engineering techniques, automation, and best practices in incident response. 

Accountabilities

• Build Engineering:  Development, delivery, and maintenance of high-quality infrastructure solutions to fulfil business requirements ensuring measurable reliability, performance, availability, and ease of use. Including the identification of the appropriate technologies and solutions to meet business, optimisation, and resourcing requirements.
• Incident Management: Monitoring of IT infrastructure and system performance to measure, identify, address, and resolve any potential issues, vulnerabilities, or outages. Use of data to drive down mean time to resolution.
• Automation:  Development and implementation of automated tasks and processes to improve efficiency and reduce manual intervention, utilising software scripting/coding disciplines.
• Security: Implementation of a secure configuration and measures to protect infrastructure against cyber-attacks, vulnerabilities, and other security threats, including protection of hardware, software, and data from unauthorised access.
• Teamwork:  Cross-functional collaboration with product managers, architects, and other engineers to define IT Infrastructure requirements, devise solutions, and ensure seamless integration and alignment with business objectives via a data driven approach.
• Learning: 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.

Assistant Vice President Expectations

• To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions.
• Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes
• 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 lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.
• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
• Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.
• Take ownership for managing risk and strengthening controls in relation to the work done.
• Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.
• Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, solve problems creatively and effectively.
• Communicate complex information. 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience.
• Influence or convince stakeholders 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 Barclays as a Migration Services Postgres SME role, where you will be responsible for building and maintaining the systems that collect, store, process, and analyze data. Your work will ensure that all data is accurate, accessible, and secure. You will collaborate with data scientists and other stakeholders to build and deploy machine learning models and support data-driven decision-making within the organization. At Barclays, we don't just anticipate the future - we're creating it.

To be successful in this role, you should have below skills:

• Database Migration: Lead the migration of databases from various platforms to PostgreSQL, ensuring data consistency, integrity, and minimal downtime 1.

• Technical Expertise: Provide deep technical expertise in PostgreSQL, including database design, query optimization, and performance tuning 1.

• Data Transformation and Schema Conversion: Generate scripts for data transformation, ensuring compatibility between source and target database schemas 1.

• Automated Data Validation: Automate data cleansing and validation processes, detecting inconsistencies and errors in migrated data 1.

• Collaboration: Work closely with other teams, including Data Engineers, AI Developers, and Solution Architects, to ensure successful migration projects 1.

• Documentation: Create and maintain comprehensive documentation for database schemas, procedures, and processes 1.

Some other highly valued skills may include below:

• Advanced knowledge of PostgreSQL database design, query optimization, and performance tuning

• Experience migrating databases from various platforms to PostgreSQL

• Ensuring data integrity, consistency, and minimal downtime

• Proficiency in SQL and scripting languages (e.g., Python, Bash)

• Automating data transformation and validation processes

• Ability to generate scripts for schema conversion and compatibility between source and target databases

• Implementing automated data cleansing and validation to detect inconsistencies

• Working with cross-functional teams (Data Engineers, AI Developers, Solution Architects)

• Clear documentation and stakeholder engagement

• Maintaining detailed documentation of database schemas, migration procedures, and operational processes

You may be assessed on the 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 our Pune office.