Remote DBA III - Optimize Critical Databases, 24/7 On-Call

Signature Performance; Kansas City (MO); Remote; USD 120,000 - 150,000; Full time

Benefits offered by this job

Health Insurance

Fully Paid Life Insurance

Fully Paid Short- & Long-Term Disabled

Paid Vacation

Paid Sick Leave

Paid Holidays

Tuition Assistance Program

401(k) Program with Employer Match

Job summary

Signature Performance is seeking a Database Administrator III to support production databases on a remote/nationwide basis. You will optimize T-SQL performance, manage backups and high availability, and coordinate with auditors and business teams to meet SLAs.

The ideal candidate has 5+ years of DBA experience (or 7+ without a degree), strong scripting with T-SQL and PowerShell, and experience with SSIS/SSRS/SSAS, with willingness for on-call rotation and learning new platforms.

Qualifications

• Bachelor's or associate degree and five years of database administration preferred.
• If no degree, a minimum of seven years of experience in database administration.
• Knowledge of Cognizant/TriZetto Facets data model/application is a huge plus.
• Ability to create T-SQL scripts required.
• Highly organized and responsible.
• Ability to work independently or in a team environment with minimal supervision.
• Analytical mindset and proven problem-solving skills.
• Self-starter who can multi-task.
• Demonstrated ability to be highly productive in a fast-paced environment.
• Experience in creating and maintaining complex SQL Databases, SQL queries, stored procedures, and functions.
• Extensible knowledge in implementing, supporting, and troubleshooting SQL replication and high availability architectures.
• Knowledge of programming languages a plus.
• Experience using PowerShell.
• Experienced in installing and configuring SSIS\SSRS\SSAS.
• Health Care experience is a plus.
• Willingness to learn new platforms i.e., Job Schedulers, Open-Source Databases, code deployment software's.
• Azure experience is a plus but not required.

Responsibilities

• T-SQL performance tuning to resolve day-to-day critical production issues using native SQL Server and third-party tools.
• Performs configuration, scripting, analysis, installation, monitoring, upgrades, and administration for database management systems.
• Ensure service level agreements are met for internal and external clients.
• Off-hour production support (including weekends) and 24/7 on-call rotation necessary.
• Determine, enforce, and document database policies, procedures, and standards.
• Effectively communicate, coordinate, and collaborate with both technical and business teams as well as auditors.
• Perform database administration tasks, such as backups, point-in-time restores, maintenance plans based on mission critical applications the organization utilizes.
• Knowledgeable at the data layer for either operational and or project level work.
• Support key components of the System Development Life Cycle (SDLC).
• Provide technical cross training to more junior DBA's.
• Ensure minimum necessary and best practices are being followed from a security perspective.
• Establishes critical strategic and operational goals; develops and implements new products, processes, standards, or operational plans to achieve strategies.
• Perform other related duties as necessary.

Skills

T-SQL

SQL performance tuning

PowerShell

SSIS/SSRS/SSAS

SQL Server

Azure

Cognizant/TriZetto Facets data model

Education

Bachelor's or Associate degree

Tools

SSIS/SSRS/SSAS

Job description

Signature Performance is seeking a Database Administrator III to support production databases on a remote/nationwide basis. You will optimize T-SQL performance, manage backups and high availability, and coordinate with auditors and business teams to meet SLAs.

The ideal candidate has 5+ years of DBA experience (or 7+ without a degree), strong scripting with T-SQL and PowerShell, and experience with SSIS/SSRS/SSAS, with willingness for on-call rotation and learning new platforms.