Database Patch Management Engineer (Bank)

APJ Software (Hong Kong) Company Limited; Hong Kong; On-site; HKD 120,000 - 180,000; Full time

Job summary

APJ Software (HK) Company Limited in Hong Kong is seeking a Database Patch Management Engineer to lead end-to-end patching across Oracle, IBM DB2, MySQL and PostgreSQL. You will manage downloads, staging, application of security patches, and CVE remediation while ensuring data integrity and minimal downtime in live banking environments.

You will collaborate with application support, QA and risk teams, develop runbooks and rollback procedures, and implement automated checks to validate patch

Qualifications

• 5–7 years hands-on database patching in production banking environments
• Experience with Oracle, IBM DB2, MySQL and PostgreSQL patching and upgrades
• Linux/Unix server administration and shell scripting
• Strong data security and CVE remediation knowledge

Responsibilities

• Perform full lifecycle patching for Oracle, IBM DB2, MySQL and PostgreSQL
• Validate patch behavior against banking workloads and ensure data integrity
• Coordinate cross-environment rollout with zero-downtime strategies
• Develop runbooks, rollback procedures and SOPs
• Monitor post-patch health, replication lag and backups
• Collaborate with application teams for end-to-end testing after patches

Skills

Database patching

Linux/Unix

Shell scripting

Vulnerability remediation

Cross-team collaboration

Tools

Oracle

IBM DB2

MySQL

PostgreSQL

Data Guard

Job description

APJ Hong Kong (www.apjcorp.com.hk ) provides the highest quality software development, maintenance and testing services. We have cost effective service centers with highly qualified IT professionals in Hong Kong. Our clients include major enterprises and organizations in the Finance, Manufacturing, Public Utility, Retail, healthcare and Government sectors. We are looking for Database Patch Management Engineer.

You will be involving…

Hands-on full database patch lifecycle execution: Download, stage and apply security patches, PSU/RU fixes, cumulative fix packs and CVE remediation updates for Oracle, MySQL, PostgreSQL and DB2 databases; conduct manual and automated post-patch instance health validation and data integrity checks.

Work proactively with application, QA teams and business units to conduct compatibility impact assessments, validate database patch behaviour against core banking transaction workloads, and create priority schedules for critical/high severity vulnerability remediation.

End-to-end hands-on cross-environment deployment: Roll out patches and database upgrades across DEV, SIT, UAT, PREPROD and Production using zero-downtime rolling maintenance, such as Data Guard replication, read replica switchover and online migration methodologies to avoid business transaction outages.

Post-deployment hands-on validation: Manually monitor database instance status, table space utilisation, SQL performance, replication lag, transaction throughput and backup success; resolve outstanding patch compliance gaps, vulnerability exceptions and compile audit-ready execution logs and evidence.

Work with application support team to conduct end-to-end functional testing to verify application operational correctness after every database patch and version upgrade. Execute core banking business flow test cases, end-to-end transaction validation, report generation verification and batch job sanity checks jointly with app teams to confirm no functional defects.

Database version lifecycle management: Lead full technical end-to-end upgrades for Oracle, DB2, MySQL and PostgreSQL; execute in-place upgrades, offline/online database upgrade.

Conduct pre-upgrade infrastructure and data readiness assessments; author detailed technical runbooks, step-by-step deployment checklists, full manual rollback playbooks and standard operating procedures built from live banking database implementation experience.

Own full failure mitigation, rollback and database restoration workflows for interrupted/failed database upgrades. Activate pre-defined rollback procedures immediately upon detecting critical upgrade errors, corrupted schemas, data inconsistency or application breakdowns during maintenance windows; restore databases from point-in-time backups.

Technical change governance delivery: Draft technical RFC documentation, complete production risk impact assessments, present database change technical details during review meetings, and execute all production database maintenance with full traceable documentation

Maintain centralised database inventory matrix tracking all instance versions, patch levels and known vulnerabilities; generate regular EOS/EOL risk reports and patch compliance dashboards for infrastructure and risk teams.

Develop lightweight shell/SQL automation scripts to streamline repetitive patching, pre-check and post-validation tasks to reduce manual operational overhead and improve change success rates.

Participate in after-hours and weekend approved change windows for production database; perform hands-on root cause analysis for any database performance or data consistency issues introduced post-maintenance.

Document all rollback execution steps, failure root causes and restoration outcomes to continuously refine upgrade runbooks and reduce future failure risks.

We are looking for…

5-7 years proven hands-on technical experience delivering database patching, fix pack rollouts and full version upgrades within live banking/financial production environments.

Hands-on administration expertise across Oracle, IBM DB2, MySQL and PostgreSQL; strong practical experience with database binary patching, Patch Set upgrade, release Patch application, online migrations and rolling upgrade workflows.

Working knowledge on schema conversion, storage reorganisation and parameter refactoring to eliminate End-of-Support (EOS) and End-of-Life (EOL) database risks would be an advantage.

Practical expertise in database security hardening, user privilege control, encryption, audit logging, SSL/TLS database connections and remediating database CVEs and security vulnerabilities.

Performance tuning knowledge covering SQL execution plans, index maintenance, table space management, buffer pool tuning, replication health monitoring and backup/recovery validation for banking transactional workloads.

Demonstrated experience designing and executing post-upgrade application functional testing, as well as hands-on database rollback, point-in-time restoration and failure mitigation for interrupted or failure upgrade activities in production environment.

Hands-on Linux/Unix server administration, shell scripting and database native scripting (PL/SQL, SQL stored procedures) to automate pre/post patch validation checks, application sanity test scripts and rollback automation workflows.

Ability to independently build complete technical runbooks, upgrade test plans, full rollback procedures and audit-compliant technical documentation based on live production delivery experience.

Solid understanding of financial data security, banking data privacy compliance regulations, sensitive customer data handling and strong risk control awareness for production data stores.

Effective cross-team collaborator capable of aligning with application developers, middleware engineers, QA, cybersecurity and business unit stakeholders within a bank environment.

Fluent in written and spoken Cantonese (Chinese) and English for internal stakeholder communications and technical documentation.

APJ Software (HK) Company Limited (APJHK) is a leading software development and consulting company established since 2002 offering high quality business and engineering software solution consultation services, project management services, etc to many well-known companies and organizations such as largest public transportation operator, public utilities companies, leading financial services companies, etc in HK and the region. We also create advance e-business solutions that encompass state-of-the-art hardware and software technology such as mobile apps, websites, etc. to enhance productivity and efficiency of our clients.

APJ Software (HK) Company Limited (APJHK) is a leading software development and consulting company established since 2002 offering high quality business and engineering software solution consultation services, project management services, etc to many well-known companies and organizations such as largest public transportation operator, public utilities companies, leading financial services companies, etc in HK and the region. We also create advance e-business solutions that encompass state-of-the-art hardware and software technology such as mobile apps, websites, etc. to enhance productivity and efficiency of our clients.