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

Surgery Center of Appleton

Surgical Technician Job at Surgery Center of Appleton

About Surgery Center of Appleton Conveniently located in the Trasino Landing shopping center at 1616 N. Casaloma Dr. in Appleton, Wis., the Surgery Center of Appleton is a partnership between Ascension Wisconsin, Regent Surgical Health and Wisconsin Spine and Pain. The...

Insight Global

Motion Graphic Artist Job at Insight Global

Job Description An Enterprise company is seeking a Designer / Motion Graphics Animator with strong graphic design and animation skills. This is a full-time contract position based in Los Angeles, working in a hybrid capacity (minimum three days per week in-office)....

Center for Elders'​ Independence

Case Management Nurse Job at Center for Elders'​ Independence

 ...About the Role The Coordination of Care Service Center RN Case Manager is responsible for monitoring and facilitating appropriate...  ...Work Schedule: Monday - Friday Qualifications ~ BSN in Nursing required from accredited school of nursing. ~ CCM Preferred.... 

IDR, Inc.

CP4BA Architect Job at IDR, Inc.

 ...authentication concepts such as LDAP, IAM, UMS, teams, roles, or SSO Required Skills for CP4BA Architect: Deep knowledge of CloudPak architecture, including common services, automation foundation, and operators Experience with different deployment patterns such as... 

Trackline

Dynamic Positioning Instructor Job at Trackline

Well regarded maritime training facility is seeking a Dynamic Positioning instructor to add to their team of maritime professionals. You will teach DP and other maritime classes you may be qualified for and share your knowledge with mariners. This requires you hold a valid...