Sr. SQL DBA

GAVS Technologies N.A., Inc; Chennai District; On-site; INR 700,000 - 1,300,000; Full time

Job summary

GAVS Technologies N.A., Inc. is hiring a SQL Database Administrator responsible for the health, performance, security, and availability of SQL Server databases.

You will install, configure, and upgrade instances, set up environments, and implement robust backup and recovery strategies. The role involves monitoring performance with SSMS, Profiler, and DMVs, tuning queries, ensuring HA/DR with Always On or replication, managing security, and performing routine maintenance while collaborating with

Qualifications

• Installation, configuration, and upgrading of SQL Server instances.
• Backup, recovery design and testing for data availability.
• Monitoring and tuning performance with SSMS, Profiler, and DMVs.

Responsibilities

• Install and configure SQL Server instances and related tools.
• Set up database environments, including file groups, storage paths, and network configurations.
• Design, implement, and manage backup and recovery strategies.
• Perform regular backups and test recovery procedures.
• Monitor database performance and identify bottlenecks, tuning queries and indexes.
• Ensure database security with roles, permissions and audits.
• Implement HA/DR solutions (e.g., Always On, mirroring, replication).
• Perform routine maintenance: index rebuild/reorganize, statistics updates, integrity checks.
• Set up monitoring and alerting to proactively address issues.

Skills

SQL Server

Performance tuning

Backup & recovery

Security management

HA/DR

Automation scripting

Tools

SSMS

SQL Server Profiler

DMVs

Job description

SQL Database Administrators (DBAs) are responsible for the overall health, performance, security, and availability of SQL Server databases. Their roles and responsibilities are multifaceted and critical to any organization relying on data.

Key Roles and Responsibilities of an SQL DBA:

• Installation and Configuration:Installing, configuring, and upgrading SQL Server instances and related tools.
• Setting up database environments, including file groups, storage paths, and network configurations.
• Backup and Recovery:Designing, implementing, and managing robust backup and recovery strategies.
• Performing regular backups and testing recovery procedures to ensure data recoverability.
• Performance Tuning and Optimization:Monitoring database performance using tools like SQL Server Management Studio (SSMS), SQL Server Profiler, and DMVs.
• Identifying and resolving performance bottlenecks through query optimization, index tuning, and server configuration adjustments.
• Security Management:Implementing and maintaining database security policies, including user access controls, roles, and permissions.
• Conducting security audits and ensuring compliance with relevant regulations.
• High Availability and Disaster Recovery (HA/DR):Implementing and managing HA/DR solutions like Always On Availability Groups, database mirroring, or replication to minimize downtime and ensure business continuity.
• Maintenance and Monitoring:Scheduling and performing routine database maintenance tasks such as index rebuilding/reorganizing, statistics updates, and integrity checks.
• Setting up monitoring and alerting systems to proactively identify and address potential issues.
• Troubleshooting and Incident Management:Investigating and resolving database-related incidents and problems in a timely manner.
• Performing root cause analysis for critical issues.
• Capacity Planning:Monitoring database growth trends and planning for future storage and performance requirements.
• Automation and Scripting:Developing and maintaining scripts (e.g., PowerShell, T-SQL) to automate routine administrative tasks.
• Documentation and Collaboration:Maintaining comprehensive documentation of database configurations, procedures, and troubleshooting steps.
• Collaborating with developers, system administrators, and other IT teams to ensure efficient database usage and support application development.