DBA- SQL
San Clemente, CA

Job Description

POSITION SUMMARY

This position is responsible for supporting and administering SQL Servers in both large-scale production and development environments across multiple products. 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.

RESPONSIBILITIES

* 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

EDUCATION

* Bachelor's Degree in Information Systems, Computer Science or related field or related experience

EXPERIENCE / REQUIREMENTS

* Experience in large SQL Server environments (5+ years preferred)
* 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
* SSIS and SSRS knowledge
* Project Management
* Ability to manage / maintain ETL & DW processes
* 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...
* 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 (less than 10%)
* While On-Call be available by phone and able to get online immediately should an outage occur

PERKS & BENEFITS

* Medical, Dental, Vision, 401k
* Company-paid Life & Disability Insurance
* Paid Vacation, Sick Days & Holidays
* Paid Parental Leave
* Wellness Program that pays up to $200 per year
* Collaborative & Open Office Environment

ABOUT DEALERSOCKET

DealerSocket is a leading provider of software for the automotive industry. Our mission is to drive the future of automotive, by simplifying the experience for its customers and partners with a suite of seamlessly integrated products. DealerSocket's suite of products includes advanced Customer Relationship Management (CRM), innovative Digital Marketing and Websites, robust Vehicle Inventory Management, insightful Analytics Reporting, and solutions to streamline dealer operations such as Desking, Credit Reporting, Compliance, and a Dealer Management System (DMS) for dealers of all sizes. To put it simply: we help dealers sell and service vehicles more profitably, while improving their customers' experience. The DealerSocket Team is more than 1,000 employees strong, serving nearly 8,000 dealerships. Visit careers.dealersocket.com to learn more about how you can join our winning team!

Skills/Requirements