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

T05QVXdKT0tlU0RHQTY1dnlsL1pVMDlhU3c9PQ==
  • 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

Marathon Fitness

Purchasing Administrator Job at Marathon Fitness

About Marathon Fitness We are one of the United States largest distributors of premium fitness equipment with 3D conceptual design services to commercial facilities. We represent PRECOR USA (Division on Peloton), Peloton, Escape Fitness, Troy Barbell, NuStep and many...

Honda Aircraft Company

Senior Financial Analyst Job at Honda Aircraft Company

Job Overview: This position is responsible for performing a variety of accounting tasks related to the maintenance of general ledger accounts, including the month-end close process, account reconciliations, and financial reporting. The primary objective is to ensure the...

RRecruiter

Bilingual Executive Assistant (Mandarin Chinese) Job at RRecruiter

&##128680; We're Hiring: Bilingual Executive Assistant (Mandarin Chinese)&##128205; Location: Houston, TX | &##127970; On-site | &##128188; Full-Time &##128176; $50K$60K/year | &##129658; Medical, Dental, Vision | &##127958; PTO Our client is looking for a Bilingual... 

Evening Star

Senior 3D Character Artist (Contract) Job at Evening Star

 ...Evening Star is looking for a contract Senior 3D Character Artist to join the team! In this role, you will be responsible for bringing...  ..., shaders, and tools Create stylized characters based on concept art and story-driven references High poly modeling and sculpting... 

Mainz Brady Group

Audio Visual Technician Job at Mainz Brady Group

 ...troubleshooting. ~ Proficiency with AV hardware and software, including control systems and networked AV solutions. ~ Solid understanding of audio, video, and lighting technologies. ~ Excellent problem-solving skills and keen attention to detail. ~ Strong communication and...