USA Staffing

Position Title: IT Specialist (APPSW)
Agency: Social Security Administration
Announcement Number: SH11571800 Opens in new window
Open Period: Monday, July 18, 2022 to Friday, July 22, 2022

For preview purposes only. To apply, please return to the USAJOBS announcement and click the Apply button.

1. Do you claim Veterans’ Preference?

A. No, I do not claim Veterans' Preference

B. 0-point Sole Survivorship Preference (SSP)

C. 5-point preference based on active duty in the U.S. Armed Forces (TP)

D. 10-point preference for non-compensable disability or Purple Heart (XP)

E. 10-point preference based on a compensable service connected disability of at least 10% but less than 30% (CP)

F. 10 point preference based on widow/widower or parent of a deceased veteran, or spouse or parent of a disabled veteran (XP)

G. 10-point preference based on a compensable service connected disability of 30% or more (CPS)

2. Are you a current or former federal employee displaced from the agency hiring for this position? Select yes if you are located in the same local commuting area of the vacancy; your permanent grade is equivalent to or above the grade level of the vacancy; AND your last performance rating of record is at least fully successful or the equivalent. (Note: You must submit supporting documentation to validate your claim of CTAP eligibility such as a Reduction in Force (RIF) separation notice or a Proposed Removal/Separation notice and a copy of your latest Notification of Personnel Action, Standard Form 50. Please review the Required Documents section of the announcement for more information.)

A. Yes

B. No

3. Are you the spouse of a member of the Armed Forces?

-OR-

Are you the spouse of a member of the Armed Forces who retired with a disability rating at the time of retirement of 100 percent or the spouse of a member of the Armed Forces who retired or separated from the Armed Forces and has a disability rating of 100 percent from the Department of Veterans Affairs?

-OR-

Are you the un-remarried widow or widower of a member of the Armed Forces killed while in active duty status?

For more information, review USAJOBS Veterans resources..

A. Yes

B. No

4. Are you a current or former federal employee displaced from a position in a federal agency other than the agency hiring for this position? Select yes if you are located in the same local commuting area of the vacancy; your permanent grade is equivalent to or above the grade level of the vacancy; AND your last performance rating of record is at least fully successful or the equivalent. (Note: You must submit supporting documentation to validate your claim of ICTAP eligibility such as a Reduction in Force (RIF) separation notice or a Proposed Removal/Separation notice and a copy of your latest Notification of Personnel Action, Standard Form 50. Please review the Required Documents section of the announcement for more information.)

A. Yes

B. No

Please answer Yes or No for each of the following areas that describe your experience and/or training in that task. Applicants must have IT-related experience demonstrating each of the four competencies below. You may be asked to provide evidence of supporting documentation that you have had this type of experience. Your responses are subject to verification against the information you provide.

1. I am thorough when performing work and conscientious about attending to detail.

A. Yes

B. No

2. I work 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; know about available products and services; and am committed to providing quality products and services.

A. Yes

B. No

3. I express 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); make clear and convincing oral presentations; listen to others, attend to nonverbal cues, and responds appropriately.

A. Yes

B. No

4. I identify problems; determine accuracy and relevance of information; use sound judgment to generate and evaluate alternatives, and to make recommendations.

A. Yes

B. No

5. Do you have 52 weeks of specialized experience at or equivalent to the GS-11 level (or above) in the federal service that is in or related to the work of the position to be filled and has equipped you with the particular knowledge, skills, and abilities to successfully perform the duties of the position? Such IT-related experience must include supporting, developing and maintaining a PostgreSQL 9.6 database.

A. Yes, and I have clearly described all of this experience in my resume. NOTE: Resumes are the key means we have for evaluating your qualifications for this position. Describe duties you perform (not just knowledge, skills, and abilities) as they relate to the specialized experience required for this position. Be clear, accurate and specific when describing your experience; e.g., list all positions separately, include full start and stop dates for each position, your work schedule (number of hours per week), your grade (if your position is federal) and a comprehensive description the relevant duties you performed in each position.

B. No

Please answer yes or no to the statements below. Note: Submission of this electronic questionnaire is certification that all responses are true to the best of your knowledge. Materially false, fictitious or fraudulent statements or representations are subject to disciplinary action.

6. Do you have experience using state-of-the-art software to implement and monitor PostgreSQL databases: PostgreSQL 9.6, TOAD, Putty, or pgAdmin?

A. Yes

B. No

7. Do you have experience maintaining and administering a PostgreSQL 9.6 relational database management system in a data sharing environment?

A. Yes

B. No

8. Do you have experience writing shell scripts using BASH or Korn, the Linux command line interface and regular expressions?

A. Yes

B. No

9. Do you have experience using one or more of the following languages: SQL, Java, Python, .NET, VB, Perl, JavaScript?

A. Yes

B. No

10. Do you have experience coding, testing and maintaining DDL and SQL scripts (e.g., improve performance, resize existing storage objects or verify health/availability of database)?

A. Yes

B. No

11. Do you have experience implementing and administering PostgreSQL 9.6 database backup/recoveries and maintenance, i.e., using autovacuum, pg_repack or pgAdmin?

A. Yes

B. No

12. Do you have experience configuring PostgreSQL 9.6 databases for high availability?

A. Yes

B. No

13. Do you have experience configuring PostgreSQL 9.6 databases for horizontal scalability?

A. Yes

B. No

14. Do you have experience implementing PostgreSQL 9.6 databases in support of an enterprise-wide application?

A. Yes

B. No

15. Do you have experience tuning complex PostgreSQL 9.6 SQL statements?

A. Yes

B. No

16. Do you have experience performing PostgreSQL 9.6 database configuration tuning?

A. Yes

B. No

17. Do you have experience utilizing modern methodologies (e.g., agile, SCRUM, Kanban methodologies) to implement PostgreSQL 9.6 databases?

A. Yes

B. No

18. Do you have experience using PostgreSQL 9.6 database tools (e.g., pgAdmin, Erwin) to design and implement PostgreSQL 9.6 database schemas?

A. Yes

B. No

19. Do you have experience using PostgreSQL 9.6 database tools (e.g., pgBadger, db_monitor) to perform PostgreSQL 9.6 database performance monitoring and tuning?

A. Yes

B. No

20. Do you have experience using PostgreSQL 9.6 database tools (e.g., db_monitor) to perform capacity planning (e.g., space, memory, and processor requirements)?

A. Yes

B. No

21. Do you have experience designing and engineering systems that use SQL to perform I/O access against a PostgreSQL 9.6 database?

A. Yes

B. No

22. Do you have experience writing PostgreSQL 9.6 SQL stored procedures?

A. Yes

B. No

23. Do you have experience creating and interpreting PostgreSQL 9.6 explain plans for the purpose of analyzing data access paths and performance improvement?

A. Yes

B. No

24. Do you have experience implementing data replication between PostgreSQL 9.6 databases and other open system Database Management Systems or into a Hadoop cluster?

A. Yes

B. No

25. Do you have experience designing a PostgreSQL 9.6 database from an entity relationship diagram?

A. Yes

B. No

26. Do you have experience resolving complex data relationships into a functional PostgreSQL 9.6 database solution?

A. Yes

B. No

27. Do you have experience analyzing performance factors (e.g., transaction volumes/rates, data volumes and value frequency/distribution) to develop a PostgreSQL 9.6 database design?

A. Yes

B. No

28. I acknowledge that I have thoroughly read each question and answered all honestly and to the best of my ability and I have not overstated my experience. My resume will specifically address the experience in this assessment.

A. Yes

B. No

Your session will expire due to inactivity in 60 seconds.

Unsaved data may be lost if you allow this session to expire.

Warning! The announcement has now closed.

Failure to continue will prevent you from completing and submitting the application.

Click the Stay Connected button below to continue your session.

Terms & Conditions

Your Session is About to Expire!