Job Description

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.

What You'll Be Doing:

• 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.

What Required Skills You'll Bring:

• An active Top-Secret security clearance.
• Ability to obtain and maintain an SCI.
• Ability to obtain and maintain a CI POLY.
• Bachelors degree in a STEM with 8+ years of relevant work experience. In lieu of a Bachelors 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.

What Desired Skills You'll Bring:

• 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.

Job Tags

Similar Jobs