Database Administrator

1 month ago


Old Toronto Ontario, CA ALLTECH CONSULTING SVC INC Full time

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

  1. Creation of technical specifications for Azure, SQL and Oracle database systems development
  2. Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards
  3. Undertake special assignments/sub-projects as assigned
  4. Conduct, assess, evaluate and document stakeholder interests and business needs
  5. Create and validate business scenarios and use cases
  6. 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
  7. Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as required
  8. Create system and user interface design and modifications (data & screen) as required
  9. Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output
  10. Ensure alignment and adherence to Ministry of Government Services’ processes and standards
  11. Support the testing team during system and UAT testing
  12. Participate in Knowledge transfer

Skills and Knowledge:

  1. Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications
  2. Create, test and implement safeguards to maintain data integrity and protect against unauthorized access
  3. Assist with SQL optimization and code reviews to ensure queries are efficient

Mandatory Requirements:

  1. At least 10 years of experience
  2. 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 skills.
• 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.

#J-18808-Ljbffr

  • Old Toronto, Ontario, CA Momentum Financial Services Group Full time

    Momentum Financial Services is a leading provider of financial services in North America. For 40 years, we've been committed to providing financial solutions that meet the evolving needs of consumers and business owners. Through our retail network of over 400 locations, known as Moneymart, Insta Cheques and the Cheque Cashing store, we provide access to...


  • Old Toronto, Ontario, CA Broadridge Full time

    At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you’re passionate about developing your career, while helping others along the way, come join the Broadridge team. We are currently seeking a highly skilled and detail-oriented SQL Server and related DB technologies Operations specialist to join our...


  • Old Toronto, Ontario, CA Broadridge Full time

    At Broadridge, we've built a culture where the highest goal is to empower others to accomplish more. If you’re passionate about developing your career, while helping others along the way, come join the Broadridge team. We are currently seeking a highly skilled and detail-oriented Database Lead. Selected candidate will join a global DB Operations team...


  • Old Toronto, Ontario, CA Nexus Systems Group Inc. Full time

    Location Address: Hybrid (Currently remote with the possibility of transitioning into a hybrid work model in the future. Candidates are expected to come to the office when necessary) – Toronto Contract Duration: June 3rd, 2024 until October 31, 2024 Number of Positions: 1 Scheduled Hours: 8:30am-5pm (Occasional over time and weekend hours may be...


  • Old Toronto, Ontario, CA Talentworld Full time

    Put your Oracle 12c & 19c skills to work in an exciting role where you'll manage and enhance a vital database infrastructure. Take charge of RMAN backups, data encryption, SQL optimization, and OEM management. Enjoy a flexible hybrid work model while contributing to essential applications and systems. Ready to drive excellence? Apply today!TalentWorld is...


  • Old Toronto, Ontario, CA Ministry of the Solicitor General Full time

    Come showcase your project management, team leadership and technical consulting expertise in data management and database administration with the Justice Technology Services Division at the Ministry of the Solicitor General. As a crucial member of our team, you will play a pivotal role in supporting mission-critical Police applications, leveraging your...


  • Old Toronto, Ontario, CA ALLTECH CONSULTING SVC INC Full time

    * Work with EFP technical team to plan/prepare and execute migration of e-Business Suite and TPE (Transfer Payment Extension) application from On-Prem Supercluster to Oracle Cloud Infrastructure. * Performance tuning of e-Business Suite R12.2/19c in multi-node RAC environment. * Configure, deploy Oracle Access Manager, Oracle Universal Directory (OUD),...


  • Old Toronto, Ontario, CA ProViso Staffing Full time

    Story Behind the Need: Business group: Cloud Engineering – main teams are responsible for creating platform (Kubernetes) and all connections for logging monitoring chargeback and setting up all processes around creating/establishing Cloud resources for different projects; creating processes for automating releases; spearheading creation and management of...


  • Old Toronto, Ontario, CA Precision Castparts Full time

    Summary:Responsible for the implementation, configuration, maintenance, and performance management of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our division applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.The...


  • Old Toronto, Ontario, CA Extreme Networks Full time

    Extreme Networks Named to Computerworld’s 2023 List of Best Places to Work in IT!Over 50,000 customers globally trust our end-to-end, cloud-driven networking solutions and rely on our top-rated services and support to accelerate their digital transformation efforts. With double-digit growth year over year, no provider is better positioned to deliver better...


  • Old Toronto, Ontario, CA S I Systems Full time

    Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server Database for a Fin-Tech ClientOur Fin-Tech Client is in need of a Sr. SQL Server Database administrator to design, configure, maintain, and optimize a SQL Server DatabaseIn response to the rapidly changing payments landscape and the multiyear Payments Canada...


  • Old Toronto, Ontario, CA Ontario Society of Occupational Therapists Full time

    ONTARIO SOCIETY OF OCCUPATIONAL THERAPISTSPosition: Database and Membership Manager - Full TimeLocation: TorontoPosting Date: 07/29/2024Application Deadline: 08/28/2024Description of OpportunityReporting to: Executive DirectorPosition Type: Permanent, Full Time, HybridPOSITION SUMMARY: The Membership and Database Manager (MDM) delivers unparalleled customer...


  • Old Toronto, Ontario, CA Kaizen Lab Inc. Full time

    Data Analysis and Database Specialist Data, Research and Evaluation Full Time, Permanent Hybrid Level 7 Covenant House helps youth ignite their potential and reclaim their lives. As Canada’s largest agency serving youth who are homeless, trafficked or at risk, we offer the widest range of services to hundreds of young people every day. More than a place to...


  • Old Toronto, Ontario, CA Manulife Full time

    We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and...

  • CRM Administrator

    1 month ago


    Old Toronto, Ontario, CA Cardata Consultants Inc. Full time

    Who You AreYou are a problem solver with a strong attention to detail. As the CRM administrator, you will be the technical owner and expert of our Hubspot CRM platform and the go-to person for reporting, troubleshooting, database management, and integrations. You will work with various stakeholders to optimize our CRM. You have direct influence on how we use...


  • Markham, Ontario, I3P, CA Pet Valu Full time

    Database Services Manager page is loaded Database Services Manager Apply locations 0001 – Markham Office time type Full time posted on Posted 3 Days Ago job requisition id R21202 Location: Markham, OntarioJob Description:Job OverviewA hands-on Manager Database Services who thrives in a dynamic work environment, this role involves leading a database...


  • Old Toronto, Ontario, CA Accoravillage Full time

    Take the next steps in your IT career by joining us as a System Administrator! What does the IT System Administrator do? Working remotely, the System Administrator is responsible for the maintenance, configuration, and reliable operation of computer systems and servers. This role works with hardware and software and participates in research and...


  • Old Toronto, Ontario, CA InfoSec Global Full time

    Who We Are:As the pioneer and leader in Cryptographic Agility Management solutions, InfoSec Global secures the world’s digital assets by helping the way people discover, protect, control and future-proof their crypto assets with agile cryptography. Powered by patented technologies and delivered through a “crypto-as-a-service” approach, InfoSec...

  • Azure Administrator

    1 month ago


    Old Toronto, Ontario, CA Insight Direct UK Ltd Full time

    Select how often (in days) to receive an alert: Remote, CA Requisition Number: 97456 About Insight: Insight Enterprise Inc serves clients in 190 countries, and in Canada, our robust Staffing department specializes in placing top-notch talent in sought-after roles across the nation. Description:Our client in the automotive industry is seeking an Azure...

  • Leasing Administrator

    4 weeks ago


    Old Toronto, Ontario, CA Equiton Partners Inc. Full time

    About Equiton: Equiton Living is a privately owned, full-service property management company that provides quality, well-maintained apartments across Ontario. Hands-on, proactive management, highly trained and experienced staff, relationship-oriented business practices, and continued reinvestment in our properties are the keys to our success. Our focus is on...