I/S - Salary - Senior SQL Database Administrator

Standard Motor Products, Inc
Lewisville, Texas
Dec 01, 2023
Dec 10, 2023
Position Type
Full Time
Organization Type
Established in 1919 and traded on the NYSE, Standard Motor Products, Inc., (SMP) is a leading independent manufacturer, distributor, and marketer of replacement parts for motor vehicles in the automotive aftermarket industry, with a complementary focus on heavy duty, industrial equipment and original equipment markets.

We are organized into two operating segments. Each segment focuses on providing our customers with full-line coverage of its products, and a full suite of complementary services that are tailored to our customers' business needs and driving end-user demand for our products. Our Engine Management Segment manufactures and distributes a full line of critical components for the ignition, electrical, emissions, fuel and safety-related systems of motor vehicles. Our Temperature Control Segment manufactures and distributes a full line of critical components for the temperature control (air conditioning and heating) systems, engine cooling systems, power window accessories and windshield washer systems of motor vehicles.

We sell our products primarily to automotive aftermarket retailers, program distribution groups, warehouse distributors, original equipment manufacturers and original equipment service part operations in the United States, Canada, Europe, Asia, Mexico and other Latin American countries.

We employ approximately 4,300 people in North America, Europe and Asia.

General Description of Responsibilities:

  • Supports, maintains, and configures all Microsoft SQL servers in all SMP facilities company-wide
  • Daily management of all databases, maintenance plans, and SQL Agent jobs on all SQL servers
  • Works with software developers to create new data objects based on best practices (tables, views, and stored procedures)
  • Works with software developers on query tuning and schema refinement
  • Monitors health and performance of all SQL servers
  • Ensures high levels of performance, availability, sustainability, and security
  • Analyzes, solves, and corrects issues in real time
  • Performs complex technical performance and system resource utilization analysis
  • Performs complex SQL troubleshooting across a broad spectrum of potential root causes including but not limited to SAN, DASD, server hardware resources, SQL server configuration, locking, blocking, SSIS/ETL, and T-SQL code issues
  • Refines and automates processes, tracks issues, and documents changes
  • Identifies inadequate or inefficient systems/processes and recommends alternative solutions to increase efficiency
  • Serves as the project manager and coordinates the utilization of all IT resources for all new SQL server implementations and for all upgrades of existing SQL servers
  • Works closely with the infrastructure team on new server provisioning, SAN provisioning, and resource sizing
  • Works closely with the infrastructure and software development teams on troubleshooting activities
  • Composes and maintains SQL database diagrams as required
  • Composes and maintains ETL and integration documentation as required
  • Conducts and manages all testing activities as required for change management activities
  • Provides 24/7 support for critical production systems
  • Performs scheduled maintenance and supports release deployment activities after hours
  • Proactively identifies new trends and technologies for possible application within the company
  • Provides extensive knowledge and technical leadership to effectively collaborate with the software developers
  • Conducts feasibility studies and determines economic justification of all proposed SQL server projects
  • Maintains all required corporate IT SOX compliance documentation for SQL DBA activities

Work Experience Requirements:
  • 8+ years of experience as a SQL Server DBA or similar role
  • Demonstrated expert with Performance Tuning and Optimization (PTO)
  • Demonstrated expert with backups, restores, and recovery models
  • Demonstrated expert with profiler traces, execution plans, and other performance tuning & troubleshooting tools
  • Strong experience with storage area networks, disk volume strategy, system resource sizing assessments, and ongoing optimization
  • Strong experience developing, configuring, and deploying SSIS, SSRS, & SSAS in both online and data warehouse environments
  • Strong experience implementing and supporting Power BI
  • Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience installing, configuring, and maintaining Windows server
  • Experience in software change management practices
  • Thorough knowledge of the software development lifecycle. Programming experience is a plus
  • Exposure to Azure SQL
  • Working knowledge of Active Directory
  • Experience with DB2 for IBM I and IBM iSeries Administration is a huge plus
  • Experience with Oracle & SAP Sybase is a plus
  • Experience with third-party replication & high-availability solutions from Veritas & Zerto is a plus
  • Prior work in the manufacturing, distribution, or automotive space is a plus
  • Team lead and/or management experience is a plus
  • Strong sense of ownership and pride in your performance and its impact on company's success
  • Goal-oriented with a strong desire to bring open issues to a resolution quickly
  • Excellent time-management skills
  • Excellent verbal and written communication skills
  • Ability to work independently or collaboratively as part of a team
  • Ability to effectively communicate with peers and management on a technical and non-technical level
  • Ability to effectively prioritize competing issues
  • Critical thinker with a strong analytical mindset
  • Strong problem-solving skills
  • Ability to foster relationships throughout the organization and built trust through demonstrated strong job performance and effectiveness as a team player
  • Ability to effectively create and maintain detailed technical documentation as required
  • Ability to conduct testing and training activities as required
  • Ability to adhere to all SOX software change management requirements
  • Ability to use Office products (Excel, Word, Power Point, Access, Project, Visio)

Education Requirements:
  • Bachelor's degree required
  • Relevant professional certifications a plus (MCDBA, MCTS, MCITP, MVP)

Standard Motor Products is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

More searches like this