Information Technology Specialist (Data Management)
- Employer
- USAJobs
- Location
- Washington, D.C
- Closing date
- Jul 1, 2019
View more
- Industry
- Government and Public Services, Federal
- Function
- Management
- Hours
- Full Time
- Career Level
- Experienced (Non-Manager)
You need to sign in or create an account to save a job.
Duties
Summary
The IT Specialist (Data Management) position is located in the Court Services and Offender Supervision Agency for the District of Columbia (CSOSA), Office of Research and Evaluation (ORE). ORE is composed of behavioral and social scientist responsible for conducting research and program evaluation of community supervision and interventions believed to contribute to the successful supervision of offenders in the community.
Learn more about this agency
Responsibilities
(The duties described reflect the full performance level of this position)
Develops database designs based on organizational mission and functional requirements. Defines data elements, data relationships, and data tables using database theory including entity relationship diagramming; object-oriented, hierarchical, and relational design; and data normalization.
Designs and develops data warehouses and data marts to support Executive Information and Decision Support Systems.
Analyzes database performance and makes modifications as necessary to improve resource utilization, increase stability and efficiency, and reduce system response time. Monitors the database size and growth, table allocation, disk utilization, and query performance. Improves performance through data indexing, query optimization, and de-normalization.
Participates in, and/or performs, the planning, design, implementation, and/or management of an agency-wide IT enterprise architectural framework that integrates, aligns, and streamlines business, application, information, and technology architectures to support the mission, strategies, goals, structure, and processes of the agency.
Travel Required
Not required
Supervisory status
No
Promotion Potential
13
Requirements
Conditions of Employment
A background security investigation will be required for all new hires. Appointment will be subject to the applicant's successful completion of a background security investigation, drug testing, and favorable adjudication. Failure to successfully meet these requirements will be grounds for termination.
U.S. Citizenship: Applicants must be U.S. citizens or nationals. Failure to certify US Citizenship may result in your application not being considered.
Qualifications
Qualifying experience for the GS-13 level requires IT-related experience that demonstrates each of the following four competencies: Attention to Detail; Customer Service; Oral Communication; and Problem Solving; AND one (1) year of specialized experience at least equivalent to the GS-12 level. Specialized experience is experience that is in or directly related to the line of work of the position to be filled and that has equipped the applicant with the particular competencies/knowledge, skills, and abilities to successfully perform the duties of the position. Experience must be IT-related and may be paid or unpaid experience.
Example of specialized experience for positions at the GS-13 level, typically gained in the IT field or through performance of work where the primary concern is IT, includes experience analyzing a number of alternative approaches when advising management concerning major aspects of IT system design. The experience demonstrates accomplishment of IT project assignments requiring knowledge of IT requirements and techniques pertinent to the position to be filled. Specific examples of specialized experience are: resolved specific, complex, and/or intricate database performance issues that affected the confidentiality, integrity, and availability of data; developed specifications for new or modified IT systems to meet enterprise architecture (EA) requirements; designed database schema and query structure of new databases to meet complex or intricate business requirements; designed and developed data mining and data warehousing systems to enhance data management.
Click here to see the full Qualifications Statement.
Education
There is no education substitution for the required qualifications.
Additional information
BASIS OF RATING: Your application will be rated under Category Rating Procedures and be placed in one of three categories: Highly Qualified (highly proficient with an overall comprehensive level of knowledge, skills, and abilities of the job based on a complete review of experience, education and training), Well Qualified (competent in the position with an overall accomplished level of knowledge, skills, and abilities of the job based on a complete review of experience, education and training), or Qualified (an overall basic level of knowledge, skills and abilities of the job based on a complete review of your experience, education and training). With the exception of positions which are professional and scientific at the GS-09 (or equivalent) and above, qualified preference eligibles with a compensable service-connected disability of 30-percent or more (CPS) and those with a compensable service-connected disability of at least 10-percent but less than 30-percent (CP) move from the category in which they would otherwise be placed to the top of the highest quality category.
This vacancy announcement may be used to fill future vacancies for identical positions within the next year.
Bargaining Unit Status: Eligible
Relocation Expenses: Relocation expenses are not authorized.
Appointment may require completion of a one-year probationary period.
CSOSA uses E-Verify, If you are selected for this position, the documentation that you present for purposes of completing the Department of Homeland Security (DHS) Form I-9 will be verified through the DHS "E-Verify" System. Federal law requires DHS to use the E-Verify System to verify employment eligibility of all new hires, and as a condition of continued employment obligates the new hire to take affirmative steps to resolve any discrepancies identified by the system.
How You Will Be Evaluated
You will be evaluated for this job based on how well you meet the qualifications above.
You will be rated based on your qualifications for this position as evidenced by the education, experience and training you report relative to this position which shows that you possess the knowledges, skills and abilities required. Paid or unpaid experience will be considered.
Background checks and security clearance
Security clearance
Other
Drug test required
Yes
Required Documents
Generally, preference is granted to veterans who entered military service prior to October 14, 1976; or served on active duty during the period from August 2, 1990, through January 2, 1992, and who are otherwise eligible; or who served on active duty during the period beginning September 11, 2001, and ending on the last day of Operation Iraqi Freedom; or who have served in a military action for which they received a Campaign Badge or Expeditionary Medal. This includes the Armed Forces Expeditionary Medal (AFEM) awarded to those who participated in Operation Joint Endeavor or Operation Joint Guard. Also, you may be entitled to veterans' preference if you are a disabled veteran; you have received a Purple Heart; you are the spouse or mother of a disabled veteran; or you are the widow, widower, or mother of a deceased veteran. You will need to submit a Standard Form (SF) 15 and proof of your claim. If you are claiming 5-point veterans' preference you must attach a copy of your DD-214 "Certificate of Release or Discharge from Active Duty" or other proof of eligibility. If you are applying for consideration under the 30% or more Disabled Veteran Authority, you must attach a SF-15, "Application for 10-Point Veterans' Preference" plus the proof required by that form.
If you are an eligible Career Transition Assistance Program (CTAP) or Interagency Career Transition Assistance Program (ICTAP) applicant, you may apply for special selection over other applicants for this position. Individuals who have special priority selection rights under the CTAP or ICTAP must be well qualified for the position. To be well qualified, applicants must satisfy all qualification requirements for the vacant position and meet the mid-level (scoring between 85 and 89) of the crediting plan for all factors or the established cutoff score. CTAP/ICTAP eligibles must submit one of the following as proof of eligibility for the special selection priority: a separation notice; a "Notice of Personnel Action" (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. 8337(h) or 8456.
Selective Service Registration: As a condition of employment, all male applicants born after December 31, 1959, must have registered for the selective service. If selected for this position, the applicant must sign a statement certifying his registration, or the applicant must demonstrate exempt status under the Selective Service Law.
Direct Deposit: All Federal employees are required to have Federal salary payments directly deposited into a financial institution of their choosing.
If you would like to use your education to qualify for this position, you must provide an unofficial transcript with the application.
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.
Summary
The IT Specialist (Data Management) position is located in the Court Services and Offender Supervision Agency for the District of Columbia (CSOSA), Office of Research and Evaluation (ORE). ORE is composed of behavioral and social scientist responsible for conducting research and program evaluation of community supervision and interventions believed to contribute to the successful supervision of offenders in the community.
Learn more about this agency
Responsibilities
(The duties described reflect the full performance level of this position)
Develops database designs based on organizational mission and functional requirements. Defines data elements, data relationships, and data tables using database theory including entity relationship diagramming; object-oriented, hierarchical, and relational design; and data normalization.
Designs and develops data warehouses and data marts to support Executive Information and Decision Support Systems.
Analyzes database performance and makes modifications as necessary to improve resource utilization, increase stability and efficiency, and reduce system response time. Monitors the database size and growth, table allocation, disk utilization, and query performance. Improves performance through data indexing, query optimization, and de-normalization.
Participates in, and/or performs, the planning, design, implementation, and/or management of an agency-wide IT enterprise architectural framework that integrates, aligns, and streamlines business, application, information, and technology architectures to support the mission, strategies, goals, structure, and processes of the agency.
Travel Required
Not required
Supervisory status
No
Promotion Potential
13
Requirements
Conditions of Employment
A background security investigation will be required for all new hires. Appointment will be subject to the applicant's successful completion of a background security investigation, drug testing, and favorable adjudication. Failure to successfully meet these requirements will be grounds for termination.
U.S. Citizenship: Applicants must be U.S. citizens or nationals. Failure to certify US Citizenship may result in your application not being considered.
Qualifications
Qualifying experience for the GS-13 level requires IT-related experience that demonstrates each of the following four competencies: Attention to Detail; Customer Service; Oral Communication; and Problem Solving; AND one (1) year of specialized experience at least equivalent to the GS-12 level. Specialized experience is experience that is in or directly related to the line of work of the position to be filled and that has equipped the applicant with the particular competencies/knowledge, skills, and abilities to successfully perform the duties of the position. Experience must be IT-related and may be paid or unpaid experience.
Example of specialized experience for positions at the GS-13 level, typically gained in the IT field or through performance of work where the primary concern is IT, includes experience analyzing a number of alternative approaches when advising management concerning major aspects of IT system design. The experience demonstrates accomplishment of IT project assignments requiring knowledge of IT requirements and techniques pertinent to the position to be filled. Specific examples of specialized experience are: resolved specific, complex, and/or intricate database performance issues that affected the confidentiality, integrity, and availability of data; developed specifications for new or modified IT systems to meet enterprise architecture (EA) requirements; designed database schema and query structure of new databases to meet complex or intricate business requirements; designed and developed data mining and data warehousing systems to enhance data management.
Click here to see the full Qualifications Statement.
Education
There is no education substitution for the required qualifications.
Additional information
BASIS OF RATING: Your application will be rated under Category Rating Procedures and be placed in one of three categories: Highly Qualified (highly proficient with an overall comprehensive level of knowledge, skills, and abilities of the job based on a complete review of experience, education and training), Well Qualified (competent in the position with an overall accomplished level of knowledge, skills, and abilities of the job based on a complete review of experience, education and training), or Qualified (an overall basic level of knowledge, skills and abilities of the job based on a complete review of your experience, education and training). With the exception of positions which are professional and scientific at the GS-09 (or equivalent) and above, qualified preference eligibles with a compensable service-connected disability of 30-percent or more (CPS) and those with a compensable service-connected disability of at least 10-percent but less than 30-percent (CP) move from the category in which they would otherwise be placed to the top of the highest quality category.
This vacancy announcement may be used to fill future vacancies for identical positions within the next year.
Bargaining Unit Status: Eligible
Relocation Expenses: Relocation expenses are not authorized.
Appointment may require completion of a one-year probationary period.
CSOSA uses E-Verify, If you are selected for this position, the documentation that you present for purposes of completing the Department of Homeland Security (DHS) Form I-9 will be verified through the DHS "E-Verify" System. Federal law requires DHS to use the E-Verify System to verify employment eligibility of all new hires, and as a condition of continued employment obligates the new hire to take affirmative steps to resolve any discrepancies identified by the system.
How You Will Be Evaluated
You will be evaluated for this job based on how well you meet the qualifications above.
You will be rated based on your qualifications for this position as evidenced by the education, experience and training you report relative to this position which shows that you possess the knowledges, skills and abilities required. Paid or unpaid experience will be considered.
Background checks and security clearance
Security clearance
Other
Drug test required
Yes
Required Documents
Generally, preference is granted to veterans who entered military service prior to October 14, 1976; or served on active duty during the period from August 2, 1990, through January 2, 1992, and who are otherwise eligible; or who served on active duty during the period beginning September 11, 2001, and ending on the last day of Operation Iraqi Freedom; or who have served in a military action for which they received a Campaign Badge or Expeditionary Medal. This includes the Armed Forces Expeditionary Medal (AFEM) awarded to those who participated in Operation Joint Endeavor or Operation Joint Guard. Also, you may be entitled to veterans' preference if you are a disabled veteran; you have received a Purple Heart; you are the spouse or mother of a disabled veteran; or you are the widow, widower, or mother of a deceased veteran. You will need to submit a Standard Form (SF) 15 and proof of your claim. If you are claiming 5-point veterans' preference you must attach a copy of your DD-214 "Certificate of Release or Discharge from Active Duty" or other proof of eligibility. If you are applying for consideration under the 30% or more Disabled Veteran Authority, you must attach a SF-15, "Application for 10-Point Veterans' Preference" plus the proof required by that form.
If you are an eligible Career Transition Assistance Program (CTAP) or Interagency Career Transition Assistance Program (ICTAP) applicant, you may apply for special selection over other applicants for this position. Individuals who have special priority selection rights under the CTAP or ICTAP must be well qualified for the position. To be well qualified, applicants must satisfy all qualification requirements for the vacant position and meet the mid-level (scoring between 85 and 89) of the crediting plan for all factors or the established cutoff score. CTAP/ICTAP eligibles must submit one of the following as proof of eligibility for the special selection priority: a separation notice; a "Notice of Personnel Action" (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. 8337(h) or 8456.
Selective Service Registration: As a condition of employment, all male applicants born after December 31, 1959, must have registered for the selective service. If selected for this position, the applicant must sign a statement certifying his registration, or the applicant must demonstrate exempt status under the Selective Service Law.
Direct Deposit: All Federal employees are required to have Federal salary payments directly deposited into a financial institution of their choosing.
If you would like to use your education to qualify for this position, you must provide an unofficial transcript with the application.
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.
You need to sign in or create an account to save a job.
Get job alerts
Create a job alert and receive personalized job recommendations straight to your inbox.
Create alert