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.

We are currently seeking an experienced professional to join our team in the role of Technical Service Manager.

 

Business: CTO Infrastructure 

 

Principal responsibilities

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)
Requisitos

    Technical Expertise

    • 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. 

     

    Banking Domain Knowledge

    • 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. 

     

    Soft Skills

    • 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. 

     

    What additional skills will be good 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).

    Candidate with less relevant experience or skills may be offered a lower Global Career Band than stated above.

     

     

     

    HSBCLL/GZ*

    About HSBC Technology China

    We develop, implement and support software and IT services and processes that allow HSBC to remain at the forefront of high-quality banking systems.

     

    You’ll achieve more when you join HSBC.

     

    HSBC is an equal opportunity employer 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. We encourage applications from all suitably qualified persons irrespective of, but not limited to, their gender or genetic information, sexual orientation, ethnicity, religion, social status, medical care leave requirements, political affiliation, people with disabilities, color, national origin, veteran status, etc., We consider all applications based on merit and suitability to the role.

     

    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 (GuangDong) Limited***