3665 Sr. DBA (SQL Server and Azure)

Our client is a national provider of industry-leading workers' compensation solutions for employers, third-party administrators, insurance companies, and government agencies. They are looking for a Senior Database Administrator who will focus on migrating SQL Servers and databases to Azure, as well as maintaining and optimizing those servers once in Azure. Does this sound like you? We value and encourage diversity in the workplace and women, minorities, and veterans are highly encouraged to apply. Thank you.

Location: Remote-prefer Portland, OR area

Type: Contract to hire

The Senior Database Administrator in this role will focus on migrating SQL Servers and databases to Azure, as well as maintaining and optimizing those servers once in Azure. The administrator will work as a part of a team that is responsible for administering, supporting, and assisting in the implementation of new and existing SQL systems, data conversions, and data migrations. Your day will also include some day-to-day administration, performance tuning, and maintenance supporting several core systems. The Database Administrator will also be responsible for reviewing maintenance plans, ensuring 100% of databases are backed up, responding to failures, and writing and testing disaster recovery plans.

Responsibilities:

• Migrate SQL Server databases to Azure
• Maintain and optimize SQL Servers and databases in Azure
• Ensure system availability and recovery
• Execute performance tuning, backup, and restoration of databases
• Provide daily management of Microsoft SQL Server infrastructure and assure service availability
• Optimize database performance and troubleshoot issues
• Strong ability to write & optimize TSQL queries
• Implement security measures and ensure data integrity
• Work with business users, developers, and infrastructure teams to ensure quality products
• Maintain policies and procedures to ensure regulatory compliance
• Keep SQL servers up to date with necessary patches
• Perform server migration/upgrade activities
• Perform other duties as assigned

Qualifications:

• 5+ years' experience in database administration of complex production SQL Server database environments
• Hands-on experience migrating SQL Server to Microsoft Azure
• Experience maintaining SQL Server on Azure VMs and Azure SQL Databases
• Deep knowledge of Microsoft SQL Server 2016+
• Thorough understanding of Relational Databases, T-SQL Scripting, Database Normalization best practices, database technologies, and concepts
• Hands-on experience troubleshooting and resolving database integrity and performance issues on production servers
• Strong Performance Tuning and Query Optimization skills
• Proficient with SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
• Database Design in a Software Development Environment as a contributor
• Experience with Team Foundation Server, Visual Studio Team Server, and/or Azure DevOps

Bonus Points

• Strong working knowledge of PowerShell for automation, scripting, and operational tooling
• Experience establishing, configuring, and maintaining SQL Server AlwaysOn high availability
• Practical expertise configuring and maintaining Microsoft SQL Server Replication in a production environment
• Experience with Service Broker
• Experience with SSRS, SSIS or SSAS
• Bachelor's degree in Computer Science or a related field or equivalent experience