SQL - DBA

NITYO; Bengaluru; On-site; INR 900,000 - 1,700,000; Full time

Job summary

NITYO is seeking a SQL Database Administrator (SQL DBA) to install, configure, maintain, secure, and optimize Microsoft SQL Server databases in Bengaluru. The role focuses on high availability, performance, backup, recovery, and security for business-critical applications.

Key responsibilities include installation, patching, tuning, monitoring, and documentation, with collaboration across DevOps and infrastructure teams to ensure robust database environments.

Qualifications

• Experience installing, configuring, upgrading, and patching Microsoft SQL Server.
• Ability to monitor and tune SQL Server performance.
• Experience with backups, DR strategies, and recovery testing.
• Knowledge of high availability configurations (Always On, log shipping).
• Security administration and auditing of database access.

Responsibilities

• Install, configure, and patch SQL Server instances.
• Monitor health and performance; optimize queries and indexes.
• Configure backups and disaster recovery.
• Maintain high availability and failover processes.
• Collaborate with DevOps and infrastructure teams.
• Document procedures and SOPs.

Skills

SQL Server administration

Performance tuning

Backup & recovery

High availability & DR

Security administration

Monitoring & maintenance

Tools

PowerShell

T-SQL

SQL Server Agent

Job description

SQL Database Administrator (SQL DBA)

The SQL Database Administrator (SQL DBA) is responsible for installing, configuring, maintaining, securing, and optimizing Microsoft SQL Server databases. The role ensures high availability, performance, reliability, backup, recovery, and security of database environments while supporting business-critical applications.

Key Responsibilities

• Database Administration
  • Install, configure, upgrade, and patch Microsoft SQL Server instances.
  • Create and maintain databases based on business requirements.
  • Configure SQL Server services and database settings.
  • Monitor database health and performance.
• Performance Tuning
  • Analyze slow-running queries and optimize SQL performance.
  • Create and maintain indexes.
  • Optimize stored procedures, functions, and views.
  • Monitor CPU, memory, disk I/O, and database growth.
  • Identify and resolve performance bottlenecks.
• Backup & Recovery
  • Configure Full, Differential, and Transaction Log backups.
  • Develop disaster recovery strategies.
  • Perform database restore testing.
  • Ensure Recovery Point Objective (RPO) and Recovery Time Objective (RTO) requirements are met.
• High Availability & Disaster Recovery
  • Configure and maintain SQL Server Always On Availability Groups.
  • Configure Database Mirroring, Log Shipping, or Failover Clustering where applicable.
  • Monitor replication and failover processes.
  • Participate in disaster recovery testing.
• Security Administration
  • Create and manage SQL logins, users, and roles.
  • Implement database security best practices.
  • Configure encryption (TDE) where required.
  • Audit database access and permissions.
  • Ensure compliance with security standards.
• Monitoring & Maintenance
  • Monitor SQL Server using native tools and third-party monitoring tools.
  • Configure SQL Server Agent Jobs.
  • Perform database consistency checks (DBCC).
  • Monitor error logs and Windows Event Logs.
  • Perform regular database maintenance.
• Capacity Planning
  • Monitor database storage utilization.
  • Forecast storage requirements.
  • Plan database growth strategies.
  • Recommend hardware improvements.
• Automation
  • Develop PowerShell, T-SQL, or SQL Agent jobs for automation.
  • Automate backup, monitoring, and maintenance tasks.
  • Create reusable administrative scripts.
• Troubleshooting
  • Resolve database outages.
  • Investigate blocking and deadlocks.
  • Troubleshoot replication issues.
  • Resolve login and connectivity issues.
  • Support production incidents and perform root cause analysis.
• Documentation
  • Maintain database architecture documentation.
  • Document backup and recovery procedures.
  • Create Standard Operating Procedures (SOPs).
  • Maintain change management documentation.
• Collaboration
  • Work with developers to optimize database design.
  • Support DevOps and application deployment activities.
  • Coordinate with infrastructure and cloud teams.
  • Participate in change management and release activities.

Requirements

• Mandatory skills
  • Install, configure, upgrade, and patch Microsoft SQL Server instances.
  • Create and maintain databases based on business requirements.
  • Configure SQL Server services and database settings.
  • Monitor database health and performance.
• Performance Tuning
  • Analyze slow-running queries and optimize SQL performance.
  • Create and maintain indexes.
  • Optimize stored procedures, functions, and views.
  • Monitor CPU, memory, disk I/O, and database growth.
  • Identify and resolve performance bottlenecks.
• Backup & Recovery
  • Configure Full, Differential, and Transaction Log backups.
  • Develop disaster recovery strategies.
  • Perform database restore testing.
  • Ensure Recovery Point Objective (RPO) and Recovery Time Objective (RTO) requirements are met.

Work Arrangements

• Location: Bengaluru, Karnataka, India | Hyderabad, Telangana, India | Chennai, Tamil Nadu, India
• Remote: Not specified