Senior Data Engineer
Grainger
ApacheAWSAzureCloudDistributed SystemsDockerETLGoogle Cloud PlatformKafkaKubernetesOpenShiftPostgres+5 more
Data Engineering Lead
TransUnion
full-time
Posted on:
Location Type: Hybrid
Location: Chicago • Illinois, New York, Pennsylvania, Virginia • 🇺🇸 United States
Visit company websiteSalary
💰 $112,500 - $187,500 per year
Job Level
Senior
Tech Stack
AnsibleOraclePostgresShell ScriptingSQLTerraform
About the role
- 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
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
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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
OraclePostgreSQLSQLPL/SQLShell scriptingAnsibleOracle GoldenGatepglogicalperformance tuningdisaster recovery
Soft skills
collaborationtroubleshootingroot cause analysisincident management
Certifications
Bachelor’s degree in Computer Science
