Technical Service Manager, HSBC

HSBC

Location:
China, Shanghai

Category:
IT - Administration

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

We are currently seeking an experienced professional to join our team in the role of Technical Service Manager. 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.

Job Responsibility:

Core Banking System Database Management
Oversee the end-to-end lifecycle management of Oracle databases supporting critical banking systems (e.g., payment clearing, customer accounts, risk control, regulatory reporting), ensuring 24x7 high availability (SLA 99.999%+) through architecture design, deployment, monitoring, backup/recovery, and version upgrades
Lead Oracle RAC cluster architecture design and performance tuning, resolving node resource contention, Cache Fusion lock competition, cross-instance transaction latency, and optimizing cluster throughput and scalability
Implement Data Guard physical/logical standby solutions with Fast-Start Failover (FSFO) for sub-second automated failover
Conduct regular disaster recovery drills to achieve RPO and RTO
Manage Oracle Exadata environments, optimizing storage cell resource planning for hybrid OLTP/OLAP workloads, leveraging Smart Scan and Hybrid Columnar Compression to enhance query performance
High Availability Architecture & Performance Optimization
Perform deep SQL optimization using SQL Trace, AWR/ASH reports, and SQL Monitor to diagnose bottlenecks
Design indexing strategies, materialized views, and partitioning schemes to minimize full-table scans and lock contention
Develop elastic scaling solutions for banking peak loads (e.g., quarterly interest accrual, bulk payments), leveraging Transparent Application Continuity (TAC) for seamless session failover and transaction continuity
Establish capacity planning models to forecast storage, CPU, and IOPS requirements based on historical trends and business needs
Design cost-effective scaling strategies (e.g., Oracle DBaaS elasticity)

Requirements:

10+ years as Oracle DBA, 5+ years in financial core systems
Expert in Oracle 12c/19c/23i architecture (Buffer Cache, Undo/Redo, ASH/ADDM)
Proficient in RAC troubleshooting (split-brain resolution, node eviction) and OCR/Voting Disk disaster protection
Hands-on experience with Data Guard Broker, FSFO, Active Data Guard, and Rolling Upgrades
Skilled in SQLT, AWR, and SQL Monitor to resolve enq: TX lock contention, latch competition, and I/O bottlenecks
Optimized Exadata Smart Scan, storage indexes, and data compression strategies
Experience with Oracle Cloud@Customer or DBaaS deployments, integrating cloud backup/monitoring/KMS
Proficient in Shell/Python scripting for automated backups, stats collection, and log analysis
Deep understanding of banking transaction patterns (ACID compliance, high-frequency payments, batch processing) and ability to anticipate database stress scenarios
Familiarity with financial regulations to ensure audit-compliant database designs
Resilience & Adaptability: Proven track record resolving critical outages (e.g., RAC node failures causing global transaction blocks) within 30 minutes
Coordination & Ownership: Experience in multi-timezone collaboration and driving cross-departmental initiatives
Communication & Documentation: Fluent English able to draft technical proposals and present risks to global stakeholders

Nice to have:

Oracle OCM, Exadata Implementation Specialist certifications
Experience in core banking system migration (e.g., Oracle to distributed databases)
Experience with other mainstream databases such as MongoDB, Mysql, PostgreSQL etc
Familiarity with other domestic databases (such as OceanBase, TiDB, PolarDB, TDSQL)

What we offer:

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

Additional Information:

Job Posted:
June 02, 2025

Expiration:
July 30, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Technical Service Manager