Blue Sky Innovative Solutions
Database Administration and ETL Subject Matter Expert
Blue Sky Innovative Solutions - Washington, District of Columbia, us, 20022
Work at Blue Sky Innovative Solutions
Overview
- View job
Overview
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. utomate 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. wareness 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. ble 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 www.bsis-llc.com. 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 http://map.sba.gov/hubzone/maps/ . 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.
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. utomate 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. wareness 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. ble 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 www.bsis-llc.com. 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 http://map.sba.gov/hubzone/maps/ . 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.