Database Administrator

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., * 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

• 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

Pulled from the full job description

• Parental leave
• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Dental insurance, * 401(k) matching
• Bonus based on performance
• Competitive salary
• Dental insurance
• Health insurance
• Paid time off
• Parental leave
• Training & development
• Vision insurance