Senior Database Administrator

2 weeks ago


Toronto, Ontario, Canada NR Consulting Full time
Position Title : Senior Database Administrator
Location :-Toronto, ON (Hybrid)
Mode :- Contract

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.

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 ( 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

Technical Skill

• 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.

Must haves: At least years of experience Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (+ years) Previous experience in OPS will be an asset

  • Toronto, Ontario, Canada Ensono Full time

    Ensono Senior Mainframe Datacom DBA Madison , Wisconsin Apply Now Senior Mainframe Datacom DBARemote - United StatesJR010139 The successful candidate will perform mainframe database software upgrades coupled with administration and tuning to support our customers' CA Datacom environments. They will be called upon to perform a variety of tasks including...


  • Toronto, Ontario, Canada PeopleToGo Full time

    DESCRIPTION OF REQUEST - STATEMENT OF WORK SPECIFICATIONS and REQUIREMENTS:Description of the initiative/objectivesOur customer is looking for:· One (1) Senior Database Administrator, who is capable of analyzing, leading, participating and advising on an initiative for modeling, developing, implementing Enterprise Information Management to ensure the...


  • Old Toronto, Ontario, Canada Motorola Solutions Full time

    Senior Database Administrator (Canada Remote) page is loaded Senior Database Administrator (Canada Remote) Apply locations Toronto, Canada (ONT40) Ontario Remote Work time type Full time posted on Posted 3 Days Ago job requisition id R46746 Company Overview At Motorola Solutions, we're guided by a shared purpose – helping people be their best in the...


  • Toronto, Ontario, Canada QA Consultants Full time

    Senior Database Administrator-SQL Job Type: Contract Primary Location: Remote – Toronto, ON We have several projects with major North American companies. Currently, we are looking to bring on a DBA to support a gaming client of ours. Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical...


  • Toronto, Ontario, Canada AGCO Full time

    Term: Permanent, Full-TimeDivision/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity BranchApplication Deadline: May 24, 2024Level: Level 10Salary Range: Min: $92,902 to Max: $116,123Work Location: Head Office, Toronto, ON; HybridThe Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that...


  • Old Toronto, Ontario, Canada CorGTA Inc. Full time

    Senior Oracle Database Administrator - 6 month contract - up to $63.00 p/h INC. $55–$63 an hour - Temporary, Full-time, Fixed term contract Job details Here's how the job details align with yourprofile . PayJob type Temporary Full-time Fixed term contract Shift and schedule Monday to Friday Location CorGTA Inc. in Toronto, ON Full job...


  • Toronto, Ontario, Canada Ombudsman Ontario Full time

    Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency under the Ministry of the Attorney General, responsible for overseeing alcohol, gaming, horseracing, and cannabis retail in Ontario, guided by honesty, integrity, and public interest.Position: Database AdministratorReporting to: Senior Manager of IT Infrastructure and OperationsLocation:...


  • Toronto, Ontario, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.We are currently seeking competent individuals to fulfill the role of DBA to join our...


  • Toronto, Ontario, Canada Alcohol and Gaming Commission of Ontario Full time

    The Alcohol & Gaming Commission of Ontario (AGCO) is responsible for regulating the alcohol, gaming, horse racing and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.The Information & Information Technology Branch requires an experienced Database Administrator, who will be...


  • Toronto, Ontario, Canada QA Consultants Full time

    Senior Database Administrator-SQLJob Type: ContractDuration- 6 months to startPrimary Location: Remote – Toronto, ONWe have several projects with major North American companies. Currently, we are looking to bring on a DBA to support a gaming client of ours.Key ResponsibilitiesManage SQL Server databases through multiple product lifecycle environments, from...


  • Toronto, Ontario, Canada Ministry of Public and Business Service Delivery Full time

    About UsThe OpportunityThe Government Services Integration Cluster (GSIC) is considered one of the most respected and innovative clusters within the OPS. If you are an expert with Oracle 19C, PeopleSoft HCM and/or Cloud skills and are looking to utilize them on a daily basis then the Enterprise Human Capital Solutions Practice is looking for you to join our...


  • Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled Database Administrator - Senior for one of our clients.Position: Database Administrator - SeniorLocation: Toronto, Ontario (Hybrid)Duration: Long Term ContractMust haves: 10+ years of demonstrated experience supporting/managing Oracle DB, including but not limited to architecture,...


  • Old Toronto, Ontario, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group's mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time to...


  • Old Toronto, Ontario, Canada Tundra Technical Solutions Inc. Full time

    Story Behind The NeedThe Global Technology Services (GTS) Tools and Monitoring group's mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time to...


  • Toronto, Ontario, Canada Finance Professionals Inc. Full time

    Typical Day in Role: Oracle Installation, Database creations and upgrades from lower Database versions to higher versions. Troubleshooting connectivity and addressing any system concerns. Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems). Plan and perform...


  • Toronto, Ontario, Canada Veeva Systems Full time

    Veeva [NYSE:VEEV] is the leader in cloud-based software for the global life sciences industry. Committed to innovation, product excellence, and customer success, our customers range from the world's largest pharmaceutical companies to emerging biotechs. Veeva's software helps our customers bring medicines and therapies to patients faster.We are the first...


  • Toronto, Ontario, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade:Participate in the review of project and maintenance release artefacts Use Case, System Requirement Specification, etc.; Prepare and implement database changes according to design; Promote database changes through Development, Integration Testing,...


  • Toronto, Ontario, Canada IBI Group Full time

    Company DescriptionWe are a global architecture, engineering, planning, and technology firm defining the cities of tomorrow.By connecting design and technology, we change how people experience their built environment. We work across disciplines to create the intelligent systems, sustainable buildings, and efficient infrastructure that shapes the way people...


  • Toronto, Ontario, Canada Momentum Financial Services Group_new Full time

    Job DescriptionThis is an excellent opportunity for a seasoned database administrator with expertise in Azure cloud technologies, advanced SQL features, Qlik, and Azure Data Factory (ADF) to join a dynamic team and contribute to the success of our cloud-based data initiatives. If you meet the above qualifications and are passionate about database...


  • Toronto, Ontario, Canada The Mabin School Full time

    Database Administrator / IT HelpdeskDuration: 20 hrs / week over 3-4 days / weekLocation: Toronto, ONPlease note this is a hybrid role. About The Mabin School:The Mabin School is a small, co-educational JK to Grade 6 progressive school with a strong commitment to inquiry, integration, and reflection. We are Canada's first independent Ashoka Changemaker...