Lead Database Administrator

**About the role**

The **Lead Database Administrator (DBA)** plays a pivotal role within our organization, responsible for managing and optimizing complex databases. As a lead DBA, you will provide expert-level support for database systems, collaborate with the architecture, development, and support teams to enforce standards, plan capacity, troubleshoot issues, and safeguard critical data. Your technical knowledge and leadership ensure the integrity, security, and performance of our critical data resources. Join our team and contribute to the stability and efficiency of our data infrastructure

**What you’ll be working on**
- As a lead DBA, you will provide **expert-level support** for **Microsoft SQL **and **Oracle **databases.
- Your responsibilities will include but not limited to **backups**, **recovery**, **software patching**, and **database builds/installation**.
- You will guide the design, tuning, and configuration of databases both for on prem and cloud (**AZURE, AWS, Oracle, and Google**) using “best practices.”
- Expert knowledge in SSIS catalog services and creating environments to perform seamless deployments between environments for SSIS packages.
- Expert in creating catalogs and SSIS environments and SSIS integration solutions using Visual Studio to deploy packages.
- Collaborate with architecture, security, and development teams to **establish and enforce** standards and best practices related to database management.
- Ensure adherence to security protocols and data integrity guidelines.
- Plan, monitor and manage the **capacity** of database systems.
- Optimize performance to accommodate growing data needs.
- **Identify and resolve** database issues promptly.
- Optimize query performance and system responsiveness.
- Maintain **detailed documentation** to ensure transparency and knowledge sharing.
- Document database configurations, procedures, and troubleshooting steps.
- Coordinate with server build teams and other stakeholders to **deliver reliable database solutions**.
- Work closely with architects, security, developers, and system administrators.
- Be prepared to manage **data recovery scenarios**.
- Define and implement robust **backup and recovery strategies**.
- Provide on-call rotation support for critical production systems, including after-hours maintenance and release deployment activities.

**We’re looking for someone with**
- **Education**: Bachelor’s or Master’s degree in Computer Science, Information Technology, or related fields.
- **Certifications**: Relevant certifications such as **Microsoft Certified: Azure Database Administrator Associate** or **MCSE: Data Management and Analytics** and **Oracle Certified Professional **are advantageous.
- **Experience**: 15 + **years** of experience as a DBA, with advanced knowledge of large-scale databases in a 24/7 environment.
- **Technical Skills**:

- Proficiency in database **Server administration**, including backups, restores, and performance tuning.
- Familiarity with **Windows Server**, **T-SQL**, and **PowerShell** scripting.
- Understanding of **high availability** and **disaster recovery** concepts.
- Experience in DTS package conversion to SSIS and fine-tuning SSIS packages.
- Experience in creating Visual Studio solutions for integration services to deploy projects to SSIS catalog databases.
- Proven experience in cloud technologies (**AZURE, AWS, Oracle, and Google**).

**Why join us**

Our approach to employee wellness is holistic, which is why alongside competitive salaries, and excellent health and dental benefits, corporate employees have access to:

- Medical coverage through the United Healthcare Choice Plus Plan
- Telemedicine and virtual medical visit coverage
- Prescription coverage through Express Scripts
- Two dental plan options with Delta Dental of MA
- Flexible Spending Accounts
- Company-paid life insurance and short-term disability benefits
- Supplemental life insurance
- Long-term disability

Future Electronics is taking a hybrid approach to work. We value collaboration and working together, which our offices facilitate, combined with working remotely.

Future Electronics is an equal opportunity employer.

YourFuture

**Benefits**:

- Company pension
- Dental care
- Disability insurance
- Discounted or free food
- Employee assistance program
- Extended health care
- Life insurance
- Paid time off
- RRSP match
- Wellness program
- Work from home

Schedule:

- Monday to Friday
- On call

**Experience**:

- Microsoft SQL Server: 10 years (required)

Licence/Certification:

- work permit in Canada (preferred)

Work Location: Hybrid remote in Pointe-Claire, QC H9R 5C7