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

Court Appointed Special Advocates (CASA) of Southeast Texas

Marketing and Events Coordinator Job at Court Appointed Special Advocates (CASA) of Southeast Texas

 ...Position Overview The Marketing and Events Coordinator is responsible for planning and executing CASA of Southeast Texass marketing, communications, and fundraising event initiatives. This position ensures consistent branding, strengthens CASAs visibility in the community... 

Confidential Jobs

Driver Recruiter Job at Confidential Jobs

 ...Driver Recruiter Confidential Employer Cincinnati, OH | Hybrid (14 days per month, or as needed for occasional projects) We are...  ...Responsibilities Source and attract qualified CDL drivers through online platforms, social media, networking, and referrals. Quickly... 

Wake Forest University

Assistant Professor, Department of Health and Exercise Science (R0008127) Job at Wake Forest University

Assistant Professor, Department of Health and Exercise Science (R0008127)*Location:* Winston Salem, NC *Open Date:* Sep 09, 2025*Close Date:* Dec 01, 2025*Description:* WAKE FOREST UNIVERSITY. The Department of Health and Exercise Science invites applications... 

BeFit Rehabilitation

Occupational Therapy Assistant Job at BeFit Rehabilitation

 ...solely focuses on providing rehab services to residents within assisted living facilities. We want our team to truly become a part...  ...seeking a full-time, dedicated, and compassionate Certified Occupational Therapy Assistant (COTA) to join our healthcare team. The ideal... 

Somewhere

Virtual Assistant - 43855101511 Job at Somewhere

 ...CVs will be accepted. Position : Virtual Assistant Working Schedule : 9a-5p...  ...determined by the candidate's level of experience and at the discretion of the client)...  ...executive is seeking a full-time Virtual Assistant to work U.S. hours. The ideal candidate...