Senior Database Administrator

CorVel

  • Portland, OR
  • $97,019-163,027 per year
  • Permanent
  • Full-time
  • 1 month ago
Description :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.This is a remote position.ESSENTIAL FUNCTIONS & 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
  • 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
KNOWLEDGE & SKILLS:
  • 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
EDUCATION & EXPERIENCE:
  • 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
PREFFERED QUALIFICATIONS:
  • 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
PAY RANGE:CorVel uses a market based approach to pay and our salary ranges may vary depending on your location. Pay rates are established taking into account the following factors: federal, state, and local minimum wage requirements, the geographic location differential, job-related skills, experience, qualifications, internal employee equity, and market conditions. Our ranges may be modified at any time.For leveled roles (I, II, III, Senior, Lead, etc.) new hires may be slotted into a different level, either up or down, based on assessment during interview process taking into consideration experience, qualifications, and overall fit for the role. The level may impact the salary range and these adjustments would be clarified during the offer process.Pay Range: $97,019 – $163,027A list of our benefit offerings can be found on our CorVel website:In general, our opportunities will be posted for up to 1 year from date of posting, or until we have selected candidate(s) to fulfill the opening, whichever comes first.ABOUT CORVEL:CorVel, a certified Great Place to Work® Company, is a national provider of industry-leading risk management solutions for the workers’ compensation, auto, health and disability management industries. CorVel was founded in 1987 and has been publicly traded on the NASDAQ stock exchange since 1991. Our continual investment in human capital and technology enable us to deliver the most innovative and integrated solutions to our clients. We are a stable and growing company with a strong, supportive culture and plenty of career advancement opportunities. Over 4,000 people working across the United States embrace our core values of Accountability, Commitment, Excellence, Integrity and Teamwork (ACE-IT!).A comprehensive benefits package is available for full-time regular employees and includes Medical (HDHP) w/Pharmacy, Dental, Vision, Long Term Disability, Health Savings Account, Flexible Spending Account Options, Life Insurance, Accident Insurance, Critical Illness Insurance, Pre-paid Legal Insurance, Parking and Transit FSA accounts, 401K, ROTH 401K, and paid time off.CorVel is an Equal Opportunity Employer, drug free workplace, and complies with ADA regulations as applicable.#LI-Remote

CorVel