SQL Server DBA

Comerit; United States; Remote; USD 83,000 - 165,000; Full time

Job summary

Comerit is seeking an experienced SQL Server DBA contractor to accelerate the RMS migration project. The role is remote and involves upgrading RMS from SQL Server 2012 to 2016, with access to both environments via SQL Server Management Studio Standard.

Experience with on-prem to cloud migrations adds value. The ideal candidate will have 10+ years of DBA experience, strong analytical skills, and a proven ability to work independently while collaborating with development teams to design,

Qualifications

• 10 years of SQL Server DBA experience.
• Experience with upgrade and migration from various versions.
• Proficient in Failover Clustering and Always On technologies, replication.

Responsibilities

• Installing, configuring, and upgrading SQL Server databases.
• Configuring high availability and disaster recovery solutions.
• Developing and maintaining database standards, policies, and procedures.
• Developing and implementing data security measures.
• Developing and maintaining database access and permissions.
• Developing and managing backup and recovery plans.
• Troubleshooting and resolving database performance issues.
• Monitoring and tuning database performance.
• Proactively addressing database issues.
• Developing and maintaining database documentation.
• Collaborating with developers to design and implement SQL Server databases.

Skills

SQL Server DBA

Analytical skills

High availability

Performance tuning

Replication/AlwaysOn

Independent / team player

Tools

SQL Server Management Studio

Job description

This is a remote position. Comerit is a global management consulting firm and market leader in Data Enablement, Cloud Migration and Intelligent Analytics . We partner with clients to integrate data and analytics capabilities of digital business platforms and ecosystems to support enterprise growth, speed and agility. Our project teams and resources are high level professionals that perform consulting services and development throughout our technology practices.

Job Description:

Our client is seeking an experienced SQL Server DBA contract resource to accelerate the migration of the RMS (Records Management System, by Central Square) system. The migration is from the current version of RMS that is on SQL Server 2012 to a new version of RMS on SQL Server 2016. As the system is on premise, our client has complete access to both versions of the databases via SQL Server Management Studio Standard

DBA Responsibilities:

• Installing, configuring, and upgrading SQL Server databases.
• Configuring high availability and disaster recovery solutions.
• Developing and maintaining database standards, policies, and procedures.
• Developing and implementing data security measures.
• Developing and maintaining database access and permissions.
• Developing and managing backup and recovery plans.
• Troubleshooting and resolving database performance issues.
• Monitoring and tuning database performance.
• Proactively addressing database issues.
• Developing and maintaining database documentation.
• Collaborating with developers to design and implement SQL Server databases.

Requirements

• SQL Server DBA and related (10 Years)
• Strong analytical skills, identifying problems, evaluating complex information from multiple sources, and determining and providing recommendations based on this analysis.
• Performance tuning, troubleshooting, upgrading, and migration from various versions and platforms (i.e. on-prem to cloud, version X to version y)
• Experience with setup and support of Microsoft Failover Clustering Services and SQL Server Always-on technologies, Snapshot and Transactional Replication
• Ability to work independently as well as working as a team member

Contract Length: 6 Months (Remote)