Ally Jobs

Job Information

Ally Senior Database Administrator in Charlotte, North Carolina

Position Description

This is a senior-level Oracle Database Administrator. This role is primarily responsible for translating business requirements and functional specifications into technical requirements that support integrated and sustainable database systems. Viewed as the subject matter expert for the team. Manages multiple, moderately complex projects and direct activities of a team related to special initiatives or operations. Routine accountability is for technical knowledge and capabilities as a team member or as an individual contributor. Works under minimal supervision, with general guidance from more seasoned consultants or managers. Works on complex problems where analysis of situations or data requires an in-depth evaluation of various factors. Exercises judgment within broadly defined practices and policies in selecting methods, techniques, and evaluation criterion for obtaining results. This person must also develop and apply an in-depth understanding of company and industry best practice methodologies, policies, standards, and controls in order to participate in all database life management phases.

Job Responsibilities

  • Migrate databases from Solaris to Exadata - Oracle Enterprise Linux

  • Provides technical documentation, automation scripting, installation, monitoring, and trouble-shooting across a large enterprise environment

  • Install, Configure Golden gate for data replication

  • Install, Configure RAC databases for high availability

  • Provide support on all the stages of database implementation and/or database related deployments

  • Upgrade databases from lower version to latest version

  • Participate in project meetings, as necessary, to understand application and database requirements

  • Ability to work independently and to resolve complex Oracle issues

  • Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries.

  • Proactive monitoring of the databases

  • Troubleshoot Oracle performance and non-performance related issues either independently or in conjunction with other DBAs

  • Manage backup/recovery for Oracle instances

  • Management of database and resource capacity planning.

  • Implement and enforce database security based upon best practice, SOX regulations, and company policies

  • Installation of new Oracle instances and upgrades

  • A weekly on-call rotation in order to maintain 7x24coverage

  • Setting up and resolving issues with Oracle Data Guard environments

  • Experience in task automation and scripting languages(shell, perl)

  • Participate in cross-training and knowledge transfer with team members

  • Documentation and research of new technologies that are related to current and future team goals

Qualifications

  • Strong verbal and written communication skills

  • Min. experience of 7+ yr. Oracle DBA required

  • Proven experience installing and managing high availability production oracle database instances supporting OLTP applications.

  • Ability to provide technical documentation, automation scripting, installation, monitoring, and trouble-shooting across a large enterprise environment

  • Database server sizing and capacity planning

  • Database server tuning for performance and scalability

  • Oracle Database server internals

  • Oracle Database Tuning, usage of AWR, ADDM, ASH and UNIX native commands for performance and scalability

  • Oracle Enterprise Manager 13c (OEM) experience

  • In-Depth understanding of High Availability and Disaster Recovery requirements and solutions

  • Expert knowledge and experience with Oracle Golden Gate replication and troubleshooting Oracle GoldenGate Extracts, Data-Pumps and replicats

  • In-Depth understanding of Oracle RAC (11g and 12c), Oracle Dataguard & Dataguard broker

  • Experience with Oracle backup and recovery procedures using RMAN

  • Proven track record in supporting large number of db simultaneously

  • Familiarity with Exadata

  • Strong production support experience & customer service skills and Advanced troubleshooting techniques in support of 24x7 On-call duties

  • Takes the initiative to act on issues

  • Knowledge of enterprise architecture principles

Desired Job Skills

  • Delphix

  • Project management and oversight

  • Devops for Database

  • NoSQL databases

  • Latest Oracle DBA Certification

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. Plus, we have a flexible paid-time-off program including time off for volunteer opportunities. Ally's Total Rewards Program is designed to enrich your life at work -- and outside of it and includes:

  • Industry-leading 401K retirement savings plan with matching and company contributions

  • Wellness program encouraging healthy living with financial rewards

  • Flexible health insurance options including dental and vision

  • Pre-tax Health Savings Account with generous employer contributions

  • Pre-tax commuter benefits

  • Other work-life integration benefits including parental and caregiver leave, adoption assistance, backup child and adult/elder day care program, child care discounts, tuition reimbursement, 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.

Job Title: Senior Database Administrator

Company: Ally Financial Inc.

Category: Information Technology

BU Function: IT

Experience Level: Experienced

Requisition ID: 19-6985

DirectEmployers