Senior Database Administrator

Job Deliverables:
Creation of technical specifications for Azure, SQL, and Oracle database systems development
The Senior Database Administrator will 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
Senior Database Administrator will 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 a 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

Must Haves:
At least 10 years of experience
Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)

Evaluation Criteria
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 the 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)

Note:
Hybrid role- 2-3 days on-site per week required

24-05909