Database Administrator

POSITION OVERVIEW
The Database Administrator sustains and secures the Oracle databases underpinning the Defense Logistics Agency (DLA) Financial Website — a Federal financial reporting and audit-readiness intranet application — in support of the DoD. This role is responsible for Oracle RDBMS administration and PL/SQL development on Red Hat Enterprise Linux and Windows; database performance tuning, backup and recovery, patching, and major-release upgrades; data modeling (Erwin) and data-mart/dimensional design; database security and data-integrity management; and supporting migration of Oracle database application servers to Military and Government Azure environments. This is an off-site position with periodic on-site support at Fort Belvoir, VA or the Washington, DC metropolitan area. This position requires an active Secret Clearance, and an Oracle Certified Professional (OCP) certification.

DUTIES AND RESPONSIBILITIES

• Provide support of mission-critical Oracle databases and the DLA Financial Website by developing code and


• Perform Oracle database analysis in RHEL and Windows development and production environments; continually perform database object creation and performance tuning
  


• Develop, test, and implement the organization's physical databases across multiple platforms, technologies, and computing environments
  


• Develop PL/SQL, stored procedures, and triggers, and manage SQL Loader / ETL processes for loading data into Oracle on RHEL and Windows
  


• Design and document logical and physical data models for all Oracle instances using Erwin; build data marts and dimensional models, including aggregation, partitioning, and indexing strategies
  


• Perform database backup and recovery (hot and cold), apply Oracle Critical Patch Updates, and execute major-release Oracle upgrades
  


• Implement Oracle security management and data-integrity controls
  


• Provide application database analysis support throughout the project life cycle, including code and data-related object promotions and database change management
  


• Act as backup to the Senior DBA, and as backup to monitor and service the components of Oracle WebLogic, as needed
  


• Manage application log communication with ArcSight and Splunk
  


• Build and maintain reports using data visualization and business intelligence tools to meet DLA customer needs; assist team members with data imports and other areas as needed
  


• Participate in migration of Oracle database application servers to Military and Government Azure environments
  


• Produce required deliverables — scripts and source code supporting the database and financial application, and performance/tuning evaluation reports
  


• Attend and participate in DLA Information Operations status meetings and meetings with DLA Financial Management Office personnel
  


• Maintain currency with new Oracle technology releases annually and provide the COR verification of related annual training

REQUIRED QUALIFICATIONS

• Active Secret Clearance
  


• Oracle Certified Professional (OCP) certification
  


• Minimum five (5) years relevant experience
  


• At least three (3) years Financial Website experience within the Federal Government
  


• At least three (3) years Federal Government Audit Readiness & Reconciliation experience
  


• Relevant certification from a nationally recognized technical authority
  


• DoD 8570.01-M / 8140 IAT Level I baseline certification (e.g., CompTIA A+ CE, Network+ CE, SSCP, or another DoD-approved IAT Level I baseline)
  


• Appropriate Computing Environment (CE) certification as outlined by the Cybersecurity Computing Environment Certification Working Group, applicable to the platform administered (Oracle database)
  


• Proficiency in Java, Python, WebLogic scripting, Linux shell scripting, C#, and HTML/JavaScript
  


• Strong Oracle RDBMS experience — SQL and PL/SQL, stored procedures, triggers, and data-access optimization; SQL Loader and ETL into Oracle on RHEL and Windows
  


• Data modeling with Erwin (logical and physical) and analytical, large-scale data model experience; data-mart population and dimensional modeling (aggregation, partitioning, indexing)
  


• Database performance and tuning; backup and recovery (hot and cold); Oracle Critical Patch Update maintenance; major-release upgrades; physical database design; and data warehousing features
  


• Oracle security management and data-integrity implementation
  


• Oracle Enterprise Manager experience
  


• Red Hat Enterprise Linux (RHEL) experience, including shell scripting (Bourne, Korn)
  


• Experience with ArcSight and Splunk
  


• Full project life-cycle experience in code migration, database change management, and data management; ability to manage multiple projects
  


• Demonstrated experience migrating Oracle database application servers to Military and Government Azure environments
  


• Additional stack familiarity: Visual Basic, Java, Java scripting, current Oracle version, and RHEL
  


• Strong problem-solving, documentation, and customer-communication skills
  


• Preferred: experience with source control tools such as GIT