Database Administrator - SQL Server (5-7 yrs)

Job Title : SQL Server DBA

Experience : 5-7 Years

Location : Remote

Key Responsibilities :

- Install, configure, and maintain SQL Server instances, including SQL Server 2019 and above.

- Perform routine health checks and monitor performance of SQL databases.

- Resolve log space, disk space, and database mirroring connectivity issues on production servers.

- Perform and document database restoration tests for critical applications

- Work with the Veeam team to validate database backups and restorations.

- Provide capacity planning and implementation support for database migration projects.

- Implement security groups and manage database access requests

- Resolve authentication and login-related issues affecting production reports and applications.

- Ensure compliance with security policies and best practices.

- Turn on SQL Profiler for performance monitoring and transaction tracking.

- Identify and resolve slowness issues, including database service unavailability problems.

- Work on Always On error resolutions and failover service checks.

- Perform database consistency checks and resolve data integrity issues.

- Provide support for Windows patching activities on SQL production servers.

- Follow up on server reboots and ensure system health post-maintenance.

- Participate in business continuity planning

Required Skills & Qualifications :

- Proven experience as an SQL Server DBA (5+ years preferred).

- Strong knowledge of SQL Server versions, including 2019 and above.

- Experience with database backups, restoration, and high availability solutions (Always On, Mirroring, Replication).

- Expertise in troubleshooting performance issues and optimizing queries.

- Familiarity with BI tools and Data Warehouse (DWH) concepts.

- Experience with security administration, authentication mechanisms, and access control.

- Proficiency in T-SQL scripting and database automation.

- Experience with monitoring tools such as Nagios.

- Excellent problem-solving and communication skills.

- Experience working with cloud-based database environments (Azure SQL).

- Knowledge of ITIL best practices for incident and change management.