Sign upLog in
See more jobs

Database Administrator

Cb
  • Remote
    30+ days ago

    Job Description

    Replies within 24 hours
    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.

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




    Numbers & Facts

    Location (
    Remote
    )

    Skills

    • Analysis Skillsunmatched
    • ArcSightunmatched
    • Business Intelligence Softwareunmatched
    • Change Managementunmatched
    • Communication Skillsunmatched
    • Computer Certificationsunmatched
    • Computer Systemsunmatched
    • Data Managementunmatched
    • Data Martunmatched
    • Data Modelingunmatched
    • Data Processingunmatched
    • Data Qualityunmatched
    • Data Recoveryunmatched
    • Data Visualizationunmatched
    • Data Warehousingunmatched
    • Database Administrationunmatched
    • Database Analysisunmatched
    • Database Backupunmatched
    • Database Designunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Recoveryunmatched
    • Database Triggersunmatched
    • Dental Insuranceunmatched
    • Design Documentunmatched
    • Dimensional Modelingunmatched
    • Documentationunmatched
    • Federal Governmentunmatched
    • Finance Softwareunmatched
    • Financial Auditunmatched
    • Financial Managementunmatched
    • Financial Reportingunmatched
    • Gitunmatched
    • Governmentunmatched
    • HTML (HyperText Markup Language)unmatched
    • Health Insuranceunmatched
    • Information/Data Security (InfoSec)unmatched
    • Internet Securityunmatched
    • Intranet Software/Applicationunmatched
    • Javaunmatched
    • JavaScriptunmatched
    • Linux Operating Systemunmatched
    • Logisticsunmatched
    • Microsoft C# (C Sharp)unmatched
    • Microsoft Visual Basicunmatched
    • Microsoft Windows Azureunmatched
    • Microsoft Windows Operating Systemunmatched
    • Militaryunmatched
    • Multiplatform/Cross-Platformunmatched
    • Multitaskingunmatched
    • Oracleunmatched
    • Oracle Application Serverunmatched
    • Oracle DBA (Database Administrator)unmatched
    • Oracle Databaseunmatched
    • Oracle Enterprise Managerunmatched
    • Oracle PL-SQLunmatched
    • Oracle SQL*Loaderunmatched
    • Oracle WebLogic Serverunmatched
    • Performance Analysisunmatched
    • Performance Tuning/Optimizationunmatched
    • Problem Solving Skillsunmatched
    • Production Systemsunmatched
    • Project Lifecycleunmatched
    • Project/Program Managementunmatched
    • Python Programming/Scripting Languageunmatched
    • Reconciliationunmatched
    • Red Hat Linux Operating Systemunmatched
    • SQL (Structured Query Language)unmatched
    • Scripting (Scripting Languages)unmatched
    • Secret Clearanceunmatched
    • Security Information and Event Management (SIEM)unmatched
    • Sh (Bourne Shell) Scriptingunmatched
    • Software Patchesunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • Splunkunmatched
    • Stored Proceduresunmatched
    • Systems Administration/Managementunmatched
    • Test Plan/Scheduleunmatched
    • Training/Teachingunmatched
    • United States Department of Defense (DoD)unmatched
    • Unix Shell Programmingunmatched
    • Vision Planunmatched
    • Web Designunmatched
    • erwin Data Modelerunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder