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.
We are hiring a Junior Database Administrator, Infrastructure & Operations, IT
**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**: 12.4
**Office Location**: 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
- 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**:

- SQL Server 2016, 2019 database administration tasks
- 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.
- Strong customer service orientation.
- 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**:

- Office environment
- 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.

Why join First National?
- 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.
FNLOON