Summary

IT Specialist positions located in DOL, Bureau of Labor Statistics (BLS), Office of Technology and Survey Processing (OTSP) provide IT support to all aspects of BLS data development initiatives. BLS measures labor market activity, working conditions, price changes, and productivity in the U.S. economy to support public and private decision making.

Duties

Help

Sr. Oracle Database Engineers specialize in data modeling, SQL development, and performance tuning systems with large volumes of data. They advance OTSP initiates by architecting scalable schemas and optimizing database systems. This role bridges application development and database engineering, ensuring high-throughput Oracle environments operate with maximum speed, minimal latency, and optimal resource utilization. Responsibilities include but are not limited to the following:

Database Design & Architecture

• Logical Modeling: Translating complex business workflows into clean Entity-Relationship Diagrams.
• Physical Modeling: Implementing physical Oracle schemas balancing strict normalization with strategic denormalization. Implementing physical model using Oracle Database. Working with Partitioning Strategies and Data Lifecycle.

Database Development

• Advanced PL/SQL: Writing optimized, secure packages, stored procedures, functions, and database triggers.
• Code Collaboration: Partnering with software teams to review, refactor, and integrate database logic.

Performance Tuning & Optimization

• Bottleneck Diagnosis: Analyzing Executions Plans. Analyzing system performance utilizing Oracle AWR, ASH, and ADDM reports. Analyzing Executions Plans.
• Code Refactoring: Rewriting inefficient SQL and PL/SQL code to maximize Oracle Optimizer efficiency.

Requirements

Help

Conditions of employment

• Must be a U.S. Citizen.
• Must be at least 16 years old.
• Requires a probationary period if the requirement has not been met.
• Candidate required to obtain the necessary security/investigation level.

Qualifications

Qualification requirements include meeting minimum proficiency levels for required competencies and demonstrating one year of specialized experience equivalent to at least the next lower grade level, i.e. GS-12, in the Federal Service.

Competencies

1. Attention to Detail - is thorough when performing work and conscientious about attending to detail. (Advanced-level proficiency or higher).
2. 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. (Advanced-level proficiency or higher).
3. Decision Making - makes sound, well-informed, and objective decisions; perceives the impact and implications of decisions; commits to action, even in uncertain situations, to accomplish organizational goals; causes change. (Intermediate-level proficiency or higher).
4. Information Management - identifies a need for and knows where or how to gather information; organizes and maintains information or information management systems. (Advanced-level proficiency or higher).
5. Interpersonal Skills - shows understanding, friendliness, courtesy, tact, empathy, concern, and politeness to others; develops and maintains effective relationships with others; may include effectively dealing with individuals who are difficult, hostile, or distressed; relates well to people from varied backgrounds and different situations. (Advanced-level proficiency or higher).
6. 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. (Intermediate-level proficiency or higher).
7. Problem Solving - identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations. (Advanced-level proficiency or higher).
8. Teamwork - encourages and facilitates cooperation, pride, trust, and group identity; fosters commitment and team spirit; works with others to achieve goals. (Advanced-level proficiency or higher).
9. Technical Competence - uses knowledge that is acquired through formal training or on-the-job experience to perform one's job; works with, understands, and evaluates technical information related to the job; advises others on technical issues. (Advanced-level proficiency or higher).

Specialized Experience

Specialized experience serves as evidence that an applicant possesses the knowledge, skills, and abilities/competencies required for successful performance in the position. For this position, specialized experience is defined as one year of experience performing all of the following activities:

1. Demonstrated experience supporting Oracle Database architecture activities. Examples of experience indicators at this level may include the following:

• Supporting the setup and configuration of Oracle environments across development, test, and production systems; or
• Supporting updates to database schemas by applying structural changes to tables, indexes, and constraints.

2. Demonstrated experience supporting SQL and PL/SQL development activities. Examples of experience indicators at this level may include the following:

• Developing PL/SQL procedures, functions, packages, and triggers;
• Writing and executing SQL statements and scripts;
• Debugging PL/SQL components; or
• Participating in testing and validation of PL/SQL.

3. Demonstrated experience supporting Oracle performance diagnostics and analysis activities. Examples of experience indicators at this level may include the following:

• Reviewing SQL execution behavior and documenting findings; or
• Reviewing recurring performance indicators and identifying trends/irregularities.

Education

Education may not be substituted for experience at this level.

Additional information

Applicants must meet all legal and regulatory requirements. Reference the Required Documents section for additional requirements.

For more information, click Telework Position Information. This is not a remote work position. The selectee will report to an assigned DOL office location on a regular basis and is eligible for participation in telework as determined by management in accordance with DOL policy.

Based on agency needs, additional positions may be filled using this vacancy.

The Department of Labor may use certain incentives and hiring flexibilities, currently offered by the Federal government to attract highly qualified candidates. Click for more information on Pay, Leave, and Workforce Flexibilities.

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

Review our benefits