DB Administrator Sr - CDC

We offer remote work opportunities (AK, AR, AZ, CO, FL, HI, IA, ID, IL, KS, LA, MD, MN, MO, MT, NE, NV, NM, NC, ND, OK, OR, SC, SD, TN, TX, UT, VA/DC, WA, WI & WY only).

Our Department of Defense contract requires ship and a favorably adjudicated DOD background investigation for this position.

Veterans, Reservists, Guardsmen and military family members are encouraged to apply!

Job Summary

Designs, develops, and maintains Microsoft SQL databases in development, testing, and production environments. Administers and supports third-party vendor databases. Implements and maintains adherence to accepted security standards. Oversees the stabilization and performance optimization of production databases. Functions as a Subject Matter Expert on database development and support.

Education & Experience

Required:

Bachelor's Degree in Business Administration, Computer Science, Mathematics, Engineering or related field with programming and database systems coursework or equivalent database administration experience
5+ years as a SQL Database Administrator with progressively higher-level experience leading to a Senior Database Administrator role or equivalent
2+ years' experience with Azure cloud environments
Experience with SQL Server Services group: Database Services, Integration Services
Knowledge of High Availability (HA) and Disaster Recovery (DR) options
Experience working with Windows server, including Active Directory
Experience in implementing Clustering
Experience following the Software Development Life Cycle
Knowledge of support tools (SSMS, OEM, Toad)

Preferred:

Experience with Oracle RDBMS / RAC on Linux
Experience with Snowflake
Experience with Azure Data Factory
Experience with Data Bricks
Experience with PowerBI
Experience with Change Data Capture (CDC) preferably using Striim
Knowledge of SQL Server Always On

Key Responsibilities

Responsible for managing data base platforms to include performance tuning, monitoring and troubleshooting. When performance issues arise, determine the most effective way to increase performance including hardware, server configuration changes, or index/query changes.
Maintains SQL databases in development, Quality Assurance, and production environments.
Installs and configures new databases.
Designs, recommends, and promotes implementation of required database structures. Applies data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
Assists developers with complex query tuning and schema refinement.
Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO). Test backups to ensure we can meet the business's Recovery Time Objectives (RTO)
Performs security related functions centered on NIST compliance including, automated scan reviews, and remediation of vulnerabilities.
Acts as a technical resource for application and data users, data administrators, and others.
Serves as point of contact with technical peers for the resolution of infrastructure-related issues.
Ensures compliance with TriWest HIPAA, privacy and government security policies.
Provides technical support and guidance for applications programming in support of all aspects of database systems.
Monitors and enforces standards for all database platforms.
Creates databases, table spaces, tables, indexes, triggers, procedures, and all other objects.
Defines the content and structure of the database (schema) and advises users on efficient techniques for extracting data.
Consults with development groups concerning the impact new applications will have on the database.
Maintains accurate and up-to-date database system documentation.
Supports all phases of testing. Correct errors and make necessary database modifications.
Applies patches and application upgrades.
Performs other duties as assigned.
Regular and reliable attendance is required.

.:

Competencies

Communication / People Skills: Ability to influence or persuade others under positive or negative circumstances; adapt to different styles; listen critically; collaborate.

Computer Literacy: Ability to function in a multi-system Microsoft environment using Word, Outlook, TriWest Intranet, the Internet, and department software applications.

Coping / Flexibility: Resiliency in adapting to a variety of situations and individuals while maintaining a sense of purpose and mature problem-solving approach is required.

Information Management: Ability to manage large amounts of complex information easily, communicate clearly, and draw sound conclusions.

High Intensity Environment: Ability to function in a fast-paced environment with multiple activities occurring simultaneously while maintaining focus and control of workflow.

Multi-Tasking / Time Management: Prioritize and manage actions to meet changing deadlines and requirements within a high volume, high stress environment.

Organizational Skills: Ability to organize tasks, adjust to priorities, learn systems, within time constraints and with available resources; detail-oriented.

Problem Solving / Analysis: Ability to solve problems through systematic analysis of processes with sound judgment; has a realistic understanding of relevant issues.

Technical Skills: Advanced knowledge of database design, development, and maintenance practices and principles, with specific experience in Microsoft SQL 2008 R2 and higher. Strong knowledge of SQL Server database service, Integrations service and Reporting service, and familiarity with SQL Analysis Service. Advanced knowledge in database procedures, tools, and utilities for maintaining and optimizing databases; strong understanding of database structure, application servers, and application infrastructure. Understanding and experience implementing NIST security standards utilizing DOD STIGS.

Working Conditions

Working Conditions:

Works non-standard hours as required
Works within a standard office environment, with limited travel
Requires occasional evening or weekend work to implement changes when users are not on the system
On-call rotation (7X24) to provide technical support to end users for urgent needs
Extensive computer work with prolonged periods of sitting
Department of Defense security clearance required

Company Overview

Taking Care of Our Nation's Heroes.

It's Who We Are. It's What We Do.

Do you have a passion for serving those who served?

Join the TriWest Healthcare Alliance Team! We're On a Mission to Serve !

Our job is to make sure that America's heroes get connected to health care in the community.

At TriWest Healthcare Alliance, we've proudly been on that important mission since 1996.

Benefits

We're more than just a health care company. We're passionate about serving others! We believe in rewarding loyal, hard-working people who are willing to learn as they grow. TriWest Healthcare Alliance values teamwork. Join our team, fulfill your responsibilities, and you may also be considered for frequent pay raises, overtime opportunities to earn even more, recognition and reward programs, and much more. Of course, we also offer a comprehensive and progressive compensation and benefits package that includes:

• Medical, Dental and Vision Coverage
• Generous paid time off
• 401(k) Retirement Savings Plan (with matching)
• Short-term and long-term disability, basic life, and accidental death and dismemberment insurance
• Tuition reimbursement
• Paid volunteer time

TriWest job postings typically include a salary range, which can vary based on the specific role and location, but generally this position ranges from around $123,000 - $136,000 per year.

Equal Employment Opportunity

TriWest Healthcare Alliance is an equal employment opportunity employer. We are proud to have an inclusive work environment and know that a diverse team is a strength that will drive our success. To that end, TriWest strives to create an inclusive environment that supports diversity at every organizational level, and we highly encourage candidates from all backgrounds to apply. Applicants are considered for positions based on merit and without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or any other consideration made unlawful by applicable federal, state, or local laws.