07th October, 2020
Request for Tender
Provision of SQL Server Consultant – SQL Server Clusters Installation and Migration of Government databases
The Australian Aid Program, through the Solomon Islands Resource Facility, funds Australia’s ‘Solomon Islands Governance Program’, a four-year, $30 million initiative, running from 2017 to 2021. The Program’s goal is to strengthen the ability of government agencies to more effectively support economic growth and improve public service delivery.
The Governance Program supports all three strategic objectives of the Department of Foreign Affairs and Trade’s (DFAT) Aid Investment Plan for Solomon Islands by supporting stability, enabling economic growth and enhancing human development.
The Governance Program seeks to do this by building and sustaining capacity across the Solomon Islands’ public sector. The aim is to improve service delivery by removing barriers associated with weak governance in areas such as public financial management, human resource planning and systems administration.
There are three end of program outcomes:
- Fiscally and socially responsible budgeting and borrowing policies.
- Improved PFM that facilitates service delivery.
- A more accountable and responsible public service.
The Governance Program has provided an impetus towards a stronger partnership between DFAT and the Solomon Islands Government (SIG), with increased mutual accountability and increased emphasis on demand-driven inputs. Inbuilt program flexibility allows for amending support when required and capturing opportunities as they arise The Tender
The Solomon Islands Government Information and Communication Technology Services Unit (SIG ICT Services) are seeking a SQL Server Consultant to address database management performance issues and recommend any necessary solutions to ensure an improve enterprise environment.
Working under the Deputy Director for Projects, the Consultant will be required to install up to seven new SQL clusters of SQL server 2016 and migrate all SIG databases to new clusters. In cases where systems are not compatible with SQL Server 2016, the Consultant should aim for the highest compatible version. This migration will apply to all production, test, training and disaster recovery databases. Besides the existing databases, the Consultant should also prepare a cluster for exclusive use of an ongoing, on-premises, Microsoft Dynamics 365 deployment. Bidders can have details of the database, servers and sizes by emailing firstname.lastname@example.org
By accessing the SIG ICT Service remotely, the SQL Server Consultant will be required to:
- Assess current SQL usage and security, and identify areas where the system and performance can be improved.
- Design SQL infrastructure to allow integration of various databases from different government departments
- Advise on SIG systems compatibility with different SQL versions.
- Develop a roadmap that encompasses improvements to the SQL system, data warehouses and business intelligence tools.
- Prepare new clusters into which databases will be moved
- Migrate existing databases to new clusters aiming at higher version when compatible
- Optimise the databases distribution across clusters based on load and level of importance to SIG.
- Develop, prepare and coordinate System Integration Tests and User Acceptance Tests.
- Work with vendors to understand databases and systems requirements and compatibility
- Develop and implement roll-back strategies
- Train technical staff on the implementation of a SQL Cluster and SQL Server maintenance
- In partnership with the Information Systems Team and the Datacentre Management Services Contractor, reorganising existing regular data backups to meet business needs and risk management.
1. A draft report with detailed assessment of current SQL challenges and recommendation for improved usage and security. This report must fully address scope of work outlined in this scope of services and expected outputs
2. Final report to SIG ICT Services after incorporating feedback from SIG ICTS on current SQL challenges and recommendation for improved usage and security. This report must fully address scope of work outlined in this scope of services and expected outputs. Qualifications and experience
How to Apply:
- The Consultant/s should have a minimum of 10 years of experience of SQL Server administration, including large-scale upgrades and database migration. [CVs of all consultant/s are to be provided as part of the application]. Evidence of at least two (2) similar projects that have been completed in the last ten (10) years.
- Strong interpersonal and communication skills and a demonstrated ability to work effectively and collaboratively in a cross-cultural environment
- Experience working in government of large-scale organisations on similar upgrade projects; with a proven ability to identify and manage risks; to identify and solve complex problems; and implement sustainable solutions
- Demonstrated ability to work effectively with others and contribute to sustainable outcomes including the ability to negotiate effective solutions.
- [Desirable] Experience working in a developing country, preferably in the Pacific region, including small island countries that have recently implemented similar projects.
The full Request for Tender can be downloaded from: https://bit.ly/2I5A4CX
Proposals should be submitted to email@example.com by Sunday 1st November 2020
Any questions about the requirements of the activity or tender should be sent by email to the address above by 21st October.
Cardno has been engaged by DFAT to manage the Solomon Islands Resource Facility (SIRF). SIRF is an integrated facility that delivers both Technical Assistance and Deployee Support Services, in Solomon Islands.
- Conducts procurement and contract management of technical assistance and supports performance management
- Provides support services (management of residential accommodation, maintenance services and security) for Australian Government’s deployees and technical advisers; and
- Financial management and reporting including monitoring and evaluation of the Facility
The Facility is a critical source of operational support to DFAT, Programs and Technical Advisers as they attempt to navigate a shifting operating context, consolidate previous achievements while also prioritising new ways of working to ensure Australia’s assistance better achieves service delivery impact. About Cardno
We are a global provider of integrated professional services which enrich the physical and social environment for the communities in which we live and work. Our team of multidisciplinary specialists has more than 70 years’ experience in designing, developing and delivering sustainable projects and community advancement programs.
Cardno is an equal opportunity employer. Cardno encourages women and Solomon Islands nationals to apply.
Cardno is committed to Safety and the Prevention of Sexual Abuse and Harassment (PSEAH), Child Protection and bribery prevention. We want to engage with the right people to deliver our client programs. As part of our approach you will be subjected to formal background screening, criminal record checks, employment verification, and periodic compliance checks. All Cardno staff receive safety, compliance and safeguards training and are responsible for contributing to a safer working culture.
Apply For Job