This position is located in the Department of Defense (DoD) Office of the Inspector General (OIG), Mission Support Team (MST), Chief Information Office (CIO). The incumbent is an Information Technology Specialist in the Systems Integration Division, Data Management team, and will be responsible for the design and maintenance of critical OIG data and databases.
Summary
This position is located in the Department of Defense (DoD) Office of the Inspector General (OIG), Mission Support Team (MST), Chief Information Office (CIO). The incumbent is an Information Technology Specialist in the Systems Integration Division, Data Management team, and will be responsible for the design and maintenance of critical OIG data and databases.
Special authorities include appointment based on: former employment with the Canal Zone Merit System or Panama Canal Employment System, service in the Office of the President or Vice-President or on the White House Staff, former incumbency of a position brought into the competitive service, former ACTION volunteer service, former Foreign Service, certain former overseas employment, and employment as a National Guard technician.
Serves as a senior-level expert in establishing, maintaining, supporting, and upgrading databases and their associated architecture and environment to include SQL Server Policy-Based Management and windows clustering, and provides consulting in database design, set-up, maintenance, systems integration, and operating systems.
Designs and administers production and non-production databases and performs physical data modeling, creation, normalization loading, performance tuning, and monitoring of the databases.
Defines data flow, identifies and translates user requirements into data design, and provides design documentation for decision support.
Provides daily oversight of database systems including establishing and managing database accounts, privileges and resources, and assurance of security and data integrity.
Analyzes current and future agency strategic plans, operating plans, policies, and procedures; and provides support to Information Technology management staff on a variety of issues relating to database management.
Performs installation, upgrades, configurations, and patch application for database environments and supports system operations and application use including performance monitoring, system tuning, and help desk call support.
Males born after 12/31/1959 must be registered for Selective Service
Position has been designated as Noncritical Sensitive. The incumbent is required to obtain and maintain a Secret security clearance.
Unless you have already completed a creditable probationary period, you will be required to serve a two-year probationary period.
The incumbent must be able to acquire and maintain an Information Assurance Manager Level II certification in accordance with DoD 8570.1-M.
The incumbent is required to submit to urinalysis to screen for illegal drug use prior to appointment and is subject to random drug testing for the duration of service with Department of Defense (DoD) OIG. Organizational entities with the DoD are not required to conduct drug testing for DoD civilian employees moving by transfer or reassignment from one DoD Testing Designated Position (TDP) to another TDP with no break in service within the DoD, unless deemed appropriate on a case-by-case basis by the gaining Component.
The incumbent must adhere to the DoD Standards of Conduct.
Qualifications
Basic Requirement: You must have IT-related experience demonstrating attention to detail, customer service, oral communication, and problem solving.
Specialized Experience: You must have at least 52 weeks of specialized experience at the GS-12 level in the federal service or at an equivalent level. Specialized experience is defined as: providing database technology support to users and managers; developing and presenting recommendations for technology program improvement; coordinating database development and implementation; and leading technical projects.
Candidates will be further evaluated on the level and quality of their experience and possession of the following relevant competencies in order to determine the level of your qualifications. These competencies include:
Knowledge of enterprise data architecture, systems engineering, and database design
Knowledge of logical data models
Skill in data modeling
Knowledge of MS SQL Server 2016 and Windows Server 2012 (or newer versions)
Ability to write stored procedures, triggers, and T-SQL queries
Skill in oral communication
All qualification and time-in-grade (if applicable) requirements must be met by the closing date of this announcement.
Volunteer Experience: 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, student, social). Volunteer work helps build critical competencies, knowledge, and skills, and can provide valuable training and experience that translates to paid employment. You will receive credit for all qualifying experience, including volunteer experience.
Additional information
Position(s) may be filled by displaced Department of Defense (DoD) employees through the Priority Placement Program.
This job opportunity announcement may be used to fill additional vacancies within 90 calendar days of the initial issue date of the referral list.
Veterans' Employment Opportunities Act (VEOA): See Veterans Guide for definition. Submit a copy of your most recent DD-214 (member 4) showing length of active duty, character of service and type of discharge. Disabled Veterans: See Veterans Guide for definition. Submit a copy of your most recent DD-214 (member 4) showing length of active duty, character of service and type of discharge and a VA Certification Letter. Family Members Eligible under Executive Order 12721: Submit a SF-50, Notification of Personnel Action, from the position and any other documentation proving eligibility. Interchange Agreements: Submit an SF-50, Notification of Personnel Action, or equivalent document providing information pertinent to your appointment eligibility for the position to which you are applying. Military Spouse: Submit a copy of the spouse's PCS orders or VA certification of disability or death of service member, along with any other documentation proving eligibility such as a most recent SF-50, Notification of Personnel Action. NAF/AAFES Interchange Agreement: Submit a SF-50, Notification of Personnel Action, from the position and any other documentation proving eligibility. Severely Disabled (Schedule A): Submit proof of disability in the form of written certification from a licensed medical professional, OR a licensed vocational rehabilitation specialist, OR any Federal agency, State agency, or agency of the District of Columbia or a U.S. territory that issues or provides disability benefits. Reemployed Annuitants: DoD policy on employment of annuitants will be used in determining eligibility of annuitants. The DoD policy is available at http://www.dtic.mil/whs/directives/corres/pdf/1400.25-V300.pdf. Interagency Career Transition Assistance Program (ICTAP): Provides eligible displaced Federal competitive service employees with selection priority over other candidates for competitive service vacancies. Applicants must be well-qualified, which is defined as meeting all minimum qualification standards and eligibility requirements and possessing skills that clearly exceed the minimum qualification requirements for the position established by the Best Qualified category definition. If applicable, you must submit with your application package one of the following as proof of eligibility: a separation notice, a SF-50 documenting separation; an agency certification that you cannot be placed after injury compensation has been terminated; an OPM notification that your disability annuity has been terminated; or a Military Department or National Guard Bureau notification that you are retired under 5 U.S.C. Section 8337(h) or Section 8456. Information about ICTAP eligibility is on OPM's Career Transition Resources website here.
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.
We will review your application package to ensure that you meet basic qualification requirements. If you meet basic qualifications, your personal, educational and work experience, will be evaluated against your responses to the questionnaire. You will be assessed to the extent to which you posses the competencies listed in the "Qualifications" section above and ultimately placed into one of three quality category levels: Best Qualified, Highly Qualified and Qualified. Applicants will receive further consideration in accordance with category rating procedures.
Best-Qualified: This highest category will be used for those candidates who possess the type and quality of experience that substantially exceeds the minimum qualifications of the position, including all selective placement factors and appropriate quality ranking factor(s), as determined by the job analysis.
Highly-Qualified: This higher category will be used for those candidates who possess the type and quality of experience that exceed the minimum qualifications of the position, as determined by the job analysis.
Qualified: This lowest category will be used for those candidates that meet the minimum qualifications of the position and are proficient in some, but not all, of the requirements of the position. Candidates may require extensive training and/or orientation in order to satisfactorily perform the duties of the position.
During further evaluation, you may be asked to provide additional information or participate in other methods of assessment, such as structured interviews. Individuals who are subject matter experts in the requirements of this position may participate in further evaluations.
Your responses will be carefully reviewed and must be supported by factual information in your resume. Inflating or otherwise enhancing your qualifications and errors or omissions may result in lowering your self-rated level or loss of further consideration.
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.
Résumé showing relevant experience (cover letter optional). Résumé should include the following: where you worked, job title, duties and accomplishments, employer's name and address, supervisor's name and phone number, starting and end dates (Mo/Yr), hours per week, and salary;
Completed assessment questionnaire;
Copy of your most recent SF-50, Notification of Personnel Action, if applicable, documenting current Competitive (#1 on block 34 of SF-50) position occupied. If the position currently occupied is Excepted Service (#2 on block 34 of SF-50), you must provide an SF-50 that provides proof that you've held a permanent position with career or career-conditional status, unless your Excepted Service appointment qualifies you for appointment through an interchange agreement or miscellaneous authority. If currently occupying an excepted service VRA, provide an SF-50 documenting your current Veterans Recruitment Appointment.
To claim veterans' preference, submit a DD-214 indicating the most recent dates of service, character of service and type of discharge. To claim 10% or more disability, submit a VA certification letter in addition to a DD-214 (If selected, a completed and signed SF-15 will be required prior to your entrance on duty.). Future military retirees can submit a "Statement of Service" only if retirement DD-214 or proof of transitional leave is not yet available. The "Statement of Service" must be signed by, or by direction of, the adjutant, personnel officer, or commander of your unit or higher headquarters and must indicate when your terminal leave will begin, your rank, dates of active duty service, the type of discharge and character of service (i.e. honorable).
Submission of a resume alone is NOT a complete application. This position may require the completion of additional form/s and/or supplemental materials. Failure to provide the required information and/or materials will result in your application not being considered for employment.
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must provide a complete Application Package. See Required Documents section of this announcement.
Click 'Apply Online' to create an account or log in to your existing USAJOBS account.
1. Follow the prompts to complete the assessment questionnaire and upload required documents.
2. Please ensure you click the Submit My Answers button to submit your application.
3. Check application status by logging into your USAJOBS account, clicking Application Status, then More Information for this position. Return to an incomplete application by logging into your USAJOBS account and clicking Update Application in the vacancy announcement. You must re-select your resume and other documents from your USAJOBS account or your application will be incomplete.
DODIG - MISSION SUPPORT TEAM
4800 Mark Center Drive
Alexandria, VA 22350
US
Next steps
You will receive emails at various points in the evaluation process to notify you of: 1) receipt of your application; 2) after further evaluation, whether or not you are referred to the selecting manager for consideration and possible interview; and 3) the final disposition of your application when recruitment is complete.
To check the status of your application or return to a previous or incomplete application, log into your USAJOBS account, select My Applications, and click on the more information link under the application status for this position.
If you submit a question to the OIG Recruiter, please include your name, the job title and the job announcement number to assist the specialists in providing a response in a timely manner.
Reasonable Accommodation: OIG provides reasonable accommodation to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please notify the OIG recruiter. The decision on granting reasonable accommodation is made on an individual case basis. Equal Employment Opportunity: OIG is an equal opportunity employer. Selections for this position are based solely on merit without regard to race, color, religion, age, gender, national origin, political affiliation, disability, sexual orientation, marital or family status or other non-merit based factors. Privacy Act Notice (PL 93-579): The information requested here is used to determine qualifications for employment and is authorized under 5 U.S.C. 3302 and 3361. False Statements: Misrepresentation of your experience or education or otherwise providing false or fraudulent information may be grounds for not hiring you or for firing you after you begin work.
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
Résumé showing relevant experience (cover letter optional). Résumé should include the following: where you worked, job title, duties and accomplishments, employer's name and address, supervisor's name and phone number, starting and end dates (Mo/Yr), hours per week, and salary;
Completed assessment questionnaire;
Copy of your most recent SF-50, Notification of Personnel Action, if applicable, documenting current Competitive (#1 on block 34 of SF-50) position occupied. If the position currently occupied is Excepted Service (#2 on block 34 of SF-50), you must provide an SF-50 that provides proof that you've held a permanent position with career or career-conditional status, unless your Excepted Service appointment qualifies you for appointment through an interchange agreement or miscellaneous authority. If currently occupying an excepted service VRA, provide an SF-50 documenting your current Veterans Recruitment Appointment.
To claim veterans' preference, submit a DD-214 indicating the most recent dates of service, character of service and type of discharge. To claim 10% or more disability, submit a VA certification letter in addition to a DD-214 (If selected, a completed and signed SF-15 will be required prior to your entrance on duty.). Future military retirees can submit a "Statement of Service" only if retirement DD-214 or proof of transitional leave is not yet available. The "Statement of Service" must be signed by, or by direction of, the adjutant, personnel officer, or commander of your unit or higher headquarters and must indicate when your terminal leave will begin, your rank, dates of active duty service, the type of discharge and character of service (i.e. honorable).
Submission of a resume alone is NOT a complete application. This position may require the completion of additional form/s and/or supplemental materials. Failure to provide the required information and/or materials will result in your application not being considered for employment.
If you are relying on your education to meet qualification requirements:
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
To apply for this position, you must provide a complete Application Package. See Required Documents section of this announcement.
Click 'Apply Online' to create an account or log in to your existing USAJOBS account.
1. Follow the prompts to complete the assessment questionnaire and upload required documents.
2. Please ensure you click the Submit My Answers button to submit your application.
3. Check application status by logging into your USAJOBS account, clicking Application Status, then More Information for this position. Return to an incomplete application by logging into your USAJOBS account and clicking Update Application in the vacancy announcement. You must re-select your resume and other documents from your USAJOBS account or your application will be incomplete.
DODIG - MISSION SUPPORT TEAM
4800 Mark Center Drive
Alexandria, VA 22350
US
Next steps
You will receive emails at various points in the evaluation process to notify you of: 1) receipt of your application; 2) after further evaluation, whether or not you are referred to the selecting manager for consideration and possible interview; and 3) the final disposition of your application when recruitment is complete.
To check the status of your application or return to a previous or incomplete application, log into your USAJOBS account, select My Applications, and click on the more information link under the application status for this position.
If you submit a question to the OIG Recruiter, please include your name, the job title and the job announcement number to assist the specialists in providing a response in a timely manner.
Reasonable Accommodation: OIG provides reasonable accommodation to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please notify the OIG recruiter. The decision on granting reasonable accommodation is made on an individual case basis. Equal Employment Opportunity: OIG is an equal opportunity employer. Selections for this position are based solely on merit without regard to race, color, religion, age, gender, national origin, political affiliation, disability, sexual orientation, marital or family status or other non-merit based factors. Privacy Act Notice (PL 93-579): The information requested here is used to determine qualifications for employment and is authorized under 5 U.S.C. 3302 and 3361. False Statements: Misrepresentation of your experience or education or otherwise providing false or fraudulent information may be grounds for not hiring you or for firing you after you begin work.
Fair and transparent
The Federal hiring process is set up to be fair and transparent. Please read the following guidance.
