Overview

Momento USA is a global technology consulting, talent acquisition and creative development firm that addresses clients most pressing needs and challenges.

We currently looking for SQL Server DBA. Please see the job description below for your reference.

SQL Server DBA

100% REMOTE

Long term contract

Job Description:

SQL Server DBA

SQL Server, SAN. Special apps for back up (NetApp). DR Planning, Performance issues and how to improve db activity.

Application 200 C-Sharp applications. Inquired about SQL upgrade & compliance regulations, because is in Healthcare Industry.

Primary job responsibilities include:

• Design and implement multi-site Microsoft SQL Server Always On.
• Own, track and resolve database related incidents and requests within SLAS Plan and perform automated and attended database maintenance activities via planned and unplanned windows Implement monitoring, auditing, data backup and recovery solutions.
• Maintain the integrity of the company's security and compliance programs as it relates to the database infrastructure
• Provide technical direction to Engineering teams on best practices for deploying applications. Serve as the company's inhouse Microsoft SQL Server evangelist and expert advisor.
• Experience in Database Administration in Microsoft SQL Server (2017 & 2019) Mastery in SQL Server Distributed Always On and all other high availability database features is a must
• Experience in troubleshooting and resolving database integrity issues, migration issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tool
• Ability to detect and troubleshoot SQL Server related CPU, Memory, 10, Storage, and other resource contention
• Strong knowledge of backups, restores, recovery models, database shrink operations, Dynamic Management Views, Clustering, Database mirroring, auditing, and replication
• Expert experience in implementing operational automation
• Strong knowledge of how indexes, index management, integrity checks, configuration, encryption, patching.
• How statistics work, how indexes are stored, how they can be created and managed effectively SQL Development - ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints) Documentation skills for processes and procedures SQL Database Operational support to tech users On call availability in case required with additional charges.

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.