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

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

HMG Careers

Remote - Customer Service Sales Job at HMG Careers

 ...About the job Remote - Customer Service Sales Are you ready to join an exceptional team that offers comprehensive training, benefits, and...  ...personal and professional growth. What We Offer: Full-time virtual career, offering the flexibility to work remotely. Average... 

ABM Industries

Building Engineer- Entry Level Job at ABM Industries

 ...maintaining and repairing all facility system equipment associated with HVAC operations and mechanical and electrical systems. The Building...  ...to read and interpret blueprints. ~ As required, highest-level relevant state/local license for Stationary Engineer and/or HVAC... 

CHRISTUS Health

Certified Occupational Therapist Assistant - Physical Therapy - PRN Job at CHRISTUS Health

 ...Description Summary: Under the supervision of a Registered Occupational Therapist, schedules, plans and delivers prescribed occupational therapy treatments, services and home instruction to patients in such areas as daily living skills, functional mobility, neuromuscular... 

Novartis Group Companies

Principal Scientist, Biology (San Diego) Job at Novartis Group Companies

 ...This position will not require travel. Ph.D. M.S., or B.S. degree in a relevant scientific discipline with 5-8+ years of relevant...  ...colleagues to drive programmatic success. Expertise in molecular biology, biochemistry, chemical biology, cell biology, induced... 

Godby HPE

HVAC Install Apprentice Job at Godby HPE

 ...Job Description Job Description Salary: $20-$25 Hourly DOE Godby Heating Plumbing Electrical is searching for an HVAC Install Apprentice to join our team. Experience not required Training and education provided Valid Driver's License required Background...