Oracle Database Administrator

$104,200 - $182,400/Yr

Parsons - Springfield, VA

posted 3 months ago

Full-time - Mid Level
Springfield, VA
Professional, Scientific, and Technical Services

About the position

As an Oracle Database Administrator at Parsons, you will play a crucial role in managing and optimizing our database systems to support various applications and data analysis efforts. Your responsibilities will include performing daily database administration functions such as performance monitoring, developing queries and reports based on customer requirements, modifying or developing database views, and managing backup and recovery operations. You will be tasked with designing the logical data relationships and query structures of new databases, taking into account factors such as access methods, access frequency, storage media, data volatility, query requirements, and operating environments. This is essential for supporting insider threat detection application software and data analysis initiatives. In addition to designing new databases, you will also be responsible for creating enterprise database strategies for functions such as backup, recovery, and data migration. You will sustain existing Data Warehouse and application databases, ensuring they operate efficiently and effectively. Evaluating data sets and engineering solutions for integrating them into the Data Warehouse will be a key part of your role. Furthermore, you will develop, sustain, and preserve user manuals and instructions that guide customers in executing data access functions, such as running queries and reports. Collaboration is vital in this position, as you will participate in multi-functional teams and manage your work through JIRA, ensuring that projects are completed on time and meet the required standards.

Responsibilities

  • Perform daily database administration functions such as performance monitoring, developing queries and reports based on customer requirements, modifying or developing database views, and managing backup and recovery operations.
  • Design the logical data relationships and query structures of new databases considering factors such as access methods, access frequency, storage media, data volatility, query requirements, and operating environments to support insider threat detection application software and data analysis.
  • Design enterprise database strategies for functions such as backup, recovery and data migration.
  • Sustain existing Data Warehouse and application databases.
  • Evaluate data sets and engineer solutions for integrating into the Data Warehouse.
  • Develop, sustain and preserve user manuals and instructions that guide customers in executing data access functions such as running queries and reports.
  • Participate in multi-functional teams and manage work through JIRA.

Requirements

  • Bachelors or equivalent experience in related field.
  • Experience with SQL and SQL Plus languages.
  • Experience managing Oracle databases.
  • Experience building and scheduling data integration scripts that automate the ingestion of data from multiple sources (Oracle, SQL, Postgres).

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Paid time off
  • 401(k)
  • Life insurance
  • Flexible work schedules
  • Holidays
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service