Oracle Database Administrator

Parsons•Springfield, MO

About The Position

Parsons is seeking and Oracle Database Administrator to maintain and support operational Oracle databases, ensuring efficient data transformation processes for storing and retrieving customer data within a data warehouse environment. In this role, you will configure, maintain, and administer application-specific databases, ingest data from both internal and external sources, and present that data for analytics and business intelligence purposes.

Requirements

An active Top-Secret security clearance.
Ability to obtain and maintain an SCI.
Ability to obtain and maintain a CI POLY.
Bachelor’s degree and 8+ years of relevant work experience. In lieu of a degree, 13+ years of work-related experience will be considered.
A minimum of 5+ years of experience with Oracle APEX and ORDS applications.
Demonstrable proficiencies in SQL and SQL Plus languages.
Experience managing Oracle databases.

Nice To Haves

Performance Monitoring & Optimization.
Skilled in analyzing and improving database performance and scalability.
Database Security Best Practices.
Knowledge of role-based access, encryption, auditing, and compliance requirements.
Experience with Linux/Unix Environments.
Comfortable navigating and scripting in command-line environments.
Backup and Disaster Recovery Planning.
Familiar with RMAN, Data Guard, and other backup/recovery strategies.
Scripting and Automation.
Experience with tools like Bash, Python, or Ansible for task automation.

Responsibilities

Managing provisioned data warehouse and application databases in an Oracle Exadata Cloud Services environment.
Performing daily database administration functions, which involve developing queries and reports based on customer requirements, modifying or creating database views, and managing backup and recovery operations.
Monitoring database performance, publishing daily performance metrics, and resolving database issues that impact application performance.
Applying vendor-provided updates to database tables and schemas.
Managed and configured Oracle APEX to support multiple mission-critical applications.
Designing logical data relationships and query structures based on customer requirements, considering factors such as access methods, access frequency, storage media, data volatility, query requirements, and operating environments.
Evaluating data sets and engineering solutions for integration into the Data Warehouse.
Developing, sustaining, and maintaining user manuals and instructions to guide customers in executing data access functions, such as running queries and reports.
Participating in multi-functional teams and managing work through JIRA.