Senior SQL Server/MySQL DBA and Website Administrator (Based in Japan/JRF Global Operation)

JRF Intelligence Limited

JRF Intelligence Limited

JRF Intelligence Limited

Follow

Summary

  • Vacancy: —
  • Location: Japan
  • Salary: Negotiable
  • Experience: At least 8 years
  • Published: 12 Oct 2024

Requirements

Education

  • Bachelor of Science (BSc) in Computer Science & Engineering

Experience

  • At least 8 years
  • The applicants should have experience in the following business area(s):
    Software Company, IT Enabled Service

Responsibilities & Context

Database administration/Must have skills :

  • Minimum 8 years of experience in Microsoft SQL Server DBA and 6 years as MySQL DBA.

  • Operating Systems (MS Windows Server 2016/2019/2022 and Linux, UNIX)Microsoft SQL Server database from 2014/2016 up to 2022

  • MySQL Server 5.7 up to MySQL 8.4.2 LTS (understanding of MySQL 9.0.1/IR)

  • Must have Database Administration experience on AWS and other cloud environment and experience with cloud-based database services.

  • Proficient in scripting languages (e.g., PowerShell, Python, Linux, UNIX Shell Scripting) for automation of database tasks.

  • Install, configure, and maintain SQL Server and MySQL clustering, replication, backup, and recovery processes. 

  • Proficiency in SQL and T-SQL Development: Writing, understanding and modifying the existing SQL queries(CRUD, Joins, Sub queries etc.), stored procedures, functions and trigger.

  •  Experience in database maintenance, like fragmentation checks including daily backups and recovery, Off site backups. re-index operations, update statistics, and other system commands.

  • Perform database upgrades, patches, and migrations.

  • Automated Monitoring/Alerting

  • Performance Tuning/Collection/Analysis (MS PerfMon) and optimize queries to improve overall system performance.

  • Solid experience in High Availability (HA) and Disaster Recovery (DR) strategies for SQL Server i.e. Clustering, Mirroring, Log shipping, Replication, etc.

  • Experience performing database migrations and implement database security controls, including authentication, authorization, encryption, and access management.

Expertise in SQL Server tools (Profiler, DTA, SSMS, PerfMon, DMVs).

Web Hosting Skills.·

  • Manage website hosted on AWS, GoDaddy and Namecheap Server·       

  • Install, updates SSL Certificates·

Hosting technologies such as Apache HTTP Server, Microsoft Internet Information Services (IIS), Nginx and Tomcat.

  • Experience on managing e-commerce Websites.Desirable skills:·        Understanding of DevOps practices and tools (e.g., Bitbucket, CI/CD, Docker, Kubernetes).

  • No SQL Databases- such as DynamoDB, MongoDB etc.

  • PHP, Javascript, Ajax, HTML, CSS

  • Framework: Laravel, Bootstrap, Vuejs, Tailwind

Skills & Expertise

AWS

Database Administrator (DBA)

MCSA

MCSE

Microsoft Azure

Workplace

Work at office

Employment Status

Full Time

Job Location

Japan

Source link

To apply for this job email your details to admin@chakricircular.com