Database Administrator

Job Description:

• 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

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)

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