PostgreSQL Database Support/Consultant Specialist

Job Description Some Careers Have More Impact Than Others. If you're looking for a career where you can make a real impression, join HSBC and discover how valued you'll be. 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 Principal Responsibilities 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. Qualification : A Bachelor degree or equivalent experience with a major or minor in Computer Science or related field. Requirements - 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. - Experience to 8 years - 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. www.hsbc.com/careers 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