Home
Jobs

SQL Server DBA

5 - 10 years

7 - 11 Lacs

Posted:3 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

SQL Server DBA2
Key Responsibilities:
Database Management:
  • Manage, configure, and maintain
    SQL Server databases in high-availability environments (Active-Active).
  • Ensure optimal database performance, tuning queries, and optimizing resources.
  • Monitor and resolve database performance issues, minimizing downtime.

  • Cluster Setup and Management:
  • Design, implement, and support
    SQL Server AlwaysOn availability groups and
    failover clustering.
  • Ensure
    high availability and
    disaster recovery across multi-node SQL Server clusters.
  • Monitor and manage cluster health, replication, and failover processes.

  • On-Prem to AWS Migration:
  • Lead and execute migration of
    on-premise SQL Server databases to
    AWS cloud, including
    RDS and
    EC2 setups.
  • Plan, architect, and execute database migration strategies with minimal downtime and risk.
  • Configure databases in AWS environments, ensuring scalability, performance, and security.

  • Backup, Recovery, and Disaster Recovery:
  • Implement and manage
    backup and recovery strategies to safeguard critical data.
  • Test and maintain
    disaster recovery plans to ensure database availability during unforeseen events.
  • Manage database replication between on-premises and cloud infrastructure.

  • Security and Compliance:
  • Ensure databases adhere to security and compliance policies, implementing
    data encryption,
    access control, and
    auditing.
  • Regularly conduct
    security audits and apply patches and updates to mitigate vulnerabilities.
  • Collaborate with security teams to meet industry compliance standards.

  • Support and Troubleshooting:
  • Provide
    24/7 support for production databases, ensuring rapid resolution of any issues.
  • Troubleshoot and resolve complex database issues related to performance, availability, and security.
  • Document procedures, guidelines, and best practices for maintaining and optimizing SQL Server environments.

  • Automation and Scripting:
  • Automate routine database tasks, including backups, monitoring, and performance tuning using tools such as
    PowerShell,
    T-SQL, or other automation tools.
  • Continuously improve efficiency and reduce manual intervention in database operations.

  • Collaboration:
  • Work closely with development, infrastructure, and operations teams to ensure smooth database operations across all environments.
  • Provide guidance and best practices for database design, development, and optimization.

  • Required Skills and Qualifications:

  • 5+ years of experience as a SQL Server DBA in enterprise environments.
  • Strong knowledge of
    SQL Server clustering,
    AlwaysOn availability groups, and
    Active-Active setups.
  • Experience with
    on-premises to AWS migration for SQL Server databases.
  • Expertise in
    AWS RDS,
    EC2, and other AWS database services.
  • Proven experience in
    performance tuning,
    query optimization, and
    database maintenance.
  • Strong understanding of
    backup, recovery, and
    disaster recovery strategies.
  • Proficiency in
    T-SQL,
    PowerShell, and other automation scripting languages.
  • Excellent troubleshooting, problem-solving, and communication skills.
  • Mock Interview

    Practice Video Interview with JobPe AI

    Start Amazon Rds Interview Now
    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
    Jade Global
    Jade Global

    Information Technology and Services

    San Diego

    500+ Employees

    408 Jobs

      Key People

    • Neeraj Kumar

      CEO
    • Ankur Choudhary

      CFO

    RecommendedJobs for You

    Chennai, Tamil Nadu, India

    Indore, Madhya Pradesh, India

    Sahibzada Ajit Singh Nagar, Punjab, India