Enterprise System Administrator

Colonial Group; Plano (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Colonial Group in Plano, TX is seeking an Enterprise Systems Administrator to oversee the administration, support, and integration of the company’s ERP and related systems, including IFS, SugarCRM, and homegrown GURU tools. You will manage user access, upgrades, backups, and security controls, ensuring reliability across multiple environments.

The role requires 5+ years in enterprise applications, strong SQL skills, and experience with APIs/integration patterns, with travel up to 30% and on-call

Qualifications

• Bachelor’s degree in IT, business, or related field, or equivalent ERP experience.
• 5+ years admin experience with ERP/CRM/PLM in manufacturing/engineering.
• Experience with IFS Applications or IFS Cloud.
• Experience with ERP upgrades, cloud migrations, and testing.
• Experience across Manufacturing, Supply Chain, Sales, Engineering, or Operations.
• Strong SQL and relational DB concepts; performance tuning.
• Experience with APIs, middleware, ETL, and data integration.
• Ability to document processes and provide end-user training.

Responsibilities

• Administer multiple enterprise systems (IFS, SugarCRM, GURU).
• Manage user accounts, permissions, environments, patches, and upgrades.
• Lead migrations and major upgrades including IFS Cloud.
• Design and maintain integrations between systems and backend services.
• Monitor performance, implement alerting, and ensure SLAs.
• Provide end-user support and develop training materials.
• Coordinate with vendors and IT partners on enhancements.
• Maintain security/compliance and change management procedures.

Skills

Enterprise Systems

SQL

APIs

CRM integrations

ERP systems

Vendor coordination

Education

Bachelor's degree

Tools

IFS

SugarCRM

GURU

CATIA integrations

Job description

Summary:

The Enterprise Systems Administrator is responsible for the administration, technical support, integration, performance, and continuous improvement of the company’s enterprise application portfolio, including IFS (ERP), SugarCRM, the home-grown GURU system (engineering/PLM/CAD integrations), other line-of-business applications, and associated databases and middleware. This role acts as an internal systems subject-matter expert, managing system configuration, user and permission administration, integrations, monitoring, incident resolution, upgrades/migrations (e.g., IFS Applications 9 → IFS Cloud), reporting, backups, security controls, and vendor coordination.

Duties and Responsibilities:

• Serve as technical and functional administrator for multiple enterprise systems (IFS, SugarCRM, GURU, PLM/CAD connectors like CATIA integrations, and other LOB applications).
• Manage system administration activities: user/accounts and permissions, role-based access, environment provisioning (dev/test/prod), configuration, patches, and version upgrades.
• Lead and support platform migrations and major upgrades (including IFS Cloud migration): plan, coordinate testing (UAT/regression), perform validation/data reconciliation, resolve issues, and stabilize post-go-live.
• Design, implement, and maintain integrations between enterprise systems and backend services (APIs, middleware, ETL, message queues), working with infrastructure and DB teams to ensure reliability.
• Monitor application and database performance, perform tuning and capacity planning, and implement alerting/observability for SLAs.
• Troubleshoot and resolve functional and technical application issues, including collaboration with IT, network, infrastructure, DBAs, and external vendors/implementation partners.
• Administer databases and support SQL troubleshooting, data loads/migrations, data integrity, and ad-hoc data requests; coordinate backups and recovery procedures.
• Develop and maintain system documentation, runbooks, operational procedures, and audit/compliance controls for change management and security requirements.
• Create and support operational and management reporting (built-in reporting tools, SQL-based reports, dashboards) and support users with report development.
• Develop and maintain automation and scripting (PowerShell, Python, or similar) for routine administration, deployments, and health checks.
• Provide end-user support, training materials, and knowledge transfer for multiple systems to improve adoption and reduce incidents.
• Coordinate with external vendors, consultants, and implementation partners on enhancements, escalations, and best practices.
• Participate in IT project workstreams for application implementations, integrations, and process improvements; perform impact analysis for changes.
• Maintain security and compliance of application environments (patching, permissions, auditing, ITAR/security clearance coordination where applicable).

Education and Work Experience:

• Bachelor’s degree in Information Technology, Business, Supply Chain, Manufacturing Systems, Computer Science, or a related field preferred; equivalent combination of education and relevant ERP experience may be considered.
• Minimum 5 years administering enterprise applications (ERP/CRM/PLM/LOB) and related databases in a manufacturing/engineering environment preferred.
• Prior experience supporting IFS Applications, IFS Cloud, or a comparable enterprise ERP platform required.
• Experience supporting ERP implementations, upgrades, or cloud migrations, including testing, end-user support, and data validation.
• Experience working across multiple business functions such as Manufacturing, Supply Chain, Sales, Engineering, Quality, or Operations.
• Experience with ERP security, user setup, permission management, reporting, and functional configuration.
• Demonstrated experience with integrations (API, SOAP/REST, middleware, ETL), SQL and relational databases, and application monitoring tools.
• Working knowledge of SQL and relational database concepts preferred.
• Experience working with third-party vendors, implementation partners, or ERP consultants preferred.

Work Authorization/Security Clearance Requirements:

• N/A

Knowledge, Skills, and Abilities:

List of needed knowledge, skills, and abilities to accomplish the duties and responsibilities of the job.

• Strong systems-administration skills across enterprise applications and supporting infrastructure.
• Proficiency with SQL, relational DB concepts, and basic DBA tasks (indexing, query tuning, backups/restores).
• Familiarity with APIs, integration patterns, middleware, and data exchange between systems.
• Ability to analyze business processes and recommend practical system improvements that align with operational needs and ERP best practices.
• Strong troubleshooting and problem-solving skills, with the ability to resolve both functional and system-related issues promptly.
• Strong written and verbal communication skills, including the ability to create training documents, process documentation, and end-user instructions.
• Ability to manage multiple priorities and support requests in a dynamic environment while maintaining a high level of customer service.
• Strong organizational skills and attention to detail, particularly in system setup, testing, reporting, and documentation.

Work Conditions:

Environment Type:

• Indoors. Production and Office Environment. Temperature Controlled.

Exposure Types:

• Small and/or enclosed spaces

Work Hours:

• On-call for emergent conditions.
• Standard work schedule, overtime may be necessary for meeting deadlines, required travel, and emergent conditions

Travel Requirements:

• This position may involve travel up to 30% of the time.

Physical Demands:

• Medium work that includes moving objects up to 50 pounds.
• Moving about on foot to accomplish tasks, particularly for long distances or moving from one work site to another.
• Picking, pinching, typing, or otherwise working, primarily with fingers rather than with the whole hand or arm as in handling.
• Prolonged periods sitting at a desk and working on a computer.
• Prolonged periods working on feet, using tools, and performing repetitive actions that entail frequent bending and stooping.
• Repeating motions that may include the wrists, hands, and/or fingers.

AIT Safety -

AIT enforces a safety culture whereby all employees have the responsibility for continuously developing and maintaining a safe work environment. As appropriate, each employee is responsible for completing all training requirements. All employees who work in or enter the production environment are required to wear personal protective equipment.

AIT Quality -

- It is our policy to provide quality products and services that meet customer expectations and delivery requirements. Accordingly, each employee must conform to the AIT Quality Policy and carry out job activities in compliance with applicable AIT Quality System documents and customer contracts. Each employee must read and understand his/her Quality Management and Customer Satisfaction responsibilities.

AIT Procedure Compliance -

Each employee must read, understand, and implement the general and specific operational, safety, quality, and environmental requirements of all plans, procedures, and policies about his/her job.

Security Clearance Statement -

This position may require a government security clearance; you must be a U.S. citizen for consideration.

ITAR Requirements -

To conform to U.S. Government commercial space technology export regulations, including the International Traffic in Arms Regulations (ITAR), 8 U.S.C. § 1324b(a)(3), applicants for employment at AIT must be a U.S. citizen or national, lawfully admitted for permanent residence into the U.S. (i.e. current green card holder), or lawfully admitted as a refugee or granted asylum under 8 U.S.C. § 1157-1158.

Equal Employment Opportunity -

AIT is proud to be an Equal Opportunity Employer and is committed to attracting, retaining, and developing a highly qualified, diverse, and dedicated workforce. AIT hires and promotes people based on their qualifications, performance, and abilities. We support the establishment and maintenance of a workplace that nurtures trust, equality, and teamwork, in which all employees recognize and appreciate the diversity of individual team members. We provide all qualified applicants for employment and employees with equal opportunities for hire, promotion, and other terms and conditions of employment, regardless of their race, color, religion, gender, sexual orientation, gender identity, national origin/ethnicity, age, physical or mental disability, genetic factors, military/veteran status, or any other status or characteristic protected by federal, state, and/or local law.

Affirmative Action and Disability Accommodation -

Applicants wishing to view a copy of AIT’s Affir…