Apptad - Database Administrator - Senior

1 week ago

Golden Horseshoe, Canada Apptad Inc Full time
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: Long-Term 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 Manager's 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/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
Must haves:
  • At least 10 years of experience
  • Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)
  • Previous experience in OPS will be an asset
#J-18808-Ljbffr

  • Apptad -Software Developer - Senior

    2 weeks ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad -Software Developer - Senior Job Location: 5700 Yonge Street, 9th Floor,Toronto,Ontario (Hybrid - work 3 days on site and 2 days remote) Job Duration: Long-Term Job Description: Review and understand code and architecture of the existing code, and make updates as required to ensure the code is modular and can support scalability...

  • Apptad -Software Developer - Senior

    2 weeks ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad -Software Developer - Senior Job Location: 5700 Yonge Street, 9th Floor,Toronto,Ontario (Hybrid - work 3 days on site and 2 days remote) Job Duration: Long-Term Job Description: Review and understand code and architecture of the existing code, and make updates as required to ensure the code is modular and can support scalability...

  • Apptad - Software Developer - Full Stack - Senior

    7 days ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Software Developer - Full Stack - Senior Job Location: 777 Bay St,Toronto,Ontario (Hybrid - Candidate must be able to work 3 days onsite and 2 days Remote) Job Duration: Long-Term Job Description:Responsibilities Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities....

  • Apptad - Software Developer - Full Stack - Senior

    1 week ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Software Developer - Full Stack - Senior Job Location: 777 Bay St,Toronto,Ontario (Hybrid - Candidate must be able to work 3 days onsite and 2 days Remote) Job Duration: Long-Term Job Description: Responsibilities Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading...

  • Apptad - Software Developer - Full Stack - Senior

    1 week ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Software Developer - Full Stack - Senior Job Location: 777 Bay St,Toronto,Ontario (Hybrid - Candidate must be able to work 3 days onsite and 2 days Remote) Job Duration: Long-Term Job Description: Responsibilities Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading...

  • Apptad - Technology Architect - Senior

    2 weeks ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Technology Architect - Senior Job Location: 5700 Yonge Street, 9th Floor-Toronto.Ontario (This position is currently listed as "Hybrid" as consultants will be required to work partly in the physical workplace and partly remotely) Job Duration: Long-Term Job Description: Work in collaboration with Network Designer to roll out Next...

  • Apptad - Technology Architect - Senior

    2 weeks ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Technology Architect - Senior Job Location: 5700 Yonge Street, 9th Floor-Toronto.Ontario (This position is currently listed as "Hybrid" as consultants will be required to work partly in the physical workplace and partly remotely) Job Duration: Long-Term Job Description: Work in collaboration with Network Designer to roll out Next...

  • Apptad - Technical Specialist - - Case Management and ERP - Senior

    7 days ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Technical Specialist - - Case Management and ERP - Senior Job Location: 400 University Ave, Toronto,Ontario(Hybrid - Candidate must be able to work 3 days onsite and 2 days remote) Job Duration: Long-Term Job Description Responsibilities: MUST HAVE:Hands-on Cur am Development Experience Provides subject matter expertise and hands-on...

  • Apptad - Software Developer

    2 weeks ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Software Developer Job Location: 222 Jarvis Street,Toronto,Ontario (Hybrid - Candidate must be able to work 3 days onsite and 2 days remote) Job Duration: Long-Term Job Description: Responsibilities Required to translate technical systems specifications into working, tested applications. This includes. Developing detailed programming...

  • Apptad - Software Developer

    2 weeks ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Software Developer Job Location: 222 Jarvis Street,Toronto,Ontario (Hybrid - Candidate must be able to work 3 days onsite and 2 days remote) Job Duration: Long-Term Job Description: Responsibilities Required to translate technical systems specifications into working, tested applications. This includes. Developing detailed programming...

  • Apptad - Project Manager/Leader - Senior

    1 week ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Project Manager/Leader - Senior Job Location: 5700 Yonge Street, 9th Floor, Toronto, Ontario, Guelph Data Centre, 1000 Southgate Ave, Guelph, ON (Hybrid - Candidates needs to work onsite 3 days a week and 2 days remote) Job Duration: Long-Term Job Description: Develop project plans, work packages, obtain approvals Create and manage...

  • Apptad - Project Manager/Leader - Senior

    1 week ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Project Manager/Leader - Senior Job Location: 5700 Yonge Street, 9th Floor, Toronto, Ontario, Guelph Data Centre, 1000 Southgate Ave, Guelph, ON (Hybrid - Candidates needs to work onsite 3 days a week and 2 days remote) Job Duration: Long-Term Job Description: Develop project plans, work packages, obtain approvals Create and manage...

  • Apptad - Solutions Designer - Senior

    1 week ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Solutions Designer - Senior Job Location: Toronto, Ontario (Candidate needs to be in office - 3 days in a week) Job Duration: Long-Term Job Description Responsibilities: Undertakes the design of hosting technology solutions based on the client?s service specifications, standards, policies, best practices and cost models, in...

  • Apptad - Solutions Designer - Senior

    1 week ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Solutions Designer - Senior Job Location: Toronto, Ontario (Candidate needs to be in office - 3 days in a week) Job Duration: Long-Term Job Description Responsibilities: Undertakes the design of hosting technology solutions based on the client?s service specifications, standards, policies, best practices and cost models, in order to...

  • Apptad - Solutions Designer - Senior

    1 week ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - Solutions Designer - Senior Job Location: Toronto, Ontario (Candidate needs to be in office - 3 days in a week) Job Duration: Long-Term Job Description Responsibilities: Undertakes the design of hosting technology solutions based on the client?s service specifications, standards, policies, best practices and cost models, in order to...

  • Apptad - OCL Cloud Migration - One (1) Software Developer - Senior

    6 days ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - OCL Cloud Migration - One (1) Software Developer - Senior Job Location: Onsite / 21 College Street, Toronto Job Duration: Long-Term Job Description: Notes: 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...

  • Apptad - OCL Cloud Migration - One (1) Software Developer - Senior

    6 days ago

    Golden Horseshoe, Canada Apptad Inc Full time

    Job Title: Apptad - OCL Cloud Migration - One (1) Software Developer - Senior Job Location: Onsite / 21 College Street, Toronto Job Duration: Long-Term Job Description: Notes: 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...

  • Database Engineer Intern

    1 week ago

    Golden Horseshoe, Canada Vosyn Full time

    Company Overview: At Vosyn, we embrace the exciting, game-changing world of Artificial Intelligence, driving innovation and pioneering impactful projects across various industries. Our incubator, AI Venture Lab is nestled in the heart of , is a crucible of entrepreneurial spirit, supported by intelligent processes and industry-leading best practices. We...

  • Senior Database Java Developer

    2 weeks ago

    Golden Horseshoe, Canada Alert Driving Full time

    Backend Application Developer - Job DescriptionPosition SummaryWe are currently looking for an experienced application developer who is well-versed in database-centric application development and will support the ongoing development of the company’s web-based software products and internally developed support systems. You have extensive experience...

  • Senior Database Java Developer

    2 weeks ago

    Golden Horseshoe, Canada Alert Driving Full time

    Backend Application Developer - Job DescriptionPosition SummaryWe are currently looking for an experienced application developer who is well-versed in database-centric application development and will support the ongoing development of the company’s web-based software products and internally developed support systems. You have extensive experience...