Oracle Database Administrator

RMantra Solutions; Alexandria, Northern (VA, KY); Hybrid; USD 120,000 - 150,000; Full time

Job summary

RMantra Solutions is seeking a seasoned Database Administrator in Arlington, VA, onsite with occasional travel. The role requires an active DOD TS/SCI clearance and 5+ years of DBA experience, with Oracle 12c/19c proficiency and security expertise.

Responsibilities include designing schemas, tuning SQL, monitoring performance, and ensuring data protection. You will collaborate with developers to optimize queries and workflows, and may be on-call to maintain uptime.

Qualifications

• Bachelor’s degree in a technical discipline and at least eight years of experience.
• Active DOD TS/SCI clearance (CI poly possible).
• Minimum of five years of demonstrated database administration experience.

Responsibilities

• Plan, implement, and maintain database schemas and structures.
• Monitor and optimize SQL performance; address bottlenecks.
• Perform daily database administration and troubleshooting of system databases and replication.
• Enforce security measures, set up user permissions, and ensure data protection compliance.
• Collaborate with developers to optimize queries and database design for applications.
• Provide on-call support and ensure maximum uptime.

Skills

Database administration

SQL tuning

PL/SQL

Leadership

Communication

Education

Bachelor’s degree

Tools

Oracle Database

SQL

AWR/ADDM

Oracle Data Guard

Job description

This position is 100% Onsite. This position is in Arlington, VA, with occasional/situational travel.

Certificate

Location:

Schedule

100% onsite

Clearance

US Citizens withDOD Top Secret/SCI

• Performs technical planning, system integration, verification and validation, cost and risk, and support ability and effectiveness analysis.
• Proactively monitors database health, optimizes SQL code, and addresses performance bottlenecks.
• Designs and implements database schemas and structures according to project requirements.
• Perform daily database administration, monitoring, and troubleshooting of system database and replication issues.
• Monitor database performance and memory allocations using standard tools.
• Develops and maintains documentation for database environments, including data standards and procedures.
• Develop and execute SQL queries for routine and ad hoc requests.
• Modify existing database scripts to enhance systems support and create new database scripts for recurring database issues.
• Implements security measures, sets up user permissions, and ensures compliance with data protection policies.
• Translate requirements and data into usable database schemas by creating or recreating ad hoc queries, scripts and macros, making updates to existing queries, and creating new queries to manipulate data into a master file.
• Plans for storage requirements and database growth, and scale infrastructure as needed.
• Maintains data accuracy and ensures maximum uptime and may require some on-call support.
• Troubleshoot and resolve database problems.
• Collaborates with developers to optimize queries, stored procedures, and database design for applications.
• Must be a self-starter, strong leader, and the ability to work independently with little supervision.

Basic Qualifications

• Candidate must possess an active DOD TS/SCI. May be asked to obtain CI Poly.
• Bachelor’s degree in a technical discipline and at least eight (8) years of relevant experience. Additional experience may be substituted for a degree.
• Must have at least five (5) years of demonstrated experience as a database administrator.
• Must have at least five (5) years of Oracle Database Administration experience, specifically with Oracle 12c, 19c, or later.
• Must have in-depth experience implementing and maintaining database security.
• Must have in-depth experience conducting database performance tuning and monitoring.
• Must have in-depth experience troubleshooting and resolving database problems/issues.
• Must have experience with procedural languages such as PL/SQL and proficiency in PL/SQL development and optimization.
• Excellent written and verbal communication skills
• Demonstrated experience communicating effectively across internal and external organizations
• Preferred prior experience with DISA and DISA’s support to mission partners

Preferred Qualifications

• Experience with real time highly available data replication technologies such as Oracle Data Guard (configuration, monitoring, failover/switchover).
• Experience with SQL tuning and diagnostic skills including performance tuning (AWR ADDM).
• Experience with the Scaled Agile Framework (SAFe) methodology and/or as a member of an Agile team.
• Experience with database design and development.
• Extensive, in-depth understanding of databases, primarily Oracle and/or other relational and non-relational/NoSQL databases such as PostgreSQL.
• Experience using Oracle SQL/PLSQL, and SQL in general.

Join a dynamic team where your ideas matter and your career thrives.