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

Uk90ZjBkOE9GQ3VsT1BZVFk5cnU1L2xo
  • 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

GoJet Airlines

Flight Attendant - ORD $5k Bonus Job at GoJet Airlines

 ...GOJETAIRLINES-FLIGHTATTENDANT LOCATION-CHICAGO,IL JobDescriptionandOverview Doesgettingpaidtotravelsoundlikeadreamjob?ThatispreciselywhatourFlightAttendantsdoeveryday.GoJetAirlinesislookingforfriendly,professional,andenthusiastic... 

JGM

Passenger Boarding Bridge Operator - Newark Airport (EWR) Job at JGM

 ...Passenger Boarding Bridge Operator - Newark Airport (EWR) Job Summary: A Passenger Boarding Bridge Operator (PBB) (also known as...  ...is in parking position and if theres any obstruction or any equipment illegally parked inside the PBB maneuvering area daily. Perform... 

POPUPFLORIST

Events Manager Job at POPUPFLORIST

 ...POPUPFLORIST is a leading experiential floral design and event production company that creates unforgettable experiences for some of the worlds leading brands in fashion, entertainment, and lifestyle. Based in New York City, we work across a wide spectrum of creative... 

Curative

Alzheimer's Principal Investigator in Georgia - Neurologist, Psychiatrist, or Gerontologist Job at Curative

Join the Pioneers in Alzheimer s Research at ARTC - Georgia Are you a neurologist, gerontologist, or psychiatrist looking to make a significant impact in the field of Alzheimer s research? The renowned Alzheimer s Research and Treatment Center invites you to become...

Cheyenne Regional Medical Center

Registered Nurse Job at Cheyenne Regional Medical Center

 ...A Day in the Life of a Registered Nurse: The Registered Nurse assesses, plans, implements...  ...and ancillary departments to achieve quality outcomes. Completes Unit specific orientation...  ...it helps meet the patients needs and improve patient outcomes. Verbal, written, and...