As a Database Administrator, you are the primary on the most complex or escalated issues and may provide direction and guidance to team members. You will work closely with IT stake holders, vendors and other teams to deliver high quality database services.
Key Areas of Responsibilities
Offer DBA PostgreSQL / MYSQL support for application development team.
Ensure integrity, availability, security and performance of POSTGRESQL / MYSQL database systems by providing technical support and maintenance.
Monitor database uptime, performance and recommend improvements for operational efficiency.
Assist in capacity planning, space management and data maintenance activities for database system.
Perform database enhancement and modification as per the requirements.
Perform database recovery and backup tasks on daily and weekly basis.
Develop and maintain patches for database environments.
Identify and recommend database techniques to support business needs.
Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
Responsible for pro-active remediation of database operational problems.
Manages logins and user accounts, including assigning database object permissions and privileges.
Rotation for morning and weekend support/on- call
Requirements
Bachelor’s degree/above in Computer Science, MIS or related
5-8 years of relevant experience including database admin, database programming, including 3 years as a hands on PostgreSQL / MYSQL database administrator
Strong Knowledge on Database Installation, Upgrades and Migration
Strong Knowledge on applying POSTGRESQL / MYSQL Patches and Fixes
Experience in POSTGRESQL / MYSQL 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
Strong analytical, verbal and written communication skills in English, and Chinese will be of advantage
Capacity planning for all aspects of a database system (storage, compute, memory, etc.)
Additional Requirements
Good Knowledge of MS SQL Servers will be of advantage
Experience with automation and scripting skills using Perl, Python a strong plus
Strong ITIL principles is a plus
Understanding of networking and connectivity and how it relates to a database environment
Experience in Financial Services or other regulated industry
Good team player. Capable of working independently under pressure and dynamic environment
#J-18808-Ljbffr
工作資料:
公司名稱: CLSA
職位: Sr Manager, Databases, IT
工作地點: 香港
國家: HK
如何提交申請:
在閱讀並了解職位資料中說明的入職標準及最低資格要求後, Sr Manager, Databases, IT at the office 香港 以上,請立即準備好求職信、履歷表(CV)、畢業證書副本及其他證明文件。請透過下方的「下一頁」連結提交申請。
詳情: Leadingnation in 香港 seeks a Quantitative Research Intern to work on quantitative finance projects and model the work of full-time employees. You will engage in a comprehensive education program...
詳情: Role Description The Consulting Analyst / Research Director is responsible for leading research initiatives, delivering strategic analysis, and providing high-impact recommendations that support busin...
詳情: Our client is a leading international engineering and consulting group with a strong presence across Europe and Asia. The 公司名稱 delivers multidisciplinary services spanning design, project managemen...
詳情: Leadingnation is seeking an experienced finance professional in 香港 to manage monthly reporting, budgeting, and forecasting. The ideal candidate will have up to 6 years of experience in finance,...
詳情: We are looking for a high calibre HR professional to join our Rewards and Governance (R&G) team in the Group Human Resources Department. Key responsibilities and requirements of the 職位 are summa...