Senior Database Admin

CorVel Career Site•Portland, OR

1d•Remote

About The Position

The Sr. Database Administrator works 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. This role is also responsible for Transact-SQL (T-SQL) review, database change deployments, and monitoring of existing systems while assisting in the migration to new systems. A normal work day includes day-to-day administration, performance tuning, and maintenance support for several core systems. The Database Administrator will also be responsible for reviewing maintenance plans, ensuring 100% of databases are backed up, responding to failures, as well as writing and testing disaster recovery plans. This is a remote position.

Requirements

Deep knowledge of Microsoft SQL Server 2014, 2016, and/or 2019
Thorough understanding of Relational Databases, T-SQL Scripting, Database Normalization best practices, database technologies, and concepts
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
6+ years’ experience in database administration of SQL Server database environments
Hands-on experience in backups and recovery
Experience troubleshooting and resolving database integrity and performance issues
Experience with Performance Tuning and Query Optimization

Nice To Haves

Experience in Microsoft SQL Server Replication (preferred)
Experience with Microsoft Azure SQL Database (preferred)
Experience with SSRS, SSIS or SSAS (preferred)
Experience in implementing operational automation (preferred)
Bachelor's degree in Computer Science or a related field or equivalent experience (preferred)

Responsibilities

Ensure system availability and test or execute recovery
Execute performance tuning, backup, and restoration of databases
Provide daily management of Microsoft SQL Server infrastructure and assure service availability
Maintain all databases including Development, QA, and Production environments
Work with business users, developers, and infrastructure teams to ensure quality products
Responsible for documenting all database maintenance procedures
Maintain policies and procedures to ensure regulatory compliance
Keep SQL servers up to date with necessary patches
Perform release management activities
Perform server migration/upgrade activities
Perform other duties as assigned