Database Administrator - Application - 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 standard
  

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/subprojects 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
  

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 / RealTime data delivery with either MSSQL or Oracle products (5 years)
  

Requirements

Technical Skills

• Oracle Exadata Golden Gate MSSQL Azure SQL technical knowledge and experience.
  
• Demonstrated experience in modifying database structures using information provided by application developers
  
• Demonstrated experience with monitoring optimizing and performance tuning using either manual or automated tools
  
• Able to develop and interpret highly complex SQL to support queries and provide feedback for developers.
  

Analysis and Problem Solving

• Research and evaluation of complex design options.
  
• Superior ability to identify root cause of complex environmental or underlying database specific issues.
  
• Determining areas of risk and recommending innovative alternatives and options for resolution to meet program needs.
  
• Demonstrated experience working within a team environment to troubleshoot and resolve technical problems.
  

Communication and Interpersonal Skills

• Demonstrated writing and negotiation
  
• Oral and written communication skills Interpersonal and consultative skills
  
• Experience preparing operational documentation (build guides procedures etc)
  

Knowledge Transfer

Knowledge to be Transferred:

• All documentation relating to functional and technical specifications for systems development. Codes Scripts.
  
• Knowledge to be Transferred to:
  
• Project Manager team members
  
• Details of Transfer:
  
• Knowledge Transfer to occur throughout the project life cycle.
  
• 1:1 meetings / team meetings / documentation on SharePoint site