Senior Database Administrator (PostgreSQL / MySQL)
citicclsa · Hong Kong SAR China
Job description
About the role
Citic CLSA is looking for a Senior Database Administrator who acts as the first point of contact for the most complex or escalated database issues and may guide team members. The role works closely with IT stakeholders, vendors and other teams to deliver high-quality database services.
Key responsibilities
- Provide DBA support for PostgreSQL and MySQL used by the application development team.
- Ensure the integrity, availability, security and performance of the database systems through technical support and maintenance.
- Monitor uptime and performance, recommend improvements, and assist with capacity planning, space management and data maintenance.
- Perform database enhancements, modifications, recovery and backups on a daily and weekly basis.
- Develop and maintain patches, and identify techniques that support business needs.
- Lead the development of automated monitoring and proactive intervention procedures to reduce downtime.
- Take part in creating development, staging and production instances and migrating between them.
- Proactively fix database operational problems and manage logins, user accounts and object permissions.
- Work morning and weekend shifts and on-call rotation.
Required profile
- Bachelor's degree or above in Computer Science, MIS or a related field.
- Around 10 years of relevant experience, including database administration and database programming; candidates with less experience may be considered as Sr Analyst.
- Ability to work non-standard shifts, including nights and weekends, and on-call duty.
- Good team player able to work under pressure with minimal supervision; strong English communication skills, Chinese an advantage.
Required skills
- Strong knowledge of database installation, upgrades and migration, and of applying PostgreSQL and MySQL patches and fixes.
- Database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/SQL, query and system tuning, backup and recovery, standby and replication.
- Command-line and database server administration, and capacity planning for storage, compute and memory.
- Networking and connectivity in a database environment.
- Nice to have: experience with other databases such as MS SQL, OceanBase or MySQL, BCP knowledge, Perl and Python scripting, and people management and leadership experience.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Hong Kong.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 23 minutes ago
Expires 1 month from now
3 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
citicclsa
Hong Kong SAR China
Related job offers
-
Lead Business Analyst, EQD (Commodity) IT
citicclsa Hong Kong SAR China -
Senior Project Manager, Commodity Options IT
citicclsa Hong Kong SAR China -
Senior Business Analyst / Project Manager, Compliance Applications
citicclsa Hong Kong SAR China -
Product Strategy
GoTymeX Hong Kong -
Senior Business Analyst - HR Applications
citicclsa Hong Kong SAR China