RQ10815 - Database Administrator - Senior

Job Description

Deliverables:

The Services and Deliverables to be provided by the Vendor will include the following:

• Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.;
  
• Prepare and implement database changes according to design;
  
• Promote database changes through Development, Integration Testing, QA, UAT, Production environments;
  
• Prepare, install, configure Operating Systems, databases and database patches;
  
• Maintain, administrate, tune performance of databases, e.g. Oracle, Microsoft Azure SQL, Synapse and Mainframe IMS, DB2 databases;
  
• Provide database space calculations for the supported database environments;
  
• Perform reference data administration as required;
  
• Plan and co-ordinate implementation with developers, ITS, UNIX and .NET application support and other Data Management staff;
  
• Design and write data loading and/or conversion scripts/stored procedures;
  
• Maintain and enhance Mainframe to Oracle data replication utilizing Tibco IMS Data Replicator, Oracle stored procedures and GoldenGate;
  
• Build and test database backup/recovery scripts;
  
• Build and test database automation scripts;
  
• Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards;
  
• Document and resolve any database problems/issues;
  
• Provide effective knowledge transfer to Ministry staff at all stages of this assignment;
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• Expert Database administration experience, e.g., Oracle and Microsoft Azure SQL
  
• Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools
  
• Experience with database development, e.g., stored procedure, PL/SQL
  
• Experience with Oracle and Microsoft Azure Database replication
  

Skill Set Requirements:

• Expert Database administration experience, e.g., Oracle, Microsoft Azure SQL, Synapse and Mainframe (IMS & DB2) database
  
• Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning
  
• Experience with database development, e.g., stored procedure, PL/SQL, PL/I, Cobol, Assembler
  
• Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools
  
• Experience with IMS/DB2 to Oracle replication
  

Database Administration:

• Expert Database administration experience, e.g., Oracle, Microsoft Azure SQL, Synapse and Mainframe (IMS & DB2) databases.
  
• Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools
  
• Experience with Mainframe z/OS Operating system, tools and technologies
  

Systems Development:

• Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning
  
• Experience with database development, e.g., stored procedure, PL/SQL, PL/I, Cobol, Assembler
  

Data Replication:

• Experience with IMS/DB2 to Oracle replication
  

Requirements
Experience and Skill Set Requirements: Must Haves: Expert Database administration experience, e.g., Oracle and Microsoft Azure SQL Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools Experience with database development, e.g., stored procedure, PL/SQL Experience with Oracle and Microsoft Azure Database replication Skill Set Requirements: Expert Database administration experience, e.g., Oracle, Microsoft Azure SQL, Synapse and Mainframe (IMS & DB2) database Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning Experience with database development, e.g., stored procedure, PL/SQL, PL/I, Cobol, Assembler Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools Experience with IMS/DB2 to Oracle replication Database Administration: Expert Database administration experience, e.g., Oracle, Microsoft Azure SQL, Synapse and Mainframe (IMS & DB2) databases. Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools Experience with Mainframe z/OS Operating system, tools and technologies Systems Development: Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning Experience with database development, e.g., stored procedure, PL/SQL, PL/I, Cobol, Assembler Data Replication: Experience with IMS/DB2 to Oracle replication