Job Title: Apptad Database Administrator Senior
Job Location: 21 College Street Toronto Ontario (This position is currently listed as Onsite; however the Assignment under this request will provisionally be Hybrid)
Job Duration: LongTerm
Job Description
NOTE:
- This position is currently listed as Onsite; however the Assignment under this request will provisionally be Hybrid working 7.25 hours per calendar day sometime between 8:00
- 5:00 PM (excluding lunch breaks) Monday to Friday inclusive unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation.
- During the duration of the assignment you will be under the discretion of the Hiring Managers requirements for the Project you are assigned to.
- 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.
Skills
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)
Criteria Ratings MUST TOTAL 100
Criteria 1: Technical Skills 55 Points
- 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.
- Criteria 2: Analysis and Problem Solving 30 Points
- 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.
- Criteria 3: Communication and Interpersonal Skills 15 Points
- 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
Must haves:
- At least 10 years of experience
- Experience in database replication / RealTime data delivery with either MSSQL or Oracle products (5 years)
- Previous experience in OPS will be an asset