Perativ Looking for Database Administrator / SQL Developer at Toronto, ON Full Time

Company Name: Perativ General Partnership

Business Address: 4 – 191 Attwell Drive, Toronto, ON M9W 5Z2

Position Title: Database Administrator (DBA) / SQL Developer

Terms of Employment: Permanent, Full-Time

Language of Work: English

Hiring Wage: $70,000 – $85,000 annual salary, with eligibility for annual bonuses and raises based on performance.

Benefits: Upon completion of 3-month probation period, health and dental benefits, a $400 annual Health Spending Account, and Employee Assistance Program provided and paid for in full by the company.

Location of Work: Hybrid, combination of remote and at business address.

Contact Information: Jeff Shlanger, Director of Human Resources, [email protected]

Environment Summary:

At Perativ, we are helping our customers, which include some of Canada’s major banks, materially reduce their management cost, improve their customer experience, and make their operations more productive. If you are a creative and passionate Database Administrator (DBA) / SQL Developer, who is looking to learn and grow on a small agile team, this is a great opportunity to join us and together we will continue to build and expand our proprietary platform that is disrupting the space and becoming the standard for all banking cash supply chain management.

This opportunity will push you to challenge the status quo and stimulate growth in yourself and your career. We have long term employees because we adjust roles to fit career goals. Whether you are looking to expand your knowledge across IT and other departments, looking to move into management roll or become a master of your own domain. Check out this opportunity and how we can match up with your career goals.

Perativ is a leading financial technology SaaS platform that combines analytics, AI automation and ATM operations to deliver new thinking on cash distribution for financial institutions.

Position Overview:

The DBA / SQL Developer position is a unique opportunity for an individual with prior experience seeking new challenges and broad database development and administration responsibility. The successful candidate will be responsible for monitoring, maintenance, and operational support of our entire portfolio of databases. Maintain reliability, stability, and data integrity of the databases. Provide support in the administration, backup, integrity, and security of various SQL Server databases. Responsible for database tasks from software upgrades and custom interfaces, to troubleshooting. Continually assess, improve, and optimize our current database environment.

As a DBA / SQL Developer, you should be highly organized and detail-oriented with strong analytical and problem-solving skills, plus the ability to prioritize and execute tasks in a high-pressure environment. It is also important that you display excellent verbal and written communication and interpersonal skills as well as the ability to present ideas in user-friendly language.

Key Job Duties and Responsibilities:

The candidate will work with Senior Data Architect and IT teams to ensure that Microsoft SQL Server (MSSQL) database maintenance and development tasks are performed as described by Perativ’s SOC2 guidelines including, but not limited to the following:

• Manage and administer SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance.
• Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics.

• Design, develop, and maintain complex SQL database structures that enable data to be efficiently stored and retrieved.
• Create and optimise complex SQL queries for data analysis and reporting.

• Analyze existing SQL queries and suggest new ones for performance improvements.
• Participate in SQL Server Installation, upgrades, migrations, and configuration.
• Routinely refine and automate regular processes, track issues, and document changes.
• Troubleshoot system problems as they arise and ensure system problems are documented.
• Deployment of projects and solutions into production database resources.
• Maintain database documentation as required.
• Maintain and administer database security access.
• Perform database Ad-hoc backups and restores.
• Troubleshoot and resolve database connectivity issues.
• Proactively monitor and respond to database alerts.
• On-call requirements to ensure 24 x 7 support of database operations.

• Stay up to date with the latest trends and technologies in SQL development including data security procedures and data protection legislation.

Skill Requirements:

• Completed Post-Secondary education in Computer Science, Information Technology or related areas OR equivalent combination of education and experience.
• 4+ years of experience of MS SQL Server production support in a mission critical environment, enterprise level, MSSQL on Azure VMs.
• 4+ years experience in Transact SQL, DTS, SSIS package development.
• 4+ years of SQL Server database development / programming.
• Experience with analysis and tuning of T-SQL queries to improve performance.
• Familiarity with server troubleshooting in a Microsoft Azure environment.
• Ability to plan and problem solve in a fast paced, dynamic environment.
• Experience maintaining database security, integrity, and availability.
• Experience in implementing operational automation using scripts.

• Experience with backups, restores, and recovery models.

• Experience working with Windows server, including Active Directory and disk configurations.
• Knowledge of and proficiency with the following:
  • .NET development (Visual Basic, C#)
  • SQL Server on Azure VM
  • Azure SQL
  • Azure DevOps

Remote Work:

• This position offers a Hybrid work schedule. You will be required to be in the office a minimum of 2 days each week following a probationary period of 3 months where you will be required to be in the office 5 days a week, with the ability to work from home for the remaining workdays (subject to specific business needs requiring office attendance).
• When working from home, a reliable internet connection is required. Remote work is supported with cloud-based applications and collaboration tools (i.e., MS Teams)

To Apply:

You can learn more about our company by visiting our websites: www.access-cash.com and www.perativ.com.

To apply, please respond to this ad, including your resume.

Perativ is committed to providing equal employment opportunities to all qualified employees and applicants. We value diversity and inclusion and encourage all qualified people to apply. If we can make this easier through accommodation in the recruitment process, please make it clear within your cover letter. We will review applications as they are received and look forward to hearing from you.

We would like to thank you for your interest. Please note that all submissions will be assessed, however, only candidates selected for interview will be contacted.