MS SQL DBA

Role: Database Administration -MSSQLDBA
Required Technical Skill Set (Skill Name)- MSSQL DBA
Exp: 6 - 12 Years
Skills: MSSQL, DBA, SQL Server 2019, SQL Server 2016/2017


Role Descriptions:


Desired Competencies (Technical/Behavioral Competency)


Must-Have
• Manage day-to-day operations of databases including monitoring, backups, and routine maintenance tasks.
• Strong understanding of database architecture and design principles.
• Extensive experience with database performance tuning and optimization techniques.
• Troubleshoot and resolve database issues such as performance bottlenecks and connectivity problems.
• Design and implement high availability and disaster recovery solutions for critical databases.
• Implement and maintain database security measures, including user access controls and data encryption.
• Plan and assist in database upgrades, patching, and migrations.
• Collaborate with development teams to optimize database schemas and queries for performance.
• Document procedures and best practices for database management and maintenance.
• Familiarity with database administration tools for monitoring and maintenance.
• Expertise in database clustering, Always on Availability groups, and failover technologies.
• Install SQL server on standalone and always on clusters


Good-to-Have
• Client performance troubleshooting, Application Performance Monitoring
• Strong problem-solving and troubleshooting skills.
• Good communication skills for collaborating with team members and stakeholders.
• Conduct capacity planning and resource forecasting
• PowerShell scripting for automations


Role descriptions / Expectations from the Role
• Manage Maintain and Administer databases overall
• Troubleshoot and resolve database issues
• Plan, Assist and do upgrades and Maintenance activities as and when required