Information Technology Specialist (DATAMGT) (Senior Database Administrator)

Corrections professionals who foster a humane and secure environment and ensure public safety by preparing individuals for successful reentry into our communities.

Duties

This position is located within the Central Office of the Federal Bureau of Prisons (FBOP), in the Systems Development Branch (SDB) of the Information Technology and Data Division (ITDD).

Provides expert guidance and technical support to IT specialists regarding the requirements analysis, design, programming, testing, and implementation for FBOP databases.

Researches specific IT topics to evaluate alternatives. Integrates and uses the respective IT knowledge in the formulation of plans that meet operational objectives.

Reviews code to ensure industry standards and best practices are met with a focus on business requirements.

Develops complex queries, reports, dashboards, and designs report formats; carries out prototyping, develops code, tests, and implements it in the production environment.

Architects data warehousing reporting solutions from conception to delivery consisting of analysis of high level design, data modeling, extract, transform, and load (ETL) development, user interface development, integration, and implementation, using the appropriate tools.

Salary

• $143,913 - $187,093/year

Conditions of Employment

• U.S. Citizenship is Required.
• See Special Conditions of Employment Section.
• Selective Service Requirement: http://www.sss.gov

Career Transition Programs (CTAP or ICTAP): These programs apply to Federal and/or DOJ employees who meet the definition of surplus or displaced from a position in the competitive service. To receive selection priority for this position, you must:

• 1. Meet CTAP or ICTAP eligibility criteria;
• 2. Be rated well-qualified for the position, scoring at least half of the total possible points for the vacancy KSAs or competencies; and
• 3. Submit the appropriate documentation to support your CTAP or ICTAP eligibility.

NOTE: Applicants claiming CTAP/ICTAP eligibility must complete all assessment questions to be rated under the established category rating criteria.

Qualifications

To be considered for the position, you must meet the following qualification requirements.

Education:

There is no substitution of education for specialized experience at this grade level.

Experience:

You must have IT related experience demonstrating each of the four competencies listed below.

• 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.

AND

Specialized Experience:

You must have one year of specialized experience at the next lower GS-grade (or equivalent). Specialized experience is experience that has equipped the applicant with the particular qualifications to successfully perform the duties of the position and is typically in or related to the work of the position to be filled. Such experience is typically gained in the IT field or through the performance of work where the primary concern is IT.

Some examples of this qualifying experience are:

• Monitored and analyzed database performance, identified and resolved issues, and performed optimization tasks.
• Lead medium to large projects, provided guidance to less experienced staffs, and made recommendations.
• Troubleshooted database issues and responded to technical support requests..
• Planned future capacity requirement.
• Experienced on handling data recovery and disaster recovery.

AND

Selective Placement Factor:

Applicants applying for this position MUST also possess the following Selective Factor. In the event that you do not possess the Selective Factor, you will be found ineligible for the position.

• Applicant must have a minimum of 6 year of DB2 z/OS database administration experience as well as prior experience with IBM Content Manager and WebSphere on a z/OS Mainframe platform.

NOTE: All applicants MUST clearly address the Selective Factor in their resume.

If applicable, credit will be given for paid and unpaid experience. To receive proper credit, you must show the actual time (such as the number of hours worked per week) spent in activities.

**Your eligibility for consideration will be based on your responses to the questions in the application.**

Education See Qualifications Section for education requirements, if applicable. ONLY if education is a requirement/substitution for specialized experience, applicant MUST upload legible transcripts as verification of educational requirement. Transcripts MUST be uploaded and electronically linked from USAJOBS at the time you apply and MUST include identifying information to include School Name, Student Name, Degree and Date Awarded (if applicable). All academic degrees and coursework must be completed at a college or university that has obtained accreditation or pre-accreditation status from an accrediting body recognized by the U.S. Department of Education. For a list of schools that meet this criteria, Click Here. Foreign Education: For information regarding foreign education requirements, please see Foreign Diploma and Credit Recognition at the U.S. Department of Education website: Recognition of Foreign Qualifications. If you are selected for this position and qualified based on education (i.e. basic education requirement and/or substitution of education), you will be required to provide an OFFICIAL transcript prior to your first day on duty. Other Information Qualified Preference Eligible Veterans may be exempt from meeting the maximum age. Please refer to the Required Documents Section for the appropriate documentation to submit to validate veteran eligibility. Current Federal Law Enforcement Employees: This is a non-law enforcement clerical or administrative support position (one-grade interval). Individuals selected for these positions will lose law enforcement coverage and will need to return to a position with "primary" law enforcement coverage to regain coverage. Special Conditions of Employment Section: For non-law enforcement positions, the Fair Chance Act prohibits specific inquiries concerning an applicant's criminal or credit background unless the hiring agency has made a conditional offer of employment to the applicant. An applicant may submit a complaint, or any other information, to the agency within 30 calendar days of the date of alleged non-compliance by contacting the EEO Office in the Central Office at BOP-PRD-EEOOffice-S@bop.gov. Appointment is subject to satisfactory completion of a pre-employment and panel interview, urinalysis, physical, and background investigation. All applicants are subject to, and must satisfactorily pass all screening requirements in relation to National Crime Information Center (NCIC) and credit check. All applicants not currently working in an institution will be required to complete a qualification inquiry regarding convictions of misdemeanor crimes of domestic violence in order to be authorized to carry a firearm. The Core Value Assessment (CVA) is an in-person assessment that must be facilitated at a Bureau of Prisons Human Resource Servicing office. On the day of the scheduled interview, a CVA will be administered. The applicant assessment must be completed within a 70 minute time period and a passing score of 68 must be obtained. Further employment consideration will not be extended if the applicant fails to complete the examination or fails to achieve a passing score. Note: The Core Value Assessment will not be administered to current BOP employees. Successful completion of the "Introduction to Correctional Techniques", three-week training course at Glynco, Georgia is required. Additional selections may be made if vacancies occur within the life of the certificate. As a condition of employment for accepting this position, you will be required to serve a 1-year probationary period during which we will evaluate your fitness and whether your continued employment advances the public interest. In determining if your employment advances the public interest, we may consider: your performance and conduct; the needs and interests of the agency; whether your continued employment would advance organizational goals of the agency or the Government; and whether your continued employment would advance the efficiency of the Federal service. Upon completion of your probationary period your employment will be terminated unless you receive certification, in writing, that your continued employment advances the public interest. Exceptions may apply. See 5 CFR part 11. Required Documents

Failure to provide legible required documents and/or follow the prescribed format often results in removal from consideration.  If uploading documentation, do not identify/save your documents utilizing a special character such as %, #, @, etc.  Documentation should be identified/saved as VA Letter, DD-214, or Transcripts.

•  Veterans' Preference Documentation:
  • Failure to submit all required documents at the time of application will result in the loss of claimed preference eligibility.
  • DD-214: Veterans MUST provide a DD-214 demonstrating that they have been discharged or released from active duty under honorable conditions (i.e., the individual must have received either an honorable or general discharge).
  • SF-15: If you are a disabled veteran, a Purple Heart recipient, widow/widower of a veteran, the spouse of a disabled veteran or the parent of a disabled or deceased veteran, you must submit:
    • A completed Standard Form (SF) 15, "Application for 10-Point Veteran Preference" AND all required documentation identified on the SF-15. 
    • NOTE: A Department of Veterans Affairs letter must contain the Veteran’s Name and Combined Service-Connected Evaluation. For a copy of the most current SF-15, Click Here.
  • If you are on active duty and expect to be discharged or released from active duty service within 120 days, you may submit a Certificate of Release or Discharge from Active Duty from the appropriate Branch Personnel Office containing the following information: (1) the military service dates including the expected discharge or release date; (2) and the character of service (must be an honorable or general discharge); and (3) any qualifying service/campaign/expeditionary medals.
• Resume: Resume (includes name and contact information) limited to 2 pages showing relevant experience (cover letter optional). Experience that would not normally be part of the Federal employee's position is creditable when documented by satisfactory evidence of qualifying experience (e.g., a memorandum from the manager, Human Resource Manager, SF-52, etc.)
• To receive credit for experience contained in an application, the experience must be documented:
  • Reflecting start date and end date in month/year format (MM/YYYY) AND
  • Include the number of hours worked per week.
• SF-50: for proof of prior LEO coverage, if applicable.

For more help, visit USAJOBS Help Center - What should I include in my resume?

We cannot be held responsible for incompatible software, delays in mail service, applicant application errors, etc.

How to Apply

You must apply through the online application system at www.USAJOBS.gov. Follow the prompts to register, answer a few questions and submit all required documents.

Limit your resume to 2 pages. If the only resume(s) received is/are longer than two pages, your application is ineligible for further consideration. Submission of a resume alone is not a complete application. This position may require the completion of additional forms and/or supplemental materials as described under the Required Documents section. Please carefully review the complete job announcement and the "How to Apply" instructions. Failure to provide the required information and/or materials will result in your application not being considered for employment.

We recommend using a sans-serif font size like Lato, if available. Other widely available options are Calibri, Helvetica, Arial, Verdana, Open San Source Sans Pro, Roboto or Noro Sans. Make your page margins 0.5 inches. Consider using 14-point size font for titles and 10-point for the main text in your resume. USAJOBS Help Center - How to add a resume to your profile

Claiming Veterans Preference? If yes, you MUST claim preference on-line during the application process and upload documentation to support preference claimed. Failure to claim Veterans Preference or provide supporting documentation may result in you not receiving appropriate consideration during the assessment process.

Required supporting documentation must be electronically uploaded or transferred from USAJOBS (uploaded).

All required supporting documentation MUST be received by the Consolidated Staffing Unit by 11:59 p.m., Eastern Standard Time, on the closing date of the vacancy announcement. You MUST include the vacancy announcement number on your supporting documentation.

Supporting documentation for announcements with an application limitation MUST be uploaded the same day you apply, as these positions may close earlier than stated in the announcement.

Paper applications: If applying online is impossible, please contact the Consolidated Staffing Unit at the telephone number listed below, prior to the closing date of the announcement for the alternate application procedure.

If applicable see Notice for Preference Eligible Veterans Applicants. 

Contact for Assistance in Applying On-Line:
DOJ, Federal Bureau of Prisons
Consolidated Staffing Unit
346 Marine Forces Drive
Grand Prairie, TX 75051
E-Mail: BOP-HRM-HRSC-ConsolidatedStaffingUnit-S@bop.gov
Phone: 972-352-4200