Data Engineer, Mid

$80,226 - $103,500/Yr

Unclassified - Chicago, IL

posted about 2 months ago

Full-time - Mid Level
Remote - Chicago, IL
10,001+ employees

About the position

As a Database Analyst Advisor at GDIT, you will play a crucial role in transforming data into actionable insights for our clients. Your responsibilities will encompass the design, planning, implementation, and administration of databases, ensuring their security, access, and proper documentation. You will be tasked with establishing, implementing, and maintaining GFM Oracle RDBMS servers that support both development and quality assurance testing operations. This includes installing Oracle RDBMS software, performing necessary upgrades, and developing a patching schedule to address vulnerabilities promptly. In addition, you will evaluate and apply DoD Security Technical Implementation Guides (STIGs) and establish a robust Oracle DBMS High Availability plan, which includes strategies like Flashback, Snapshots, and RMAN/Hot/Cold Backups. Addressing Oracle RDBMS downtime and performance issues will be a critical part of your role, as will creating and troubleshooting RHEL Linux shell scripts. You will also be responsible for supporting release deployments of DDL/DML scripts and assisting various GFM teams with on-demand data and business-oriented queries by familiarizing yourself with the data relationships and structures across multiple applications and schemas within the GFM ecosystem. Your work will support Agile development projects that are managed by time-sensitive schedules and sprints, focusing on database changes that range from structural to logical, with an emphasis on quality, performance, and adherence to standards. You will maintain database configuration control across multiple environments, including Development, QA/Test, Government Test, and Production. Additionally, you will migrate Oracle AWS GovCloud EC2-based databases to AWS RDS for Oracle databases and perform regular data-related tasks such as performance monitoring and generating reports. Flexibility in your schedule will be necessary to support after-hour production deployments and to respond to emergency issues in an on-call capacity.

Responsibilities

  • Design, plan, implement, and administer databases, ensuring security and access.
  • Establish, implement, and maintain GFM Oracle RDBMS servers for development and QA testing.
  • Install and upgrade Oracle RDBMS software as necessary.
  • Develop a patching schedule to address vulnerabilities in a timely manner.
  • Evaluate and apply DoD Security Technical Implementation Guides (STIGs).
  • Establish and maintain Oracle DBMS High Availability plans including Flashback, Snapshots, and RMAN/Hot/Cold Backups.
  • Address Oracle RDBMS downtime and performance issues promptly.
  • Create and troubleshoot RHEL Linux shell scripts.
  • Support release deployment of DDL/DML scripts.
  • Assist GFM teams with on-demand data and business-oriented queries.
  • Support Agile development projects with database changes focusing on quality and performance.
  • Maintain database configuration control across multiple environments.
  • Migrate Oracle AWS GovCloud EC2-based databases to AWS RDS for Oracle databases.
  • Perform regular data-related tasks such as performance monitoring and reporting.

Requirements

  • 5+ years of related experience in administering Oracle DBMS and coding Oracle database solutions.
  • Strong SQL and PL/SQL skills with troubleshooting capabilities related to performance and database structure.
  • Experience with application design utilizing various database management systems and knowledge of DBMS internals.
  • 3 years of experience in establishing and deploying new Oracle database systems and solutions.
  • Experience with AWS Gov Cloud environment.
  • IAT II certification required.

Nice-to-haves

  • Technical training, certifications, or degree in a relevant field.

Benefits

  • 401K with company match
  • Comprehensive health and wellness packages
  • Internal mobility team dedicated to career development
  • Professional growth opportunities including paid education and certifications
  • Paid vacation and holidays
  • Paid parental leave
  • Paid military leave
  • Paid bereavement leave
  • Paid jury duty leave
  • Short and long-term disability benefits
  • Life and accidental death and dismemberment insurance
  • Critical illness and business travel accident insurance.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service