Oracle Database Administrator

SDA Solutions LLC
Arlington, VA, United States
21 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$87,100.0 - $152,450.0
Working hours
Regular working hours

Tech stack

Agile Methodology Application Performance Management Automation of Tests Cyber Security Databases Database Design Database Queries Database Security Oracle Data Guard Failover Integrated Development Environments PostgreSQL
+16 more
NoSQL Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Software Deployment Software Requirements Analysis SQL Stored Procedures PL-SQL SQL Databases Diagnostic Tools Enterprise Software Applications Sql Optimization System Availability Database Performance Sql Tuning

Job description

SDA Solutions is seeking an experienced Oracle Database Administrator to support a mission-critical Department of Defense program in Arlington, Virginia. This position is responsible for administering, optimizing, and maintaining highly available Oracle database environments supporting enterprise applications within a secure, classified infrastructure.

The ideal candidate is a motivated database professional with experience designing, implementing, and maintaining Oracle database environments while ensuring high availability, performance, security, and reliability.

Responsibilities Administer, maintain, and support Oracle database environments supporting mission-critical applications. Design, implement, and maintain database schemas, structures, and objects based on system requirements. Perform daily database administration, monitoring, troubleshooting, and maintenance activities. Monitor database performance, memory utilization, and overall system health using standard database administration tools. Identify and resolve database performance issues through SQL optimization and performance tuning. Develop, modify, and maintain SQL scripts, PL/SQL procedures, stored procedures, and database automation scripts. Create ad hoc queries, reports, and data extracts to support operational and business requirements. Implement and maintain database security, user permissions, and access controls in accordance with security policies. Troubleshoot and resolve database availability, replication, and performance issues. Plan for database growth, storage requirements, and long-term capacity planning. Collaborate with software developers to optimize database design, SQL queries, and application performance. Develop and maintain database documentation, operational procedures, standards, and technical guides. Support database integration, validation, testing, and production deployments. Maintain data integrity, maximize system availability, and participate in on-call support as required. Work independently while collaborating effectively with engineering, infrastructure, and development teams.

Requirements

Active TS/SCI security clearance with the ability to obtain and maintain a CI Polygraph. Bachelor’s degree in a technical discipline and 8 or more years of relevant experience. Additional education, training, or experience may be considered in lieu of a degree. Minimum five (5) years of experience as an Oracle Database Administrator. Minimum five (5) years of experience administering Oracle Database 12c, 19c, or later. Experience implementing and maintaining Oracle database security. Experience monitoring, troubleshooting, and tuning Oracle database performance. Experience diagnosing and resolving database-related issues in enterprise environments. Strong experience developing and optimizing PL/SQL procedures, packages, and scripts. Experience writing SQL queries for both operational support and reporting. Excellent written and verbal communication skills. Ability to effectively communicate and collaborate with technical teams and stakeholders. Required Certification

Current DoD 8570/8140 IAT Level II certification. Acceptable certifications include:

Security+ CE CySA+ CCNA Security, Equivalent DoD-approved IAT Level II certification, Experience supporting DISA or other Department of Defense enterprise environments. Experience with Oracle Data Guard, including configuration, monitoring, failover, and switchover. Experience performing SQL performance tuning utilizing AWR, ADDM, and other Oracle diagnostic tools. Experience working within Agile or SAFe software development environments. Experience with Oracle database design and development. Experience supporting PostgreSQL or other relational and NoSQL database platforms. Experience developing with Oracle SQL and PL/SQL. Why SDA Solutions?

About the company

SDA Solutions is committed to delivering innovative technology solutions that support critical national security missions. We value collaboration, technical excellence, and professional growth while providing our employees with opportunities to work on meaningful programs supporting our federal customers.

If you’re looking to apply your Oracle database expertise in a challenging, mission-focused environment, we’d like to hear from you.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.clearancejobs.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:59 min

Scaling clusters and handling automated replica failover

Jürgen Pilz · WWC 2023

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

7:52 min

Audience questions on database performance, deployments, and data migrations

Gregor Bauer Gregor Bauer · LIVE

5:25 min

Implementing redundancy, failover, and architectural load balancing patterns

Mihaela-Roxana Ghidersa · LIVE

3:16 min

Terminology differences between relational and NoSQL databases

Tim Faulkes · LIVE

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

Videos

See all

Related articles

See all