PacificSource Health Plans

  • Database Administrator

    Job Location US-OR-Springfield
    Job ID
    2018-144A
    Type
    Regular Full-Time
    Hiring Pay Range
    60k - 70k
    # of Openings
    1
    Status
    Exempt
  • Overview

    Support and maintain all enterprise databases and environments with a focus on providing high performance availability. This includes database development, information ETL, administration, maintenance, and troubleshooting to all PacificSource departments and subsidiaries. Assist other Information Technology staff with database-related tasks.

    Responsibilities

    1. Provide support and maintenance for all corporate databases.
    2. Design, develop, and maintain Microsoft SQL databases and Integration Services packages.
    3. Install and maintain DBMS server software. Manage and champion upgrade processes.
    4. Configure and administer cloud-based database and data warehouse services such as Amazon RDS / Redshift and Azure SQL Database / Data Warehouse.
    5. Recommend and implement modifications and improvements to existing databases to increase performance, user-friendliness, and stability.
    6. Perform server health monitoring, alerting and incident response.
    7. Interpret user requests on database changes, updates, and restores; perform appropriate actions.
    8. Handle source control and configuration management issues.
    9. Responsible for data security, integrity and disaster recovery, including strategies, implementation, and staff education.
    10. Responsible for scheduled and unscheduled DB backup and restoration in the event of disaster or as assistance to staff.
    11. Advise developers in best practice database table design, champion development and design standards.
    12. Rotational on-call after hours critical incident support.

    Supporting Responsibilities:

    1. Meet department and company performance and attendance expectations.
    2. Follow the PacificSource privacy policy and HIPAA laws and regulations concerning confidentiality and security of protected health information.
    3. Perform other duties as assigned.

     

    Qualifications

    Work Experience:Minimum 3 years of intensive database administration in an enterprise environment, working as a professional DBA.  Commercial and/or Medicare health care insurance industry systems experience preferred.

     

    Education, Certificates, Licenses: BS in Computer Science, Information Systems, MIS or similar or equivalent combination of education and experience. System vendor certifications such as MCSA or MCSE in Data Management and Analytics or Cloud Platform and Infrastructure or AWS Associate-level certification, or similar preferred.

     

    Knowledge: Microsoft SQL Server, SQL Stored Procedure Development, T-SQL, SQL Server Management Studio, Microsoft SQL Server Reporting Services, Microsoft SQL Server Analysis Services, Microsoft SQL Server Integration Services, Microsoft Power Suite (PowerView, PowerPivot, PowerQuery), Microsoft Master Data Services and Data Quality Services, Dell/Quest Lightspeed, Spotlight and Foglight, Informatica. Additional desired experience includes Azure SQL Database, Azure Data Warehouse, AWS RDS, AWS Redshift, Cognizant/TriZetto Facets; EDI (ANSI x12 formats), HL7, and integration of enterprise wide applications.

     

    Ability to respond to common inquiries and effectively present information to a variety of groups. Requires excellent interpersonal skills and ability to work closely with others as well as independently. Database normalization skills. Proficiency in word processing, spreadsheets, and other common office software tools, including Microsoft Office. Interest in ongoing training and learning about technology. Excellent written and verbal communication skills. Basic math skills, including fractions, percentages, ratios, and proportions. Ability to read, analyze, and interpret technical journals, financial reports, and legal documents.

     

    Competencies

    Our Values

    •   Adaptability
    •   Building Customer Loyalty
    •   Building Strategic Work Relationships
    •   Building Trust
    •   Continuous Improvement
    •   Work Standards  
    •   Contributing to Team Success
    •   Planning and Organizing

     

     

    • We are committed to doing the right thing.  
    • We are one team working toward a        common goal.
    • We are each responsible for our customers’        experience. 
    • We practice open communication at all        levels of the company to foster individual, team and company growth.  
    • We actively participate in efforts to improve our communities-internal and external.  
    • We encourage creativity, innovation, continuous improvement, and the pursuit of excellence.

     

    Environment: Work inside in a general office setting with ergonomically configured equipment. Travel is required approximately _5_% of the time. Requires some activity outside normal working hours. Requires ability to be on-call.

     

    Physical Requirements: Stoop and bend. Sit and/or stand for extended periods of time while performing core job functions.  Repetitive motions to include typing, sorting and filing. Light lifting and carrying of files and business materials. Ability to read and comprehend both written and spoken English. Communicate clearly and effectively.

     

    Disclaimer: This job description indicates the general nature and level of work performed by employees within this position and is subject to change. It is not designed to contain or be interpreted as a comprehensive list of all duties, responsibilities, and qualifications required of employees assigned to this position. Employment remains AT-WILL at all times.

     

    PacificSource is an equal opportunity employer.  All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, national origin, sex, sexual orientation, gender identity or age.

    Apply

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