Database Administrator 6320-20

2 weeks ago

Toronto, Canada Foilcon Full time

**Description**
- Experience with Streaming Analytics, Data Factory and Azure Functions
- Experience with MS SQL 2016/2019, Azure SQL and experience upgrading SQL-based systems
- Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion, and migrations
- Provides specialized technical expertise in the overall support and maintenance of systems solutions that leverage Windows administration/support and scripting etc.
- Ability to provide post-implementation support and resolve any post-implementation technical issues
- Experience creating, reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging
- Debugging MS SQL Scripts/Code in a Windows-based environment including resolving performance issues
- Experience with relational and hierarchical database technologies
- Experience in the use of information retrieval packages using query languages
- Knowledge and experience with Debezium, Streaming Analytics and Azure SQL, Event Hub, Data factory, Data Bricks
- Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
- A team player with a track record for meeting deadlines

**Desirable Skills**:

- Debugging and resolving issues with Change Data Capture (CDC) and SQL 2016/2019
- Experience with middleware and gateways
- Experience conducting design walkthrough sessions with project team
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
- Ability to provide user and system documentation as required

**Skills**:
Experience and Skill Set Requirements

**DBA Skills: 40%**
- 10+ years of experience in database administration, maintenance, optimization, and fine tuning of databases
- 3-5 years of experience with creating data flow diagrams, entity relationship modeling and techniques
- 5+ years of experience in database development using SQL, SQL Plus, Stored Procedures, transitional databases
- Experienced with Extract, Load and Transform (ETL) processes and technologies
- Working knowledge of MS SQL Server 2008 to 2019 and maintenance, setup, configuration, deployment, troubleshooting
- Experience with building, troubleshooting, and maintaining SQL query scripts
- Experience with deployment and maintenance of distributed data warehouse environments and associated reporting tools

**Technical Skills: 40%**
- Working knowledge of database normalization theory, STAR schema theory; data warehouse principles and cubes design
- Working knowledge of information security principles, techniques, and tools
- Experience in the use of information retrieval packages and working knowledge of query languages
- Experience in monitoring and enforcing database rules
- Experience in incident, change and configuration management procedures
- Working knowledge of Cognos and Crystal Reports reporting tools
- Experience with Enterprise Content Management Experience with Business Intelligence (BI) tools and methodologies

**Analytical & Communication Skills: 20%**
- Demonstrated experience and competency to develop effective relationships with senior management and stakeholders.
- Strong oral and written communications and principles and methods, to draft reports and analyses
- Experience working with team-collaboration tools (Confluence and Jira
- Proven and demonstrable troubleshooting and analytical skills
- Able to understand impact of work from a business perspective
- Strong verbal and written communication skills
- Strong consulting skills to engage with all stakeholders
- A demonstrated team player with a track record for meeting deadline

**Must Haves**:

- Experience with MS SQL 2016/2019, Azure SQL and experience upgrading SQL-based systems.
- Experience with Streaming Analytics, Data Factory and Azure Functions.
- Ability to provide post-implementation support and resolve any post-implementation technical issue.
- Knowledge and experience with Debezium, Streaming Analytics and Azure SQL, Event Hub, Data factory, Data Bricks.

  • Database Administrator

    1 month ago

    Toronto, 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. **Job Title: Database Administrator - Senior** **Location: Toronto, Ontario (Onsite)** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS...

  • Database Administrator

    6 days ago

    Toronto, 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 - Senior** **Location: Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must haves**: - 10+ years of demonstrated experience supporting/managing Oracle DB, including...

  • Oracle Database Administrator

    7 days ago

    Toronto, 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 - Senior** **Location: Toronto, Ontario (Hybrid)** **Must haves**: - Support data migration activities from external data sources into source Oracle/Siebel database - Maintain and...

  • Oracle Database Administrator

    1 month ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Senior** **Database Administrator **for one of our clients. **Position: Senior Database Administrator** **Location: Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must Have** - More than 10 yrs. Oracle DBA experience - Approved experience with Oracle 12c & 19c...

  • Database Administrator 6046-03

    1 month ago

    Toronto, Canada Foilcon Full time

    **The Services **and Deliverables to be provided will include the following**: - 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, QA, UAT, Production...

  • Oracle Database Administrator

    7 days ago

    Toronto, 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 - Senior** **Location: 40 St. Clair Ave. W, Toronto, Ontario (Hybrid)** **Duration: Long Term** **Employment: Contract** **Must haves**: - Support data migration activities from...

  • Database Administrator

    4 weeks ago

    Toronto, Canada The Mabin School Full time

    Database Administrator / IT Helpdesk Duration : 20 hrs / week over 3-4 days / week Location : Toronto, ON Please 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...

  • Database Administrator

    6 days ago

    Toronto, 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,...

  • Database Administrator

    7 days ago

    Toronto, Canada AGCO Full time

    **Term**: Permanent, Full-Time **Division/Branch**: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch **Application Deadline**: May 24, 2024 **Level**: Level 10 **Salary Range**: Min: $92,902 to Max: $116,123 **Work Location**: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario...

  • Database Administrator

    7 days ago

    Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    The **Alcohol and Gaming Commission of Ontario (AGCO)** is a regulatory agency that reports to the Ministry of the Attorney General. The AGCO is responsible for regulating the alcohol, gaming, horseracing, and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest. The Cybersecurity...

  • Database Administrator

    1 month ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Database Administrator - Senior** **Location: 595 Bay Street,, Toronto, Ontario** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS 11-12 in a Windows environment and SQL Server RDBMS 2008-2019 - Database installation, upgrade, monitoring, troubleshooting,...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Interac Corp. Full time

    Database Administrator At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Atlantis IT group Full time

    **JD**: **Role - Database Administrator** **Location-** **Toronto, ON(Hybrid)** **Duration - Contract** Desirable Skills: Experience in Agile product development in Scrum or Kanban would be an assetAWS certification(s) such as AWS Certified Database Specialty would be an asset. Thanks & regards, Jack **Apptoza Inc.** Phone: (678)-869-5418 Ext 5003

  • Oracle Database Administrator

    2 days ago

    Toronto, Canada Procom Full time

    Oracle Database Administrator On behalf of our client in the Banking Sector, PROCOM is looking for an Oracle Database Administrator. Oracle Database Administrator - Job DescriptionEnhanced performance due to Database Offload in ExadataReduced size of database without compromising performance by leveraging compression technologyProvided trustworthy data from...

  • Database Administrator

    3 days ago

    Toronto, Canada YouthCare Full time

    Most Important - At least 10 years of experience - Experience in database replication / Real-Time data delivery with either MSSQL or Oracle - products (5+ years)RequirementsGeneral Skills - Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL - Create, test and implement safeguards to maintain data integrity and protect...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Canadian Institute of Plumbing & Heating Full time

    The Canadian Institute of Plumbing & Heating is looking for a database administrator to complete a data clean up for our organization. - Excellent technical skills - Meticulous attention to detail - A logical approach to work - The ability to prioritize tasks - Problem solving skills - Good organizational skills - Previous work in the database "Your...

  • Database Administrator

    4 days ago

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

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...

  • Database Administrator

    5 days ago

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

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...

  • Database Administrator

    4 days ago

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

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...

  • SQL Database Administrator

    2 weeks ago

    Toronto, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...