Job Description

Experience and Skill Set Requirements

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

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

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

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.

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.

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

All documentation relating to functional and technical specifications for systems development. Codes Scripts.

Project Manager, team members

Knowledge Transfer to occur throughout the project life cycle.

1:1 meetings / team meetings / documentation on SharePoint site

MUST HAVES:

Oracle, SQL Managed Instance & Elastic Pools

• Performance tuning using AWR, ASH, and execution plans
• Storage optimization, partitioning, and indexing strategies

Oracle GoldenGate

• Designing, deploying, and monitoring GoldenGate replication topologies
• Tuning extract/replicat processes, log retention, and checkpointing

Azure Data Replication

• SQLMI transactional replication
• Elastic pool implementations and tenant level balancing

Operational Excellence

• Incident response, performance baselines, and proactive monitoring
• Root cause analysis and post incident optimization

Job Tags

Similar Jobs