Information Technology Specialist (DATAMGT) (Senior Database Administrator)

Summary

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

Duties

Help

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.

Requirements

Help

Conditions of employment

• U.S. Citizenship is Required.
• See Special Conditions of Employment Section.
• Selective Service Requirement: ;/li>

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.

Additional 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

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.

Expand Hide additional information

Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.

Benefits

Help

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.