senior SQL server DBA

Summary:
IAA is looking for a qualified Senior Database Administrator to join our Information Technology team.
IAA certified as a Great Place to Work is a leading global marketplace connecting vehicle buyers and sellers. Leveraging leadingedge technology and focusing on innovation IAAs unique multichannel platform processes more than 2.5 million vehicles annually. Headquartered in Westchester IL IAA has nearly 4500 talented employees and over 200 facilities throughout the US Canada and the United Kingdom. The primary responsibilities are administration support and development of Microsoft SQL Server version 2019 in a high availability environment.

Perform SQL database administration tasks:
Monitoring and tuning all SQL databases to ensure availability
Monitoring production databases and data processing jobs
Implementing and administering database replication
Troubleshooting performance issues relating to indexes finetuning queries and stored procedures
Coordinating database checkpoint frequencies archive logging resource usage with programmers and system Administrators
Creating capacity planning forecast
Establishing and maintaining customtailored backup/restore procedures and disaster recovery plans for Production Servers.
Enhancing system availability
24 X 7 Production support
Serve as a point of escalation

Provide support to Application Development Groups in the following ways:
Providing logical database structures alternatives
Creating a physical database design
Helping with construction testing and installation
Ensuring application performance integrity and availability
Proficient with system development techniques and tools

SQL Server Software Maintenance:
Installing configuring securing SQL Production servers
Upgrading databases from earlier versions to the latest versions
Applying MS maintenance fixes
Providing technical support to the application developers
Reviewing new databases that come with purchased packages

Skills and Qualification Requirements:
Experience supporting mission critical production systems is required.
Excellent written and verbal communications skills including the ability to communicate effectively with peers other application teams and clients.
Provide direction to application development team(s)
Organization and time management skills are critical.
Must continue to enhance technical knowledge and skills through research and experimentation inhouse and

Education/Certification Requirements:
Candidate must have a 4 year degree (or equivalent experience)
7 years of MS SQL Server Administration experience required
Requires solid knowledge of MS SQL Server programming and administration for mission critical systems

In return for your excellent skills and abilities we offer a benefits package including: health insurance 401K STD/LTD Life Insurance/AD&D paid holidays and vacations.
IAA is committed to providing equal employment opportunities regardless of race religion creed color sex age national origin disability sexual orientation gender identity genetic information veteran status citizenship status or marital status.
IAA is a drugfree workplace. EEOE

Job Title

senior SQL server DBA

Top Skills Details need # of years and list anything lacking in submittal

Top Skills / Priority Day to Day:
SQL Server Upgrades (Migrating to SQL 2022) including Service Pack Upgrades
Building out SQL Servers
Monitoring tool installation & configuration
Store Procedure Updates
Handling SNOW Tickets
Oncall rotation (will work oncall throughout the week every third week)

Worksite Address

2 Westbrook Corporate Ctr Ste 500WestchesterIllinoisUnited States

Oncall rotation every third week MF
Environment requires someone who is proactive issue resolution oriented can tackle project and a lot of ticket work support oncall rotation and the fact the team is small cant hide behind anyone. There is an accountability culture in place requiring work to be done when tasked This person will be supporting their 24/7 Operations team including SQL 2019

Insurance Auto Auctions is one of the leading North American salvage auto auctions companies. They have a flexible model for business which includes bids taking place live and over the internet. With bidding taking place over the web growing IT has been a real focus for the organization. IAA has been in the industry for over 25 years and they have the most comprehensive warehouse of automotive totalloss auction data. This particular opportunity is a new role with IAA and has a ton of potential for someone to make a difference in the level of efficiency the SCOM tool has on their monitoring environment. There is also a second phase to this technology platform aimed at incorporating service now from the parent company KAR in Q3 2016. There will be a level of involvement with this platform in order to do so.

Culture / once FULL TIME perm employee benefits perks:
Collaborative team (Engineer & Networking teams)
Consumer is App Dev teams
Learn SQL 2016
Building SQL 2016 boxes
Moving to cloud for new apps
Opportunity to grow (current Director started as a Jr. DBA and moved into Director
Manager gives autonomy to staff not micromanaged (provides his team an objective but in the end its up to the individual to set standards)
Gives ownership to his staff
Some work from home not a ton but flexibility exists here
Relaxed Environment
Easy going people
Team Building events such as basketball and golf
Onsite cafeteria
Onsite Convenient Store
Onsite Starbucks
Exposure to a lot of technology
Collaborative team environment
Benefits Overview:
BCBS PPO Plans w/ a 3 tiered deductible (High Medium Low)
o HSA is offered
Delta Dental Dental coverage
Vision insurance offered paid by employee
2 weeks PTO
3 personal days
3 sick days
IAA pays for two times the individuals annual salary in life insurance coverage
401K match of 34%

Work Environment

smaller team tough personalities and candidates must be okay with getting challenged by team members. Also must be okay with learning their environment and taking feedback from a process / ways of working perspective.

Additional Skills Tags

indexingdatabase administrator

Additional Skills & Qualifications

Candidate must have strong communication skills to work on a team the collaborates and works together.

Impact to the Internal/External Customer

This will provide more automation and monitoring to application teams and ensure that infrastructure is providing more of a service to applications teams.

DBA team will take a proactive stance in providing reports to application development teams and ensuring that the business is operating at an optimal level. Ensure highest level availability for applications to run seamless auctions.

Interview Information

1. Phone Screen with hiring manager and talent acquisition.
2. Panel webex interview with management and technical DBA

Business Challenge

There are a backlog of automation and monitoring projects in which IAA wants to provide more customization across the environment in support of the 1921 application teams infrastructure supports.

There are performance issues with applications that are leveraged by employees at Branch locations. There is no dedicated leader to ensuring that resources are leveraged both from a business and application development perspective to get things done. Reports are generated monthly and its become challenged to have the buyin to be more so proactive in solving issues before real risks come to fruition.