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