Remote Oracle DBA for Mission-Critical Data & Security

Basecamp Consulting and Solutions LLC; United States; Remote; USD 125,000 - 145,000; Full time

Job summary

Basecamp Consulting and Solutions LLC seeks a seasoned Database Administrator to manage Oracle RDBMS, PL/SQL, and data modeling on RHEL/Windows for the DLA Financial Website. The role includes performance tuning, backups, patching, upgrades, and security controls with DoD compliance.

Remote position with periodic on-site support at Fort Belvoir, VA or DC area. Active Secret clearance and OCP certification required.

Qualifications

• 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.
• 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).
• 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.
• 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.

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

Skills

Oracle RDBMS

PL/SQL

Erwin data modeling

Backup and recovery

Oracle security

ArcSight

Splunk

Azure migration

RHEL

SQL Loader/ETL

GIT (preferred)

Tools

Erwin

ArcSight

Splunk

SQL Loader

ETL

GIT

Job description

Basecamp Consulting and Solutions LLC seeks a seasoned Database Administrator to manage Oracle RDBMS, PL/SQL, and data modeling on RHEL/Windows for the DLA Financial Website. The role includes performance tuning, backups, patching, upgrades, and security controls with DoD compliance.

Remote position with periodic on-site support at Fort Belvoir, VA or DC area. Active Secret clearance and OCP certification required.