Principal SQL DBA

| Remote
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Join our award-winning A-Team! 

Ready to produce exceptional results with exceptional people?  Get in touch, we would love to get to know you. 

Affinitiv is the largest provider of end-to-end, data-driven marketing and software solutions exclusively focused on the automotive customer lifecycle. Backed by 20+ years of automotive and marketing expertise, we pride ourselves on being the go-to experts in the industry. Not only do we work with over 6,500 dealerships and every major manufacturer in the country, we’re well-versed in OEM standards and the intricacies of a dealership or group’s local business.

Affinitiv is looking for a Principal SQL DBA to join our team. You will be working closely with the Development team on a Cloud-hosted application and a number of SQL servers to ensure the environment is built, configured, managed, and monitored correctly to support the business. You will help drive decisions on right-sizing servers and storage, troubleshooting performance issues, ensuring the highest level of reliability for the platform, and tuning the environment for maximum scalability and security and help with azure cloud migration.

Responsibilities

  • Administers, manages and monitors all systems, including databases, in development, test and production environments.
  • Design and implementation of Azure cloud databases, high-availability solutions, replication, encryption, and disaster recovery solutions.
  • Data Partitioning, Purging and Archiving solutions in the Azure SQL ecosystem.
  • Migration of on-premises database to the Azure Cloud using SQL on VM, SQL MI, Azure SQL Database.
  • Azure CLI and/or PowerShell.
  • Writing T-SQL, including complex stored procedures, functions, views, and triggers.
  • Query analysis and troubleshooting Leadership responsibilities
  • Provide technical leadership through example, develop innovation, strategies, processes, and best practices.
  • Monitor database performance, implement changes and apply new patches and versions when required.
  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
  • Perform scheduled maintenance and support release deployment activities after hours
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • 24x7 support for our SQL Server environment.
  • Own and manage uptime and performance SLAs.
  • Ability to work well with team globally specifically in India
  • Work with Development and QA team, guide developers on following best coding practices to write optimal & efficient code.

Requirements

  • 10+ years of DBA experience in a production environment
  • 3+ years supporting Azure SQL cloud-based databases.
  • Nice to have experience of managing SQL Servers in AWS.
  • 5+ years in database tuning and project support, database server upgrades and migrations, writing and troubleshooting database stored procedures.
  • Experience with Azure SQL Family specifically SQL MI and Azure SQL Database.
  • Application Development experience (preferably using .NET) and writing database scripts.
  • Good understanding of DevOps and the role of database administration teams in DevOps.
  • Experience of doing database deployment using .dacpac.
  • Advanced knowledge of performance tuning and administration, query analysis, performance monitoring and tuning, and maintenance routines
  • Background in automating processes
  • Experience with creating and maintaining database infrastructure
  • Experience with database clustering (FCI or Always On Availability Groups)
  • Experience with database monitoring tools like SentryOne and native tools like Perfmon, Profiler, PAL and SQL DMVs.

Work from Here

At Affinitiv, we have the best of both worlds.   Our team members have embraced remote work and our Work from Here program allows for remote working and the utmost flexibility while keeping in person collaborating thriving in a safe work environment.   Our Work from Here approach gives team members a choice to work on campus or remote, leaders can hold in person or virtual team meetings to collaborate and cultivate relationships.

Affinitiv knows you have interests outside of work, which is why we offer a comprehensive benefits package that includes medical, dental, vision and 401K effective day 1 just to name a few.   We also offer generous PTO so you can enjoy off time with family and friends.   

At Affinitiv, we celebrate diversity, equality, and an inclusive environment.

Affinitiv is committed to providing an environment of mutual respect where equal employment opportunities are extended to all employees and applicants for employment. We prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

All aspects of employment are decided on the basis of qualifications, competence, merit, and business needs. Affinitiv is proud to be an equal opportunity employer.


Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • HadoopFrameworks
    • SparkFrameworks
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • Google AnalyticsAnalytics
    • MixpanelAnalytics
    • PendoAnalytics
    • AsanaManagement
    • ConfluenceManagement
    • JIRAManagement
    • SmartsheetManagement
    • WordpressCMS
    • HubSpotCRM
    • SalesforceCRM

Location

We are located in the southwest corner of The Loop, right on the river! Just over the bridge from Union & Ogilvie and a few blocks from two L stops.

What are Affinitiv Perks + Benefits

Affinitiv Benefits Overview

Every employee is valued at Affinitiv and our employee's health and well‑being are important to us. We are proud to provide employees and their dependents with valuable and significant benefits. You and your family have unique needs, which is why Affinitiv offers a variety of benefit plans from which you may choose.

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Affinitiv's C -Suite is 38% diverse including our CEO, Sid Nair. Affinitiv recently launched a Diversity charter & Inclusion council to celebrate our differences, drive business success & have fun!
Diversity manifesto
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
The Affinitiv Diversity Council is BRIDGE: Building Real Inclusion via Deliberate Growth and Empathy.BRIDGE is a group of Affinitiv team members & leaders focused on diversity, equality & inclusion.
Hiring Practices that Promote Diversity
At Affinitiv, we celebrate diversity, equality, and an inclusive environment. Affinitiv is committed to providing an environment of mutual respect and where differences are celebrated.
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Child Care & Parental Leave Benefits
Generous Parental Leave
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Customized development tracks

Additional Perks + Benefits

At Affinitiv, we embrace "work from here" culture, so wherever that might be we are open and flexible on work location arrangements during our core business hours of 8-5 CST.

More Jobs at Affinitiv19 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Marketing
Operations
Product
Sales
Marketing
new
Remote
Developer
new
Remote
Product
new
Remote
Operations
new
Chicago
Data + Analytics
new
Remote
Developer
new
Remote
Developer
new
Remote
Developer
new
Remote
Developer
new
Remote
Developer
new
Remote
Data + Analytics
new
Remote
Data + Analytics
new
Remote
Product
new
Remote
Operations
new
Remote
Operations
new
Remote
Operations
new
Remote
Operations
new
Remote
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Affinitiv's full profileSee more Affinitiv jobs