Database Administrator

Database Administrator

30 Jun
|
Jonas Software
|
Halifax

30 Jun

Jonas Software

Halifax

Job Description:

Database Administrator



Jonas Software Solutions Inc.



Halifax



Jonas Software is a wholly-owned subsidiary of Constellation Software Inc. (“CSU” on the Toronto Stock Exchange) and employs over 3,000 team members working in 95 software companies worldwide. We are serial acquirers of vertical market software providers with a widely publicized buy-and-hold-forever strategy. Fiscal 2019 was a record-breaking year on the acquisition front, with 17 deals closed across North America, Europe, Australia, and New Zealand as we entered 6 new verticals.



To support our next phase of growth we are opening a new Research & Development operation, Jonas Software Solutions, in Halifax, Nova Scotia.





We are now looking to recruit our first wave of Developers, QA Analysts, Designers, DBAs, Product Owners, and other key individuals with all levels of experience to form an integral part of the Jonas business across North America.



Database Administrator



The Database Administrator will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our customer-facing applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills. We will look to you to create customer-focused solutions, and deliver optimized solutions for application performance. This role includes participating in an on-call rotation, as well as occasional after-hours support.



The successful candidate will be responsible for the ongoing maintenance and support of an existing on-premises Microsoft SQL Server Enterprise environment, including SQL replication services, storage management, patching, and general database maintenance. They will also lead the data migration to an AWS cloud-based database engine environment. They will have the opportunity to design the new database solution utilizing cloud-native AWS RDS database engines, as well as be a major contributor to our database warehouse and business intelligence (BI) projects. Must be capable of working independently and collaboratively.



Job Responsibilities:

Manage and maintain multiple Microsoft SQL Server databases in multiple product lifecycle environments, including Development, QA, On-Boarding, and Production.

Manage and maintain SQL Server database replication to multiple subscribers.

Tune and define maintenance jobs to ensure high levels of performance, stability, and availability, as well as conformance to documented best practices.

Ensure system integrity through the use of both native and third-party monitoring tools.

Maintain data integrity, security, and emergency recovery procedures.

Perform 2nd level database support for external end-users as well as internal technical teams.

Resolve moderately complex technical problems.

Independently analyze, solve, and correct issues in real-time.

Refine and automate regular processes, track issues, and document changes.

Perform scheduled maintenance and support release deployment activities after hours.

Monitor necessary system backups.

Participate in the On-call Support rotation.



Job Qualifications:

Bachelor-Level degree in a technical field (MIS, CS, Engineering, etc), or 4 years of additional experience.

3+ years of Microsoft SQL Server database administration experience in a mixed virtual and physical systems environment.

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

Experience with SQL Server database replication.

Experience with backups, restores, and recovery models.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

Advanced analytical and organizational skills.

Excellent communication and interpersonal skills.

Ability to multi-task and context-switch effectively between different activities and teams.

Must be flexible and willing to work rotating on-call shifts as assigned.

Must be available to provide scheduled services during the evening and overnight hours, as necessary.

Ability to travel 1-2 times a year to the US



Skills and Knowledge Preferred:

Experience with SQL Server Reporting Services (SSRS)

Experience with SQL Server Integration Services (SSIS)

Experience with SQL Server database replication

Experience with Postgres and AWS RDS Databases Engines

High Availability / Disaster Recovery / Availability Groups

Data Warehousing / Business Intelligence Experience

Understand Parquet data format, and data lake formation

Technical writing skills beneficial



We are part of the largest software company in Canada with a unique blend of local control and Big Company support and we are recruiting our first 30 team members in Nova Scotia. Whether you are an ambitious graduate looking to kick start your career or an industry high achiever searching for the next opportunity why not get in touch and find out more about our plans. We would love to hear your story, learn about your ambitions, and figure out if we could have a great future together.



Business Unit:

Scheduled Weekly Hours:

37.5



Worker Type:

Regular



More About Jonas Software:

Jonas Software is the leading provider of enterprise management software solutions to the Country and Golf Clubs, Foodservice, Construction, Fitness & Sports, Attractions, Salon & Spa, Education, Radiology/Laboratory Information Systems, and Product Licensing industries. Within these vertical markets, Jonas is made up of over 65 distinct brands, which are respected and leaders within their own domain.



Jonas’ vision is to be the branded global leader across the aforementioned vertical markets and to be recognized by customers and respective industry stakeholders as the trusted provider of ‘Software for Life’ and as an ambassador for technology, product innovation, quality, and customer service.



Jonas Software is the valued technology partner of over 60,000 customers worldwide in more than 30 countries. Jonas employs over 2,000 skilled individuals consisting of a cross-section of industry experts and technology professionals. Jonas is headquartered in Canada and also operates offices throughout North America, the United Kingdom, Europe, Australia New Zealand and Africa. Jonas is a 100% owned subsidiary of Constellation Software Inc., headquartered in Toronto and traded on the S&P;/TSX 60.