Ms Sql Database Administrator

3 - 6 years

3 - 8 Lacs

Posted:6 days ago| Platform: Naukri logo

Apply

Work Mode

Hybrid

Job Type

Full Time

Job Description

Key Responsibilities:

  • Provide L2 support for MySQL database management, ensuring high availability and performance.
  • Perform

    database performance optimizations

    to enhance application responsiveness and efficiency.
  • Manage and troubleshoot

    table joints

    and

    triggers

    to ensure data integrity and optimized query performance.
  • Implement and maintain

    recommended backup policies

    to safeguard data, including regular snapshots and restoration processes.
  • Monitor and address

    query execution timeout

    issues and optimize queries for improved performance.
  • Analyze and mitigate

    asynchronous replication lag

    and configure both

    asynchronous and synchronous replication

    setups.
  • Conduct

    kernel patchings

    and

    database patchings

    to ensure the system is secure and up to date.
  • Optimize

    server configurations

    including CPU, memory, file system, and NAS settings to improve database performance.
  • Assist in

    migrations and upgradations

    of databases with minimal downtime and data loss.
  • Create and manage snapshots on Amazon RDS and restore instances/databases using snapshot restore techniques.
  • Utilize

    S3 buckets

    for efficient storage and backup solutions, ensuring proper data access and retrieval.
  • Implement

    tags creation

    for better resource management and cost tracking in cloud environments.
  • Manage

    SSL certificate renewals

    to maintain secure database connections.

Qualifications:

  • Proven experience as a

    MySQL DBA

    or in a similar support role.
  • Experience with cloud services, particularly

    AWS RDS

    .
  • Strong understanding of database concepts, including performance tuning, replication, and backup strategies.
  • Proficiency in MySQL server configurations and optimizations.
  • Familiarity with scripting languages for automation and system management.
  • Excellent problem-solving skills and ability to work under pressure.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You