Database Administrator

Job Description

The Division:

MAJIQ is the proven market leader for sales order processing and manufacturing execution systems software dedicated to the Pulp and Paper industry.

MAJIQ is part of over 100 companies within the Constellation Software Inc. family (csisoftware.com). We offer the benefit of working with a medium sized company while enjoying the support and opportunity of being part of a 2000 employee organization. Constellation Software is an international provider of market leading software and services to a number of industries across both the public and private sectors. Constellation acquires, manages and builds vertical market software businesses that provide mission-critical software solutions to address the specific needs of its customers in those industries.

The Position:

MAJIQ is seeking a database administrator to join our staff in the continued evolution of our ElixirTM application. You will work closely with senior Product Engineering managers and other MAJIQ developers in support of the development and deployment of our product.

Job Responsibilities:

• Perform application support, and Database (Microsoft SQL Server and Oracle) maintenance tasks.
• Develop procedures and scripts for continuous improvement, repeatable processes and database maintenance.
• Ensure consistency and completeness across customer systems.
• Research technical problems and assist in identifying solutions.
• Interact with application teams and client personnel on technical issues.
• Coordinate database changes with technical team, projects team and management,
• Provide expertise in SQL tuning, backup and recovery support, installation and configuration of Microsoft SQL Server & Oracle, patch installation, table and index partitioning, data archiving, database capacity planning, and complex security architectures.
• Write SSRS reports and Power BI solutions.
• Monitor and maintain database backups, optimization jobs, and integrity checks. Take corrective action as required.
• Perform database performance tuning, query optimization, reports, jobs and processes.
• Provide guidance and direction for new technology adoption.
• Assist in leading the technical direction for Database Administration by coordinating and presenting technology solutions to Group Leads, Team Leads, Managers, and the client.
• Participate in detailed design and product test execution as required.
• Identify and initiate process improvements.
• Identify and acquire industry technical and business knowledge.
• Other projects and duties as required.

Job Qualifications:

• Bachelors in Computer Science or Information Technology or equivalent work experience.
• 5+ years of experience providing database administration services in the Windows environment.
• Strong problem solving skills, including the ability to analyze complex problems and create well documented solutions.
• Experience with Microsoft -SQL Server.
• Proficient in T-SQL, PL/SQL and writing complex SQL.
• Experience with instance configuration and tuning and query tuning.
• Experience with database upgrades and patches.
• Experience with database backup and recovery procedures.
• Experience with writing PowerShell scripts.
• Experience with SSIS packages.

Additional Preferred Skills:

• Experience with Oracle 12c
• Azure SQL Database
• Exciting Benefits we offer:
• Market-leading Salary
• Medical Coverage Self & Dependents
• Parents Medical Coverage
• Provident Fund