Senior Enterprise PostgreSQL DBA - Global Investment Bank in HK
Pinpoint Asia Limited
Hong Kong, Hong Kong, Hong Kong
Job type: fulltime
Job industry: Banking & Financial Services
- Responsible for the monitoring and uptime of all production databases.
- Ensures availability, security and integrity of assigned databases.
- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime.
- Develop Stored Procedures and Database Triggers in support of application development.
- Participate in application development projects and be responsible for database architecture and design.
- Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
- Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
- Responsible for regular backups and recovery of databases.
- Responsible for Query tuning and preventative maintenance.
- Analyzes long-term database performance trends to optimize database and application performance.
Skills and Experience:
- 5-10+ years of relevant experience in enterprise database administration in a mission-critical environment
- 3-5 years of experience as a hands-on PostgreSQL database administrator.
- Strong Knowledge on Database Installation, Upgrades and Migration.
- Strong Knowledge on applying PostgreSQL Patches and Fixes
- Experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
- Strong knowledge of Linux and shell scripting (e.g., Bash, Perl).
- Strong understanding of command line and database server administration.
- Capacity planning for all aspects of a database system (storage, compute, memory, etc.)
- Strong analytical, verbal and written communication skills.
- Ability to work in shift including nights and/or weekend on-call (rotation basis)
- Good team player. Capable of working under pressure and dynamic environment with minimal supervision
- Degree in Computer Science or any IT stream.
- Good Knowledge of MS SQL Servers
- Experience with automation and scripting skills using Perl, Python is a strong plus
- Strong ITIL principles are a plus.
- Understanding of networking and connectivity and how it relates to a database environment.
- Experience in Financial Services or other regulated industry preferred
- ORACLE database administration experience a plus
- Certified PostgreSQL DBA
If this outstanding opportunity sounds like your next career move, please send your resume in Word format to Matthew Chung at and put Senior Enterprise PostgreSQL DBA - Global Investment Bank in HK in the subject header.
Data provided is for recruitment purposes only.
Headquartered in Hong Kong, Pinpoint Asia is the go-to Specialist Firm for Technology Recruitment
We are a team of specialist tech recruiters (many of our recruiters come from an IT background) and we serve a wide range of clients, all the way from tech startups (especially FinTech) to some of the top Financial Institutions on Wall Street and several other large scale enterprises in other industries.
Our significant market reputation and status as the leading search firm for many of our clients is a direct result of our strong industry relationships, intimate understanding of the marketplace and proven ability to deliver results.
Our vision is to help companies hire smarter and help job seekers get closer to their career aspirations.
To see all our open jobs please reach out to us at (EA License # 62713)
We are also seeking top-calibre candidates for the following exciting roles:
1) VP/ED, Full-stack Development Lead - FICC Macro Tech - Elite Global i-Bank (Can Sponsor Work Permit)
2) Data Engineering & Analytics Platform Development Lead
3) Senior Network Engineer / L3 Support (VP) - Elite Global Investment Bank