Description

• Ensure availability and performance of the databases that support online services and business operations (e.g. system monitoring, performance tuning, routine maintenance tasks, etc.)
  
• Perform capacity planning to properly identify required hardware, software, database configuration/architect necessary to support application needs.
  
• Enforce best practices for improving performance, scalability and operational manageability of production databases.
  
• Create and perform database and system maintenance policy and procedures.
  
• Perform and document disaster recovery functions.
  
• Work with development team to coordinate new data development ensuring consistency and integration.
  
• Work with Database Analyst to optimize all database objects, stored procedures, tables, views, triggers, indexes, user-defined functions and SSIS packages.
  
• Knowledge of Policy Management, Resource Governor and dynamic management views
  
• Part of on-call rotation to respond to and resolve database issues to ensure production applications are online