Job Details

Key Result Areas:

• Develops and executes long-term strategic goals for production databases in conjunction with data owners and department managers.
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
  
• Design and implement redundant systems, policies, and procedures for backup and recovery, disaster recovery, data archiving, and change control to ensure effective protection and integrity of data assets.
  
• Collaborates with business analysts to identify database requirements and design databases; with application developers to develop database architectures, coding standards, and quality assurance policies and procedures; and with business intelligence staff to fulfill needs of data warehouses.
  
• Creates and manages databases. Optimizes performance through SQL code reviews and walk-throughs, proactive monitoring of the database environment, and making changes to data structures, SQL and the DBMS subsystems.
• Supports database functions by designing, coding and supporting utilities.
• Develops and supports integrations to systems outside the company.
  

Key Technical Competencies:

• Experience with database administration for MS SQL Server.
  
• Experience in troubleshooting and resolving database problems.
  
• Experience in performance tuning and database optimization, using native monitoring and troubleshooting tools.
  
• Experience with backups, restores and recovery models.
  
• Knowledge of high availability and disaster recovery options for MS SQL Server.
  
• Experience in implementing operational automation using scripts.
  
• Knowledge of indexes, index management, and statistics.
  
• Experience working with Windows server, including Active Directory and proper disk configurations.
  
• Good communication and documentation skills.
  
• Ability to work independently and give attention to detail.
  
• Ability to be flexible, such as the ability to work on multiple tasks, handle interruptions, and adapt to changing priorities.
  
• Bachelora??s degree in Business, Computer Science, Software Engineering or related field.
  
• Practical experience can be used in lieu of education.