Senior SQL Server DBA II

Bengaluru, IN

Apply now

Job Purpose Summary

This position is responsible for acting as a strong 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.

Essential Job Duties

·         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

  • While on-call be available by phone 24/7 and be able to get on war-room calls to triage, should an outage occur

·         Provide support during maintenance windows or deployment/release activities

·         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

Job Qualifications

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

Experience / Requirements:

·         Experience in large SQL Server environments (8+ years preferred)

·         Strong experience in Performance Optimization & Query Tuning skills

·         In-depth knowledge of effective Index Tuning

·         Ability to manage / maintain ETL & DW processes (Azure Synapse experience preferred)

·         SSAS, SSIS, SSRS knowledge

·         Solid experience with SQL Server in cloud (Azure PaaS experience 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

·         On-call troubleshooting within a 24/7 production environment and providing escalation support as necessary

·         Expert knowledge of SQL Server 2012 and up

·         Ability to communicate clearly and effectively with various departments such as Engineering, Infrastructure, Product, etc...

·         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

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 job URL