Systems Analyst-Database Administrator

POSITION SUMMARY: The Systems Analyst - Database Administrator (DBA) is a skilled and motivated member of the dynamic IT team. The DBA is responsible for building, configuring, and maintaining over 200 Microsoft SQL Server and Oracle database instances throughout our environment. Working closely with the System Administrator team, the DBA ensures seamless integration, optimal performance, and data security across systems.

WHAT YOU’LL DO:

Database Management

1. Implement and maintain Microsoft SQL Server and Oracle database systems.
2. Enforce database standards, guidelines, and best practices for optimal performance and security.
3. Monitor database performance, identify bottlenecks, and optimize queries and indexing strategies.
4. Perform capacity planning to ensure database systems can handle future growth.

Operations and Maintenance

1. Support database installations, upgrades, migrations, and patches.
2. Schedule and implement regular database backups, restore testing, and disaster recovery plans.
3. Maintain data integrity and ensure data availability across multiple environments.
4. Troubleshoot database-related issues and work collaboratively to resolve incidents promptly.

Collaboration and Integration

1. Work closely with the Senior Database Administrator and System Administrators team to ensure compatibility and integration of databases with server infrastructure.
2. Collaborate with application developers to design efficient database structures supporting business applications.
3. Provide guidance on database access, usage, and security for end-users and development teams.

Security and Compliance

1. Implement and manage database security policies, roles, and permissions.
2. Ensure compliance with company policies and regulations, including data protection and privacy standards.
3. Conduct periodic audits to assess database security and address vulnerabilities.

Documentation and Training

1. Create and maintain detailed documentation for database configurations, processes, and procedures.
2. Provide training and support to IT staff and end-users regarding database-related topics.

MUST-HAVES:

1. Bachelor’s degree or three (3) year college diploma in Computer Science, Information Technology, or a related field.
2. Two to four (2-4) years of experience in database administration, with expertise in Microsoft SQL Server and Oracle databases. Candidates with over four years’ experience will be considered for a Senior role.
3. Experience writing SQL queries, stored procedures, and database scripts.
4. Experience with database performance tuning and optimization.
5. Strong knowledge of database backup, recovery, and disaster recovery techniques.
6. Experience with Windows Server and Linux environments.
7. Solid understanding of database security principles and best practices.
8. Experience with high-availability solutions such as Always On Availability Groups, Oracle RAC, or Data Guard.
9. Knowledge of cloud-based database services (e.g., Azure SQL Database, Oracle Cloud).
10. Familiarity with automation tools and scripting (e.g., PowerShell, Python).
11. Experience with monitoring and performance tools like SQL Profiler, Oracle Enterprise Manager, or third-party solutions.
12. Strong problem-solving and analytical skills.
13. Excellent communication and teamwork abilities.
14. Attention to detail and a commitment to delivering high-quality solutions.
15. Ability to manage multiple priorities in a fast-paced environment.

OTHER CONDITIONS:

1. Minimal exposure to disagreeable conditions typical of an office position: exposed to stress and pressure associated with multiple priorities and deadlines.
2. Must be able to travel within the Southwestern Ontario area, when required.
3. Must be able to work evenings and weekends, when required.

ABOUT US:

TransForm Shared Service Organization, a non-profit, unique, innovative, results-driven organization founded by hospitals in the Erie St. Clair region. Our services include clinical and business system application support, integration and development, information system infrastructure, information privacy, security, IT break fix, project management as well as other back office support services. As a strategic solutions centre committed to exceptional service delivery, TransForm leads, innovates and supports health system transformation. If you are service oriented, dedicated to exceeding performance expectations and interested in reaching your full potential, TransForm is for you! We welcome and appreciate your interest in our organization. Want to know more about TransForm? Visit our website.

HOW TO APPLY:

1. Please email a copy of your cover letter and resume to HR@transformsso.ca.
2. Reference the job and where you found the job posting in the subject line of the email.

TransForm is committed to employment equity and welcomes diversity in the workplace. TransForm encourages applications from all qualified individuals including women, members of racialized communities, indigenous persons, immigrants & refugees, persons with disabilities, and persons of any sexual orientation, gender identity or gender expression. Upon request, accommodations for disabilities will be provided to support participation in all aspects of the recruitment process.

By applying to this position, you are confirming you possess a Canadian citizenship, permanent resident status or a valid work permit. We thank all applicants for their interest. Only those selected for an interview will be contacted. TransForm is currently not accepting applications or solicitation from recruitment agencies. Thank you for your cooperation.

STAY CONNECTED TO US:

Follow us on LinkedIn, Facebook, Indeed, and X for the latest job postings and news!