Database Administrator - Halifax, Canada - Track Group, Inc

Description

Track Group is a global leader in providing end-to-end location monitoring and complimentary app-driven solutions that combine real-time tracking devices and professional monitoring services with advanced data analytics.

The current focus is delivering electronic monitoring products and services for the global criminal justice market.


Position Summary:

The Database Administrator is a key member of the Network Operations team and is responsible for MS-SQL Server installation, configuration, disaster recovery, performance analysis and tuning, index maintenance and monitoring of data.

Performs database and software life-cycle activities to ensure the highest level of system performance and availability and compliance with business requirements.

This is a "hands-on" position requiring solid technical skills as well as excellent interpersonal and communication skills.

In this role, the Database Administrator will interface directly with internal teams and customers as well as external vendors as needed and provide day-to-day operational and technical support for databases across the enterprise.

Participate in technical research and development to enable continuing innovation within the Track Group technology team. The Database Administrator reports to the Network Operations Manager.


Essential Duties and Responsibilities:

• Manage MS-SQL Server databases across multiple environments, from development to missioncritical production systems.
• Ensure uptime for mission critical systems and participate in rotating oncall coverage.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Refine and automate complex processes using SQL Agent jobs, SQL Server Integration Services, etc.
• Independently analyze, solve, and correct issues in real time.
• Develop and maintain complex SQL code and ETL processes that include process logging, data validation and integrity checks.
• Assist software developers with complex query tuning and schema refinement, participate in SQL code reviews.
• Perform scheduled maintenance and support release deployment activities after hours.
• Effectively document and communicate database changes/issues/risks to the appropriate Track Group stakeholders, partners, and vendors.
• Respond to, troubleshoot and resolve/escalate issues in a timely and accurate manner.

Requirements:


Education, Skills, and Experience:

• Bachelor's degree in a related field. In some cases, substantial, relevant experience may be substituted for this qualification.
• 5+ years of Microsoft SQL Server Administration experience required.
• Advanced level SQL development and tuning skills (T-SQL and SSIS).
• Experience with performance tuning and optimization, using native monitoring and troubleshooting tools.
• Experience with backups, restores and recovery models.
• Experience with Microsoft Reporting Services (SSRS).
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS-SQL Server.
• Advanced analytical and troubleshooting skills with ability to review trends/patterns and identify issues.
• Impeccable attention to detail.
• Ability to multitask and contextswitch between different activities.
• Strong interpersonal and communication skills. Must be able to integrate and communicate clearly and easily with other team members, as well as endusers at all levels.
• Experience with Azure SQL and related Azure database services is preferred.
• Familiarity with Red-Gate tools is a plus.
• Demonstrated ability to learn new technologies.

Benefits
- _Generous amounts of time away from work_ to promote a healthy work-life balance. We offer three weeks of _paid vacation days _in addition to observing all _major holidays per year. _Additionally all employees are entitled to _five sick days _per calendar to use at their discretion.

• Access to Life, Long Term Disability, Health, Dental and Vision insurances with a _company contribution_ for you and any covered dependents.
• Opportunities for growth along our clearly defined Career Path, including mentorship and leadership development programs to help you _achieve all of your professional goals._