Database Administrator

5 days ago

Toronto, Canada Sunwing Travel Group Full time

**Join us in making vacation dreams come true**
****

Are you searching for a fun, passionate, travel loving team? -Sunwing has the EPIC work culture you have been searching for. We are currently looking for a
**Database Administrator** to join us in making vacation dreams come true. As the Database Administrator, you are responsible for the installation, configuration, upgrade, administration, monitoring, maintenance, and security of the databases installed at Sunwing in MS Azure on IaaS and PaaS solutions. The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements as well as plan, coordinate and implement security measures to safeguard the databases. The position reports to the
**Manager, Database Services** and will be located in Toronto, ON.
_ _
- have your career _
- soar to new heights - _
- under ou_
- r_
- wing_

**W**
**ork Perks***:

- Remote and/or Hybrid Work Opportunities
- Great travel perks
- _ Goodlife_ Corporate Discount
- Comprehensive benefits package
- RRSP Matching Program
- Growth opportunities
- Free Parking
- Open concept, collaborative workspace
- Fresh Café with delicious snacks and meals at a subsidized price
- Opportunity to give back through our social responsibility initiatives

**What You’ll Do**:

- _ Investigate and resolve _d_atabase issues_
- _ Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security_
- _ Deploy database change scripts provided by third party vendors_
- _ Ensure that new database code meets company standards for readability, reliability, and performance_
- _ Maintain, implement and develop reports showing usage, metrics and consumption of dba resources and suggest ways to improve performance on each_
- _ Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc_._)_
- _ Document the company’s database environment as well as operational procedures and processes_
- _ _Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)_
- _ Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems_
- _ Assist in migration of SQL Server instances to Azure PaaS from Azure IaaS solutions_
- _ Upgrade MS SQL Server environment to the latest versions and patches_
- _ Provide after hours On Call Support as required as you will be the person the company would call if the SQL Server service stopped working_
- _ Conduct SQL Server lunch-and-learn sessions for developers_
- _ Design and write complex SQL Server scripts to automate database management tasks where possible_
- _ Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end, including after-hours and weekends_
- _ When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes_
- _ Assist developers with complex query tuning and schema refinement_

***
**What You’ll Need**:

- _ Degree in Computer Science, Computer Engineering, or five (5) years of equivalent experience in the Administration of Databases on premises and in Azure_
- _ 5 years or more experience in:_
- _ Tuning T-SQL queries to improve performance_
- _ MS SQL Server Installation and Configuration for Stand-Alone and clustered instances_
- _ Writing SSIS Packages _
- _Working with Windows Server (all versions) including Active Directory, Partitioning, Disk Configuration_
- _ Architecture, SQL Server Backup and Restore concepts and with SQL Server tools _
- _Good understanding of Data Modeling, RDBMS Concepts, Cloud Data Warehouse Concepts_
- _ Experience with and/or good understanding of Azure Analysis Services, Azure Data Factory, Azure Synapse Dedicated SQL Pool and Snowflake_
- _ Be an effective team player, with ability to be flexible and adaptable when dealing with change_
- _ Able to juggle multiple tasks, tight deadlines and changing priorities_
- _ Strong communication and relationship building skills_

**About Us**:
*

  • Database Administrator

    3 weeks ago

    Toronto, Canada Red Label Vacations Full time

    **Reports to**:Director, IT **Department**:IT **Location**:Hybrid**: - **Head Office, Toronto, ON/ Canada & work from home **Summary**: As DBA you'll be the first respondent to database problems that arise and carry out periodic maintenance and troubleshooting. To ensure success as a database administrator, you should be an excellent problem-solver and...

  • Database Administrator

    2 weeks ago

    Toronto, Canada Rang Healthcare Full time

    Job Title: Database Administrator Duration: 04 Month Contract Location: 125 Sir William Hearst, Toronto, ON M3M 0B5 (Position is 3 days onsite in a week) Must haves: Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database Experience with database development, e.g., stored procedure, PL/SQL,...

  • Database Administrator

    3 weeks 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

    1 week ago

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

  • Database Administrator

    2 months ago

    Toronto, Canada iPartner Staffing Full time

    Must haves: - Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x; UNIX OS (Operating System) and Linux OS, utilities, shell scripting - **Expert level knowledge of Oracle 12c/19c database administration**, maintenance, security implementation include:, upgrade and...

  • Database Administrator

    3 weeks ago

    Toronto, Canada iPartner Staffing Full time

    Role: Database Administrator - Senior Location: Toronto, ON Contract **Must-haves**: - More than 10 yrs Oracle DBA experience - Approved experience of Oracle 12c AND 19c using multi-tenant architecture - Oracle 12c and 19c RAC - Grid infrastructure/ASM - RMAN backup and Restore - Data Encryption using ASO/TDE - Oracle Dataguard Physical/Logical...

  • Database Administrator

    8 hours ago

    Toronto, Canada Raise Full time

    Database Administrator Location: Toronto, ON- Hybrid – (2-3 days in office)Contract Length: 6 Months with possibility of extension.We at Raise are hiring a Database Administrator for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand.We’re hiring right now; if you’re...

  • Database Administrator

    3 weeks 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, 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...

  • Database Administrator

    5 days ago

    Toronto, Canada Raise Full time

    Database Administrator (Financial Industry) Location: Toronto, ON- Hybrid – ( In office every Tuesday for the time being) Contract Length: 6 Months with possibility of extension. We at Raise are hiring a Database Administrator (Financial Industry) for one of our top clients. After establishing th

  • Database Administrator

    7 days ago

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

  • Database Administrator

    3 weeks ago

    Toronto, Canada Momentum Financial Services Group 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...

  • Database Administrator

    2 months ago

    Toronto, Canada Cloudvital Technologies Full time

    We are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...

  • Database Administrator

    1 week ago

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

  • Database Administrator

    7 days ago

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

  • Database Administrator

    5 days ago

    Toronto, Canada Raise Full time

    Database Administrator (Financial Industry)Location: Toronto, ON- Hybrid – ( In office every Tuesday for the time being)Contract Length: 6 Months with possibility of extension.We at Raise are hiring a Database Administrator (Financial Industry) for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their...

  • Database Administrator

    1 week ago

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

  • Database Administrator

    1 month ago

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

  • Database Administrator

    3 weeks ago

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

  • Database Administrator

    2 weeks 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...