Exp: 5-7 Yrs
Remote
full time
Shift: S2
Immediate
Primary Skills: MS SQL DBA
Secondary Skills: Azure SQL
Job Summary:
The SQL Server Database Administrator (DBA) is responsible for the design, implementation, maintenance, and optimization of Microsoft SQL Server databases. The role involves ensuring the availability, security, performance, and integrity of databases, as well as collaborating with development teams and other IT professionals to deliver effective database solutions.
Responsibilities:
Database Management:
Install, configure, and upgrade SQL Server instances.
Create and manage database objects, such as tables, indexes, views, and stored procedures.
Monitor and maintain database performance, including query optimization and troubleshooting.
SQL Server Migration and Upgrade
Database Migration using the backup/restore method.
Detach/Copy/Attach databases from the source SQL server instance to target.
In place / Side by side DB migration.
Backup and Recovery:
Develop and implement database backup and recovery strategies.
Regularly perform database backups and verify their integrity.
Plan and conduct disaster recovery tests to ensure data availability.
Security:
Implement and manage database security measures, including access control and user authentication.
Monitor and audit user activities to ensure data security and compliance with regulations.
Performance Tuning:
Identify and resolve performance issues, such as slow queries and resource bottlenecks.
Optimize database configurations for better overall performance.
High Availability:
Configure and manage database replication, clustering, and mirroring for high availability.
Implement failover mechanisms to minimize downtime in case of server failures.
Capacity Planning:
Monitor database growth and resource utilization.
Plan for and implement necessary scaling strategies to accommodate data growth.
Automation:
Develop scripts and automate routine database maintenance tasks.
Implement database deployment au