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

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

Our Lady of Fatima Catholic Church

Music Accompanist Job at Our Lady of Fatima Catholic Church

Accompanist for Saturday and Sunday Services

OnPoint Medical Group

Medical Assistant - Internal Medicine at Harvard Park Job at OnPoint Medical Group

 ...Medical Group is a physician-led network of skilled Primary and Urgent care providers who are committed to expanding access to quality healthcare in the most effective and affordable manner possible. Our "Circle of Care" has one primary goal to ensure the health and... 

Larson Maddox

Counsel, Corporate Governance & Securities Job at Larson Maddox

 ....S. and international subsidiaries. Coordinate with external counsel on global entity requirements and filings. Provide legal oversight...  ...U.S. law school; licensed in Illinois or eligible for in-house registration. ~8+ years of legal experience, with a focus on public... 

Confidential Jobs

District Manager - Beauty Industry Job at Confidential Jobs

 ...passionate about building high-performing teams that know how to sell and deliver an exceptional guest experience. This is not a back-office role: we need a dynamic, hands-on leader who can energize teams, drive traffic, and maximize revenue. Key Responsibilities:... 

Kofile

Marketing Manager Job at Kofile

 ...Role Overview: We are seeking a versatile, hands-on Marketing Manager to drive our brand building and demand generation efforts...  ...audiences). This is a high-impact, visible role that will directly influence Kofiles growth. Key Responsibilities: Brand...