Oracle Database Administrator

Concept Plus, LLC; United States; Remote; USD 110,000 - 140,000; Full time

Job summary

Concept Plus is seeking an Oracle DBA to provide technical support for a federal client’s systems, focusing on daily sustainment of a Web/Oracle architecture in AWS. The role requires maintaining databases, configurations, and compliance with DISA STIGs, while coordinating releases and backups.

The ideal candidate has 3+ years of Oracle DBA experience, Oracle PL/SQL expertise, and AWS RDS know-how, plus an active Secret clearance or ability to obtain one.

Qualifications

• US citizen with active Secret Clearance.
• BA/BS preferred, can be replaced by additional experience.
• 3+ years of Oracle DBA experience and infrastructure software development.
• 1+ year database management in AWS Cloud (RDS).
• 3+ years of Oracle PL/SQL experience.
• Experience with Oracle database replication.
• Security+ CE or CCNA Security certification required.
• Active Secret Clearance or ability to obtain Secret Clearance.
• Knowledge of AWS and/or OCI technologies.

Responsibilities

• Maintain database and configuration on DB servers and hosting areas.
• Update and track TCNOs and related NOTAMs for database support.
• Coordinate firewall access and release schedules with PMO.
• Install maintenance releases of client applications and resolve anomalies.
• Develop database strategies, monitoring, and performance improvements.
• Ensure compliance with STIGs and prepare release packages for migrations.
• Maintain schema and supporting processes for CAB; ensure data availability for analysis.
• Facilitate backups and assist with restore testing and CVI/QT&E testing.

Skills

Oracle DBA

Oracle PL/SQL

AWS RDS

Oracle replication

DevSecOps / Agile

Education

BA/BS degree

Security+ CE or CCNA Security certification

Tools

Oracle Certified Professional

AWS Gov Cloud / Cloud One experience

Job description

About the role

Concept Plus is seeking an Oracle DBA to provide technical support to a federal clients’ systems. The primary focus is daily sustainment for a Web/Oracle system architecture in AWS.

What you’ll do

• Maintaining the database and configuration on each database server and/or Cloud One, or any other hosting area, the Government deems fit
• Maintaining system configuration if third party software is utilized on the hosting environments · Updating and tracking Time Compliance Network Orders (TCNOs) and if applicable, NOTAMS related to database support
• Coordinating firewall access to maintain mainframe/server accessibility for users and interfaces
• Coordinating release schedules with the PMO and interfacing partners
• Installing new maintenance releases of client applications
• Resolving system anomalies
• Developing database strategies, system monitoring, and improvements to database performance and capacity, and plan for future requirements
• Complying with DISA Security Technical Implementation Guides (STIGs)
• Preparing software release packages to migrate to newer versions of COTS (hardware or software)
• Modifying the database structure based on approved software changes
• Maintaining, updating, and ensuring the schema. Processes, and subprocesses that are required for reports from the Propulsion Actuarial Client Server are available and useable by the Propulsion community 100% of the time to ensure all data analysis, forecasting, and other requirements can be always fulfilled
• Facilitating backups; ensure data is accurate and complete if restored from a backup; and assist with the backup restoration
• Preparing databases to be used in testing to include but not limited to Component Validation and Integration (CV&I), Qualification Test and Evaluation (QT&E), performance testing, user-acceptance testing, and regression testing
• Support customer with audit compliance reviews with task like data-calls and PBC responses
• Develop Infrastructure as Code(IaC) scripts for database related solutions

Required Qualifications

• US Citizen with active Secret Clearance
• BA/BS preferrable, can be replaced by additional experience
• 3 years of DBA experience (Oracle) and Infrastructure software development
• 1+ years Database management in an AWS Cloud environment (RDS)
• 3+ years of experience with Oracle PL/SQL
• Experience with Oracle database replication · Security+ CE or CCNA Security certification required
• Active Secret Clearance or the ability to obtain a Secret Clearance
• Knowledge of AWS and/or OCI related technologies and utilities

Preferred Qualifications

• Oracle Certified Professional for 11g or above · Strong interpersonal and communications skills.
• AGILE Environment experience, DevSecOps
• Have AWS Cloud One or AWS Gov Cloud experience

Concept Plus is an Equal Opportunity Employer. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.