Senior Database Administrator (Postgresql)

Purpose
• Manage all daily activities within team
• Make sure all the instructions/tasks assigned by Head/Deputy CIO/CIO are clear and completed as per the deadline by all staffs.
• Coordinate teams with others to achieve the overall targets/goals of IT Division

KEY RESPONSIBILITIES:
• Deploy, monitor, operate and maintain all kinds of FE’s database on premise as well as on Cloud.
• Install and upgrade hardware and software; update patches, tune and optimize the databases, database servers and other softwares are running on database servers.
• Proactive monitor database systems, detect and prevent risks if any, set up critical thresholds, overloaded thresholds alerts and report to IT management in time to ensure database systems operation continuously.
• A leading quantitative fund is looking for a candidate who is a subject matter expert with hands-on experience supporting Oracle & PostgreSQL databases.
• This role will be primarily focused on production database administration for Oracle & PostgreSQL databases.
• Install, monitor, and maintain Oracle PostgreSQL & MySQL software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning and assist in business process integration with various data sources.
• Fulfills user requests ranging from access control, backup, restore, refresh to non-production to performance tuning.
• Create new service requests with vendors, monitoring and updating service requirements to solve problems related to databases
• Plan and deploy auditing, security policy for databases and database servers. Administrate and monitor the database firewall system to protect the database, set up warnings and prevent data loss through the monitoring system.
• Setup, administer and monitor database, ELT jobs, Golden Gate services, ODI, IBM Infosphere, SSIS…