Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Re-Sourcing Manager

Health Plan of San Joaquin

Re-Sourcing Manager

National
Full Time
Paid
  • Responsibilities

    DO YOU WANT TO WORK WITH AN EXPANDING TEAM THAT HAS THE COMPLEXITY OF A LARGE COMPANY WITH THE VISIBILITY WITH A MID-SIZED ONE WHILE ALSO RECEIVING FANTASTIC PERKS AND BENEFITS? WE ARE SEEKING A SENIOR DATABASE ADMINISTRATOR WITH STRONG TECHNICAL ABILITIES, AND A PASSION FOR PROVIDING QUALITY SUPPORT TO OUR TEAMS.

    WHAT YOU WILL BE DOING:

    You will be responsible for managing database environment and infrastructure in a manner that ensures data availability, confidentiality, integrity, manageability, security and recovery.

    • Designs, builds, implements, tests and maintains databases. environment and infrastructure.
    • Plans and conducts structured testing of database designs to confirm functionality and performance.
    • Monitors and tunes database environment and infrastructure to meet business needs.
    • Evaluates, selects and implements technology and techniques to enhance database environment and infrastructure.
    • Manages database code deployments and upgrades.
    • Develops, implements and maintains documentation, policies, standards, procedures and guidelines necessary to effectively administer and ensure the security of the database environment.
    • Develops, tests, implements and maintains backup strategy and recovery plans.
    • Collaborates with other IT teams in support of workload automation.
    • Creates, analyzes and reports on database metrics and key performance indicators (KPIs).
    • Maintains and configures user system access levels based on established Role Based Access Controls.
    • Collaborates with support vendor as needed to ensure database environment reliability.
    • Provides tier 3 and above support to the Help Desk.

    Required Skills

    WHAT YOU BRING:

     

    Required

    • In-depth skills and knowledge in SQL services, included but not limited to the ability to run SQL server complete, differential, and transaction log backups.
    • In-depth knowledge in SQL services to include but not limited to indexing and performance tuning.
    • In-depth knowledge of and ability to install, test, and implement database software servers and database management systems and upgrades.
    • In-depth knowledge of and ability to perform database capacity planning.
    • Strong knowledge of Microsoft products (Windows and domain architecture), and network and domain architecture.
    • In-depth knowledge of database servers and engines – layout, design, performance factors, data management.
    • In-depth knowledge of and ability to write stored procedures, complex queries, correlated/nested sub-queries, derived tables, and Common Table Expressions (CTE).
    • Strong knowledge with XML and interpreted languages, C# is preferred.
    • Strong knowledge in SQL Server Integration Services (SSIS) with the ability to design complex ETL packages for extracting and loading data to the acquisition, conforming, integration, and dimension layers.
    • In-depth knowledge of and ability to implement database security elements to support minimal necessary access requirements.
    • In-depth knowledge of and ability to link database servers to support complete SQL query scripts.
    • In-depth knowledge of referential database integrity and normalization.
    • Strong knowledge of the principles and methods of all phases of systems development lifecycle methodology.
    • Produces work that is accurate and complete.
    • Produces the appropriate amount of work.
    • Actively learns through experimentation when tackling new problems, using both successes and failures to learn.
    • Rebounds from setbacks and adversity when facing difficult situations.
    • Knows the most effective and efficient process to get things done, with a focus on continuous improvement.
    • Strong knowledge of Bill Inmon data warehouse architecture with ability to create ETL packages to populate acquisition, conforming, integration, and dimension layers.
    • Strong knowledge of the principles and methods of project management appropriate to medium sized projects of moderate complexity.
    • Strong analytical and problem solving skills.
    • Interpersonal skills - interacts effectively with individuals both inside and outside of HPSJ; relates openly and comfortably with diverse groups of people.
    • Strong oral and written communication skills, with the ability to effectively communicate with business and technical users and make presentations.
    • Time management and organizational skills. Uses time effectively and efficiently. Values time. Concentrates his/her efforts on the more important priorities. Can attend to a broader range of activities. Meets deadlines.
    • Strong customer service skills.
    • Ability to work independently and as part of a team.
    • Basic mathematics skills.
    • Ability to speak and be understood in English.
    • Ability to handle confidential information with appropriate discretion.

    Preferred

    • Experience with Microsoft Visio, and the ability to create data/process flow diagrams from business requirements.

    Required Experience

    WHAT YOU HAVE:

     

    Required

    • Bachelor’s Degree in Computer Science, Business Administration, or closely related field; and
    • At least five years of T-SQL experience in design and support of Microsoft SQL Server; and
    • At least five years’ experience in stored procedures, triggers, query and performance tuning; and
    • At least five years’ experience in administering high transactional, high availability large database systems; or
    • Equivalent combination of education and

     

    Preferred

    • Experience in a managed care health plan environment.
    • Experience with QNXT claims processing system
    • Master’s Degree in Computer Science, Management Information Systems, or closely related field.

     

    WHAT YOU WILL GET:

    • HPSJ Perks:
      • Competitive salary
      • Robust and affordable health/dental/vision (90% paid medical for employees and 100% paid dental/vision for employees) with choices in providers
      • Generous paid time off (starting at 3 weeks of PTO, 4 paid floating holidays including employee’s birthday, and 9 paid holidays)
      • CalPERS retirement pension program, automatic employer-paid retirements contributions, in addition to voluntary defined contribution plan
      • Two flexible spending accounts (FSAs)
      • Employer-Paid Term Life and AD&D Insurance
      • Employer-Paid Disability Insurance
      • Employer-Paid Life Assistance Program
      • Health Advocacy
      • Supplemental medical, legal, identity theft protection
      • Access to exclusive discount mall
      • Education and training reimbursement in addition to employer-paid elective learning courses.
    • A chance to work for an organization that is mission-driven – our members and community are at the core of everything we do.
    • A shorter commute ­– if you’re commuting from the Central Valley to the Bay Area.
    • Visibility and variety – you have a chance to work with people at all levels of the organization, and work on diverse projects.

     

     

    OUR VISION:

    • Continuously improve the health of our community.

    OUR MISSION:

    • We provide healthcare value and advance wellness through community partnerships.
  • Qualifications

    WHAT YOU BRING:

     

    Required

    • In-depth skills and knowledge in SQL services, included but not limited to the ability to run SQL server complete, differential, and transaction log backups.
    • In-depth knowledge in SQL services to include but not limited to indexing and performance tuning.
    • In-depth knowledge of and ability to install, test, and implement database software servers and database management systems and upgrades.
    • In-depth knowledge of and ability to perform database capacity planning.
    • Strong knowledge of Microsoft products (Windows and domain architecture), and network and domain architecture.
    • In-depth knowledge of database servers and engines – layout, design, performance factors, data management.
    • In-depth knowledge of and ability to write stored procedures, complex queries, correlated/nested sub-queries, derived tables, and Common Table Expressions (CTE).
    • Strong knowledge with XML and interpreted languages, C# is preferred.
    • Strong knowledge in SQL Server Integration Services (SSIS) with the ability to design complex ETL packages for extracting and loading data to the acquisition, conforming, integration, and dimension layers.
    • In-depth knowledge of and ability to implement database security elements to support minimal necessary access requirements.
    • In-depth knowledge of and ability to link database servers to support complete SQL query scripts.
    • In-depth knowledge of referential database integrity and normalization.
    • Strong knowledge of the principles and methods of all phases of systems development lifecycle methodology.
    • Produces work that is accurate and complete.
    • Produces the appropriate amount of work.
    • Actively learns through experimentation when tackling new problems, using both successes and failures to learn.
    • Rebounds from setbacks and adversity when facing difficult situations.
    • Knows the most effective and efficient process to get things done, with a focus on continuous improvement.
    • Strong knowledge of Bill Inmon data warehouse architecture with ability to create ETL packages to populate acquisition, conforming, integration, and dimension layers.
    • Strong knowledge of the principles and methods of project management appropriate to medium sized projects of moderate complexity.
    • Strong analytical and problem solving skills.
    • Interpersonal skills - interacts effectively with individuals both inside and outside of HPSJ; relates openly and comfortably with diverse groups of people.
    • Strong oral and written communication skills, with the ability to effectively communicate with business and technical users and make presentations.
    • Time management and organizational skills. Uses time effectively and efficiently. Values time. Concentrates his/her efforts on the more important priorities. Can attend to a broader range of activities. Meets deadlines.
    • Strong customer service skills.
    • Ability to work independently and as part of a team.
    • Basic mathematics skills.
    • Ability to speak and be understood in English.
    • Ability to handle confidential information with appropriate discretion.

    Preferred

    • Experience with Microsoft Visio, and the ability to create data/process flow diagrams from business requirements.