The Senior Database 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. In this role, you will also be responsible for transact SQL review, database change deployments, and system monitoring of existing systems while assisting in the migration to new systems. Your day will be inclusive of 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 role within the US.
ESSENTIAL FUNCTIONS & RESPONSIBILITIES:
- 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
- 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
- Release application database changes to production environments
- Perform server migration/upgrade activities
- Perform other duties as assigned
KNOWLEDGE, SKILLS & EXPERIENCE:
- 5+ years’ experience in database administration of complex production SQL Server database environments
- Knowledge of Microsoft SQL Server 2014/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
- Experience with SQL Server in Azure (Azure SQL Database; SQL on Azure VM)
- 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
PREFERRED KNOWLEDGE, SKILLS & EXPERIENCE:
- Real world experience migrating SQL Server to Microsoft Azure
- 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 the 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.
CorVel is an Equal Opportunity Employer, drug free workplace, and complies with ADA regulations as applicable.
#J-18808-Ljbffr