Database Administrator Developer
Position ID 2019-5785 Position Type Full Time Position Location(s) CA-AB-Calgary
DIFFERENT BY DESIGN
At MNP we pride ourselves on being different it’s our entrepreneurial drive that sets us apart. It’s the same drive that’s helped us become Canada’s fastest growing national firm.
We foster collaboration, value your ideas, promote based on talent, live balanced lifestyles and make time for FUN. We are one firm, one team, collaborating to support you wherever you want to take your career.
Join the momentum. We are currently seeking a Database Administrator / Developer to join our growing Technology team. MNP is a leading national accounting, tax and business consulting firm in Canada.
Driving innovation throughout the firm, our Technology team provides industry-leading solutions that enable MNP to better serve our clients and people.
We deliver on the strategic needs of service lines, industry and specialty groups, and operations at all levels throughout the firm.
Our specialists develop, enable and support initiatives that allow MNP to deliver client service, collaborate, communicate and operate reliably and efficiently.
RESPONSIBILITIES AND QUALIFICATIONS
Install, monitor, maintain and performance tune databases, ensuring a high level of data availability
Perform backup and recovery, connectivity and security, software installation, configuration, patching and upgrades
Security and architecture design for on premise and cloud SQL instances
Database design and data modelling
Write complex stored procedures, triggers and scripts
Data warehouse design (e.g. dimensional modeling) and data mining
Supporting database management systems, online analytical processing cubes (OLAP) and ETL (Extract, transform, load) frameworks
Performance monitoring and tuning
Translation of business needs to data requirements,
Establish disaster recovery protocol
Provide ongoing database support for development team as required
Develop a thorough understanding of MNP’s services, businesses and industry
Completion of a University Degree in Computer Science or related field
Three (3) or more years professional experience in database development
Experience with the administration of a multi-server Microsoft SQL Server environment
Experience with database design and data modelling
Experience writing and evaluating complex queries
Experience with database performance tuning
Experience troubleshooting database problems in both production and non-production environments
Experience with ETL & Data Migration using SSIS
Experience with clustering and Always On availability groups
Familiar within a Windows Server environment
Experience with Azure SQL would be an asset
Experience with SSRS would be an asset
Core Competencies and Personal Characteristics
Integrity professional whose honesty, integrity, confidentiality and high ethical standards contributes to effective leadership and optimal business relationships
Energy displays enthusiasm, optimism, drive and passion while maintaining a high level of productivity and a balanced lifestyle
Diversity understands the importance of different backgrounds, perspectives and experiences and is respectful of individual differences
Communication effectively expresses ideas and conveys information in business writing, conversations and interactions with others
Client Service Excellence understands the importance of quality client service by being courteous, responding to client requests in a timely manner and monitoring satisfaction
Teamwork & Relationship Development works collaboratively with team members in order to achieve a common goal and develops, maintains and strengthens relationships with others, both inside and outside the Firm
Accountability takes responsibility for one’s own performance by setting clear goals and tracking progress against those goals;
is highly organized and uses personal judgement and decision making
Flexibility effectively manages multiple assignments, adapts to changing priorities and is able to work independently or as part of a team
MNP encourages a balanced lifestyle and offers benefits that suit the way our team members work and play! In addition to a competitive salary, our MyRewards MNP package includes paid personal days, wellness program initiatives, health and dental benefits, a group pension plan with matching contribution, firm sponsored social events, and professional development assistance.
MNP proudly serves and responds to the needs of our clients in the public, private and not-for-profit sectors. Through partner-
led engagements, we provide a collaborative, cost-effective approach to doing business, with innovative strategies to help organizations succeed across the country and around the world.