Database Administrator, Senior

2 weeks ago

French Camp, United States Health Plan San Joaquin Full time

The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

This position is remote; Candidates MUST reside in Cailfornia.

What You Will Be Doing:

Under general supervision, responsible for managing database environment and infrastructure in a manner that ensures data availability, confidentiality, integrity, manageability, security and recovery.

Our Vision:

Continuously improve the health of our community.

Our Mission:

We provide healthcare value and advance wellness through community partnerships.

Essential Functions:

  • 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.
What You Bring:

Knowledge, Skills, Abilities and Competencies

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.
What You Have:

Education and Experience

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 experience.
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.
Licenses, Certifications
  • None.
What You Will Get:

HPSJ Perks:
  • Competitive salary
  • Robust and affordable health/dental/vision 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.
  • 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.


We are an equal opportunity employer and diversity is one of our core values. We believe that differences including race, ethnicity, gender, sexual orientation, and other characteristics, will help us create a strong organization that is sensitive to the needs of those we serve. Employment decisions are made on the basis of qualifications and merit.

HPSJ provides equal employment opportunities to employees and applicants for employment and prohibits discrimination based on color, race, gender (including gender identity and gender expression), religion (including religious dress and grooming practices), marital status, registered domestic partner status, age, national origin (including language use) or ancestry, physical or mental disability, medical condition (including cancer and genetic characteristics), sex (including pregnancy, childbirth, breastfeeding or related medical condition), genetic information, sexual orientation, military or veteran status, political affiliation or any other characteristic made unlawful by applicable Federal, State or local laws. It also prohibits unlawful discrimination based on the perception that anyone has these characteristics or is associated with anyone who has or is perceived to have these characteristics.

Important Notice: This job description is not a contract between HPSJ and the employee performing the job. The duties listed in the job description may be changed at the discretion of HPSJ, and HPSJ may request the employee to perform duties that are not listed on the job description.

  • Senior Server Administrator

    5 months ago

    Camp, United States Valiant Integrated Services Full time

    RESPONSIBILITIES AND DUTIES: Configure and test Active Directory Federated Services between the KBSC, PASC, CX-K, and JBSC information systems to enable coalition interoperability between training audience and exercise control personnel. Provision user and administrative accounts for the KTEN for approximately 800 exercise users using automated...

  • Senior C2 Systems Engineer

    4 weeks ago

    Camp Pendleton, United States Elyon International Full time

    Job OverviewElyon International, a leading provider of cutting-edge solutions, seeks an experienced Senior C2 Systems Engineer to join our team.CompensationThe successful candidate can expect a salary ranging from $65,000 to $75,000 per year, commensurate with experience and qualifications.Key ResponsibilitiesThe Senior C2 Systems Engineer will lead and...

  • Computer Systems Administrator

    7 days ago

    Camp Pendleton, United States Stahl Companies Full time

    Job OverviewStahl Companies is seeking an experienced IT Services professional to join our team. As an IT Services Manager, you will be responsible for overseeing the daily performance of computer systems, answering user inquiries, and providing technical assistance and support.Key ResponsibilitiesOversight of computer system performance and response to user...

  • Senior Accountant

    4 weeks ago

    Rodriguez Camp, United States Volt Full time

    You Deserve a Job you love Volt is Immediately hiring a Senior Accountant for a leading organization in Delano, CA As a Senior Accountant you will: Review accounting documents to ensure accuracy of information and calculations and makes correcting entries.Input all general ledger vouchers.Analyze various general ledger accounts for accuracy, create new...

  • SharePoint Developer, Senior

    2 weeks ago

    Camp HM Smith, United States Booz Allen Hamilton Full time

    Job Number: R0211475SharePoint Developer, Senior The Opportunity: Are you looking for the possibility to utilize your talents and skills to not only develop software but bring solutions to transform the digital workspace? As a SharePoint developer, you can solve a problem with a complete end-to-end solution in a fast-paced, Agile environment. We're looking...

  • Proposal Development Specialist

    4 days ago

    Camp Hill, Pennsylvania, United States Optimal Staffing Full time

    About Our TeamWe are a dynamic team at Optimal Staffing, seeking a skilled Proposal Development Specialist to join our ranks. This role involves supporting the development and implementation of marketing strategies, preparing qualification packages, letters of interest, proposals, and presentations, as well as maintaining records in the Deltek Vision...

  • Independence Advocate

    4 days ago

    Camp Hill, Pennsylvania, United States Service Coordination Unlimited Inc Full time

    About the RoleWe are seeking an Independence Advocate to join our team at Service Coordination Unlimited Inc.This rewarding role involves supporting individuals in achieving their goals and living independently.Job Description:We provide personalized support at Service Coordination Unlimited Inc. Our goal is to empower our participants to live fulfilling...

  • Transportation Marketing Coordinator Position

    6 days ago

    Camp Hill, Pennsylvania, United States Optimal Staffing Full time

    Job SummaryOptimal Staffing is seeking a motivated and organized Marketing Assistant to support the Transportation team. As a key member of our team, you will play a vital role in assisting local proposal activity, corporate information, qualifications, licenses, and related materials.The ideal candidate will have excellent writing, editing, and proofreading...

  • Community Support Specialist

    6 days ago

    Camp Hill, Pennsylvania, United States Service Coordination Unlimited Inc Full time

    Job OverviewAt Service Coordination Unlimited Inc, we are committed to providing person-centered services that make a positive impact in the community.We seek a dedicated Community Support Specialist to support individuals in achieving their goals and living independently.About Us:We provide tailored support at Service Coordination Unlimited Inc. We strive...

  • Government Office Coordinator

    2 weeks ago

    Camp Verde, Arizona, United States Town of Camp Verde, AZ Full time

    Key ResponsibilitiesAssist in the preparation and distribution of meeting agendas, minutes, and official documents for the Town Council and other departments.Provide information and assistance to constituents, visitors, and others having business with the Town.Compose correspondence and other documents on a wide variety of subjects requiring knowledge of the...

  • Nursing Leadership Director

    4 weeks ago

    Camp Hill, Pennsylvania, United States PennState Health Full time

    About the RolePennState Health is seeking a highly experienced Registered Nurse to lead our nursing administration team in Camp Hill, Pennsylvania.Job SummaryThe successful candidate will be responsible for managing hospital processes related to Magnet Designation and/or Pathway to Excellence. This role requires exceptional leadership skills, strategic...

  • Senior Cardiovascular Scheduling Specialist

    1 month ago

    Camp Hill, Pennsylvania, United States PennState Health Full time

    Job Summary: We are seeking a skilled and experienced Registered Nurse to join our team as a CVU Scheduling Coordinator. The ideal candidate will have a strong background in healthcare administration and excellent communication skills.

  • Senior Credit Analyst

    4 days ago

    Camp Hill, Pennsylvania, United States LINKBANK Full time

    Job Overview:The Commercial Credit Analyst at LINKBANK is responsible for analyzing financial information of commercial borrowers and prospective commercial borrowers to determine creditworthiness. This role involves working independently with minimal supervision, requiring a deep understanding of commercial credit analysis and structure.Key...

  • Senior Quality Assurance Specialist

    7 days ago

    Camp Pendleton, United States Elyon International Full time

    About the RoleWe are looking for a talented Test Engineer to lead our quality assurance efforts. The successful candidate will have a strong background in software testing and development, excellent communication skills, and the ability to work effectively in a team environment.Responsibilities and RequirementsMinimum four years' experience applying test...

  • Member Services Coordinator

    2 months ago

    Camp Hill, United States Girl Scouts Heart of Pennsylvania Full time

    The Member Services Coordinator is responsible for enhancing customer satisfaction through effective coordination of department activities. He or she works in tandem with the Senior Manager to assist with department workflow, process improvement, administrative services, and departmental project management. This position also engages in problem solving and...

  • Commercial Credit Analyst

    4 weeks ago

    Camp Hill, United States LINKBANK Full time

    Position location is flexible. Can be Camp Hill, PA or West Chester, PA General Responsibilities / Job Summary: The Commercial Credit Analyst primarily analyzes the financial information of commercial borrowers and prospective commercial borrowers to determine creditworthiness. The position also analyzes financial information of existing borrowers to...

  • Cybersecurity Network Architect

    6 days ago

    Camp Pendleton, United States Stahl Companies Full time

    **Job Title:** Cybersecurity Network Architect**About Stahl Companies:We are a leading provider of Program Management services for commercial technology companies in the government sector. Our mission is to bring best-of-breed technology to the government, and we're seeking a skilled Cybersecurity Network Architect to join our team.About the Role:We're...

  • RN Case Manager

    3 weeks ago

    Camp Hill, United States Gentiva Hospice Full time

    Join Gentiva Hospice, a leader in hospice, palliative, home health, and personal care. Our mission is to be there for those in need, providing dedicated support to patients and their families. We believe that caring for our caregivers leads to exceptional patient care, and we pride ourselves on offering professional training, manageable nurse-to-patient...

  • Registered Nurse

    3 weeks ago

    Snow Camp, United States Genesis HealthCare Full time

    Registered Nurse - RN at Genesis HealthCare summary: As a Registered Nurse (RN), you will provide comprehensive care to patients with various complex diagnoses while collaborating with the healthcare team. The role includes performing nursing assessments, administering medications, and supervising patient care. You'll be part of a diverse, equitable, and...

  • Registered Nurse

    4 weeks ago

    Snow Camp, United States Genesis HealthCare Full time

    Registered Nurse - RN at Genesis HealthCare summary: As a Registered Nurse (RN), you will provide high-quality care to patients with complex diagnoses while collaborating with a multidisciplinary team. Your responsibilities include performing nursing assessments, administering medications, and developing effective care plans focused on improving patient...