HomeOpen positionsMS SQL Database Administrator (DBA)

MS SQL Database Administrator (DBA)

REF. NO:
AT - DBA

REQUIREMENTS

  • MS SQL Server Certification or Experience 
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools 
  • Experience with backups, restores and recovery models 
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server 
  • Experience working with Windows server, including Active Directory 
  • Excellent written and verbal communication 
  • Flexible, team player, “get-it-done” personality 
  • Ability to organize and plan work independently 
  • Ability to work in a rapidly changing environment 
  • Ability to multi-task and context-switch effectively between different activities and teams 
  • Ability to participate actively and effective with a team 
  • Bachelors Degree in a technical-related discipline 

Beneficial:

  • Experience in the IT support environment 
  • Experience with the Content Server platform or other Enterprise Content Management solutions 
  • Bachelor’s degree in Information Systems or Computer Science 

RESPONSIBILITIES

 

More specifically, the SQL Server DBA provides direct technical support for clients’ OpenText Content Server solution suite (formerly Livelink Enterprise Server) and proactively and reactively manages such implementation.

 

In further detail, the MS SQL Server DBA will:

  • Manage Microsoft SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end: Respond to client support requests by identifying problems, researching solutions, and guiding clients through corrective steps
  • Refine and automate regular processes, track issues, and document changes
  • Assist developers with complex query tuning and schema refinement
  • On occasion, provide standby / accessible after hours support for critical production issues
  • Perform scheduled maintenance and support release deployment activities after hours
  • Ensure clients are informed of their system’s health and use through metrics tracking and reporting
  • Oversee periodic reporting and metrics gathering
  • Improve and enhance service desk procedures