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

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

ICON Strategic Solutions

Laboratory Assistant (Nights/Weekends) Job at ICON Strategic Solutions

 ...Laboratory Assistant - US, San Antonio, TX - weekends/night/overnight ICON plc is a world-leading healthcare intelligence and clinical research organization. Were proud to foster an inclusive environment driving innovation and excellence, and we welcome you to join... 

NatureSweet

Digital Shelf Manager Job at NatureSweet

 ...About the Role: NatureSweet is seeking a Digital Shelf & Shopper Marketing Manager to lead strategy and execution for the digital shelf and omnichannel...  ...syndication, SEO-driven product pages, and compelling digital assets that drive purchase intent. The ideal candidate will... 

Freeman Mathis & Gary, LLP

Legal Nurse Consultant Job at Freeman Mathis & Gary, LLP

 ...a rapidly growing, national specialty litigation firm seeking a Nurse Consultant to join our Walnut Creek office. The Nurse Consultant...  ...memorandums outlining the medical treatment and determine if appropriate care and treatment was rendered Performs relevant medical research... 

Home Health Care, Inc.

Senior Living Rounding Nurse Practitioner Job at Home Health Care, Inc.

 ...group. About Twin Cities Physicians: With a mission to reduce hospitalizations and enhance senior wellness, our providers bring care to where people live. Visit to learn more. About the Role: Deliver mobile, patient-centered care to seniors... 

Redstone Search Group

Private Banker (Hunter) & Relationship Manager (Farmer) - Miami(US) Domestic Clients Job at Redstone Search Group

Redstone Private Banking Search focuses on offering 360 search solutions to the global wealth management market. With competitive coverage of Private Banks, Boutiques, Family Offices, Wealth Managers, Fund Managers and Investment Houses, Redstone Private Banking Search...