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

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

The Muscogee Nation

SR SYSTEM ADMINISTRATOR Job at The Muscogee Nation

 ...MUSCOGEE (CREEK) NATION Seeking a SR SYSTEM ADMINISTRATOR Description : Responsible for the technical design, planning, implementation, and the highest level of performance tuning and recovery procedures for mission critical enterprise systems. Serves as... 

Gold Level Media LLC

Part Time Wordpress Developer Job at Gold Level Media LLC

 ...looking for a creative and experienced Website Developer for our team. Gold Level Marketing...  ...including accurate data entry, file maintenance, web design, scripts, etc Responsibilities...  ...Turnaround project updates in a timely manner to meet deadlines Qualifications... 

Rhoads Metalworks

Maintenance Mechanic / Welder Job at Rhoads Metalworks

 ...and ventilation systems a plus - A valid and clean drivers' license and own transportation - Ability to do occasional overnight travel Benefits: Along with our very competitive salary, we off a full benefits package that includes; medical, dental, vision, 401(... 

Essentials Endodontics

Dental Office Manager Job at Essentials Endodontics

 ...Job Description Job Description Salary: We are looking for a dental office manager for our specialty office in Burleson, TX. Essential Endodontics 101 NW Renfro St. Suite #102 Burleson, TX 76028 Manager meetings are conducted once a month at the Fort... 

Sodexo

Offshore Day Cook Job at Sodexo

Sodexo - 5749 SUSITNA DRIVE [Kitchen Staff / Grill Cook / Line Cook] As a Cook at Sodexo, you'll: Read recipes and/or product directions; Estimate food requirements; Operate a variety of kitchen utensils to weigh, measure, mix, wash, peel, cut, grind, stir, strain, season...