Senior Project Server System Administrator

Airservices Australia requires an experienced Senior Microsoft Project Server Upgrade/Migration Specialist to undertake the technical upgrade and migration of its existing Microsoft Project Server 2016 environment to Microsoft Project Server Subscription Edition (PSSE). Key duties and responsibilities The current Project Server environment supports portfolio, program and project management, project scheduling, enterprise resource management, Project Web App (PWA), project governance, workflows, reporting, integrations and automation. Its supporting components include custom SQL database objects, SSIS packages, SSRS reports, PowerShell automation, Microsoft Project Professional desktop clients and security controls. The required outcome is a supported Project Server Subscription Edition service that preserves the agreed current functionality, data, configuration, integrations, reporting, workflows, security and user access. Type of resource required We need a senior, hands-on Project Server technical specialist, rather than a project manager, general Microsoft engineer or general SharePoint specialist. The successful resource should be capable of independently performing the Project Server technical work, while working with Airservices and its infrastructure/support providers for activities such as AWS infrastructure, Windows servers, SQL infrastructure, networking, certificates, identity and desktop deployment. This role will also be responsible for producing Windows Server and SQL Server build specifications for our infrastructure/support providers to provision. Mandatory skills and experience The resource should demonstrate: Extensive Microsoft Project Server experience, particularly Project Server 2016 and Project Server Subscription Edition. At least 5 years' Project Server system administration / engineering experience. Demonstrated experience performing Project Server version upgrades or migrations. Detailed knowledge of Project Web App (PWA). Strong understanding of: Enterprise Project Types Project Detail Pages enterprise custom fields and lookup tables Project Centre and PWA views Enterprise Resource Pool security groups and categories project templates baselines timesheets approvals project and governance workflows. Strong PowerShell capability for Project Server administration, configuration and migration. Strong SQL Server and T-SQL experience. Experience with SSIS, including modifying data connections and packages affected by a Project Server migration. Experience with SSRS and Project Server reporting. Understanding of Project Server reporting databases/interfaces and experience identifying and remediating unsupported reporting dependencies. Experience with Microsoft Project Professional/Desktop Client connectivity and compatibility with Project Server. Experience analysing and migrating Project Server workflows. Ability to troubleshoot complex Project Server upgrade, integration, database and configuration issues. Demonstrated experience planning and executing production migrations, including rehearsal, cutover, validation and rollback. Sufficient technical knowledge of SharePoint Server to install, configure and administer the SharePoint components required to host and operate Project Server Subscription Edition, and to perform Project Server database-attach migration activities. Overview of work 1. Discovery and assessment The resource will undertake a detailed discovery of the existing Project Server environment, including: PWA instances and configuration databases and Project Server data Enterprise Project Types and PDPs enterprise custom fields and lookup tables enterprise resources security groups/categories and permissions workflows Project sites associated with Project Server Project Professional/Desktop Client versions custom SQL databases and objects SSIS packages SSRS reports PowerShell scripts and scheduled processes integrations and data consumers direct database and OData dependencies backup/recovery arrangements. The resource will identify what can migrate as-is and what needs to be retained, remediated, replaced or retired. 2. Target design and migration planning The specialist will: validate the Project Server SE target configuration; identify Project Server compatibility/remediation requirements; confirm the Project Server database migration approach; determine the supported SQL configuration; define treatment of reporting and integration dependencies; confirm the workflow migration approach; confirm Project Desktop Client requirements; produce the detailed migration, testing, cutover and rollback plans. produce and submit build specifications for the new Test and Production Project Server Farm and associated SQL Server environments 3. Build and migrate TEST The specialist will undertake the Project Server application-layer implementation, including: installing/configuring the software components required for Project Server SE; enabling and configuring Project Server; configuring Project Server service/application components; configuring PWA; restoring/attaching/upgrading Project Server data; migrating required Project Server configuration; addressing custom SQL dependencies; updating/remediating SSIS packages; updating Project Server-related PowerShell automation; migrating/remediating workflows; addressing Project Server reporting dependencies; and configuring integrations required for the migrated service. 4. Technical testing and UAT support The specialist will perform or support: Project Server data validation PWA validation project/task/assignment validation enterprise resource validation custom field validation permissions and security testing Project Professional connectivity workflow testing SSIS testing custom SQL testing reporting testing integration testing regression testing migration/recovery testing investigation and remediation of UAT defects. 5. Production implementation The specialist will: prepare the production Project Server SE application environment; perform a full migration rehearsal; produce a detailed cutover runbook; establish go/no-go and rollback criteria; execute the production migration; validate Project Server data and functionality; validate integrations and scheduled processing; support production go-live. 6. Hypercare and transition Following implementation, the resource will: provide post-go-live Project Server technical support; monitor platform health; investigate migration-related incidents; remediate defects; finalise technical/as-built documentation; produce administration and troubleshooting documentation; conduct knowledge transfer with the Airservices support team; and formally transition the upgraded Project Server environment into BAU support. Criteria The buyer has specified that each candidate must provide a one page pitch to address all criteria specified. This is equal to 5000 characters. Essential criteria 1. Candidates who are shortlisted will be required to attend an interview as part of the selection process. Opportunity summary Sellers can submit Up to 3 candidates Number of sellers invited Fewer than 5 Number of candidates submitted Fewer than 10 RFQ closing time 02 Weeks 00 Days 06 Hours Send us feedback About Accessibility Privacy Terms of use Disclaimer and copyright An initiative of the Digital Transformation Agency The Australian Government acknowledges the Traditional Owners of Country throughout Australia and acknowledges their continuing connection to land, waters and community. We pay our respects to the people, the cultures and the Elders past and present. © Commonwealth of Australia