Our Firm

Careers

VIEW ALL APPLY NOW

SR. SQL Server DBA - Database Administrator

Experienced

DealerSocket | DBA - CRM/iDMS | Draper, UT

JOB PURPOSE SUMMARY

This position is responsible for supporting and administering SQL Servers in both large scale production and development environments across multiple products. As a SaaS company, the fundamental goal is to ensure the production environment is always operational and performing optimally. This position requires strong organizational and collaboration skills and partnering with numerous distributed teams is a must for success.

ESSENTIAL JOB DUTIES

• Participate and contribute in Weekly Sprint Planning meetings

• Ensure production SQL Servers maintain the company's requirements for HA/DR, Security, and RPO/RTO

• Provide on-call support (as part of a rotation) for production alerts or issues both during and outside normal working hours

• Provide support during maintenance windows or deployment/release activities

• Join war-room calls to triage and troubleshoot outages as they occur, including after-hours and weekends

• Build and improve automation around configuring and administering SQL Servers

• Optimize performance of SQL Servers and determine the most effective ways to increase performance including hardware purchases, server configuration changes, or index/query changes

• Implement proactive measures to improve performance and stability

• Create and maintain procedural and technical documentation

• Collaborate with other teams in enterprise level projects and provide support / guidance as needed

• Lead assigned quarterly projects from initial concept and drive to successful completion

• Provide guidance to Mid and Junior Level DBA team members

Skills & Requirements

JOB QUALIFICATIONS

Education: Bachelor’s Degree in Information Systems, Computer Science or related field or related experience

Experience / Requirements:

• Demonstrable skills in configuration, maintenance and administration of SQL Server systems and applications

• Excellent communication and collaboration skills, excellent organizational skills, proven ability to prioritize multiple activities and objectives to thrive in a rapidly changing environment

• Ability to write effective technical documentation with attention to detail and accuracy

• Familiarity SQL Monitoring and Alerting Management systems

• Experience in large SQL Server environments (10+ years preferred)

• SSIS and SSRS knowledge

• Project Management

• On-call troubleshooting within a 24/7 production environment

• Expert knowledge of SQL Server 2008 and up

• Ability to communicate clearly and effectively with various departments such as Engineering, IT Infrastructure, Project Management, etc...

• Not required but preferred experience with the following: o SQL Server in AWS and VMware platforms o Agile Methodology o PowerShell o Windows cluster management as to how it pertains to AlwaysOn and FCIs

PHYSICAL DEMANDS (TRAVEL, ETC.)

• Attend training conferences and sessions that may require travel

• While on-call be available by phone 24/7 and be able to get online immediately should an outage occur