Skip Navigation

Vacancy Questions Preview

Vacancy Questions Preview

Grade: 14
* 1.GS-14 Choose the one answer that best describes your experience.
  1. I have 1 year of specialized experience at or equivalent to the GS-13 grade level. Examples include accomplishments of assignments related to those described in the specialty below.
  2. I do not meet any of the requirements as described.


* 2.Indicate your experience with Oracle, SQL Server, MYSQL or DB2 RDBMS to perform various database tasks for the following (check all that apply):
  1. Database system integrity checks
  2. Log file monitoring and maintenance
  3. Performance Tuning including DB configuration files
  4. Database Management in a virtual environment like VMWare, XenServer.
  5. Identify, diagnose and troubleshoot database operation and performance problems
  6. Automated database monitoring and alerting using native DB tools, SQL Scripts, Java script, CRON jobs, and Perl Script
  7. None of the above


* 3.Which of the following best reflects your highest level of experience with respect to database modeling?
  1. I have completed a university level course or training on data modeling and developing nested and recursive SQL statements for data retrieval and analysis.
  2. I have worked with a development team to identify business requirements and data storage needs, establish technical specifications, database structures, and create data models.
  3. I have led a project team to use a data modeling tool to capture business requirements, data storage needs, technical specifications, and database structures and then produce from the tool a design for an enterprise-wide database application working over a worldwide network in a production environment housed in the cloud.
  4. I have directed a project team to receive a system design from a data modeling tool and transform it to a completed physical implementation of an enterprise-wide database application working over a worldwide network in a production environment housed in the cloud, and supported by enterprise service bus tools, extract-transform-load tools, and reporting tools.
  5. None of the above


* 4.Describe your experience designing methods to diagnose, measure, describe, and predict problems (check all that apply).
  1. I have selected true experimental designs (e.g., randomly assigned experimental and control group for pretest posttest) or quasi-experimental designs for the collection of performance or evaluation data.
  2. I have designed the collection of experimental data in a way that valid conclusions could be drawn about the effectiveness or significance of a particular technique or procedure.
  3. I have built electronic data systems that enforce design integrity while collecting, validating, and storing multiple dimensions of performance or evaluation data.
  4. I have used established statistical methods (such as regression analysis or factorial analysis) to make logical judgments on cause-and-effect, to logically distinguish between relevant and irrelevant contributing factors, and to discover previously unknown relationships among factors.
  5. I have designed and implemented simulation or forecasting models that analyze large amounts of data to predict future outcomes, to understand process dynamics, or to find alternative solutions to complex problems.
  6. None of the above.


* 5.Indicate your experience working with computer-based tools to draw conclusions based on an analysis of information. (Check all that apply)
  1. I have used a spreadsheet to construct tables, construct graphs and construct models.
  2. I have used computer software to run simulated experiments and tests.
  3. I have used computers to get information from dynamic visual displays.
  4. I have used a relational database management system to construct complex (embedded or recursive) SQL queries of a dataset.
  5. I have used statistical software to analyze the contribution of independent variables to the outcome of a dependent variable.
  6. I have used software to find solutions for simultaneous linear equations.
  7. I have used simulation software to discover solutions to complex queueing problems.
  8. I have written software to detect patterns of behavior and to test or monitor performance indicators.
  9. I have used database modeling software to understand the structure of a relational database management system.
  10. I have used cluster-analysis software to synthesize data results into formal findings.
  11. I have no experience working with computer-based tools to draw conclusions based on an analysis of information.


* 6.Please select all responses that describe your experience in developing relationships to achieve business results or accomplish objectives (Check all that apply).
  1. I have initiated collaboration with other organizational units within my functional area (for example, Human Resources, Information Technology, or Finance) on specific projects/initiatives to achieve common goals and objectives.
  2. I have initiated collaboration with other organizational units outside of my functional area (for example, Human Resources, Information Technology, and Finance) on specific projects/initiatives to achieve common goals and objectives.
  3. I have initiated collaboration with external organizations within my functional area (for example, other agencies, businesses, and institutions) on specific projects/initiatives to achieve common goals and objectives.
  4. I have initiated collaboration with external organizations (for example, other agencies, businesses, and institutions) in matters beyond my functional area on specific projects/initiatives to achieve common goals and objectives.
  5. I have an external (that is, outside of my own agency, business, or institution) network of colleagues and professionals with common interests to stay current on the industry and best practices.
  6. None of the above.


* 7.Please select all responses that describe your experience using data integration and presentation techniques and technologies to provide services to customers (Check all that apply).
  1. I have used my experience with application servers—such as Tuxedo, Websphere webLogic, and IIS—to diagnose and fix application performance problems for users of corporate databases.
  2. I have used my experience with data distribution to provide deliver data to customers located in isolated regions of the world with limited bandwidth and high network latencies.
  3. I have used my knowledge and experience with an enterprise service bus to federate databases located inside an intranet into a virtual database for data customers.
  4. I have used my knowledge and experience with an enterprise service bus to federate databases located inside an intranet with databases from the Internet to create a virtual database for data customers.
  5. I have used my knowledge of Extract-Transform-and-Load tools, such as Informatica, to create centralized databases for data customers.
  6. I have used my knowledge of data warehousing to build data cubes and datamarts for data customers.
  7. I have used my knowledge of Extract-Transform-and-Load tools, such as Informatica, to create data dictionaries and document the genealogy of data used for reporting by data customers.
  8. I have used my knowledge of Publish-and-Subscribe Enterprise Service Bus tools, such as webMethods, to create data integration solutions for data customers.
  9. I have used my knowledge of pattern-matching, cluster analysis and other Big Data techniques, to extract meaning from unstructured data for effective use by decision-makers.
  10. None of the above.


* 8.Which of the following types of documents have you written? (Check all that apply)
  1. Talking points
  2. Congressional inquiry responses
  3. Correspondence
  4. Data models
  5. Requirements Analyses
  6. Statistical reports on database/network/application performance
  7. Reports on application test designs, implementations, and results.
  8. Network diagrams
  9. Service Level Agreements
  10. Standard operating procedures
  11. Directives
  12. Federal Register notices
  13. Regulatory/ statutory material
  14. Policy guidance
  15. Congressional testimony
  16. Analyses of proposed policy, legislative, or management initiatives
  17. Option papers/ decision memos
  18. Publications
  19. Books
  20. Academic papers
  21. Newspaper or magazine articles
  22. Research papers
  23. Strategic plans
  24. Budget or financial plans
  25. Application, network, and database performance measures
  26. None of the above


* 9.Which of the following best describes your experience communicating orally.
  1. I have regularly served as a representative in dealing with managers and employees. This included acquiring, clarifying or exchanging facts and information needed to complete assignments.
  2. I have regularly justified, persuaded, negotiated, and/or resolved matters involving significant or controversial policy or program issues. This included communicating effectively with a full range of internal and external individuals or groups (representatives from Agency, Department, other Federal Agencies, industry leaders, congressional staffs, and officials of foreign governments).
  3. I have regularly conducted discussions and/or participated in workgroups as a program representative in which the purpose was to influence, motivate, and/or persuade persons or groups. This included using communication skills to approach individuals or groups who are skeptical or in disagreement in order to obtain the desired effect, e.g. gaining compliance with an established policy or regulation.
  4. I have regularly served as a program representative and participated in discussions in which the purpose was to plan, coordinate, or consult on work efforts or to resolve specific business problems. This included influencing or motivating individuals or groups who are working toward mutual goals and who have basically cooperative attitudes.
  5. None of the above apply


* 10.What is your experience developing and monitoring resource projections, priorities, justification, etc. for a major agency IT project; Develop agency-wide IT project management procedures, tools, and templates?
  1. I have no experience with performing these duties.
  2. I have limited experience in performing these duties and will require additional guidance and/or supervision to perform at a proficient level.
  3. I have experience performing these duties with minimal supervision or guidance. I have performed this work behavior independently across a wide range of situations.
  4. I have assisted others in carrying out this work behavior. I seek guidance in carrying out this work behavior only in unusually complex situations.
  5. I have supervised the performance of this task or I am normally the person who is consulted by workers/superiors to assist them with unusually complex situations related to this task because of my expertise.


* 11.Select the interpersonal relationship activities you have performed in a professional setting.
  1. Facilitate the resolution of competing or conflicting interests among co-workers whose cooperation is essential to the success of a project.
  2. Negotiate with and influence others in order to gain their commitment to pursue new initiatives or technologies.
  3. Interact and perform effectively in situations where frequent changes, delays or unexpected events arise that cause major shifts in priorities, timetables or work assignments.
  4. Provide direction, guidance or instruction to members of inter-disciplinary teams charged with carrying out a technical project.
  5. Use consensus-building techniques to persuade representatives of outside groups that hold opposing views or positions, to reach agreement on important issues.
  6. Effectively persuade employees to adopt new methods, procedures or techniques in order to accomplish their work.
  7. None of the above






This is a Federal job application system. Providing false information, creating fake IDs, or failing to answer all questions truthfully and completely may be grounds for not hiring, for disbarment from Federal employment, or for dismissal after the applicant begins work. Falsifying a Federal job application, attempting to violate the privacy of others, or attempting to compromise the operation of this system may be punishable by fine or imprisonment (US Code, Title 18, section 1001).