Data Engineering Lead

TransunionNew York, NY
72d$112,500 - $187,500Hybrid

About The Position

TransUnion is seeking a highly skilled Data Engineer to join the SRE Data Engineering team, specializing in Oracle, PostgreSQL, Oracle GoldenGate, Ab Initio, and related data infrastructure technologies. The ideal candidate will have a strong foundation in database engineering, replication, and automation, with proven experience in large-scale migrations and operational support. At TransUnion, we have a welcoming and energetic environment that encourages collaboration and innovation. We are consistently exploring new technologies and tools to be agile. This environment gives our people the opportunity to hone current skills and build new capabilities, while discovering their genius.

Requirements

  • 10+ years in database engineering with expertise in Oracle and PostgreSQL.
  • Proven experience with Oracle GoldenGate bidirectional replication and pglogical.
  • Strong background in Oracle on NetApp storage (ONTAP, SnapMirror, SnapVault).
  • Proficiency in SQL, PL/SQL, Shell scripting, and automation using Ansible.
  • Experience with incident management, root cause analysis, and performance tuning.
  • Familiarity with infrastructure automation tools (Ansible, Terraform) and monitoring solutions.
  • Bachelor's degree in Computer Science or related field.
  • Experience supporting Mapr and migration of Mapr.
  • Experience supporting Abinitio and migration of Abinitio.

Nice To Haves

  • PostgreSQL or Oracle certifications preferred.

Responsibilities

  • Serve as a subject matter expert for Oracle and PostgreSQL database operations, including performance tuning, troubleshooting, and root cause analysis.
  • Manage Oracle and PostgreSQL database activities such as installation, patching, upgrades, and migrations.
  • Design and implement backup, replication, and disaster recovery strategies for PostgreSQL and Oracle.
  • Provide expertise in Oracle on NetApp storage and related implementations.
  • Collaborate with DevOps and SRE teams to automate database operations and integrate with CI/CD pipelines.
  • Partner with application teams for schema changes, query optimization, and deployment processes.
  • Drive the database modernization roadmap, focusing on PostgreSQL adoption and pglogical replication.
  • Ensure compliance with security, audit, and governance standards.

Benefits

  • Flexible time off for exempt associates.
  • Paid time off for non-exempt associates.
  • Up to 12 paid holidays per year.
  • Health benefits (including medical, dental, and vision plan options and health spending accounts).
  • Mental health support.
  • Disability benefits.
  • Up to 12 weeks of paid parental leave.
  • Adoption assistance.
  • Fertility planning coverage.
  • Legal benefits.
  • Long-term care insurance.
  • Commuter benefits.
  • Tuition reimbursement.
  • Charity gift matching.
  • Employee stock purchase plan.
  • 401(k) retirement savings with employer match.
  • Access to TransUnion's Employee Resource Groups.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume

What This Job Offers

Job Type

Full-time

Career Level

Senior

Industry

Administrative and Support Services

Education Level

Bachelor's degree

Number of Employees

5,001-10,000 employees

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service