Location: HKEX - TKO Shift: Standard - 40 Hours (Hong Kong SAR) Scheduled Weekly Hours: 40 Worker Type: Permanent Job Summary: We are seeking a motiva..
Location: HKEX - TKO Shift: Standard - 40 Hours (Hong Kong SAR) Scheduled Weekly Hours: 40 Worker Type: Permanent Job Summary: We are seeking a motivated and energetic Principal Database Specialist to join our Database team. Our team maintains the administration and support for the company-wise database infrastructure. We play a critical role to maintain these company-wise systems that are critical to daily business operation. We also partner with application and infrastructure teams to operate our systems in such fast growing financial markets in Hong Kong. If you want to make an impact, come and join us. Job Duties: Responsibilities: Perform database administration and support services in Linux, Windows and Cloud platform; Implement and support infrastructure solutions in sophisticated, high-performance trading environments that demand stability, high throughput and low latency; Provide support and implementation work to application teams including database setup and SQL performance analysis; Provide advice for operating policies, technical architecture and configuration of database system; Administer and manage Oracle Databases / IBM DB2 including monitoring, troubleshooting, installation, patching and upgrade, performance tuning, backup and recovery, stress test, capacity planning; Implement compliance standards and perform regular system compliance review and proactively assesses exposure area; Maintain high system availability and ensure all database systems work properly; Review SQL, stored procedures and application interfaces with databases; Manage vendor to ensure the highest quality delivery and implementation Requirements: With at least 7 years of working experience in managing and supporting Oracle / IBM DB2 databases; Solid experience with SQL, PL/SQL and shell script/programming would be an advantage; Advanced knowledge of Oracle database including RAC, ASM, DataGuard, data partitioning, load balancing, JDBC, ODBC and integration with J2EE applications; Strong in SQL and stored procedures; Advanced knowledge of database security, backup and recovery, and performance monitoring standards; Strong hands-on experience in developing script solutions for process improvement and automation; Experiences in MQ, AWS RDS, MS SQL and MongoDB is an advantage; Understanding of relational and dimensional data modelling; Experience in system programming and administration on Linux or Windows Platform; Project management experience in sizable scale technology infrastructure implementation; Proactive, strong troubleshooting, diagnostic and analytical skills; Degree holder in Computer science, Computer engineering, information technology or relevant discipline Company Introduction: Hong Kong Exchanges and Clearing Limited (HKEX) is one of the world's major exchange groups, and operates a range of equity, commodity, fixed income and currency markets. HKEX is the world's leading IPO market and as Hong Kong's only securities and derivatives exchange and sole operator of its clearing houses, it is uniquely placed to offer regional and international investors access to Asia's most vibrant markets. As the global markets leader in the Asian time-zone, we offer a world of opportunities for early careers and experienced hires. Here, we know that diverse thinking fosters better solutions, and we are committed to building an open and dynamic environment which allows our business to innovate and our people to thrive. Discover the latest career opportunities and programmes at HKEX. HKEX is committed as an Equal Opportunity Employer. Diversity is one of our core values and we look to support, respect diverse perspectives, abilities, culture and experiences within our workplace.
