Sr. DBA- SQL

WE ARE LOOKING FOR...

POSITION SUMMARY

This position is responsible for acting as a primary technical resource for the support and administration of SQL Servers in both large scale production and development environments across multiple products. This position continually evaluates the entire SQL Server topology to identify and create plans to address performance issues, architectural shortcomings, and other opportunities for improvement. 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.  This position is a key resource contributing to the technical growth and development of the SQL DBA team through mentoring and training of other team members.

RESPONSIBILITIES
Participate and contribute in Agile methodology ceremonies
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
Continuous evaluation and implementation of proactive measures to improve performance and stability of SQL Server
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
Identify technical developmental opportunities and provide guidance to Mid and Junior Level DBA team members

REQUIRED SKILLS AND ABILITIES

EDUCATION
Bachelor’s Degree in Information Systems, Computer Science or related field or related experience
EXPERIENCE
Experience in large SQL Server environments (10+ 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
Skilled in SQL Server Data Replication (Transactional, Snapshot)
In-depth knowledge of SQL Server HA and DR features (Always On, Mirroring)
Project Management skills
Ability to manage / maintain ETL & DW processes (SSAS, SSIS, SSRS knowledge)
On-call troubleshooting within a 24/7 production environment and providing escalation support as necessary
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...
Solid experience with SQL Server in cloud and VMware platforms
Agile Methodology familiarity
Experience using PowerShell or other scripting techniques to manage a large environment
Familiarity with CI/CD concepts as they apply to the data tier
In-depth Windows operating system knowledge
PHYSICAL DEMANDS (TRAVEL, ETC)
Position requires individual to mostly sit at desk
While on-call be available by phone 24/7 and be 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!

Apply Now Copy Link