mssql dba l2.

Sr. No

Job Description / Desired Skills

Assessments by Partner

1

Installation, configuration and upgrading of Microsoft SQL Server server software and related products. Evaluate MSSQL features and MSSQL related products. Establish and maintain sound backup and recovery policies and procedures.

2

Implement and maintain database security (create and maintain users and roles, assign privileges).

3

Database performance tunning and optimization.

4

Setup and maintain documentation and standards.

5

Plan growth and changes (capacity management planning).

6

Do general technical trouble shooting and give consultation to development teams.

7

Interface with MSSQL for technical support.

8

Must have SQL clustering installation troubleshooting skills.

9

Must have SQL log shipping /mirroring / replication installation and troubleshooting skills.

10

MSSQL DR drill executions and coordination's.

11

T-SQL scripting knowledge for automation tasks.

12

ITIL Skill set requirement (Problem Management/Incident Good

13

Understanding of Windows

14

Apply RDBMS patches or upgrade the Edition/Instances as and when required, as per the approval from the respective Team Leaders.

15

Will have to do compliance audits of the setups done by the fellow engineers to make sure that the setup being handed over to the customer is done to the customer’s satisfaction.

16

Need to make sure that issues are handled in right time frames as per the SLA / commitments