TriWest Healthcare Alliance

  • DB Administrator Sr - SQL

    Recruiting Location Phoenix, AZ
    ID 2019-2821
  • Overview

    DB (Database) Administrator Senior -- SQL at TriWest Healthcare Alliance

     

    Taking Care of Our Nation’s Veterans.

    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.

     

    Are you our next DB (Database) Administrator Senior -- SQL?

     

    Do you find satisfaction in designing, developing, and maintaining Microsoft SQL OLTP and OLAP databases in development, testing, and production environments? Do you enjoy administering and supporting third-party vendor databases? Do you thrive on writing database code (stored procedures, scripts, triggers) and Integration Services packages for standalone use or for use by application programs, and implementing and maintaining adherence to accepted security standards? Are you looking for a job that is meaningful and rewarding?

     

    If you enjoy overseeing the stabilization and performance optimization of production databases, and functioning as a Subject Matter Expert on database development and support, we have a position for you.

    Responsibilities

    • Responsible for managing Microsoft SQL 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.
    • Install and configure new SQL Servers
    • Designs, recommends and promotes implementation of required database structures. Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
    • Assist developers with complex query tuning and schema refinement.
    • Ensure all database servers are backed up in a way that meets the business Recovery Point Objectives (RPO). Test backups to ensure we can meet the business 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, SQL Reports and all other objects.
    • Create and support SQL Integration Service packages.
    • Administer both internal and external facing SQL Reporting Services implementation in development, testing and production.
    • 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.

     

    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.

    Qualifications

    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.
    • 4+ years as a SQL Database Administrator with progressively higher-level experience leading to a Senior Database Administrator role or equivalent.
    • Experience with all facets of the SQL Server Services group: Database Services, Reporting services, Integration Services. . Version 2008 R2, SQL 2012, and SQL 2014
    • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Servero Experience working with Windows server, including Active Directory
    • Experience in implementing SQL 2014 Clusteringo Experience following the Software Development Life Cycleo Knowledge of VisualStudio 2012.

     Preferred:

    • SQL 2012 and higher Analysis Serviceso Knowledge of SQL 2014 Always Ono Team Foundation Server 2012
    • Actifio Backup Software Solution

    More About Working at TriWest Healthcare Alliance

    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. Team members work from home or in one of our state-of-the-art facilities. 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 

    Equal Opportunity Employer

    TriWest Healthcare Alliance is an equal employment opportunity employer. All qualified applicants are considered for employment, without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic made unlawful by applicable federal, state, or local laws.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed