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.Learn more about this agency
- 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.
Occasional travel - Approximately 5% of work time may require travel.
Job family (Series)
Conditions of Employment
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.
QualificationsBasic 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.
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.
If applicable, you may apply under the appropriate Special Appointment Authority and be considered for non-competitive appointments. Please see link for definitions of the Special Appointment Authorities: https://www.opm.gov/policy-data-oversight/hiring-information/hiring-authorities/.
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.
If you are unable to apply online, see information regarding Alternate Application.
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.
Background checks and security clearance
Drug test required
Your complete application includes:
- 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).
If you are relying on your education to meet qualification requirements:
Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from schools accredited by accrediting institutions recognized by the U.S. Department of Education.
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.
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. Learn 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 to Apply
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.
Agency contact information
4800 Mark Center Drive
Alexandria, VA 22350
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 & Transparent
The Federal hiring process is setup to be fair and transparent. Please read the following guidance.
Equal Employment Opportunity Policy
The United States Government does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factor.
Reasonable Accommodation Policy
Federal agencies must provide reasonable accommodation to applicants with disabilities where appropriate. Applicants requiring reasonable accommodation for any part of the application process should follow the instructions in the job opportunity announcement. For any part of the remaining hiring process, applicants should contact the hiring agency directly. Determinations on requests for reasonable accommodation will be made on a case-by-case basis.
A reasonable accommodation is any change to a job, the work environment, or the way things are usually done that enables an individual with a disability to apply for a job, perform job duties or receive equal access to job benefits.
Under the Rehabilitation Act of 1973, federal agencies must provide reasonable accommodations when:
- An applicant with a disability needs an accommodation to have an equal opportunity to apply for a job.
- An employee with a disability needs an accommodation to perform the essential job duties or to gain access to the workplace.
- An employee with a disability needs an accommodation to receive equal access to benefits, such as details, training, and office-sponsored events.
You can request a reasonable accommodation at any time during the application or hiring process or while on the job. Requests are considered on a case-by-case basis.
Legal and regulatory guidance
This job originated on www.usajobs.gov. For the full announcement and to apply, visit www.usajobs.gov/GetJob/ViewDetails/510281700. Only resumes submitted according to the instructions on the job announcement listed at www.usajobs.gov will be considered.