SQL Database Administrator

Skills

Strong verbal and written communication skills Ability to develop and grow interpersonal relationship within and across teams Expert knowledge of common database administration tasks such as backup & restore recovery models integrity checks and replication methods. Experience automating SQL Server administration tasks and workflows at scale. Modern SQL Server High Availability & Disaster Recovery features. Familiarity with modern SQL Server data protection and security features. Firm understanding of the most prominent Azure database technologies such as Azure SQL Database and Azure SQL Managed Instance. Fundamental knowledge of performant T-SQL code is required strong expertise in this area is a bonus. Experience with Azure Cosmos Db Experience with common tools utilized in our environment such as Splunk Litespeed SQL Backup Git ServiceNow Foglight and Spotlight. Experience developing and delivering presentations.

Description

As a Senior Database Administrator at client place, you will work as part of our Database Operations team to support a complex data tier based on Microsoft SQL Server. The ideal candidate for this role will have a passion for building, designing, and supporting complex and mission-critical data solutions with some experience in translating large-scale environments into the Microsoft Azure cloud environment.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Responsibilities for a Senior Database Administrator may vary, but should include:
Work independently and take a lead role on projects with minimal supervision.
Serve as a go-to resource for questions related to database systems.
Identify database performance and capacity requirements by analyzing current workloads and utilizing best practices.
Serve in an architectural capacity for database high availability and disaster recovery design.
Support team initiatives by developing tools and identifying opportunities for process automation; assist in evaluation and selection of standard tools.
Support and build automated environment installation and setup processes.
Interact positively with customers to support processes critical to business operations.
Monitor and troubleshoot database instances; perform root-cause analysis; identify opportunities for improved system performance, assist development teams with implementation.
Work closely with System Administration team to support infrastructure enhancements and maintenance.
Participate in production support on-call rotation to triage and resolve critical issues outside of business hours.
Contribute to other team efforts as needed to support day-to-day database operations.
Drive vulnerability remediation
Create and manage database standards

Responsibilities

• 8+ years of experience in an Information Technology environment with at least 5 years in an operational role directly supporting MS SQL Server.
• Prior experience working with large (2tb+) transactional databases.
• Prior experience working at scale across a large environment with hundreds to thousands of databases in-scope.
• Experience translating environments into Azure Managed Instance and other Azure technologies will be given a strong preference.
• Experience working with SQL replication and SQL Availability Groups