Senior Sql Database Administrator

Skills
Microsoft AzureMicrosoft SQL ServerSQLDatabase Administration
Role

What the job involves

The main requirements, responsibilities and hiring steps.

Requirements

  • 5+ years of experience working in similar roles
  • Experience working in SQL Server Production Environments and managing critical situations
  • Experience working with SQL Server FCI & AlwaysON, troubleshooting & configuration
  • Experience and troubleshooting backups, restore and database maintenance activities
  • Familiarity with T-SQL scripting
  • Understanding query tuning concepts and identifying performance bottlenecks
  • Understanding the SQL Server setup, storage and best practices
  • Knowledge of the SQL Server data structures
  • Knowledge of the SQL Server architecture and database design/layout
  • Strong written and spoken English
  • Problem-solving skills and ability to think analytically
  • Willingness to learn based on feedback
  • Ability to identify opportunities and issues in SQL Server environments
  • Ability to work independently and as a part of a team
  • Ability to help plan tasks for less experienced team members and to support and mentor

Nice to have

  • Experience working with Azure SQL Databases and Azure SQL Managed Instance
  • Knowledge of the Azure Infrastructure & Azure Backup Services
  • Basic concepts of Azure DevOps
  • Experience of other databases including but not limited to CosmosDB, Postgres, MySQL
  • Experience of SQL Server Migrations to the public cloud

Day to day

  • Establishing the access needs and security requirements of users and managing them
  • Identifying SQL database/instance performance optimisations, performing SQL Server patching, and supporting customer release deployment activities and upgrades
  • Writing database & client documentation, including procedures and definitions for customer environment specifics