SQL DBA

Company: Ally
Location: Charlotte
Posted on: March 20, 2023

Job Description:

SQL DBA.
General information
Career area
Technology
Work Location(s)
601 S. Tryon Street, Charlotte, NC
Remote?
No
Ref #
14087
Posted Date
Monday, December 5, 2022
Working time
Full time
Ally and Your Career
Ally Financial only succeeds when its people do - and that's more than some clich-- 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
At Ally, you get a startup feel, but experience the benefits of a company that's worked out the kinks and is fulfilling its purpose. We're always evolving and see that as a good thing. From owning our work to seeing its impact in the real world, our team is relentless in finding new ways technology can help make experiences better and help people. We are problem solvers, we value diverse thinking, we support one another, and we challenge ourselves to think bigger in the journey to deliver customer-obsessed tech solutions.
The SQL DBA at Ally acts as the domain specialist, translating business requirements and functional specifications into technical requirements that support integrated and sustainable database systems. Their in-depth understanding of company and industry best practice methodologies, policies, standards, and controls make them an integral leader in Ally's database life management phases.
The Work Itself

• 
  
• 
  Implement and administer Microsoft SQL Server databases within a multi-tiered environment including providing support on all the stages of database-related deployments, upgrades, and migrations
  
  
• 
  Build operations and maintenance (O&M) checklists, tactics, techniques, and processes (TTPs), and standard operating procedures (SOPs) to ensure proper performance of SQL database maintenance operations according to workload patterns and usage
  
  
• 
  Monitor/maintain/upgrade Microsoft SQL database and assist application teams with performance tuning initiatives and enhancements while ensuring that technical modifications do not adversely affect database integrity, stability, and system availability
  
  
• 
  Troubleshoot SQL database slowness, Disk/Memory/CPU utilization and suggest resolutions
  
  
• 
  Provide 24x7 support for critical production systems and perform scheduled maintenance and support release deployment activities after hours
  
  
• 
  Implement solutions for Microsoft SQL database backup and recovery infrastructure
  
  
  The Skills You Bring
  
  • 
    
  • 
    Minimum 9 years of hands-on SQL Server DBA experience
    
    
  • 
    Hands-on experience of install/configure/monitor/support SQL Server 2016/2017/2019
    
    
  • 
    Hands-on experience of install/configure/support SQL Server AlwaysOn/Log Shipping/SQL Clusters/Replication features
    
    
  • 
    Strong verbal and written communication skills, ability to interact well with other teams
    
    
  • 
    Must have hands-on experience on deploy, Migrate and Support SQL Server databases on AWS
    
    
  • 
    Hands-on experience of install/configure/monitor/support SSIS/SSRS/SSAS components
    
    
  • 
    Hands-on experience of SQL Server upgrades, database migrations & applying SQL security patches
    
    
  • 
    Excellent SQL Server troubleshooting skills
    
    
  • 
    Good Windows PowerShell programming skills
    
    
  • 
    Ability to participate in on-call rotation
    
    
  • 
    Working knowledge of IDERA SQL Server Diagnostic Manager monitoring
    
    
  • 
    Working knowledge of Active Directory and how SQL Server interacts with Active Directory
    
    
  • 
    Working knowledge of SQL Server Auditing and Compliance
    
    
  • 
    Hands-on experience of SQL Server instance builds and task automation
    
    
  • 
    Ability to design, install, configure, and secure Microsoft SQL Server 2016 in an Always on Clustered Mode
    
    
  • 
    Experience with Database migration with different servers
    
    
  • 
    Ability to explain fundamental differences between Active and passive cluster from 2012 to 2016
    
    
  • 
    Must have solid problem determination skills supporting Microsoft SQL problems
    
    
  • 
    Ability to work well independently and within a team environment
    
    
    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 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 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 childcare discounts.
      
      
    • 
      Work-Life Integration: other benefits including LifeMatters - 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.
      Ally is an equal opportunity employer committed to diversity and inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to 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.
      We are committed to working with and providing reasonable accommodation to applicants with physical or mental disabilities. For accommodation requests, email us at work@ally.com. Ally will not discriminate against any qualified individual who is capable of performing the essential functions of the job with or without reasonable accommodation.
      Base Pay Range : An individual's position in the range is determined by the scope and responsibilities of the role, work experience, education, certification(s), training, and additional qualifications. We review internal pay, the competitive market, and business environment prior to extending an offer.
      Emerging
      110,000
      Experienced
      145,000
      Expert
      180,000
      Incentive Compensation: This position is eligible to participate in our annual incentive plan.

Keywords: Ally, Charlotte , SQL DBA, IT / Software / Systems , Charlotte, North Carolina