Database Administrator

LanceSoft

  • Toronto, ON
  • Permanent
  • Full-time
  • 22 days ago
Location: Toronto, ON
Job Title : Database Administrator
Duration: 11 Months (With Possible Extension)Mandatory Requirements:
  • At least 10 years of experience
  • Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)
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)
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.
  • 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.

LanceSoft