Senior Database Admin

CorVel Corporation•Portland, OR

17h•Remote

About The Position

The Sr. Database Administrator works as a part of a team responsible for administering, supporting, and assisting in the implementation of new and existing SQL systems, data conversions, and data migrations. This role also involves Transact-SQL (T-SQL) review, database change deployments, and monitoring of existing systems while assisting in the migration to new systems. A normal workday includes day-to-day administration, performance tuning, and maintenance support for several core systems. The Database Administrator is also responsible for reviewing maintenance plans, ensuring 100% of databases are backed up, responding to failures, and 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
Experience with Microsoft Azure SQL Database
Experience with SSRS, SSIS or SSAS
Experience in implementing operational automation
Bachelor's degree in Computer Science or a related field or equivalent experience

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