Mid Database Administrator

ID 2024-2581
Job Locations
US
Category
Information Technology
Type
Regular Full-Time

Overview

DecisionPoint Corporation is seeking a Mid Database Administrator to join our US Transportation Command – Global Freight Management team. The Mid-Level Database Administrator is responsible for the design, implementation, and maintenance of Oracle databases, ensuring optimal performance, security, and availability. This role involves administering GFM Oracle RDBMS servers, installing and upgrading Oracle software, and applying DoD Security Technical Implementation Guides (STIGs). The administrator will develop patching schedules, maintain high availability plans, and address downtime or performance issues efficiently. Additionally, the role includes supporting Agile development projects, managing database configuration across various environments, and migrating databases to AWS RDS. With expertise in SQL, PL/SQL, and RHEL Linux scripting, the administrator assists teams with data queries and ensures quality performance.

Duties & Responsibilities

  • Responsible for designing, planning, implementing, and administering databases, including security, access, and documentation
  • Establish, implement, and maintain GFM Oracle RDBMS servers supporting both development and quality assurance testing operations.
  • Install Oracle RDBMS software and upgrade as necessary.
  • Develop patching schedule to ensure vulnerabilities are addressed in a timely manner.
  • Evaluate and apply DoD Security Technical Implementation Guides (STIGs).
  • Establish and maintain Oracle DBMS High Availability plan (Flashback, Snapshots, RMAN/Hot/Cold Backups, etc)
  • Address Oracle RDBMS downtime and/or performance issues in a timely manner
  • Create and troubleshoot RHEL Linux shell scripts
  • Create of notifications to advise of Oracle RDBMS issues
  • Support release deployment of DDL/DML scripts
  • Assist all GFM teams including customer with on-demand data and business-oriented queries by becoming familiar with data, data relationships and data structures across several applications and schemas that make up the GFM ecosystem
  • Support Agile development projects managed by time-sensitive schedules/sprints with Database changes ranging from structural to logical with emphasis on quality, performance, and standards.
  • Maintain Database configuration control across multiple Development, QA/Test, Government Test and Production environments.
  • Migrate Oracle AWS GovCloud EC2-based databases to AWS RDS for Oracle databases
  • Perform daily, weekly, monthly, and annual data-related tasks such as performance monitoring, weekly/monthly reports, and Carrier Rate Loads.
  • Flexible schedule to support weekly after-hour Production deployments and to answer emergency problems in an on-call status.

Qualifications

  • Active Secret Clearance.
  • Must hold an active an IAT Level II certification; CompTIA Security+ CE highly preferred.
  • 4+ years of experience administering Oracle DBMS, coding Oracle database solutions, and utilizing current database management system (DBMS) technologies.
  • Minimum of 3 years’ experience in establishing and deploying new Oracle database systems and solutions
  • Strong expertise in SQL and PL/SQL with demonstrated ability to troubleshoot performance issues, optimize database structures, and manage stored procedures.
  • Proven experience in application design and development using various DBMS, along with a deep understanding of DBMS internals.
  • Experience with AWS Gov Cloud environment

Our Equal Employment Opportunity Policy

  • EEO and Affirmative Action Policy: DecisionPoint Corporation is an Equal Employment Opportunity and Affirmative Action employer. It is the policy of DecisionPoint Corporation to provide equal employment opportunity in accordance with all applicable Equal Employment Opportunity/Affirmative Action laws, directives and regulations to all employees and qualified applicants without regard to race, ethnicity, color, religion, national origin, sex, age, disability status, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected status under Federal, State or Local laws.
  • Pay Transparency Policy: In accordance with Presidential Executive Order 13665, DecisionPoint Corporation will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
  • Authorization to Share Resume and Personal Information: By expressing your interest and submitting your resume for this position, you authorize DecisionPoint Corporation to share your resume, as well as personal information included on the resume, with its subsidiaries, affiliates and teaming partners for the purpose of considering you for this position and other available positions requiring comparable skills, education and experience. Should DecisionPoint Corporation. or its affiliates and teaming partners wish to initiate pre-employment discussions, you will be asked to complete an employment application and related employment documents.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed