Senior SQL Database Administrator

Our challenge is to use modern tools, techniques, and methods to develop, modify, and/or update complex and extremely powerful systems.  Our customers and partners need applications that enable them to easily operate and expand their automotive business and efficiently manage their teams.  Equally important is our visualization of clients’ needs to provide them the information they need to understand how their business is performing and what changes could be made to improve their performance.

 

Job Purpose 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. 

 

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

·         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 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

·         Provide assistance for code reviews, database architecture, query design, and other database best practices

·         Lead assigned projects from initial concept and drive to successful completion

 

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 (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

·         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 create/manage/maintain ETL & DW processes (SSAS, SSIS, SSRS knowledge)

·         Experience with SQL Server Change Tracking(CT) and Change Data Capture(CDC)

·         Exposure to Python

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

·         Solid 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

 

Apply Now Copy Link