Employer: U.S. Department of Justice, Environment and Natural Resources Division
OverviewOpen & closing dates 05/21/2020 to 06/01/2020ServiceExceptedPay scale & gradeGS 7Salary$50,356 to $65,459 per yearAppointment typeRecent GraduatesWork scheduleFull-Time HelpLocation1 vacancy in the following location:Washington, DCRelocation expenses reimbursedNoTelework eligibleYes as determined by agency policy HelpThis job is open toRecent graduatesIndividuals who have graduated from an accredited educational institute or certificate program within the last 2 years or 6 years for Veterans.ApplyAnnouncement numberENRD-20-050-EXCControl number568943600Duties HelpDutiesSummaryThis position is located in the Office of Information Management (OIM), in the Executive Office (EO). OIM provides support to ENRD leadership, attorneys, and support staff by developing and maintaining complex information management applications and websites critical to the mission of the Division. OIM also produces a variety of statistical information used in the management of the Division, and responding to requests from Congress, the public, and other stakeholders.Learn more about this agencyResponsibilitiesThis is an excepted service appointment under the DOJ Pathways Recent Graduates Program. This position is designed to serve as a trainee position to provide the incumbent with the knowledge, skills and/or abilities for employment in a civil service career. If this is your first appointment in the Federal service, your pay will be set at Step 1 of the Grade.As an IT Specialist (Data Mgmt) (Recent Graduate), your responsibilities include but are not limited to:Write SQL statements to query databases and to insert, edit and delete data to maintain quality or migrate data.Collaborate with domain expert to refine user requests for data and then create complex Microsoft SSRS reports using data from multiple tables using: join, union or subquery statements, and possibly different data sources using manual or ETL processes; a variety of end-user specified parameters; and sort, group, and aggregate results.Create database objects such as databases, schemas, tables, views, stored procedures, and reports using best practices such as normalization, entity relationships, schemas, unique identifiers, and indexing.Create database models, such as data dictionaries or entity relationship diagrams, and collaborate with business analyst and visual designer to document models.Manage user and application access to databases by creating individual user and service accounts, groups of users, and integration with Windows AD.Maintain Microsoft SQL Server database servers by installing recommended updates and patches and monitoring server health.Secure database servers by eliminating common vulnerabilities, implementing encryption when needed, preventing and responding to cyberattacks.Participate in improving software team’s Agile process including Scrum ceremonies and backlog refinement.Travel RequiredNot requiredSupervisory statusNoPromotion Potential13Job family (Series)2210 Infrmation Technology ManagementRequirements HelpRequirementsConditions of EmploymentYou must be a U.S. citizen or national.You must complete a background investigation to include pre-employment drug testing.Selective Service Registration is required, as applicable.You will be required to serve a one year trial period.You must maintain a bank account for direct deposit of salary.If you do not submit school transcripts, you will be rated ineligible.Ad-hoc telework in accordance with Agency policy.QualificationsRecent Graduates are on a trial period for the duration of the program. An Individual Development Plan (IDP) must be completed and approved by the supervisor within 45 days of appointment and a mentor must be assigned within 90 days of appointment.This position MAY be converted to a term or permanent appointment if the following are met: 1) successful completion of at least 1 year of continuous service, 2) completion of at least 40 hours of formal interactive training, and 3) demonstration of successful job performance. A recent graduate converted to a term appointment may be subsequently converted non-competitively into a permanent competitive service position before the term expires.To be eligible for this Recent Graduate program, one of the following requirements must be met:Recent graduates must have completed, within the previous two years, a qualifying associate, bachelor, master, professional, doctorate, vocational, or technical degree or certificate from a qualifying educational institution. If you graduated prior to May 2018, you will not be eligible for this position.Veterans unable to apply within two years of receiving their degree, due to military service obligation, have as much as six years after degree completion to apply.Note: Current students may apply if they are in the final semester of degree/certificate program. You must include your expected date of graduation on your resume. You must receive your degree prior to appointment. If you are currently a student but cannot provide proof that you expect to graduate by the end of the current semester, you will not meet the program eligibility requirements for the Recent Graduate.To qualify for this position, you must have one of the followingA. At least one year of specialized experience at, or equivalent to, the GS-5 Federal grade level applying data management concepts and methods to troubleshoot technical problems and execute database utility functions; such experience must demonstrate attention to detail, customer service, oral communication, and problem solving skills; orB. A bachelor’s degree with Superior Academic Achievement that is qualifying based on (1) class standing (upper third), (2) grade point average (3.0 or higher), or (3) honor society membership. This education was obtained in or verified by a U.S. accredited college or university; orC. One full year of graduate level education; orD. A combination of education and experience that meets 100% of the qualification requirements for this position. For example, 9 semester hours of graduate study is equivalent to 6 months of specialized experience.Undergraduate or Graduate Education: Must have a Degree in computer science, engineering, information science, information systems management, mathematics, operations research, statistics, or technology management or degree that provided a minimum of 24 semester hours in one or more of the fields identified above and required the development or adaptation of applications, systems or networks.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 skill and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.To preview questions, please click here: https://apply.usastaffing.gov/ViewQuestionnaire/10819537.YOUR RESUME MUST support your responses to the online questionnaire. Failure to provide support may result in an ineligible rating. Your latest resume submitted for this vacancy announcement will be used to determine qualifications and supersedes previous submissions.YOUR RESUME MUST provide specific details as to how your experience meets the specialized experience as described in the vacancy announcement if you are using experience to meet all or part of the qualification requirements. Please ensure that your resume includes the month and year that you began and ended each position held or that position will not be credited toward meeting the specialized experience requirement. Part-time employment will be prorated in crediting experience. Failure to provide details will result in an ineligible rating.Only experience and education obtained by the closing date of this announcement will be considered.EducationAll 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, see www.ed.govEducation completed in foreign colleges or universities may be used to meet the above education requirements if you can show that the foreign education is comparable to that received in an accredited educational institution in the United States. It is your responsibility to timely provide such evidence by submitting proof of creditability of education as evaluated by a credentialing agency with your application materials. More information may be found at https://www2.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.htmlAll documentation must be in English or include an English translation. https://www2.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.htmlAdditional informationVeterans Preference: If you are entitled to or claim veteran preference (VP), you should indicate the type of veteran preference (5 or 10 points) you are claiming on your resume. In order to determine your eligibility, you can find additional information at: http://www.opm.gov/policy-data-oversight/veterans-services/vet-guide/To verify your veteran preference entitlement, submit a copy of the Member Copy 4 of your DD-214; official statement of service from your command if you are currently on active duty; or other official documentation (e.g., documentation of receipt of a campaign badge or expeditionary medal) that shows your military service was performed under honorable conditions. If you are claiming 10-point preference, you must submit Member Copy 4 of your DD-214 in addition to the supporting documentation required and identified on the reserve side of the SF-15, Application for 10 Point Veteran Preference. If you are claiming 10-point DERIVED PREFERENCE as a relative you must submit Member Copy 4 of the veteran’s DD-214 and an SF-15 in addition to the supporting documentation required and identified on the reverse side of the SF-15. If you fail to do so, you will receive consideration as a non-veteran.Selective Service: If you are a male applicant born after December 31, 1959, you must certify that you have registered with the Selective Service System, or are exempt from having to do so under the Selective Service Law. Additional information is found at: www.sss.govRead moreHow You Will Be EvaluatedYou will be evaluated for this job based on how well you meet the qualifications above.Your application will be evaluated and rated under DOJ’s Quality Rating and Selection Procedures. Your résumé and supporting documentation will be used to determine whether you meet the job qualifications listed on this announcement. If you are basically qualified for this job, your resume and supporting documentation will be compared to your responses on the Occupational Questionnaire.Note – If you rate yourself higher than is supported by your application materials, your responses may be adjusted and/or you may be excluded from consideration for this job. If it is determined you meet minimum qualification requirements, your application will then be placed in one of three categories: Best Qualified, Highly Qualified, or Qualified. Within these categories, applicants eligible for Veterans’ Preference will receive selection priority over non-veteran preference eligibles.You will be evaluated based on the following competencies:Data ManagementTeamworkAttention to DetailCustomer ServiceOral CommunicationProblem SolvingPlease Note: Additional candidates may be selected if more positions become available in the Division within 90 days after the HR office issues the selection certificate.Read moreBackground checks and security clearanceSecurity clearanceOtherDrug test requiredYesPosition sensitivity and riskModerate Risk (MR)Trust determination processCredentialingRequired Documents HelpRequired DocumentsResumé demonstrating relevant experience and dates the experience was obtained (cover letter optional).Veterans preference documentation, if applicable (DD-214 Member Copy 4; VA Letter).An unofficial transcript showing degree completion and graduation date is required.Your online responses to the Occupational Questionnaire.Your resumé MUST include full employment information such as periods of employment with Month/Year started and ended, title of position(s), and FT or PT. If employment is PT, indicate PT hours worked. If you have Federal employment, you must include the grade of the position(s). If information is missing or incomplete on your application, you may be rated INELIGIBLE.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.Benefits HelpBenefitsA 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.Review our benefitsEligibility 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 ApplyYou must apply online through USAJOBS. Click on the APPLY button. Follow the prompts to login or create an account, answer a few questions, and submit all required documents by 11:59 PM (EST) on the closing date to receive consideration.To verify the status of your application, log into your USAJOBS account https://my.usajobs.gov/Account/Login. All of your applications will appear on the Welcome screen. The Application Status will appear along with the date your application was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status/If you are unable to apply online, you must request an alternative application which is available from the Office of Human Resources using the contact information listed below.CloseAgency contact information Nardia BennettPhone(202) 514-0106EmailNardia.Bennett@usdoj.govAddressENRD Executive Office150 M Street NEWashington, DC 20002USLearn more about this agencyNext stepsOnce the online questionnaire is received, you will receive an acknowledgement email that your submission was successful. After a review of your complete application is made, you will be notified of your rating and/or referral to the hiring official. We will notify you of the outcome after each step of the recruitment process has been completed. After making a tentative job offer, we will conduct a suitability/security background investigation. We expect to make a final job offer within 80 days after the closing date of the announcement.CloseFair & TransparentFair & TransparentThe Federal hiring process is setup to be fair and transparent. Please read the following guidance.Equal Employment Opportunity PolicyThe 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.Equal Employment Opportunity (EEO) for federal employees & job applicantsCloseReasonable Accommodation PolicyFederal 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.