Attachment J.3 Labor Categories IT Staffing.pdf

Attachment J.3

Required Labor Categories

The following represents the labor categories that are required to be staffed by this contract. Required certifications and minimum capabilities and competency levels are also described.

Contents

Attachment J.3 Required Labor Categories

1 Project Management

1.1 Principal Project Manager

1.2 Information Technology (IT) Project Administrator

2 Analysts

2.1 Business Systems Analyst, Senior

3 IT Operations

3.1 IT Configuration Manager

3.2 IT Asset Manager

4 Customer / Application Support

4.1 Application Support Specialist

4.2 Support Technician (Telecommunications)

4.3 Systems Support Engineer

5 Administrative Support

5.1 Technical Writer/Editor, Senior

6 Systems Administration/Engineering

6.1 Enterprise Systems Architect

6.2 Systems Administrator, Senior

6.3 Systems Administrator

7 Database Administration

7.1 Database Administrator, Senior

7.2 Database Architect

8 Application/Software Development

8.1 Software Developer, Senior

9 Required Certifications ............................................................................ Error! Bookmark not defined.

1 Project Management

1.1 Principal Project Manager

Considered a Subject Matter Expert in their field. Typically oversee all aspects of the project, leading a team on large projects or a significant segment of large and complex projects. Analyze new and complex project-related problems and create innovative solutions that normally involve the schedule, technology, methodology, tools, solution components, and financial management of the project. Provide applications systems analysis and long and short-range plans for application selection, systems development, systems maintenance, and production activities for necessary support resources. Requires a master’s degree and

10 years of experience in the field or related area.

1.2 Information Technology (IT) Project Administrator

Coordinates all IT projects and ensures company resources are utilized appropriately.

Compiles project status reports, coordinates project schedules, manages project meetings, and identifies and resolves technical problems. Identifies and analyzes systems requirements and defines project scope, requirements, and deliverables. Coordinates project activities and ensures all project phases are documented appropriately. Requires an associate’s degree and at least 2 years of experience in the field or in a related area. Familiar with standard concepts, practices, and procedures within a particular field. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. A degree of creativity and latitude is required. Typically reports to a manager.

2 Analysts

2.1 Business Systems Analyst, Senior

Assist in applying common best practices for the industry to the customer using a knowledge base to create conceptual business models and to identify relevant issues and considerations in selecting application software packages. Assess the operational and functional baseline of an organization and its organizational components, and help to define the direction and strategy for an engagement while ensuring the organizational needs are being addressed.

Typical areas addressed include Human Resources, Finance, Supply, and operations.

Identify information technology inadequacies and/or deficiencies that affect the functional areas ability to support/meet organizational goals. Generate functional area strategies for enhanced IT operations in a cross-functional area mode throughout the organization.

Participate in account strategy sessions, strategic assessments and design reviews to validate enterprise approach and associated work products, such as enterprise resource planning

(ERP) implementations coordinating the resolution of highly complex problems and tasks.

Reviews, analyzes, and evaluates business systems and user needs. Documents requirements, defines scope and objectives, and formulates systems to parallel overall business strategies. Requires a bachelor's degree and 5 years of experience in the field or in a related area. Familiar with relational database concepts, and client-server concepts. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. May lead and direct the work of others. A wide degree of creativity and latitude is expected. Typically reports to a manager.

3 IT Operations

3.1 IT Configuration Manager

Provide configuration management planning. Describe provisions for configuration identification, change control, configuration status accounting, and configuration audits.

Regulate the change process so that only approved and validated changes are incorporated into product documents and related software. Provide release management support including managing, planning, scheduling and controlling a software build through different stages and environments, including testing and deploying software releases. Requires a bachelor’s degree and 3 years of experience in the field or in a related area.

3.2 IT Asset Manager

Responsible for administrative duties within the IT procurement and inventory management function. Maintains records and databases containing information regarding licenses, warranties, and service agreements for the organization's hardware and software. Minimizes organizational cost through product standardization and tracking. Tracks quality throughout the product lifetime. Requires a bachelor's degree and 0-3 years of experience in the field or in a related area. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Relies on instructions and pre-established guidelines to perform the functions of the job. Works under general supervision. Typically reports to a manager.

4 Customer / Application Support

4.1 Application Support Specialist

Provides support to end users on a variety of issues. Identifies, researches, and resolves technical problems. Responds to telephone calls, email and personnel requests for technical support. Documents, tracks and monitors the problem to ensure a timely resolution. Require an associate's degree or 2 years of experience in the field or related area. Requires at least 1 technology certification as defined in Section 9 – Required Certifications. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Relies on instructions and pre-established guidelines to perform the functions of the job. Works under immediate supervision. Primary job functions do not typically require exercising independent judgment. Typically reports to a manager.

4.2 Support Technician (Telecommunications)

Provides support to end users on a variety of issues. Identifies, researches, and resolves technical problems. Responds to telephone calls, email and personnel requests for technical support. Documents, tracks and monitors the problem to ensure a timely resolution.

Requires an associate's degree or 2 years of experience in the field or in a related area. Has knowledge of commonly-used concepts, practices, and procedures within a particular field.

Relies on instructions and pre-established guidelines to perform the functions of the job.

Works under immediate supervision. Primary job functions do not typically require exercising independent judgment. Typically reports to a manager.

4.3 Systems Support Engineer

Troubleshoots and develops technical solutions related to software and setup errors for field engineers, technicians, and customers. Creates workaround procedures when standard procedures have failed and ensures issues are resolved in a timely fashion. Escalates urgent problems requiring more in-depth knowledge to appropriate internal resources. Requires an associate's degree in a related area and 5 years of experience in the field or in a related area.

Requires at least 2 certifications as defined in Section 9 – Required Certifications. Familiar with standard concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision. A certain degree of creativity and latitude is required. Typically reports to a manager.

5 Administrative Support

5.1 Technical Writer/Editor, Senior

Prepares and/or maintains documentation pertaining to programming, systems operation and user documentation. Translates business specifications into user documentation. Plans, writes, and maintains systems documentation. Supports system user documentation efforts, including development of change notices, online help screens and generation of interactive computer based training modules. Writes, edits, proofreads, and copyedits a variety of documents. Plans and prepares documents for dissemination. Manages the documentation library. Requires a bachelor's degree in a related area with at least 4 years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices, and procedures. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. May direct and lead the work of others. Typically reports to a manager or head of a unit/department. A wide degree of creativity and latitude is expected.

6 Systems Administration/Engineering

6.1 Enterprise Systems Architect

Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and installing to support an organization's application systems. Consults with users to identify current operating procedures and to clarify program objectives. May be expected to write documentation to describe program development, logic, coding, and corrections. Writes manuals for users to describe installation and operating procedures.

Requires a bachelor's degree in a related area and at least 2-4 years of experience in the field or in a related area. Must have a working knowledge of relational databases and client-server concepts. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. May lead and direct the work of others. Typically reports to a manager. A wide degree of creativity and latitude is expected.

6.2 Systems Administrator, Senior

Installs new software releases, system upgrades, evaluates and installs patches and resolves software related problems. Performs system backups and recovery. Maintains data files and monitors system configuration to ensure data integrity. Expected to recommend and help define policies and protocols that lead to efficient operations and improve the integrity of the systems. Develops and maintains technical documents, including internal policies, procedures and build instructions. May be expected to develop and maintain scripts to automate work and perform it more efficiently. Requires a bachelor's degree in and 5 or more years of experience in the field or in a related area. Requires certifications defined in Section

9 – Required Certifications. Familiar with standard concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision; typically reports to a project leader or manager. A certain degree of creativity and latitude is required.

6.3 Systems Administrator

Installs new software releases, system upgrades, evaluates and installs patches and resolves software related problems. Performs system backups and recovery. Maintains data files and monitors system configuration to ensure data integrity. May document internal policies, procedures and build instructions. May be expected to develop and maintain scripts to automate work and perform it more efficiently. Requires an associate’s degree in a related area with at least 2 years of experience in the field or in a related area. Should have technical certifications defined in Section 9 – Required Certifications. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision; typically reports to a manager. A certain degree of creativity and latitude is required.

7 Database Administration

7.1 Database Administrator, Senior

Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database. Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues. Requires a bachelor's degree and 5-10 years of experience in the field or in a related area. Familiar with standard concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals. Performs a variety of tasks. Leads and direct the work of others. Typically reports to a manager. A wide degree of creativity and latitude is expected.

7.2 Database Architect

Designs and builds relational databases, data warehouses, and/or data-marts for storage, processing, and/or decision support. Develops strategies for warehouse implementation, data acquisition, and archive recovery. Implements business rules via stored procedures, middleware, or other technologies. Defines user interfaces and functional specifications.

Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse. Cleans and maintains the database by removing and deleting old data. May evaluate new data sources for adherence to the organization's quality standards and ease of integration. Requires a bachelor's degree and 5 years of experience in the field or in a related area. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. May lead and direct the work of others. A wide degree of creativity and latitude is expected. Typically reports to manager.

8 Application/Software Development

8.1 Software Developer, Senior

Codes software applications to adhere to designs supporting internal business requirements or external customers. Standardizes the quality assurance procedure for software. Oversees testing and develops fixes. Documents system requirements for database, applications, and operation system environment. Requires extensive demonstrated coding experience in SQL and ASP.Net technologies. Requires experience in programming for Windows Server, IIS, SharePoint, and Microsoft SQL Server. Requires knowledge of Microsoft Visual Studio, and experience working as part of a development team. Experience with protocols for managing code changes in a structured manner. Experience developing release packages.

Require a bachelor's degree and at least 5 years of experience in the field or in a related area.

Has knowledge of standard concepts, practices, and procedures within a particular field.

Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks.

May lead and direct the work of others. A wide degree of creativity and latitude required.

Typically reports to a manage

9 Required Certifications

Project Manager • Project Management Certification (PMP)

• Salesforce Certified Administrator

• Professional Scrum Master (PSM)

• Cisco Certified Network Associate (CCNA)

• Microsoft Certified Systems Engineer (MCSE)

• CompTIA A+

Application Support

Specialist

• CompTIA Network+

• CompTIA Security+

• Microsoft Technology Associate (MTA) Windows Server

Administration Fundamentals

• MTA Windows Operating System Fundamentals

• MTA Security Fundamentals

• Cisco Certified Network Associate (CCNA)

Systems Support

Engineer

• Project Management Professional (PMP)

• Professional in Business Analysis (PMI-PBA)

Systems Administrator • AWS SysOps Administrator Associate

• Microsoft Azure Administrator Associate

Systems Administrator, Senior

• AWS Solution Architect Associate

• Salesforce Marketing Cloud Email Specialist

• AWS Solution Architect Professional

• Certified Cloud Security Professional (CCSP)

Support Technician

(Telecommunications)

AWS Certified Cloud Practitioner

CompTIA Security+