Database Administrator

This is a fully remote position, open to applicants in District of Columbia, +1 more state.

📋 Description

• Provide support for mission-critical Oracle databases and the DLA Financial Website by developing code and conducting Oracle database analysis in RHEL and Windows development and production environments; continuously perform database object creation and performance tuning.

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

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

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

• Execute database backup and recovery (both hot and cold), apply Oracle Critical Patch Updates, and carry out major-release Oracle upgrades.

• Implement Oracle security management and data integrity controls.

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

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

• Manage application log communication with ArcSight and Splunk.

• Construct and maintain reports using data visualization and business intelligence tools to fulfill DLA customer requirements; assist team members with data imports and other tasks as needed.

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

• Produce necessary deliverables — scripts and source code supporting the database and financial application, along with performance/tuning evaluation reports.

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

• Keep up-to-date with new Oracle technology releases annually and provide the COR verification of related annual training.

⛳️ Requirements

• Active Secret Clearance.

• Oracle Certified Professional (OCP) certification.

• A minimum of five (5) years of relevant experience.

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

• A minimum of three (3) years of experience in Federal Government Audit Readiness & Reconciliation.

• 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 specified 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 experience with Oracle RDBMS — 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 (both logical and physical) and experience with analytical, large-scale data modeling; data-mart population and dimensional modeling (aggregation, partitioning, indexing).

• Expertise in 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.

• Implementation of Oracle security management and data integrity controls.

• Experience with Oracle Enterprise Manager.

• Familiarity with Red Hat Enterprise Linux (RHEL), including shell scripting (Bourne, Korn).

• Experience with ArcSight and Splunk.

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

• Proven experience in migrating Oracle database application servers to Military and Government Azure environments.

• Familiarity with additional stacks: Visual Basic, Java, Java scripting, current Oracle version, and RHEL.

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

🏝️ Benefits

• 401(k) matching.

• Bonus based on performance.

• Competitive salary.

• Dental insurance.

• Health insurance.

• Paid time off.

• Parental leave.

• Training & development.

• Vision insurance.