RQ - Database Administrator - Senior

• Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support.
  
• Work with the project team in completing all relevant and required documentation in alignment with OPS standards.

Experience and Skill Set Requirements

Deliverables:

• Creation of technical specifications for Azure, SQL and Oracle database systems development
  
• Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards
  
• Undertake special assignments/sub-projects as assigned
  
• Conduct, assess, evaluate and document stakeholder interests and business needs
  
• Create and validate business scenarios and use cases
  
• Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture, as well as traceability to solution logical and physical architectures
  
• Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as required
  
• Create system and user interface design and modifications (data & screen) as required
  
• Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output
  
• Ensure alignment and adherence to Ministry of Government Services’ processes and standards
  
• Support the testing team during system and UAT testing
  
• Participate in Knowledge transfer
  

Requirements

Skills and Knowledge:

• Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications
  
• Create, test and implement safeguards to maintain data integrity and protect against unauthorized access
  
• Assist with SQL optimization and code reviews to ensure queries are efficient
  

Mandatory Requirements:

• At least 10 years of experience
  
• Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)
  
• Previous experience in OPS will be an asset