Basecamp Consulting & Solutions LLC
Database Administrator
Full Time • Fully Remote - US
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.
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.
Compensation: $125,000.00 - $145,000.00 per year
(if you already have a resume on Indeed)