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

b2t2OE1Fc25kZkhBbHlzT2IxMTNIczFvV2c9PQ==
  • Pentangle Tech Services | P5 Group
  • Southfield, MI

Job Description

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

Luminous Talent

Construction Superintendent Job at Luminous Talent

 ...Job Description This is a full-time (direct hire) role for a construction company specializing in Earth Retention and Segmental Paving Systems for Civil projects Our client has built a national reputation of providing exceptional Site Solutions by employing Value... 

AmTrust Financial

Telephonic Nurse Case Manager Job at AmTrust Financial

 ...Telephonic Nurse Case Manager Job Locations US-FL-Boca Raton | US-FL-Maitland Requisition ID 2025-18957 Category Managed Care Position Type Regular Full-Time Overview AmTrust Financial Services, a fast growing commercial... 

Maxion Corp LLC

Work At Home Data Entry - Remote Position- Administrative Assistant Job at Maxion Corp LLC

 ...variety of skills and backgrounds - whether you've been an administrative assistant, data entry clerk, typist, customer service rep, or even a...  ...contribute to meaningful outcomes. Enjoy the freedom of remote work while building your career. This role is your... 

Worthington Enterprises

HR Assistant Job at Worthington Enterprises

 ...Job Description Worthington Enterprises is adding an HR Assistant to our Human Resources Department. The HR Coordinator is responsible for the administrative and clerical functions of the Human Resources department, supporting the HR Manager and ensuring the smooth... 

*US AMR-Jones Lang LaSalle Americas, Inc.

Fleet Maintenance Mechanic Job at *US AMR-Jones Lang LaSalle Americas, Inc.

 ...The Fleet Maintenance Technician is responsible for diagnosing, repairing, and maintaining fleet vehicles and equipment to ensure optimal...  ...Repair and maintain fleet equipment including forklifts, industrial equipment, and support vehicles Complete daily checklists...