Sr Eng - Data Systems

Detroit

Friday, 12 April 2024

Ally and Your Career. Ally Financial only succeeds when its people do - and that’s more than some cliche people put on job postings. We live this stuff! We see our people as, well, people - with interests, families, friends, dreams and causes that are all important to them. Our focus is on the health and safety of our teammates as well as work-life balance and diversity and inclusion. From generous benefits to a variety of employee resource groups, we strive to build paths that encourage employees to stretch themselves professionally. We want to help you grow, develop, and learn new things. You’re constantly evolving, so shouldn’t your opportunities be, too? The Opportunity. 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. The Work Itself The Sr. Database Administrator will be a part of team that supports database and PL/ SQL development. Background in AWS and other cloudbased 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. The Skills You Bring 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. How We’ll Have Your Back 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: plan for the near and long term with an industry-leading 401 K 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 your family stay on track physically, socially, emotionally and financially. Building a Family: adoption, surrogacy, and fertility support as well as parental and caregiver leave, back-up child and adult/elder day care program and child care discounts. Work-Life Integration: other benefits including Life. Matters® Employee Assistance Program, subsidized and discounted Weight Watchers® program and other employee discount programs. Who We Are. Ally Financial is a customer-centric, leading digital financial services company with passionate customer service and innovative financial solutions. We are relentlessly focused on "Doing it Right" and being a trusted financial-services provider to our consumer, commercial, and corporate customers. For more information, visit www.ally.com.

 
Loading Similar Jobs...
JOBZ is an independent Job Search Engine. JOBZ is not an agent or representative and is not endorsed, sponsored or affiliated with any employer. JOBZ uses proprietary technology to keep the availability and accuracy of its job listings and their details. All trademarks, service marks, logos, domain names, job descriptions and other company descriptions / details are the property of their respective holder. JOBZ does not have its users apply for a job on the J-O-B-Z.com website. Additionally, JOBZ may provide a list of third-party job listings that may not be affiliated with any employer. Please make sure you understand and agree to the website's Terms & Conditions and Privacy Policies you are applying on as they may differ from ours and are not in our control.