Loading...
USM Jobs / Sr. SQL DBA w/ Insurance Auto Auctions, Inc. (IAA), 6mo (contract to hire) - ONLY W2
Medium Contract to Hire

JB059636 - Sr. SQL DBA w/ Insurance Auto Apply

  • Start Date:
    Interview Types
  • Skills SQL DBA Azure DevOp..
    Visa Types Green Card, US Citiz..
 
REQUIRED SKILLS
->>>  need # of years and list anything lacking in submittal / agree to perm salary range too
- Min 15 years of SQL DBA experience
-Skills in supporting on-premises and Azure DevOps
-SQL Server Upgrades (Migrating to SQL 2022) including Service Pack Upgrades
- Heavy replication skills
- Monitoring tool installation & configuration
- Stored Procedure Updates
- Handling SNOW Tickets
- On-call rotation (will work on-call throughout the week every third week)
-Skilled in solar winds and helping to reduce noise around SQL monitoring – preferred, not required (these candidates will get view 1st)
 
Conversion salary: $115,000-$130,000/year + perm benefits – (the higher end of the salary range is only for those that screen as SENIOR level) 
This DBA will be responsible for supporting on-premises and Azure operations in addition to helping with solar winds and to help reduce noise around SQL monitoring.  In addition, this resource will help POC SQL 2025.  
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, fine-tuning queries and stored procedures
·         Coordinating database checkpoint frequencies, archive logging, resource usage with programmers and system Administrators
·         Creating capacity planning forecast
·         Establishing and maintaining custom-tailored 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, in-house 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 
 

Client Address
2 Westbrook Corporate Ctr Ste 500,Westchester,Illinois,United States,60154-5779
On-call rotation every third week M-F
Environment requires someone who is proactive, issue resolution oriented, can tackle project and a lot of ticket work, support on-call rotation and the fact the team is small, can\'t 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
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.
Interview Information
1. Phone Screen with hiring manager and talent acquisition.
2. Panel webex interview with management and technical DBA