Mongo/PostGreSQL DBA/Senior 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 Senior Consultant Specialist. In this role, you will: The job holder will be responsible for the technical delivery of projects, offering technical and process guidance to project teams, serving as a member of the Database Support team, and acting as a subject matter expert for the Mongo PostgreSQL. Provide expertise in database performance monitoring, tuning, and optimization to ensure efficient and reliable database operations. Manage and maintain high availability setups, replication configurations, and perform capacity planning and disaster recovery (DR) planning. Plan and execute backup and recovery strategies. Ensure adherence to delivery standards, including the quality of deliverables and proper documentation as per agreed service levels. Stabilize Mongo PostgreSQL environments while demonstrating ownership, commitment, and urgency in addressing issues and delivering solutions. Proactively review system performance and capacity in line with service level agreements (SLAs), identifying potential issues and recommending necessary changes. Collaborate with application teams to implement short- and medium-term adjustments to meet demand. Develop scripts and configure tools to automate database operations such as housekeeping and monitoring, capacity management, backup job scheduling and daily BAU work. Assess, analyze, develop, document, and implement changes based on change requests, ensuring a clear understanding of functional requirements and translating business needs into technical specifications. Provide incident troubleshooting support, perform root cause analysis, and implement measures to prevent recurrence, ensuring high-quality and sustainable solutions. Requirements To be successful in this role, you should meet the following requirements: At least 8+ years of technical experience in the following Install, deploy and manage MongoDB/PostgreSQL on physical, virtual machines and Google cloud platform. Create, configure and monitor large-scale, secure, MongoDB sharded clusters. Support MongoDB in a high availability, multi-data center environment. Administer MongoDB Ops Manager monitoring, backups and automation. Configure and monitor numerous MongoDB instances and replica sets Configure and monitor numerous MongoDB instances and sharded clusters. Automate routine tasks with your own scripts and open-source tools. Improve database backups and test recoverability regularly. Study the database needs of our applications and optimize them using MongoDB. Maintain database performance and capacity planning. Write documentation and collaborate with technical peers online. All database administration tasks like backup, restore, SQL optimizations, provisioning infrastructure, setting up graphing, monitoring and alerting tools, replication Performance tuning for high throughput. Architecting high availability servers. Good Understanding and experience with MongoDB sharding. Good Understanding and experience with Ops Manager and ATLAS. You ll achieve more when you join HSBC. .