Jobs
Interviews
ThinkSys Inc logo

Microsoft SQL Server Database Administrator (DBA)

3 - 6 years

0 Lacs

Noida Uttar Pradesh India

Posted:12 hours ago| Platform: Linkedin logo

Apply

Skills Required

sql server database security design installation configuration monitoring troubleshooting statistics powershell backup test restoration data consistency query resolve indexing maintenance updating clustering failover latency replication linux scripting postgresql

Work Mode

On-site

Job Type

Full Time

Job Description


The Microsoft SQL Server Database Administrator (DBA) is responsible for managing and maintaining SQL Server databases, ensuring their availability, security, and performance. This role involves database design, installation, configuration, monitoring, troubleshooting, and optimization.


  • Must have exposure to working in SQL Server 2017/2019/2022 versions.

  • Candidate must possess 3-6 years of experience in SQL Server administration.


Key Responsibilities:-


1. Database Administration:-


  • Install, configure, and upgrade SQL Server instances.
  • Create, modify, and manage databases, tables, statistics & indexes.
  • Troubleshooting jobs.
  • Understand and develop SQL queries & stored procedures.
  • Knowledge of PowerShell commands and scripting.


2. Backup and Recovery:-


  • Develop and maintain backup and recovery strategies.
  • Perform regular backups and test restoration procedures.
  • Ensure data consistency and minimize downtime during recovery.


3. Performance Tuning:-


  • Optimize database performance by analyzing query execution plans.
  • Identify and resolve performance issues related to indexing, query design, and resource utilization.
  • Index maintenance and updating stats.
  • Monitor server resources (CPU, memory, disk space) and adjust configurations as needed.


4. High Availability and Disaster Recovery:-


  • Configure and manage database clustering, and Always On Availability Groups.
  • Always On - Plan and execute failover and failback procedures, and troubleshoot latency and data consistency across replicas.
  • SQL Cluster - Troubleshooting cluster issues, flipping cluster roles, etc.
  • Thorough knowledge of Transaction replication - setup, failures, latency, and troubleshooting.


5. Good to have:-


  • Developing SQL queries & stored procedures Linux Basics.
  • PowerShell scripting skills PostgreSQL Database administration.

More Jobs at ThinkSys Inc

Senior Automation Test Engineer (Immediate Joiner)

Noida, Uttar Pradesh, India

5.0 - 5.0 yrs
|

Salary: Not disclosed

Senior Automation Test Engineer (5 years or above)

Noida, Uttar Pradesh, India

5.0 - 5.0 yrs
|

Salary: Not disclosed

Senior Automation Test Engineer (Immediate Joiner)

Noida, Uttar Pradesh, India

5.0 - 5.0 yrs
|

Salary: Not disclosed

Sr. Security Engineer – VAPT & Compliance

Noida, Uttar Pradesh, India

6.0 - 6.0 yrs
|

Salary: Not disclosed

Senior Security Engineer

Noida, Uttar Pradesh, India

6.0 - 6.0 yrs
|

Salary: Not disclosed

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.

Google Play App Store
coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
ThinkSys Inc logo
ThinkSys Inc

RecommendedJobs for You

ThinkSys Inc logo

Microsoft SQL Server Database Administrator (DBA)

ThinkSys Inc

Noida, Uttar Pradesh, India

ThinkSys Inc logo

Microsoft SQL Server Database Administrator (DBA)

ThinkSys Inc

Noida, Uttar Pradesh, India