Database Administrator

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

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

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

This is a remote position.

Compensation: $125,000.00 - $145,000.00 per year