Consultant Specialist, HSBC

HSBC

Location:
India, Hyderabad

Category:
IT - Administration

Contract Type:
Employment contract

Salary:

Not provided

Save Job

Apply Position

Job Description:

HSBC is seeking a Consultant Specialist for PostgreSQL Database Support. Responsibilities include implementing, managing, and securing complex database environments, performance tuning, and contributing to technical competency development for the team. The role demands expertise in PostgreSQL architecture, SQL, and Unix/Linux environments, along with strong analytical skills and effective communication.

Job Responsibility:

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:

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 Unix\Linux 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.

Nice to have:

Expertise in automating routine DBA task like log management, backups, schema migration, indexing and monitoring
Good to have experience in cross technology migration to Postgres (ie. From oracle\SQL server to Postgres).

What we offer:

Flexible working
Opportunities to grow within an inclusive and diverse environment
Continuous professional development.

Additional Information:

Job Posted:
September 11, 2025

Expiration:
September 16, 2025

Employment Type:

Fulltime

Work Type:

On-site work

View All Jobs In This Company

Job Link Share:

Consultant Specialist