Junior Database Administrator

First National is proud to be an equal opportunity employer and is committed to diversity and inclusion regardless of race, color, religion, national origin, age, gender identity, physical or mental disability, sexual orientation and any other category protected by law.

First National supports requests for accommodation from applicants with disabilities; please contact Human Resources at accessibility@firstnational.ca should you need an accommodation at any point in the recruitment process.

Reporting To: Manager, Infrastructure & Operations

Full-Time/Part-Time: Contract

Posting Date: November 1, 2024

Closing Date: November 15, 2024

Hours of Work: 8:30 a.m. – 5:00 p.m.

Grade: Office Location: 12.4 Toronto, ON

Great location! Steps away from the main public transit station

What we offer: Highly competitive compensation package which includes, base salary, bonus, benefits, and career advancement opportunities! *Eligibility for benefits is dependent on the terms of employment

The Opportunity:

The role of the database administrator is to be responsible for the performance, integrity, and security of core SQL databases. The successful applicant will be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. They will take ownership of multiple test, development and production environments and be responsible for the maintenance of these environments to ensure all databases and servers are performing optimally.

How you will contribute:

• Monitor, collect statistical information and provide reporting on capacity and system performance
• Based on statistics, make recommendations to maintain and improve capacity and system performance
• Create, Modify, and Run stored procedures
• Monitor the system, and act upon system and application automated alerts
• Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting the installation, configuration, or data problems)
• Plan and perform database configuration, maintenance, upgrade, and patching
• Perform and manage system and database backups
• Perform manual switch to redundant system/database components, in case of system failure
• Manage SQL replication
• Create and maintain maintenance plans, performance tuning, advise programmers on improving schemas
• Create and maintain documentation relating to all database procedures and actions
• Proactively monitor 24/7 mission critical servers

The experience you need:

• Command level experience with SQL Server 2016, 2019
• Experience with SQL Server 2016, 2019 Management Studio
• Configure and maintain databases on Azure platform (SQL MI, IaaS VM)
• SQL Server HA (high availability)
• SQL Transparent Database Encryption
• SQL Server Replication
• SQL Server Database Mirroring
• New database installations
• Database monitoring performance tuning
• Backups and recovery
• Server and database security
• Index management and optimization
• Experience in developing functions and stored procedures
• Strong written and oral communication skills.
• Strong technical documentation skills.
• Good interpersonal skills.
• Experienced in the Financial Industry
• Keen attention to detail.
• Proven analytical and problem-solving abilities.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Experience working in a team-oriented, collaborative environment.
• Knowledge of applicable data privacy practices and laws.

Education and Certification

• Completion of a College diploma or university degree in the field of computer science.
• 3+ Years of experience as a DBA

Working Environment and Physical Demands Analysis:

• Periods of high volume with tight timelines
• Long periods of stationary position/sitting
• Prolonged periods of repetitive movement (i.e. using a keyboard and mouse)
• Long periods of time in viewing a computer screen
• Multi-tasking may include speaking to customers on a telephone call while looking up information on a computer program.

Competitive Compensation

Comprehensive benefits program (i.e., Health Spending Account, Maternity and Parental Leave Top Up)

Hybrid working environment.

Extensive training programs to set our employees up for success

Modern office environment conducive to collaboration

Supportive teamwork culture

Opportunities to give back to the communities and work through events focused on a variety of charities

Ongoing social events throughout the year

The team you’ll join:

Founded in 1988, First National is one of Canada’s largest non-bank lenders. We provide residential mortgages exclusively through the mortgage broker channel and we are Canada’s largest commercial mortgage lender.

First National has been consistently recognized as a great place to work and we are proud that our employee engagement feedback is higher than our industry partners.

We would like to thank all applications for their interest in this existing vacancy, but only candidates selected for an interview will be contacted.