Database Administrator/Systems Administrator

Dept of Social Services

RFQ number / 240415WZ17

Department requirements for this RFQ

Item number / Description / Details
Proposed Work Order Start Date / 1 July 2015
Proposed Initial Contract Period / Up to two (2) years
Contract Option Period / Up to two (2) years
Number of Specified Personnel required / Several
Reduced activity period / All public holidays and DSS Christmas shutdown period
Business Hours / From 7.00am to 7.00pm on a business day
Services/work required / The work performed by the Database Administrators/System Administrators will consist of:
Data Warehouse DBA -
  • Database administration primarily in the development and test domains
  • Promotions of release candidates to the test environment
  • Maintenance of physical database structures
  • Version control of database definition scripts
  • Programming of stored procedures and triggers
  • Preparation and execution of scripts
  • Data management tasks relating to application interfaces
  • Monitoring, reporting and correction of data accuracy
  • Maintenance of release standards
Database Administrators –
  • SQL Administration and support
Provisioning new database services.
Database Designer –
  • Oracle 11G administration and support
  • Aged Care Gateway provisioning.
Oracle 11G Database Administrator –
  • Oracle 11G administration and support
  • Aged Care Gateway provisioning.
Oracle Fusion Middleware Administrators – see below
SharePoint Infrastructure Administrators – see below
Systems Administrator – see below
SAS System Administrator – see below
Cognos Administrator – see below
TRIM Administrator - see below:
  • Support the Oracle Middleware components that are associated with the Aged Care Gateway solution and the existing Department’s Siebel instance, FOFMS. These components include:
o SOA suite (OSB, BPEL and BPM);
o OPA;
o OEDQ;
o IAM (OHS/OVD) and;
o OAG.
  • Support of multiple SharePoint farms for DSS and NDIA. Experience in managing SharePoint 2013, 2010 and 2007 farms is mandatory.
  • Support of .NET platforms and related components including code releases and overall maintenance of the infrastructure. This role will require a sound understanding of how .NET solutions are architected and function;
  • Support of SAS components that relate to system maintenance. Components include:
o Base SAS and Enterprise Guide (9.3);
o Management of SAS access, PC files, OLE DB and other Microsoft Office Add-ins
  • Support the Department’s instance of Cognos (10.2.1) including management of servers, access and updates. Cognos components include:
o Cognos BI
o Transformer
o Cube Designer
o Framework Manager
ILMT v7.5
Note: This is not a report developer role.
  • Support of an enterprise level TRIM/HP Records Manager instance, particularly with RM8 and IDOL. Exposure and understanding of InMailX would be greatly desirable and skills to automate administration would be highly desirable.
Oracle Database Administrator –
  • Technical designs and plans
  • Configuration and technical testing
  • Development/maintenance of automated processes for environment delivery and BAU/migration activities
  • Definition of maintenance and troubleshooting procedures
  • Production monitoring and support activities.
Senior Systems Administrator –
  • Provide technical solutions for automated provisioning of platform and application services in particular Oracle applications
  • Providing knowledge transfer and mentoring to BAU operations teams in configuration and administration of platform and application automation services
  • Providing advanced problem management support for platform and application automation services.
Siebel Systems Administrator –
  • Technical designs and plans
  • Configuration and technical testing
  • Development/maintenance of automated processes for environment delivery and BAU/migration activities
  • Definition of maintenance and troubleshooting procedures
  • Production monitoring and support activities.

Personnel Category (Skill set) / Database Administrators/System Administrators
Sub-Categories:
  • Data Warehouse DBA
  • Database Administrators
  • Database Designer
  • Oracle 11G Database Administrators
  • Oracle Fusion Middleware Administrators
  • Oracle Database Administrator
  • Senior Systems Administrator
  • Siebel Systems Administrator
  • SharePoint Infrastructure Administrator
  • Systems Administrator
  • SAS System Administrator
  • Cognos Administrator
  • TRIM Administrator

Performance / Not Applicable
Skills knowledge transfer / No Applicable
Selection criteria
Please note the importance of responding to this Selection Criteria.
Mandatory Criteria must be met to progress in the evaluation, where the Weighted Criteria is scored / Applicants should provide a brief (1 to 2 page) statement that summarises their experience and suitability for the role with respect to the following criteria.
Core Skills
Staff put forward by an agency for the Tester position must:
SELECTION CRITERIA:
  • Proven ability to work in a team environment, with the ability to work with limited supervision and achieve results. A high level of organisation and good time management skills, including a demonstrated ability to meet priorities and work to deadlines;
  • A demonstrated ability engage with requesting business areas and project stakeholders ;
  • Initiative, problem solving skills and being outcome focussed;
  • Ability to discuss technical issues/solutions with both technical and non-technical staff; and
  • Demonstrated experience in at least one of below:
Data Warehouse DBA –
  • 5 + years of experience and proven skills in the administration of SQL Server 2008 R2, SQL Server 2012 or Oracle 10g/11g/12c
  • Ability to develop complex T-SQL or PL/SQL code using stored procedures, triggers, views and functions
  • Understanding of SQL Server/Oracle database functions and related usage such as indexing, query tuning and performance
  • Excellent analytical and problem solving skills
  • Knowledge of Data Warehousing particularly WhereScape RED or SAS DI is desirable but not mandatory
  • Experience with SSRS/SSIS/SSAS desirable
Database Administrators-
  • Experience with one or multiple of the following database technologies: SQL 2005, SQL 2008, SQL 2012
  • Be familiar with techniques and processes
  • Have excellent technical skills, show initiative and be outcome focussed
  • Experience in delivering high level and detailed technical designs.
Database Designer –
  • Experience with Oracle database technologies
  • Be familiar with techniques and processes
  • Have excellent technical skills, show initiative and be outcome focussed
  • Experience in delivering high level and detailed technical designs.
Oracle 11G Database Administrator –
  • Experience with Oracle database technologies
  • Be familiar with techniques and processes
  • Have excellent technical skills, show initiative and be outcome focussed
  • Experience in delivering high level and detailed technical designs.
Oracle Fusion Middleware Administrators – see below
SharePoint Infrastructure Administrators – see below
Systems Administrator – see below
SAS System Administrator – see below
Cognos Administrator – see below
TRIM Administrator - see below:
  • Consolidation of multiple Oracle Fusion Middleware components that form part of a large scale multi instance Siebel environment
  • Provision and upgrade of SharePoint farms including intranet and internet environments
  • Streamlining .Net platforms that interact with different non-Microsoft environments
  • Consolidating of SAS environments from an infrastructure perspective
  • Ongoing investment and development of Cognos environments including refinement of security and day to day process that align with the ITIL framework
  • Ongoing investment and development of the TRIM platform.
Senior Systems Administrator –
  • Configuration and maintenance of vendor and custom solutions for automated provisioning of platform and application services
  • Utilise knowledge and experience with Oracle application platform requirements and configuration and vendor frameworks to implement automation solutions
  • Knowledge on Infrastructure O/S, Windows, Linux, Network services, integrations with Authentication Services as well as experience provisioning for Microsoft/Oracle DB and Microsoft, Siebel/Oracle application platforms
  • Knowledge and experience installing and configuring automated solutions using both vendor specific and open source technologies
  • Possess Baseline security clearance.
Siebel Systems Administrator –
  • Proven skills and experience in large scale Siebel enterprises and an ability to understand and meet business requirements
  • Sound Windows Server 2008/2012 skills and/or Linux administration;
  • Experience or understanding of Oracle Exadata (specific for the Oracle DBA role only)
  • Understanding of virtualisation (particularly with VMWare) and associated underlying components;
  • Experience in supporting Siebel or 11g in a large enterprise environment that required the use of change management;
  • Understanding of gateway zones and directory systems including Active Directory; and
  • Certification within their respective fields.
Oracle Database Administrator –
  • Proven skills and experience in large scale Siebel enterprises and an ability to understand and meet business requirements
  • Sound Windows Server 2008/2012 skills and/or Linux administration;
  • Experience or understanding of Oracle Exadata
  • (specific for the Oracle DBA role only)
  • Understanding of virtualisation (particularly with VMWare) and associated underlying components;
  • Experience in supporting Siebel or 11g in a large enterprise environment that required the use of change management;
  • Understanding of gateway zones and directory systems including Active Directory; and
  • Certification within their respective fields.
A resume must be provided for each candidate.
Other requirements
E.g Location, Security Clearance Level / The specified personnel must be covered by the Workers Compensation in the relevant States or Territory.
The successful candidate is required to undertake police check to be conducted by DSS. Start date is subject to finalised police check. Unfavourable outcome may result to early termination of the contract.
A minimum of Baseline vetting Security Clearance is required for this role.
The successful candidate will be based in Tuggeranong ACT.