Senior Database Administrator

Senior Database Administrator / Developer (Full-Time, Permanent)

Location: This is a hybrid position (4 days per week in office from 1 of our office locations below and 1 day remote).

Office Locations:

1. Brampton location @ 1 Presidents Choice Cir, Brampton, ON L6Y 5S5 (near Mississauga Rd and hwy. 407)
2. Burlington location @ 3215 North Service Road, Burlington, ON, L7N 3G2 (near hwy. 403 QEW and Guelph Line)

**Starting April 2025, Burlington location will be shutdown.

Summary: Lifemark Health Group is seeking an enthusiastic Senior Database Administrator / Developer to join our dynamic Application Development Team in a permanent full-time position. This position reports to the Development Manager, Application Services. You will be managing, maintaining, securing, and coding the company's databases. You will be responsible for making tested changes to make our databases highly available and highly performant.

About You: You are an individual with technical skills and acumen who is willing and able to contribute at a senior level. You are a database geek with many years of professional work experience and know how to code T-SQL as well as troubleshoot long running queries and other database performance tweaks. You enjoy and thrive while working with Microsoft SQL Databases in a VM as well as in the Azure PaaS (Platform as a Service).

Your Responsibilities:

1. Database Administration and Maintenance:
   • Design, implement, and maintain database systems for applications developed using C# and .NET Core.
   • Ensure high availability and disaster recovery solutions are in place for critical databases.
   • Perform regular database maintenance tasks such as backups, indexing, and performance tuning.
   • Monitor database performance and make necessary adjustments to optimize performance.
2. Azure Cloud Management:
   • Manage and optimize databases hosted on Azure SQL Database, Azure SQL Managed Instance, and other Azure data services.
   • Implement and maintain database security, including encryption, access controls, and compliance with data protection regulations.
   • Utilize Azure services like Azure Data Factory, Azure Blob Storage, and Azure Monitor for data integration, storage, and monitoring.
   • Plan and execute database migrations to Azure, ensuring minimal downtime and data integrity.
3. Support and Troubleshooting:
   • Provide advanced troubleshooting support for database-related issues, working closely with application developers and IT teams.
   • Resolve complex incidents and problems related to database performance, availability, and integrity.
   • Analyze and resolve database issues in a timely manner, ensuring minimal impact on application performance and availability.
4. Development Collaboration:
   • Collaborate with development teams to design and optimize database schemas, queries, and stored procedures.
   • Review and optimize SQL queries and database code written by application developers.
   • Provide guidance on best practices for database design, indexing strategies, and query optimization.
5. Automation and Scripting:
   • Develop and maintain automation scripts for database management tasks using PowerShell, Azure CLI, or other scripting languages.
   • Implement automated monitoring and alerting systems to proactively identify and resolve database issues.
6. Capacity Planning and Scaling:
   • Monitor database capacity and plan for future growth, ensuring the database infrastructure can scale to meet application demands.
   • Implement and manage database partitioning, sharding, and other scaling techniques as needed.
7. Documentation and Reporting:
   • Maintain comprehensive documentation of database configurations, procedures, and policies.
   • Generate and analyze reports on database performance, usage, and capacity planning.
8. Compliance and Security:
   • Ensure databases comply with industry standards and regulatory requirements (e.g., GDPR, HIPAA).
   • Perform regular security audits and vulnerability assessments on database systems.
   • Implement and enforce data encryption, data masking, and other security measures.
9. Research and Innovation:
   • Stay up to date with the latest database technologies and best practices.
   • Evaluate and recommend new tools, technologies, and methodologies to improve database performance, security, and manageability.

Required Skills and Qualifications:

1. Bachelor's degree in computer science, Information Technology, or a related field.
2. Extensive experience as a DBA, with a focus on supporting C# and .NET Core applications.
3. Strong expertise in Microsoft SQL Server, Azure SQL Database, and other Azure data services.
4. Proficiency in T-SQL, query optimization, and database performance tuning.
5. Experience with Azure cloud services, including Azure Data Factory, Azure Blob Storage, and Azure Monitor.
6. Strong understanding of database security, compliance, and disaster recovery.
7. Excellent problem-solving and troubleshooting skills.
8. Strong communication and collaboration skills, with the ability to work effectively with development teams and other stakeholders.
9. Experience with automation and scripting using PowerShell, Azure CLI, or other tools.
10. Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Azure Solutions Architect Expert are a plus.

Our Perks: You will be issued a company developer laptop, headset and a home office monitor, keyboard, and mouse. You will have the chance to work on full stack projects and learn from our intelligent team of seasoned developers and consultants. After your successful probation period, you will:

1. Have access to a yearly education re-imbursement fund.
2. Receive 30% discount from Shopper Drug Mart purchases.
3. Contribute to an Employee Stock Ownership Plan (ESOP) with employer matching percentage.
4. Have paid vacation days as well as wellness days.
5. Have a choice to enroll in our Health & Dental Flex Life Benefits (or in lieu contribute to your RRSPs).
6. Access to employee assistance program.

Who We Are: Lifemark Health Group is a market leader in customized healthcare solutions. As one of the largest and most comprehensive providers in Canada, we continue to grow exponentially. With that growth, is a vision to be the most innovative healthcare providers in community rehabilitation, workplace health and wellness and medical assessment services. Lifemark was acquired by Loblaw Companies on May 10, 2022, you can read more about the acquisition here.

Lifemark welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. Lifemark promotes equal employment opportunities for all job applicants, including those self-identifying as a member of the following groups: Indigenous peoples, Newcomers to Canada, and Visible minorities.

Please take some time to visit our corporate site at www.lifemarkhealthgroup.ca.