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

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

Sony Pictures Entertainment

Temporary Multiplatform Content Scheduler Job at Sony Pictures Entertainment

 ...subsidiary of Tokyo-based Sony Corporation. SPE's global operations encompass motion picture production, acquisition, and distribution;...  .... Education: Bachelor of Science degree in Business Administration, Data Science, Accounting, Information Technology, is preferred... 

Vertex Education

Special Education Records Coordinator Job at Vertex Education

 ...Be the one who makes a difference! At Vertex Education we are a team of high achievers, courageous leaders, and passionate believers in changing lives through education. As a purpose-led education services provider, our mission is destined to benefit many and yet it starts... 

Fox Carriers

9-15 Ft Freight Cargo/Sprinter Van DOT Owner-Operators Job at Fox Carriers

 ...TONU. ~ Full-Time, Part-Time Job. ~ Contract. Our dispatchers are well-trained to book the best loads on the market. Having TWIC card or Hazmat is an advantage that gives you the opportunity to maximize your profits. Join the Fox Carriers team to get the... 

Schneider Electric

HVAC Mechanical Technician Job at Schneider Electric

 ...troubleshooting on commercial and industrial HVAC equipment Equipment Youll Work With Chillers : Process, Centrifugal, Air-Cooled Boilers Make-Up Air Units Variable Frequency Drives (VFDs) Variable Refrigerant Flow (VRF) Units Refrigeration Equipment... 

NSS

Senior PeopleSoft/Oracle Developer Job at NSS

 ...About the Role We are seeking a seasoned PeopleSoft and Oracle Developer with a strong foundation in application development, system administration, and enterprise security. This role is ideal for a senior engineer who can work across application, middleware, and...