About the role

What will you do at Basecamp Consulting and Solutions LLC?

Benefits

401(k) matching

Bonus based on performance

Competitive salary

Dental insurance

Health insurance

Paid time off

Parental leave

Training & development

Vision insurance

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

This is a remote position.

Which skills does this role require?

Erwin Data ModelingAzure MigrationETL ProcessesOracle WebLogicArcSightSplunkJavaPythonLinux Shell ScriptingC#HTML/JavaScriptDoD 8570.01-MIAT Level IETLData MartDimensional ModelingWebLogicHTMLJavaScriptShell ScriptingAudit ReadinessData IntegrityGitVisual BasicEnterprise ManagerMachine Learning

Make your next move

Build a shortlist and prepare

Identify the requirements you can demonstrate, then choose examples from your work to discuss with the hiring team.

Build a focused shortlist before you applyCompare role requirements with your experience and give each application a clear reason.
Practice explaining your experience in an interviewRehearse your answers before meeting the hiring team.

Review the responsibilities and requirements before adding an opening to your shortlist.