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 forDatabase Infrastructure Engineer.

You will be involving…

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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.
9. 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
10. 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.
11. 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.
12. 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.
13. 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…

1. 5-7 years proven hands-on technical experience delivering database patching, fix pack rollouts and full version upgrades within live banking/financial production environments.
2. 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.
3. 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.
4. Practical expertise in database security hardening, user privilege control, encryption, audit logging, SSL/TLS database connections and remediating database CVEs and security vulnerabilities.
5. 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.
6. 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.
7. 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.
8. Ability to independently build complete technical runbooks, upgrade test plans, full rollback procedures and audit-compliant technical documentation based on live production delivery experience.
9. Solid understanding of financial data security, banking data privacy compliance regulations, sensitive customer data handling and strong risk control awareness for production data stores.
10. Effective cross-team collaborator capable of aligning with application developers, middleware engineers, QA, cybersecurity and business unit stakeholders within a bank environment.
11. Fluent in written and spoken Cantonese (Chinese) and English for internal stakeholder communications and technical documentation.

If you are interested, please feel free to apply with your full resume, present/expected salary, and availability by click on the 'Apply Now' button.