MS SQL DBA Engineer

Job Responsibilities

Manage SQL Server databases

Configure and maintain database servers and processes

Monitor the system s health and performance

Ensure high levels of performance, availability, sustainability and security

Analyze, solve, and correct issues in real time

Provide suggestions for solutions

Refine and automate regular processes, track issues, and document changes

Assist developers with query tuning and schema refinement

Perform scheduled maintenance and support release deployment activities after-hours

Specific skills needed to perform or understand SQL queries, should be able to write queries for good support of database validations or logs

Good knowledge on high availability(Always ON, Replication, clustering etc.)

Able to make quick and right decisions during business hours and off hours on weekends if there is something wrong related to the database or server.

Should be able to make the right decisions on blocking issues

Troubleshooting slow-running queries and taking necessary steps to resolve them

Troubleshooting the failed backup jobs

SQL Server Version Upgrades

DBA is often needed to deploy the SQL Server portion of software releases