This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Every day new job offers in the State of Michigan!

To post a job, login or create an account |  Post a Job

Sr Engineer – Data Systems

Ally Financial

This is a Full-time position in Detroit, MI posted November 21, 2021.

Position Description

Responsible for delivering relevant technical solutions based on best practices primarily using various database technologies.

Successful candidate should be self-driven, able to work with minimum supervision and have extensive experience in data modeling, Data Warehousing, PL/SQL, ETL processing, Reporting and a background in cloud engineering.

Candidate will be expected to work as an individual contributor as well as provide oversight and direction to other technical resources as required.

Job Responsibilities

  • The Sr.

    Database Administrator will be a part of team that supports database and PL/SQL development.

  • Background in AWS and other cloud-based technologies
  • Design, implement, code, test and maintain database technologies.
  • Prepare and review system documentation composed by development teams.
  • Perform modifications to and maintenance of operational programs and procedures.
  • Develops effective and efficient PL/SQL packages, procedures, triggers and functions according to design specifications.
  • Applies best practice for tuning for overall system performance.
  • Supports software development and test teams throughout the software development lifecycle.

    Includes incremental script execution and defect resolution.

  • Provides support for software releases.
  • Researches interfaces to identify and code required updates to support integration.

Qualifications

  • Bachelor’s degree in computer science, information systems or relevant field of study.
  • 3+ years of experience required.
  • Extensive experience with database development tools, ETL and integration technologies.
  • Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic.
  • Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures.
  • Ability to setup, maintain and enhance partition table spaces.
  • Ability to provide guidance, oversight, and peer review to more junior database developers.
  • Experience with managing and resolving problems on a live production system.
  • Solid understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports etc.
  • Experience with software development lifecycle and software development common practices (code reviews, unit testing etc.).
  • Strong written and oral communication skills are essential.
  • Solid work ethic, self-driven with the ability to work with minimal supervision.

Ally Overview

Ally Financial Inc.

(NYSE: ALLY) is a leading digital financial services company and a top 25 U.S.

financial holding company offering financial products for consumers, businesses, automotive dealers and corporate clients.

Ally’s legacy dates back to 1919, and the company was redesigned in 2009 with a distinctive brand, innovative approach and relentless focus on its customers.

Ally has an award-winning online bank (member FDIC), one of the largest full service auto finance operations in the country, a complementary auto-focused insurance business, a growing digital wealth management and online brokerage platform, and a trusted corporate finance business offering capital for equity sponsors and middle-market companies.

Business Unit/Enterprise Function

Ally’s Information Technology (IT) organization is focused on supporting and improving the position of our industry-leading business franchises through cost effective, innovative IT solutions, as well as overseeing critical functions that enable the day-to-day operations of the entire Ally Financial enterprise.

IT is also responsible for the administration and execution of information protection, disaster recovery and IT risk management.

Total Rewards Information

Ally’s compensation program offers market-competitive base pay and pay-for-performance incentives (bonuses) based on achieving personal and company goals.

But Ally’s total compensation –
– or total rewards –
– extends beyond your paycheck and is designed to support and enrich your personal and professional life, including:

  • Time Away : competitive holiday and flexible paid-time-off, including time off for volunteering and voting.
  • Planning for the Future: benefits to help you plan for the near and long term including an industry-leading 401K retirement savings plan with matching and company contributions, student loan and 529 educational assistance programs, tuition reimbursement and other financial well-being programs.
  • Supporting your Health & Well-being: flexible health and insurance options including dental and vision, pre-tax Health Savings Account with employer contributions and a total well-being program that helps you and family stay on track physically, socially, emotionally and financially.
  • Building a Family: adoption, surrogacy and fertility support as well as benefits that help you take care of your family –
    – parental and caregiver leave, back-up child and adult/elder day care program and child-care discounts.
  • Work-Life Integration: other benefits including LifeMatters® Employee Assistance Program, subsidized and discounted Weight Watchers® program and other employee discount programs.

Ally is an Equal Opportunity Employer

We extend equal employment opportunities to qualified applicants and employees on an equal basis regardless of an individual’s age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity or expression, pregnancy status, marital status, military or veteran status, genetic disposition or any other reason protected by law.