Summary
Blue Sky is seeking an experienced and highly skilled Database Administration and ETL Subject Matter Expert to support data warehousing, analytics, and enterprise reporting systems. This position is critical to sustaining end-to-end ETL processes and enterprise database infrastructure in support of high-visibility operational and analytical environments. The ideal candidate will possess deep Oracle expertise, a strong command of SQL-based data extraction and transformation, and proven experience supporting mission-critical systems. Location
Primarily on-site in the Washington, DC metropolitan area. Due to the nature of the work, relocation or long-distance commuting is not supported. Period of Performance
4 years. Responsibilities
• Design, install, configure, and maintain Oracle RAC databases, Fusion Middleware components, and high-availability ETL systems.
• Automate daily ETL operations, including data ingestion, transformation, loading, and reconciliation using Oracle tools, SQL scripts, and shell scripting.
• Create and maintain comprehensive technical documentation, SOPs, and user/admin manuals for enterprise systems.
• Support system performance tuning, Oracle optimizer improvements, and capacity planning.
• Integrate new and existing data models into business intelligence tools such as BI Publisher.
• Coordinate with system administrators to deploy, troubleshoot, and monitor applications and services.
• Lead version upgrades and security patches across Oracle Grid Infrastructure and Middleware stacks.
• Conduct requirements gathering and produce Functional Requirements Documents for application development.
• Guide junior staff and collaborate with project stakeholders to align technical solutions with operational goals.
• Provide monthly reports and participate in technical meetings and briefings. Requirements
Clearance & Eligibility
• Must currently hold an active T4 High Risk Public Trust clearance.
• U.S. citizenship is required due to security and access requirements. Education
• Bachelor's degree in Computer Science, Information Technology, or a related technical field.
Experience
• 6-10 years of experience serving as a Subject Matter Expert in Database Administration and ETL operations.
• Hands-on experience implementing end-to-end ETL pipelines, database performance optimization, and high-availability Oracle architectures.
• Demonstrated background supporting mission-critical systems in secure, regulated environments. Knowledge
• Deep understanding of Oracle database technologies, including Oracle RAC, ASM, Fusion Middleware components (OAM, OUD, BI Publisher), and Oracle Cloud Control.
• Familiarity with data encryption/decryption protocols such as PKI and GPG, as well as secure file transfer methods (SFTP, VPN, SAIG).
• Expertise in software development lifecycle (SDLC) processes, including requirements gathering, technical documentation, system testing, and change management.
• Working knowledge of big data systems and unstructured data analysis, including feasibility studies of alternative data sources.
• Awareness of cybersecurity requirements, including Executive Order 14028, NIST SP 800-53 Rev 5, and federal ICT supply chain security regulations. Skills
• Proficient in SQL/PLSQL programming and database query tools such as SQL Plus, Toad, and Oracle Scripts.
• Skilled in Oracle Data Loading tools (e.g., SQL Loader, Data Pump) and automation scripting (Windows batch, Linux shell, Perl).
• Strong ability to design and maintain automated ETL solutions, including scheduling, prioritization, and reconciliation processes.
• Capable of tuning and optimizing SQL queries and generating Oracle statistics for performance enhancement.
• Able to write and follow Standard Operating Procedures (SOPs) to maintain system uptime and ensure compliance.
• Effective communicator able to translate business requirements into technical solutions, document functional requirements, and mentor junior staff. About Blue Sky
Blue Sky Innovative Solutions (Blue Sky) assists its federal, state and local, and commercial clients with solving their toughest challenges in the areas of IT Infrastructure Support and Engineering; Application Development and Maintenance; Program and Project Management; and Management Consulting. Find out more about Blue Sky at . Blue Sky is an equal opportunity employer and recruits mission-oriented, proactive, skilled candidates from across the United States. As an SBA certified HUBZone small business, Blue Sky has a special interest in recruiting and hiring personnel who reside in HUBZones. To determine whether you reside in a HUBZone, visit . All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Read Less
