SQL DBA (with SSIS, SSAS, SSRS, and Fivetran)

Job title:

SQL DBA (with SSIS, SSAS, SSRS, and Fivetran)

Company

Adastra Corporation

Job description

Overview:Are you a skilled SQL Database Administrator (DBA) eager to take on new challenges? Adastra is looking for a dedicated professional to join our team and to play a pivotal role in designing, configuring, and managing database solutions. In this role, you will ensure data integrity, security, and accessibility, driving operational excellence and supporting our organization’s success.Location: Within GTAStatus: ContractResponsibilities:

• Build and maintain database systems of high availability and quality, depending on users’ requirements
• Define standards for physical data storage, maintenance, access, and security administration
• Use high-speed transaction recovery techniques and back up databases
• Diagnose, troubleshoot, and resolve data issues
• Analyze database access patterns, data model problems, and other bottlenecks
• Configure database parameters and define data repository requirements, data dictionaries, and warehousing needs
• Develop data models for all production schemas
• Protect the safety and integrity of the database platform through database design changes, backups, and securing of database instances
• Responsible for database operations such as data retention, health reports, and backup management
• Proactively develop scripts and tools
• Design, architect, implement, and support the data platform, including testing, improving, and maintaining new and existing databases

Qualifications, Skills & Experience:

• Excellent knowledge of MS SQL, MySQL, and SQL data backup, recovery, and security
• Proven experience working as a Database Administrator
• Deep understanding of the SQL Server architecture
• Strong experience with Fivetran
• Experience with SSIS, SSAS, SSRS
• Knowledge of VSTS (Azure DevOps)
• Strong analytical and problem-solving abilities
• Good scripting experience
• Troubleshooting experience, including knowledge of backups, restores, and recovery models
• Experience in database performance monitoring and performance bottleneck remediation

About AdastraFor more than 20 years, Adastra Corporation has been hyper-focused on data and the infrastructures to support it. We are an international consulting company working with businesses and IT Leaders to extract value through data and analytic solutions in the domains of Cloud, Data Management, Analytics, AI and ML, Governance, Hyper Automation, and Enterprise Application Development. Our team of experts, combined with our worldclass data management platform, helps provide trusted insights, establish frameworks, enforce best practices, and streamline processes for around-the-clock global coverage. Adastra has a proven track record of helping organizations of all sizes – from SMEs to Fortune 1000s – achieve their data transformation goals, whether that be accelerating innovation, improving operational excellence, or creating unforgettable customer experiences.What We Offer

• Opportunity for advancement and career progression
• Competitive compensation package
• Comprehensive benefits plan
• Successful referral program
• Satisfaction of working for a reputable company
• A flexible, dynamic, and diverse workplace

Equal Opportunity EmployerIn our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labour force participation and equal access to opportunities based on merit and performance.There has been an increased instance of fraudulent job offers coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from ‘@adastragrp.com’ or ‘@talent.icims.com’ are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign, it is fraudulent.Contact careers@adastragrp.com to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.

Expected salary

Location

Markham, ON

Job date

Wed, 22 Jan 2025 23:04:32 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnearcanada.com) you saw this job posting.