Support Database Administrator

About Niche

Niche Technology develops and supports an advanced police Records Management System (RMS). Our current offering, NicheRMS, covers the full breadth of police operations as standard, out-of-the-box functionality. NicheRMS is in live production use in Canada, the US, the United Kingdom, Europe and Australia with well over 150,000 users. This is our sole focus and line of business.

Niche Technology Inc. is a privately-owned Canadian corporation, established in 1992, that is owned and managed by its founders. Niche has subsidiaries in the UK and the US.

Our Winnipeg headquarters is hiring a Support DBA, with a focus on Microsoft SQL Server. This position works as a member of the NicheRMS technical team, a stable, talented and highly experienced group with nearly zero staff turnover.

**Responsibilities**:

- Support customer-side DBAs and their implementation partners in the use of SQL Server at all stages of their NicheRMS projects.
- Maintain current knowledge of contemporary SQL Server features and best practices and examine unexploited or new features that may enhance future versions of NicheRMS.
- Work with NicheRMS developers and customer resources to design and execute experiments relating to SQL Server performance, reliability, and other behavior, and collaborate with those resources to interpret the data and identify beneficial actions based on that analysis.
- With the NicheRMS development team, develop and maintain hosting blueprints, best practices, sizing recommendations, monitoring guidelines, and installation/configuration documentation.
- Administer on-premises and cloud dev/test infrastructure (servers, VMs, storage, etc.).
- Install, administer, and use in-house test NicheRMS deployments to better understand the platform’s use of SQL Server.
- Assist in the hiring and management of additional Support DBAs.
- Participate in the ongoing design, implementation, and management of NicheRMS SaaS and other Niche-managed deployments of NicheRMS, including hiring additional staff for that work.
- Take part in a 24/7 critical support rotation.
- Support the Niche sales team during procurement exercises with prospective customers.

Skills/Experience
- Basic SQL Server administration, including installation, patching, monitoring, index maintenance, script execution, backup, etc., in a multi-instance environment supporting multiple large databases
- BC/HA/DR solutions, including but not limited to AlwaysOn Availability Groups, active/passive clustering, and transaction log shipping
- Transactional replication
- Performance monitoring, analysis, and tuning
- Database integrity testing and repair
- Full-text search
- T-SQL scripting/programming
- Basic Windows administration, including Active Directory, file services/permissions, PowerShell, and basic TCP/IP networking
- Design, assessment, purchase, and implementation of enterprise hosting infrastructure (on-premises and cloud)
- Software development using C#
- NicheRMS system/database administration

The position requires at least 5 years of applied experience.

Company Benefits
- Modern office building with large windows, lots of natural light and 4th floor outdoor patio.
- Catered lunches on Fridays in lunchroom with espresso machine, free pop, and gaming consoles.
- Standing desks, Herman Miller chairs.
- Full on-site gym.
- Parking or transit pass provided.
- Excellent benefits package including a personal health spending account.
- Generous compensation package.

**Security Clearance**

Additional pay:

- Bonus pay

**Benefits**:

- Casual dress
- Company events
- Dental care
- Disability insurance
- Discounted or free food
- Employee assistance program
- Extended health care
- Flexible schedule
- On-site gym
- On-site parking
- Paid time off
- Wellness program

Flexible language requirement:

- French not required

Schedule:

- Monday to Friday

Ability to commute/relocate:

- Winnipeg, MB R3A 1P6: reliably commute or plan to relocate before starting work (preferred)

**Experience**:

- Microsoft SQL Server: 5 years (preferred)

**Location**:

- Winnipeg, MB R3A 1P6 (preferred)

Work Location: Hybrid remote in Winnipeg, MB R3A 1P6