Senior MS SQL DataBase Administrator

  • Full Time, Noida
  • Experience- 5+ years
  • Number of Position(s): 1
Senior MS SQL DataBase Administrator

Senior MS SQL Database Administrator | ThinkSys

Lead MS SQL Server performance, security, and availability at ThinkSys. Manage complex databases, optimization, backups, and high-availability systems.

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, 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
  • PosgreSQL Database administration

Benefits Offered

  • Flexible Work Hours.
  • Work on impactful, industry-changing projects.
  • Continuous learning and career growth opportunities..
  • Collaborative, innovative, and inclusive environment.
  • Insurance – Group Medical Coverage, Employee Personal Accident,
  • Maternity and Paternity Leaves.
  • Performance Feedback Sessions.
  • Competitive Compensation.
  • Rewards and Recognition Program, Employee Referral Program, Fun Events.