Skip to main content
U.S. flag
 

Sr. Oracle Database Engineer

Department of Labor
Bureau of Labor Statistics
Office of Technology and Survey Processing

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.

Overview

Help
Accepting applications
Posted this week · Apply by 07/06/26
Due by 11:59 p.m. ET on July 6, 2026
Location
1 vacancy in the following location:
Work site options
Telework eligible
Yes—as determined by the agency policy.
Remote job
No
Relocation expenses reimbursed
No
Salary
$121,785 - $158,322 per year
Pay scale & grade
GS 13
Promotion potential
None - This position is at its Full Promotion Potential.
Pay scale and grade determines the salary of the job.
Work schedule
Full-time
Travel Required
Occasional travel - You may be expected to travel for this position.
Appointment type
Permanent
Occupations and job series
Supervisory status
No
Federal service type
This job is in the Competitive Service
Represented by a union
Yes - The duty location is within the Washington, D.C. metropolitan area, and included in the Local 12, AFGE bargaining unit.
Drug test
No
Security clearance
Not Required
Position sensitivity and risk
Moderate Risk (MR)
Jobs require a background check and some require a security clearance. The type depends on the job.
Background check type
Financial disclosure required
No
Some jobs require financial disclosure to identify conflicts of interests.
Announcement number
MS-26-CHI-BLS-12994509-KDZ
Control number
874551900

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

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;
  • 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;
  • 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;
  • Reviewing recurring performance indicators and identifying trends/irregularities.

Education

Education may not be substituted for experience at this level.

Additional information

The mission of the Department of Labor (DOL) is to protect the welfare of workers and job seekers, improve working conditions, expand high-quality employment opportunities, and assure work-related benefits and rights for all workers.

Refer to these links for more information: GENERAL INFORMATION, REASONABLE ACCOMMODATIONS, ADDITIONAL DOCUMENTATION, FORMER FEDERAL EMPLOYEES

As a condition of employment, all personnel must undergo a background investigation for access to DOL facilities, systems, information and/or classified materials before they can enter on duty: BACKGROUND INVESTIGATION

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 here for Additional Information.

The Fair Chance Act (FCA) prohibits Federal agencies from requesting an applicant's criminal history information before the agency makes a conditional offer of employment. If you believe a DOL employee has violated your rights under the FCA, you may file a complaint of the alleged violation following our agency's complaint process Guidelines for Reporting Violations of the Fair Chance Act. Note: The FCA does not apply to some positions specified under the Act, such as law enforcement or national security positions.

All Department of Labor employees are subject to the provisions of the Drug-Free Workplace Program under Executive Order 12564 and Public Law 100-71.

Reasonable Accommodation (RA) Requests: If you believe you have a disability (i.e., physical or mental), covered by the Rehabilitation Act of 1973 as amended that would interfere with completing the USA Hire Competency Based Assessments, you will be granted the opportunity to request a RA in your online application. Requests for RA for the USA Hire Competency Based Assessments and appropriate supporting documentation for RA must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for RA are made on a case-by-case basis. If you meet the minimum qualifications of the position, after notification of the adjudication of your request, you will receive an email invitation to complete the USA Hire Competency Based Assessments, based on your adjudication decision. You must complete all assessments within 48 hours of receiving the URL to access the USA Hire Competency Based Assessments if you received the link after the close of the announcement. To determine if you need a RA, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments.

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.

How you will be evaluated

You will be evaluated for this job based on how well you meet the qualifications above.

The results of your application will be determined by a review of required documentation, responses on the application questionnaire, and responses to the online assessment, including evaluation of the below competencies. Click here for Evaluation details.

  • Accountability
  • Attention to Detail
  • Customer Service
  • Decision Making
  • Flexibility
  • Influencing/Negotiating
  • Integrity/Honesty
  • Interpersonal Skills
  • Learning
  • Reading Comprehension
  • Reasoning
  • Self-Management
  • Stress Tolerance
  • Teamwork
Application questionnaire: Applicants are required to complete a questionnaire as part of the application process. You may preview application questions for this vacancy here: https://apply.usastaffing.gov/ViewQuestionnaire/12994509.

Online assessments: Applicants are required to complete a USA Hire assessment on job-related competencies (knowledge, skills, abilities, and other characteristics). This assessment includes a cut score based on a minimum level of required proficiency in critical competencies. Applicants must meet or exceed the cut score to be considered. Those who score below the cut score or fail to complete the assessment will not be considered for the position.

The information you provide may be verified by a review of your paid, unpaid, and volunteer experience, as it demonstrates the competencies or skills required for the position to be filled. Your evaluation may include an interview, reference checks, or other assessment conducted by HR specialists, subject matter experts, or panel members and may include other assessment tools (ex. interview, structured interview, written test, work sample, etc.).

INFORMATION FOR ICTAP/CTAP ELIGIBLE(S) ONLY: If you are eligible for special priority selection under ICTAP/CTAP, you must be well-qualified for the position to receive consideration. ICTAP/CTAP eligible(s) will be considered well-qualified if they attain at least a rating score of 85 in a numerical rating scheme. Be sure to review the eligibility questions to reflect that you are applying as an ICTAP or CTAP eligible and submit supporting documentation.

When Bureau of Labor Statistics completes its hiring, the remaining list of qualified candidates may be shared with additional sub-agencies in the Department. You will have an opportunity to opt-in if you would like your name, application material, and assessment results shared to be considered for employment with additional sub-agencies at DOL. There is no guarantee of further consideration, and you can continue to explore other job opportunity announcements.

To view the announcement status or your application status: Visit https://www.usajobs.gov/Help/howto/application/status/. Your application status page is where you can view your application status, USA Hire assessment completion status, and review your notifications sent by the hiring agency regarding your application.

Bureau of Labor Statistics

Begin a challenging career with the U.S. Department of Labor (DOL), and you will help shape the workforce of tomorrow. DOL offers rewarding opportunities to contribute to a noble mission; to serve and protect American workers, prepare them for new and better jobs, and to ensure the safety and fairness of American workplaces.

The Department of Labor values its customers. Every DOL employee is responsible for delivering good customer service through accurate, courteous, efficient, and effective transactions.

The Department of Labor does not make unfavorable hiring decisions on the basis of an applicant's previous or current unemployment, or the fact that an applicant has experienced financial difficulty through no fault of his/her own and has undertaken good faith efforts to meet his/her financial obligations. Consideration is given to financial status in relation to appointments only where required by law, regulation, or Executive Order.

Applicants with disabilities can contact the vacancy point of contact listed on the job vacancy announcement to request reasonable accommodations needed for the application process.

Agency contact information

Kyle Zagorski
Phone
202-693-7668
Email
zagorski.kyle.2@dol.gov
Address
Bureau of Labor Statistics
200 Constitution Avenue NW
Washington, DC 20210
US

Your session is about to expire!

Your USAJOBS session will expire due to inactivity in 8 minutes. Any unsaved data will be lost if you allow the session to expire. Click the button below to continue your session.