SQL Server DBA (Support for Aras Innovator Platform) Job at Pentangle Tech Services | P5 Group, Southfield, MI

a0hOYUJ5aHgvNVY3b3YrY1BsSmlGWmwz
  • Pentangle Tech Services | P5 Group
  • Southfield, MI

Job Description

verview:

The SQL Server DBA will be responsible for the administration, maintenance, and performance optimization of Microsoft SQL Server databases that support the Aras Innovator-based product lifecycle management (PLM) platform.

The role ensures database reliability, availability, and performance, working closely with the engineering IT support teams.

Responsibilities:

  • Administer SQL Server databases supporting the Aras Innovator platform.
  • Perform regular maintenance including backup scheduling , index optimization , statistics updates , and health checks .
  • Monitor and optimize database performance, including query tuning and index management .
  • Manage security , roles , and permissions across development, test, and production environments.
  • Support database-related activities during Aras Innovator application upgrades and patches .
  • Implement and manage scheduled jobs , monitoring , and automation tools .
  • Participate in capacity planning , data growth forecasting , and system scaling .

Required Skills & Experience:

  • 5+ years of experience as a SQL Server DBA in enterprise production environments.
  • Expertise in T-SQL , indexing , execution plans , and performance tuning .
  • Hands-on experience with SQL Server Agent , SSRS , and SSIS .
  • Strong understanding of backup strategies and disaster recovery planning .
  • Familiarity with .NET applications and their interactions with SQL Server.
  • Experience with Aras Innovator or other PLM platforms is highly desirable.

Preferred Qualifications:

  • Experience with monitoring and alerting tools (e.g., SolarWinds ).
  • PowerShell scripting experience for automation and administrative tasks

Job Tags

Similar Jobs

Champion Xpress Carwash

Regional Fleet Sales Coordinator Job at Champion Xpress Carwash

Champion Xpress Carwash is seeking a highly motivated, outgoing, and sales-driven Regional Fleet Sales Coordinator to join our team. This individual will focus exclusively on building and growing fleet account partnerships across assigned territories. The ideal candidate...

Hawthorne Lane

Estate Manager Job at Hawthorne Lane

A confidential private family is seeking a highly organized and proactive professional to oversee the administrative management of multiple residences and provide direct support to the principals...  ...a respectful and well-run private estate environment. If you are a proactive... 

English 1

Hiring Immediately for 2025! Entry-Level English Teacher Job at English 1

 ...(select cities) + airport pick-up. ~ Sponsored legal Z work visa + up to 2 weeks of sponsored hotel accommodation upon arrival....  ...sponsored flight to China and hotel accommodation are part of the sponsorship upon successful completion of the first-year contract. In case... 

Direct Wire

Environmental Health Safety Specialist Job at Direct Wire

 ...Join Our Team as an Environmental Health & Safety Specialist at Direct Wire & Cable! Are you an experienced EHS professional with a passion for safety leadership and continuous improvement? Direct Wire & Cable is hiring an Environmental Health & Safety (EHS) Specialist... 

THE ARGYLE

Cook Job at THE ARGYLE

 ...research. We are seeking a skilled Part-Time Cook with professional kitchen experience...  ...Compensation ~ Part-time evening position, nights and weekends ~ Flexibility to scale...  ...perform repetitive motions. Ability to work flexible hours, including evenings, weekends...