Responsibilities :

• Work within a team environment to ensure all database servers are backed up in a way that meets the business.Recovery Point Objectives (RPO).
• Test backups to ensure we can meet the business.Recovery Time Objectives (RTO) Troubleshoot SQL Server performance and outages as they occur, including after-hours and weekends.
• Configure SQL Server monitoring utilities to minimize false alarms Configure new SQL Servers to match the enterprise standard configuration.
• Deploy database change scripts provided by third party vendors.
• When performance issues arise, determine the most effective way to increase performance including server configuration changes, or index/query changes.
• Document the company MSSQL database environment.

Education and Experience :

Technical and Product Knowledge:

Has understanding of product or of supporting database technologyEmbraces new technology and is able to learn at a steady pace

Versatility of Work:

Knows fundamental concepts, practices, and proceduresWork is fairly routine; instructions are usually detailedFollows the process Performs work that is varied and more challenging in natureSome evaluation, originality, or ingenuity is requiredHas increased latitude to make decisions that might not always be reviewed

Independence Level:

Works under immediate supervision and performs assigned tasksProvides frequent status to manager or leadNeeds direction, knows when to ask questions, takes initiative to tackle tasks relevant to skill level Capable of and responsive to change .

Process Improvement:

Recognizes inefficiencies and makes suggestions for process improvementTroubleshooting:Able to initiateKnows when to seek adviceTakes initiative within skill levelDBA .

Job Specific Knowledge:

Good understanding of SQL or T-SQL Understands architecture of current RDBMS Good understanding of security best practices Proficient at creating views, stored procedures, functions and table structures.Has command of business process and procedure in writing code.Some understanding of or experience programming .

languagesCommunication:

Good communication with peers within the departmentComfortable having conversations with othersContributes ideas, feedback and suggestions within teamAble to communicate effectively with others outside the departmentJudgment.

Decision Making:

Makes some independent decisionsMay be looked upon to contribute to decision making processExpected to make decisions quicker