Sr. Oracle Database Engineer
Bureau of Labor StatisticsIT 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.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.
Opens the company's application page
Listed via
USAJobs
usajobs.gov
Similar roles
Design & Tech
Related reads from TCHNX
The Inference Economy: Why Running AI Models Just Got Cheaper Than Training Them
A seismic shift in AI economics is underway. As inference costs plummet and training expenses soar, the entire industry must rethink how it builds, deploys, and monetizes intelligent systems.
The Emergence of Small Language Models: Why Efficiency Is Overtaking Scale
As the AI industry confronts computational costs and environmental concerns, a new generation of compact models is proving that bigger isn't always better. Small language models are reshaping enterprise AI deployment.
Algorithmic Bias in Design Systems: Why Your AI-Generated UI Might Exclude Users
As AI tools increasingly generate interface components, they're embedding biases that systematically exclude users. Understanding how machine learning models inherit prejudice is essential for creating truly inclusive design systems.