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

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

FLEXpath, LLC - Tennessee

FLEXpath Registered Nurse (RN) Job at FLEXpath, LLC - Tennessee

 ...pioneering person - directed care. Many of our skilled nursing facilities have achieved a 4 or 5-star overall rating from the Centers for Medicare & Medicaid Services. Additionally, we have been awarded as a certified Great Place to Work for three years in a row and Modern... 

Sterman Masser Inc

Forklift Operator - 2nd Shift Job at Sterman Masser Inc

 ...or electric ride-on or walk behind hand jacks to perform a variety of lifting and moving tasks within potato packing and shipping warehouses. ESSENTIAL DUTIES AND RESPONSIBILITIES: Learn and perform specific safety and operational procedures for each type of... 

YMCA of Greater Boston

YMCA Internships - Unpaid Job at YMCA of Greater Boston

 ...Job Description Job Description Description Explore Future Opportunities: Unpaid Internship Interest Submission YMCA of Greater Boston Location : Greater Boston Area Internship Type : Unpaid Department : Varies Are you passionate about making a difference... 

BCG Attorney Search

Patent Prosecution Attorney Job at BCG Attorney Search

A law firm located in Tempe, Arizona, is seeking a Patent Prosecution Attorney to join its intellectual property practice. The ideal candidate will have expertise in biochemistry, biotechnology, or related fields and a passion for scientific innovation. Responsibilities... 

Talent2win

Senior Full-Stack Engineer (Node + React) - Costa Rica (San Jose) Job at Talent2win

 ...Responsibilities Build scalable, high-quality software that powers a global HXM platform. Contribute across the stackfrom React frontends to Node.js/TypeScript APIs and AWS infrastructure. Participate in code reviews, pair programming, and architectural discussions....