TopDev

SENIOR DATABASE ADMINISTRATOR

SSI Securities Corporation

1C Ngô Quyền, Phường Lý Thái Tổ, Quận Hoàn Kiếm, Thành phố Hà Nội
Job Description
About Company

Your role & responsibilities

Design And Implementation

  • Define the configuration for the database implementation within the organization. This shall include proper sizing and the detail requirement on parameters, file location, etc.
  • Determine and monitor the capacity and utilization of databases and corresponding hardware.
  • Determine the upgrade path for over utilized databases and corresponding hardware.
  • Verify the justification of the database requirement from vendors for their solution installing in the company.
  • Implement the design in professional manner.
  • Ensure zero data loss by proper backup/recovery mechanism design.
  • Ensure the database facilities operating and recovery within the agreed SLA.
  • Determine the best approach for system protection requirement such as load balancing, failover, remote site protection, etc.
  • Determine the risks in database facilities and the resolution to rectify the risks

 Operation Support

  • Perform any database cleansing ensuring the health working environment.
  • Implement ETL, clean up and transform external data to fit the desired format, efficiently importing large volumes of data extracted from multiple systems into a data warehouse environment.
  • Determine the effectiveness of the restoration for the database by the backup data.
  • Determine/define the mechanism for the monitoring of the performance & exceptions of the database facilities.
  • Determine/define the mechanism on detecting any issues happening in the database facilities in the campus.
  • Rectify the issues immediately if happening.
  • Perform user administrative activities on database level but not included user administration on application level.
  • Define/design the operation reports required to summaries the status of the database facilities for management. This shall include the utilization vs capacity, rate of availability, issues, etc.

Security & Authentication

  • Determine potential weaknesses of the database software and the company’s overall system.
  • Determine how to protect the database facilities.
  • Implement best practices to minimize security risks.
  • Set up access policy according to the company’s role matrix to control who has access and what type of access they are allowed.
  • Set up audit policy.
  • Consult audit logs in the case of a security breach or irregularity.

Documentation & Version Control

  • Document the design of the database facilities with the detail of diagram, system parameters and requirement, protection mechanism, and other related material as well as its historical changes becoming part of the IT Architecture Dossier.
  • Prepare the documents keep the latest and historical information of the facilities becoming part of the inventory control of the department.
  • Maintain the configuration document for each facility keeping the latest configuration parameter, historical changes on parameters in each device, and the method of changing the parameter becoming part of the Configuration Control and Version Control within the department
  • Prepare the operation guide for each facility.

Your skills & qualifications

  • University Degrees or above in IT, Computer mathematics or related subjects.
  • At least 5 years as Database Administrator in companies in the field of banking, finance, telecommunications or equivalent.
  • Expert knowledge of Oracle Database (12c and higher) or Microsoft SQL Server Database (2016 and higher), is a must.
  • IBM DB2, PostgreSQL and MongoDB administrative experience is an advantage.
  • In-depth experience of databases running on Unix server.
  • Solid experience in supporting High Availability database environment: various operating systems, clustering, HA, event debugging and issue resolution.
  • Proficiency in using PLSQL (or T-SQL, PL/pgSQL ...) is a strong advantage.
  • Experience of database tuning and capacity planning is an advantage.
  • Experience with securities trading systems is an advantage.
  • Knowledge with security model to manage risks through patching or innovative techniques.
  • Good presentation, written and verbal communication skill.
  • Communication skills, communication confidence, teamwork, good customer relations.
  • Ability to work independently, under pressure and large.

Benefits for you

  • Highly competitive remuneration package: Attractive monthly salary, 13th month salary, KPIs cash bonus, Public holiday cash bonus, Birthday gift, Lunar new year gift,...
  • Premium AON health care insurance and full labor insurance
  • 14 days Annual leave
  • Luxury team-building trip and varied engagement activities
  • Joining the leisure clubs: Football, E-Sport, Running, Gym, Yoga....
  • Fully sponsored training to build your career
  • Professional, open minded and supportive working environment
  • Working time: Mon - Fri | 08:00-17:00

Company

SSI Securities Corporation

Industry

Chứng khoán

Company size

500-999

Nationality

Vietnam

About us

dd9356fc82ae9403aa4390a08de457b0.JPG
SSI-Image-2.jpg

General information

Minimum year of experience

Level

Job Type

Contract type

⚙️ Candidates supporters

🧑🏾‍💻 Prepare for interviews

Checking TopDev QnA tool to practice your answers to common interview questions.

Read QnA for interviews