This position is located in the National Supply Service Center (NSSC), located in Oklahoma City, OK. This position serves as the Database Administrator for the Pharmacy Support Branch and Medical/Surgical Prime Vendor programs, performing a variety of duties related to the design and development of major IHS NSSC Information Technology database systems and the development of programming specifications for those database systems. The incumbent reports to the Pharmacy Support Branch Supervisor.
Summary
This position is located in the National Supply Service Center (NSSC), located in Oklahoma City, OK. This position serves as the Database Administrator for the Pharmacy Support Branch and Medical/Surgical Prime Vendor programs, performing a variety of duties related to the design and development of major IHS NSSC Information Technology database systems and the development of programming specifications for those database systems. The incumbent reports to the Pharmacy Support Branch Supervisor.
The IHS is required by law to give absolute preference to qualified applicants who meet the Secretary of the Interior's definition of Indian for appointment to vacancies within the IHS in accordance with established IHS policy as outlined in the Indian Health Manual Part 7, Chapter 3. The IHS is an Equal Opportunity Employer.
Perform a wide variety of duties related to the design and development of major IHS NSSC Information Technology (IT) database systems and the development of programming specifications for those database systems. The primary focus is on Microsoft SQL, Microsoft Access, Microsoft Excel and SAS.
Develop and analyze database reporting operations to be automated; specify number and types of records, files, and documents to be used and outputs to be produced; prepare work diagrams and data flow charts; coordinate tests of the system and participate in trial runs of new and revised systems; and recommend computer equipment changes to obtain more effective operations.
Design and manage a system of computer programs and procedures to collect and analyze data and resolve programming issues.
Analyze product data. Gather information from users, define work problems, and design a system of computer programs and procedures to resolve the problems.
Determine and resolve data processing problems and coordinate the work with program, users, etc.
Orient user personnel on new or changed procedures, conduct special projects such as data element and code standardization throughout a broad system.
Selectee may be subject to a probationary/trial period
ESEP appointees typically serve a two year trial period
U.S. Citizenship is required
Must pass pre-employment examination.
Selective Service Registration is required for males born after 12/31/1959
Background Clearance: If you are selected for this vacancy, you must undergo a pre-employment fingerprint check and background investigation. Fingerprint results and background investigation documentation must be cleared prior to hire. You will receive instructions on how to obtain and submit fingerprints and background investigation documentation. After you begin your employment, your continued employment is contingent upon the outcome of a complete background investigation as determined by the sensitivity level of your position. The investigation must find that you are suitable for Federal employment in your position. If you are found not suitable, you will be terminated after you begin work. If you make a false statement in any part of your application, you may not be hired; you may be fired after you begin work; or subject to possible criminal charges. You may be subject to a credit check as a part of the background investigation process.
"Fingerprinting, as part of the background investigation process, may be delayed due to COVID-19. All other background investigation procedures will apply. Be advised that your continued employment will require you to complete a fingerprint check within 60 days after notification of return to full operations and successfully obtaining a favorable background investigation."
You must meet the requirements of the job by 11:59 pm (Eastern Standard Time) of the closing date: 04/08/2020
Qualifications
To qualify for this position, your resume must state sufficient experience and/or education, to perform the duties of the specific position for which you are applying.
Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community; social). You will receive credit for all qualifying experience, including volunteer and part time experience. You must clearly identify the duties and responsibilities in each position held and the total number of hours per week.
BASIC REQUIREMENTS: Experience
Individuals must have IT-related experience demonstrating each of the four competencies listed below. The experience may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate.
Attention to Detail - Is thorough when performing work and conscientious about attending to detail.
Customer Service - Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services.
Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately.
Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.
In addition to the Basic Requirements, you must also meet the Minimum Qualifications stated below.
MINIMUM QUALIFICATIONS: GS-12- Your resume must demonstrate at least one (1) year of specialized experience equivalent to at least the GS-11 grade level in the Federal service obtained in either the private or public sector. This experience includes: Designing and developing database systems using all of the following systems, Microsoft SQL (Structured Query Language), Microsoft Access, Microsoft Excel, and Statistical Analysis System (SAS). You must also have experience developing programming specifications for those database systems. Your experience must also include collecting and integrating data from multiple data sources, analyzing the data, and generating complex queries and reports; advising management on potential uses of automation to improve the efficiencies; and troubleshooting and resolving database problems (such as diagnosing and correcting database access and availability, reliability, and security problems).
You must meet all qualification requirements within 30 days of the closing date of the announcement. Federal employees in the competitive service are also subject to the Time-In-Grade Requirements: Merit Promotion (status) candidates must have completed one year of service at the next lower grade level. Time-In-Grade provisions do not apply under the Excepted Service Examining Plan (ESEP).
Education
Education is not qualifying for this position.
Additional information
Additional selection(s) of candidates may be possible within 90 days from the date the certificate of eligibles was issued for this announcement.
Federal Employees earn annual leave at a rate (4, 6 or 8 hours per pay period) which is based on the number of years they have served as a Federal employee. IHS may offer newly-appointed Federal employees credit for their directly related previous non-federal experience or active duty uniformed military service. This credited service can be used in determining the rate at which they earn annual leave is earned.
This position meets the criteria specified in pillar number one of the five pillars of the PHS Commissioned Corps. PHS Commissioned Officers interested in performing the duties of this position within the Commissioned Corps MUST apply online under the merit promotion announcement indicated above in order to receive consideration. For more information on PHS Commissioned Corps, visit the website at: https://www.usphs.gov/.
A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.
How you will be evaluated
You will be evaluated for this job based on how well you meet the qualifications above.
Additional selections may be made for similar positions across the Department of Health and Human Services (HHS) within the local commuting area(s) of the location identified in this announcement. By applying, you agree to have your application shared with interested selecting official(s) at HHS. Clearance of CTAP/ICTAP will be applied for similar positions across HHS.
To determine if you are qualified for this position, a review of your resume and supporting documentation will be made and compared against the qualifications as defined in the qualifications section of this vacancy announcement and your responses to the assessment questions.
You will be further evaluated/rated based on the information provided in your resume (your resume must state specific duties that relate to this position) and your responses to the assessment questions to determine your competency in the following:
Attention to Detail
Customer Service
Database Administration
Information Management
Oral Communication
Problem Solving
Technical Competence
You will receive a numeric rating based on your responses to the assessment questionnaires. If after reviewing your resume and responses to the assessment questions, a determination is made that you have overstated your qualifications and or experience, you may lose consideration.
The following links below provide information on how you may be eligible for various hiring authorities. If you are a Veteran, qualified CTAP and ICTAP eligible, or an individual with a disability, please refer to the following links below for additional guidance. CTAP and ICTAP candidates will be eligible for selection priority if it is determined that they have exceeded the minimum qualifications for the position by attaining at least a "well qualified" rating of 85 out of 100. Information about CTAP and ICTAP eligibility is on the Office of Personnel Management's Workforce Restructuring Career Transition website at: https://www.opm.gov/policy-data-oversight/workforce-restructuring/employee-guide-to-career-transition/. CTAP/ICTAP documentation requirements are listed in the "Required Documents" section of this announcement.
A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.
Resume: You are highly encouraged to use USAJOBS Resume Builder to ensure all required information is included in your Resume. If you use your own resume, curriculum vitae, or any other written form you choose then you must describe your job-related qualifications that includes beginning and ending dates for paid and non-paid work experience, hours worked per week, month and year of employment for each job title listed, annual salary, and description of job duties. Include name and address of employer; supervisor name and telephone number.
Required as applicable for the purposes of specific eligibility and appointment claim(s), and position requirements:
Indian Preference Applicants: If claiming Indian preference, applicants must provide a completed copy of the Form BIA-4432, "Verification of Indian Preference for Employment in the BIA and IHS Only." Indian preference will not be given unless a properly signed and dated form is submitted with your application, including any verification by an authorized Tribal Representative or BIA Official of tribal enrollment records. For detailed instructions, see form BIA-4432. Refer to BIA-4432 link: https://www.bia.gov/sites/bia.gov/files/assets/public/raca/online_forms/pdf/IndianPref_1076-0160_Exp3-31-21.pdf. When an Indian Preference candidate possesses Veterans preference the rules regarding Veterans preference apply under ESEP and the applicant must provide documentation in order to receive preference.
Veterans Preference:If claiming Veteran's Preference provide a copy of your DD214 Form (Member 4 copy). To claim 10-Point Veterans Preference, submit a SF-15 Application (http://www.opm.gov/forms/pdf_fill/SF15.pdf) along with the appropriate supporting documentation. For additional information regarding Veterans Preference visit: http://www.fedshirevets.gov.
To apply for this position, you must provide a complete Application Package. See required documents below.
Click 'Apply' to create an account or log in to your existing USAJOBS account.
Follow the prompts to upload your resume and/or supporting documents.
Read all Eligibility questions and respond accordingly. .
Complete the assessment questions.
Verify all required documentation is included in your application package.
The IHS provides reasonable accommodations to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please notify the Human Resources Office (LaDonna Cortez, Donna.Cortez@ihs.gov, and/or (405) 951-3727.) The decision on granting reasonable accommodation will be on a case-by-case basis.
OKC Area Program Wide Consultant Group
701 Market Drive
Oklahoma City, OK 73114
US
Next steps
You can track the progress of your application package via your USAJobs account. You will receive an acknowledgement from USAJobs that your submission was successful once we have received your on-line occupational questionnaire, resume, and any supporting documentation. You will be notified of the status of your application via your USAJobs Account after we conduct a qualification review of your complete application package. You will be contacted if further evaluation or interviews are required. Any exaggeration of your experience, false statements, or attempt to conceal information may disqualify you for employment consideration. We may verify all information you provide in your resume and questionnaire responses, through reference and/or background check, and/or verification of your education. If you are selected, you will be contacted personally by the human resources office posting this announcement.
You will no longer need to call the HR Office to determine your application status. USAJOBS has added an alert setting to their system to provide status updates for applicants. You can elect to activate the status updates from your USAJOBS profile at any point during the application process.
If all required documentation is not submitted with your application you will lose consideration. It is the applicant's responsibility to verify that information and documents entered, uploaded, or faxed are received, legible and accurate. HR will not modify answers submitted by an applicant.
~ ~ ~ Indian Health Service is an Equal Opportunity Employer ~ ~ ~
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
Resume: You are highly encouraged to use USAJOBS Resume Builder to ensure all required information is included in your Resume. If you use your own resume, curriculum vitae, or any other written form you choose then you must describe your job-related qualifications that includes beginning and ending dates for paid and non-paid work experience, hours worked per week, month and year of employment for each job title listed, annual salary, and description of job duties. Include name and address of employer; supervisor name and telephone number.
Required as applicable for the purposes of specific eligibility and appointment claim(s), and position requirements:
Indian Preference Applicants: If claiming Indian preference, applicants must provide a completed copy of the Form BIA-4432, "Verification of Indian Preference for Employment in the BIA and IHS Only." Indian preference will not be given unless a properly signed and dated form is submitted with your application, including any verification by an authorized Tribal Representative or BIA Official of tribal enrollment records. For detailed instructions, see form BIA-4432. Refer to BIA-4432 link: https://www.bia.gov/sites/bia.gov/files/assets/public/raca/online_forms/pdf/IndianPref_1076-0160_Exp3-31-21.pdf. When an Indian Preference candidate possesses Veterans preference the rules regarding Veterans preference apply under ESEP and the applicant must provide documentation in order to receive preference.
Veterans Preference:If claiming Veteran's Preference provide a copy of your DD214 Form (Member 4 copy). To claim 10-Point Veterans Preference, submit a SF-15 Application (http://www.opm.gov/forms/pdf_fill/SF15.pdf) along with the appropriate supporting documentation. For additional information regarding Veterans Preference visit: http://www.fedshirevets.gov.
To apply for this position, you must provide a complete Application Package. See required documents below.
Click 'Apply' to create an account or log in to your existing USAJOBS account.
Follow the prompts to upload your resume and/or supporting documents.
Read all Eligibility questions and respond accordingly. .
Complete the assessment questions.
Verify all required documentation is included in your application package.
The IHS provides reasonable accommodations to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please notify the Human Resources Office (LaDonna Cortez, Donna.Cortez@ihs.gov, and/or (405) 951-3727.) The decision on granting reasonable accommodation will be on a case-by-case basis.
OKC Area Program Wide Consultant Group
701 Market Drive
Oklahoma City, OK 73114
US
Next steps
You can track the progress of your application package via your USAJobs account. You will receive an acknowledgement from USAJobs that your submission was successful once we have received your on-line occupational questionnaire, resume, and any supporting documentation. You will be notified of the status of your application via your USAJobs Account after we conduct a qualification review of your complete application package. You will be contacted if further evaluation or interviews are required. Any exaggeration of your experience, false statements, or attempt to conceal information may disqualify you for employment consideration. We may verify all information you provide in your resume and questionnaire responses, through reference and/or background check, and/or verification of your education. If you are selected, you will be contacted personally by the human resources office posting this announcement.
You will no longer need to call the HR Office to determine your application status. USAJOBS has added an alert setting to their system to provide status updates for applicants. You can elect to activate the status updates from your USAJOBS profile at any point during the application process.
If all required documentation is not submitted with your application you will lose consideration. It is the applicant's responsibility to verify that information and documents entered, uploaded, or faxed are received, legible and accurate. HR will not modify answers submitted by an applicant.
~ ~ ~ Indian Health Service is an Equal Opportunity Employer ~ ~ ~
Fair and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
