Postgresql Database Admin/consultant Specialist

Job description Some careers shine brighter than others If you re looking for a career that will help you stand out join HSBC and fulfil your potential Whether you want a career that could take you to the top or simply take you in an exciting new direction HSBC offers opportunities support and rewards that will take you further HSBC is one of the largest banking and financial services organisations in the world with operations in 64 countries and territories We aim to be where the growth is enabling businesses to thrive and economies to prosper and ultimately helping people to fulfil their hopes and realise their ambitions We are currently seeking an experienced professional to join our team in the role of Consultant Specialist In this role you will Responsible for Technical Delivery of PostgreSQL Database Support for Build Estate Management and Business Delivery Engaging with Business Users Analysing the Requirements Planning and Implementation of New Builds Patching Migrations and Upgradation of Environments Managing monitoring and securing large and complex environments across data centres using best practices automating functions and enhancing monitoring and observability and managing product lifecycle upgrades and patch sets in highly regulated environments Providing Consultancy for New Projects Environment Setups Planning Backup and Disaster Recovery Plan implement and maintain recovery procedures and emergency disaster recovery plans Investigate and provide solutions to Database Performance related issues Query Tuning Analysing Environments Resources Capacity Good knowledge in Change Management Incident Management Root Cause Analysis Work experience in Agile Model Kanban Jira Confluence Contribute to enhancement of technical competency application knowledge of team members Enforce HSBC Standards Processes and adherence to compliance of all internal controls Requirements To be successful in this role you should meet the following requirements Qualification A Bachelor degree or equivalent experience with a major or minor in Computer Science or related field Good understanding of PostgreSQL - Architecture security operational knowledge Deep understanding of how PostgreSQL manages data including tablespaces data files indexes WAL Write-Ahead Logging and key processes like Postmaster and bgwriter Proficiency in installing configuring and upgrading PostgreSQL instances Expertise in identifying and resolving performance bottlenecks including SQL query optimization index tuning and server parameter adjustments Good to have expertise in automating routine DBA task like log management backups schema migration indexing and monitoring Strong knowledge of various backup strategies e g pg basebackup WAL archiving and recovery procedures to ensure data integrity and availability Experience in Applying Patches and troubleshooting patch failure issues Strong work experience in UnixLinux Operating system and Shell Scripting Experience in implementing and managing replication solutions Streaming replication primary standby setup Logical replication Experience on Postgres failover and load balancing Understanding of user roles privileges authentication methods and best practices for securing PostgreSQL databases Ensure database security by implementing best practices including encryption access control and auditing Monitor and mitigate vulnerabilities in Postgres SQL environments Ability to implement and utilize monitoring tools to track database health performance metrics and identify potential issues Proficiency in scripting languages e g Bash Python for automating routine tasks deployments and maintenance Advanced knowledge of SQL for querying data manipulation and database object management Data migration from existing version to new versions Backup restore from Prod to non-prod Good to have experience in cross technology migration to Postgres ie From oracle SQL server to Postgres Strong analytical and problem-solving abilities to diagnose and resolve complex database issues Effective communication skills for collaborating with development teams system administrators and other stakeholders Ability to work effectively within a team environment You ll achieve more when you join HSBC HSBC is committed to building a culture where all employees are valued respected and opinions count We take pride in providing a workplace that fosters continuous professional development flexible working and opportunities to grow within an inclusive and diverse environment Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement which is available on our website Issued by - HSBC Software Development India