Parsons-posted 5 days ago
Full-time • Mid Level
Springfield, MO
5,001-10,000 employees

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.

  • 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.
  • An active Top-Secret security clearance.
  • Ability to obtain and maintain an SCI.
  • Ability to obtain and maintain a CI POLY.
  • Bachelor’s degree in a STEM with 8+ years of relevant work experience. In lieu of a Bachelor’s 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.
  • 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.
  • medical
  • dental
  • vision
  • paid time off
  • 401(k)
  • life insurance
  • flexible work schedules
  • holidays
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service