Database Administrator

Boardwalk provides Canadians with a quality, comfortable, home living experience. We offer rental apartments and townhouses that come in a wide breadth of shapes, sizes and sets of amenities. We operate 33,000 units across Alberta, British Columbia, Ontario, Saskatchewan, and Quebec.

Boardwalk recognizes our Associates as our most valuable asset. We are proud to provide competitive wages, profit-sharing, and amazing benefits like flexible group medical and dental, fitness reimbursement, training and development, group RRSP matching, rental discounts, and more.

**Location**: Calgary, AB (Hybrid work arrangement)

**Responsibilities**:

- Design, installation, configuration and maintenance of development, testing, staging, reporting and production database servers
- Database development, including tables, keys, indexes, constraints, queries, views, stored procedures, triggers, user defined functions
- Monitoring database server CPU usage, memory usage, disk space, deadlocks, blocking, error logs and scheduled jobs
- Database performance monitoring and performance tuning
- Manage server, database, and object security
- Create maintenance plan to backup database, check database integrity, reorganize index, rebuild index, and update statistics
- Design, implement and maintain SQL Server Replication
- Create and maintain SQL Server Agent jobs, Alerts and Operators
- Create and maintain database diagrams and data dictionaries
- Database analysis, modeling, logical design, and physical design
- Code review database changes made by software developers
- Experience creating and maintaining SSRS reports and SSIS packages
- Windows Server installation, administration, and security hardening
- Expertise in utilizing Agile Development Practices

**Experience and Educational Requirements**:

- Degree or Diploma in Computer Science or equivalent
- 2+ years Demonstrated DBA experience within a large complex environment
- 2+ years Demonstrated experience with SQL Server in a database administrator role
- Experience with windows server administration

**Technical Requirements**:

- T-SQL
- SQL Server 2014, 2016, 2019, 2022
- SQL Server Integration, Reporting Services and Analysis Services
- Windows Server 2016+

**Non-Technical Requirements**:

- Quickly learns and applies new technical skills
- Excellent oral and written communication skills
- Able to work effectively with mínimal supervision
- Excellent problem solver
- Goal oriented, highly self-motivated

Interested applicants are invited to submit a cover letter and resume.
- _____________________________
Ready to shape the future of our communities? Come work with us and learn where doing what you love means never working a day in your life

Deeply rooted in family spirit and humility, Boardwalk’s five core values of integrity, associates, teamwork, customer service and social responsibility are more than just words - they are a way of life. Coupled with our Golden Foundation of ‘treat others as you would like to be treated,’ ‘be good,’ ‘love community’ and ‘have fun,’ we believe in happiness and creating the most memorable experiences for both our Associates and Resident Members, continually looking for new and innovative ways to enhance and strengthen all our Boardwalk communities.

We hope these values speak to you as they speak so meaningfully to us

As we continue to grow, we remain unwavering in our commitment to providing Resident Members with the best quality rental communities. This same commitment means Boardwalk is always seeking individuals who have a positive attitude, are energetic and passionate, self-driven, productive, have the capacity to deliver high-quality results and who believe in the power of teamwork.

Together, with you as part of our team, we will continue to create meaning every day for those who choose to call Boardwalk home.
- _____________________________
Diversity, Equity and Inclusion Commitment Statement

We are committed to attracting and retaining a diverse team that will honour and celebrate your experiences, perspectives and unique identity regardless of age, ethnicity, race, colour, abilities, religion, socio-economic status, culture, gender, sexual orientation, gender identity and gender expression.

Together, our communities strive to create and maintain working and learning environments that are inclusive, equitable and welcoming.

We believe every Associate in our team enriches our diversity by exposing us to a broad range of values, customs and experience to better understand and engage with the world around us, identify challenges, so as to discover, design and deliver solutions together.