Oracle DBA
Bureau of Labor Statistics, Suitland, MD, United States
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.
Learn more about this agency
Duties
Help
ITSPEC (DATAMGT) Oracle DBA responsibilities include but are not limited to the following:
Supporting Oracle system development and implementation : assist with designing and implementing Oracle-based systems for data acquisition, storage, and retrieval. Supporting Oracle database operations and performance : install, configure, and maintain Oracle database software; monitor performance; ensure backups and recovery operations. Providing user support and policy guidance : respond to user inquiries and explain established policies and procedures related to Oracle data systems. Evaluating and recommending database technologies : research emerging database solutions, assess current systems, and propose improvements for performance, reliability, and security. Contributing to security and continuity planning : develop and test continuity and access-security plans, applying information assurance principles in all data management activities. 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
Candidates must demonstrate proof of meeting the Minimum Qualifications, that is, both the Experience and the Specialized Experience listed below.
Minimum Qualifications
Experience
IT-related experience; experience may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate. Experience must have demonstrated each of the four competencies listed below.
Attention to Detail - Is thorough when performing work and conscientious about attending to detail. An experience indicator at this level includes planning, prioritizing, and organizing requirements that impact the work and outcomes of a work unit. 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. An experience indicator at this level includes in-depth technical customer support such resolving non-routine problems, questions, or complaints; following-up on customer inquiries and requests for assistance to resolve problems about products or services. 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. An experience indicator at this level includes orally presenting technical information in an effective, professional, and understandable manner in formal settings; engaging in discussions and sharing of information with co-workers or team members. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations. An experience indicator at this level includes gathering and analyzing facts, drawing conclusions, and developing recommendations/identifying alternatives to solve difficult problems such as utilizing various sources to conduct research to determine proper alternatives and providing recommendations to resolve issues that impact the work and outcomes of a work unit.
AND
Specialized Experience
Applicants must have 52 weeks of specialized experience equivalent to at least the next lower grade level, i.e. GS-11, in the Federal Service. Specialized experience is defined as all of the following:
1. Demonstrated experience supporting the design and implementation of Oracle databases.
Examples of experience indicators at this level may include the following:
- Development Environment: Modifying tables, indexes, and constraints to maintain referential integrity, enforce data-validation rules, and support a normalized schema.
- Test Environment: Executing data refreshes, validating patches, and performing functional and performance checks to ensure changes operate as expected.
- Staging Environment: Running controlled deployment scripts and conducting pre-production validation to confirm database changes are production ready.
2. Demonstrated experience supporting Oracle PL/SQL development.
Examples of experience indicators at this level may include the following:
- Developing PL/SQL procedures, functions, and/or triggers
- Writing and executing SQL queries and scripts
- Debugging PL/SQL code to correct errors
- Supporting release activities by testing PL/SQL components
3. Demonstrated experience supporting routine Oracle database operations.
Examples of experience indicators at this level may include the following:
- Assisting with the installation and configuration of database software.
- Maintaining data structures (e.g. tables and indexes) to support database integrity.
- Applying security patches and version upgrades to the database.
- Supporting backup and recovery processes to ensure data continuity.
- Troubleshooting operational issues to minimize database downtime.
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.
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 for more information on Pay, Leave, and Workforce Flexibilities.
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.
Help
Review our benefits
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.
Learn more about this agency
Duties
Help
ITSPEC (DATAMGT) Oracle DBA responsibilities include but are not limited to the following:
Supporting Oracle system development and implementation : assist with designing and implementing Oracle-based systems for data acquisition, storage, and retrieval. Supporting Oracle database operations and performance : install, configure, and maintain Oracle database software; monitor performance; ensure backups and recovery operations. Providing user support and policy guidance : respond to user inquiries and explain established policies and procedures related to Oracle data systems. Evaluating and recommending database technologies : research emerging database solutions, assess current systems, and propose improvements for performance, reliability, and security. Contributing to security and continuity planning : develop and test continuity and access-security plans, applying information assurance principles in all data management activities. 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
Candidates must demonstrate proof of meeting the Minimum Qualifications, that is, both the Experience and the Specialized Experience listed below.
Minimum Qualifications
Experience
IT-related experience; experience may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate. Experience must have demonstrated each of the four competencies listed below.
Attention to Detail - Is thorough when performing work and conscientious about attending to detail. An experience indicator at this level includes planning, prioritizing, and organizing requirements that impact the work and outcomes of a work unit. 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. An experience indicator at this level includes in-depth technical customer support such resolving non-routine problems, questions, or complaints; following-up on customer inquiries and requests for assistance to resolve problems about products or services. 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. An experience indicator at this level includes orally presenting technical information in an effective, professional, and understandable manner in formal settings; engaging in discussions and sharing of information with co-workers or team members. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations. An experience indicator at this level includes gathering and analyzing facts, drawing conclusions, and developing recommendations/identifying alternatives to solve difficult problems such as utilizing various sources to conduct research to determine proper alternatives and providing recommendations to resolve issues that impact the work and outcomes of a work unit.
AND
Specialized Experience
Applicants must have 52 weeks of specialized experience equivalent to at least the next lower grade level, i.e. GS-11, in the Federal Service. Specialized experience is defined as all of the following:
1. Demonstrated experience supporting the design and implementation of Oracle databases.
Examples of experience indicators at this level may include the following:
- Development Environment: Modifying tables, indexes, and constraints to maintain referential integrity, enforce data-validation rules, and support a normalized schema.
- Test Environment: Executing data refreshes, validating patches, and performing functional and performance checks to ensure changes operate as expected.
- Staging Environment: Running controlled deployment scripts and conducting pre-production validation to confirm database changes are production ready.
2. Demonstrated experience supporting Oracle PL/SQL development.
Examples of experience indicators at this level may include the following:
- Developing PL/SQL procedures, functions, and/or triggers
- Writing and executing SQL queries and scripts
- Debugging PL/SQL code to correct errors
- Supporting release activities by testing PL/SQL components
3. Demonstrated experience supporting routine Oracle database operations.
Examples of experience indicators at this level may include the following:
- Assisting with the installation and configuration of database software.
- Maintaining data structures (e.g. tables and indexes) to support database integrity.
- Applying security patches and version upgrades to the database.
- Supporting backup and recovery processes to ensure data continuity.
- Troubleshooting operational issues to minimize database downtime.
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.
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 for more information on Pay, Leave, and Workforce Flexibilities.
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.
Help
Review our benefits