Database Administrator (UNIX/Cloud: 4143)

Job Type
Haken
Salary
3,400 JPY - 3,700 JPY per hour
Japanese Level
None
English Level
Advanced (TOEIC 860)
Start Date
ASAP
Location
Tokyo

Description

This is an exciting opportunity for global minded application engineers to be able to work for one of the top E-Commerce Companies in Japan.

 

【Responsibilities】

- Carry out incident and problem management support to the highest standards and co-ordinate the resolution with the appropriate resolver groups

- Proactively detect problems related to service and infrastructure operations and delivery services conduct diagnostics and provide service request ownership to ensure resolution of user problems

- Create and maintain documentation including requirements, design, and user manuals

- Exposure to manage the development/QA environment.

- Implement user/objects & access rights management best practices

- Analyze query plan to improve performance

- Ensure database and service level objectives through proactive monitoring

- Exposure to backup and restore process

 

【会社概要 | Company Details】
グローバルに展開する一部上場インターネットサービス企業です。様々な事業を展開し、成長を続けています。日本にいながら異文化コミュニケーションができる国際的な環境かつ、女性や外国籍の管理職登用にも積極的なダイバーシティな環境でもあります。世界的にも知名度アップを図り、スポーツチームのスポンサーなども積極的に行っています。
エンジニアの方には嬉しい、WindowかMacを自分で選択することができます!社内カフェテリアは明るく、毎日食べても飽きないほど、メニューが豊富です!
スキルハウスから就業しているスタッフも多く、年間成約数もトップレベルを誇ります。会社同士の信頼関係も厚く、面接のプロセスもスムーズです。実際に企業に応募する前に、経験豊富な企業の専任担当より会社の様子など、詳しくお伝えいたします。また、日本語・英語でのレジュメの書き方のアドバイスや面接の準備もいたします。ケースbyケースですが、社内ツアーを設定することもできます。

Our client is a large global Internet service company that has enjoyed sustained growth as they continue to expand their business in various new areas and industries. This is a great opportunity to work in a diverse and international environment in Japan. Our client actively strives to be an equal opportunity employer, and they have many female and foreign nationals in upper management positions. Their brand has also gained global recognition as they sponsor some of the world's most famous sports teams. Our client prides themselves in providing a comfortable working environment for their employees. Engineers are welcome to choose their own setup (Windows/Mac, etc.); whatever makes them comfortable! Free meals are also provided at the company cafeteria. Their chefs work to create exciting new menus and dishes, so employees never get tired of the food!
 
【就業時間 | Working Hours】
9:00 - 17:30(Mon - Fri)
 
【休日休暇 | Holidays】
完全週休2日制(土日祝休み)、年末年始、年次有給休暇、その他特別休暇など
Saturday, Sunday, and National Holidays, Year-end and New Year Holidays, Paid Holidays, Other Special Holidays
 
【待遇・福利厚生 | Services / Benefits】
各種社会保険完備(厚生年金保険、健康保険、労災保険、雇用保険)、 屋内原則禁煙(屋外に喫煙所あり)、 通勤交通費支給等
Social insurance, Transportation Fee, No smoking indoors allowed (Designated smoking area), etc.

Required Skills

- Working experience as a DBA

- Working experience in Unix platforms

- Working experience in any cloud service provider like AWS, GCP, Azure.

- Good presentation, communication skills

- System operations and administration experience on enterprise systems

- Willingness to learn and find solutions to complex problems.

- Working knowledge in relational/columnar databases (e.g. Postgres, Presto, Hive, BigQuery, etc)

- Experience in DWH Environment (Knowledge of ETL/DI/BI Reporting)

Preferred Skills

- Understanding of Normalization and De-normalization concept

- Ability to write efficient SQL & exposure to query tuning

- Good hands-on in data modelling.

- Good working knowledge on Unix shell scripting, Python.

- Experience in infrastructure automation & configuration management tool like Terraform.

- Understand concept & the use of partitioned tables.

- Good knowledge on Airflow orchestration and preparing DAGs

- Good understanding of data archive/restore policies.

- Good at automating various processes.

- Good at users/objects/rights management.

- Some experience in an environment where ETL/BI tools such as Informatica, Tableau, Domo and Microstrategy are an important part of the environment