SQL - DBA

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
• 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.

Work Arrangements

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