Responsibilities:

• Understand and apply advanced database administration, management and performance tuning techniques specific to SQL Server

• Proactively identify trends in SQL statements and provide recommendation for efficient use of resources

• Proactively identify resource requirements to ensure high availability of database systems

• Provide technical advice and expertise to less senior staff members

• Provide 24x7 on call support as part of a scheduled rotation with other team members

• Provide advanced technical troubleshooting for applications and database systems with emphasis on root cause analysis

Ability to perform the following:

• Participate in design and application review sessions, assist with definition of computing standards and recommend policies related to those standards
• Research solutions to various business and technical problems, evaluate alternatives and be able to present recommendations and justifications to management
• Configure and tune hardware and software to insure optimum performance and resource utilization
• Develop advanced shell scripts, SQL scripts in support of database operations
• Enforce Security policies and procedures on databases
• Write and maintain documentation describing changes and modifications to all systems and databases
• Perform exports, backups, restores, refreshes and data extracts as required
• Act as technical liaison in support for database related project activities
• Develop strong working knowledge of key applications and their interaction with the database