Panago Pizza

Senior Database Administrator

Database Administrator in Vancouver, BC , New Westminster, BC , Abbotsford, BC

Posted 2019-10-15
Description

Job Description

Our Senior Database Administrator develops and maintains the database related designs, procedures and standards, and operating production and non-production environments. As a member of a project team, the incumbent participates and supports systems per software development lifecycle (SDLC) processes and procedures, guidelines, and best industry practices. Primarily involved with technical teams, staff, faculty, and student communities, the Senior Database Administrator also provides technical support, assistance, coaching and mentoring to these stakeholders. Incumbent may also be asked to perform other duties as required.

Desirable Expertise and Experience

• Excellent communication skills, verbally and written, in English
• Excel at explaining and demonstrating complex business and technical concepts to all audiences
• Ability to liaise with technical groups and assist them in the definition and articulation of their requirements
• Ability to “think outside the box”, re-evaluate, and database management practices
• Provide advice and support to users on the use and operation of application systems
• Organize and manage time to meet deadlines
• Effectively contribute to the overall improvement of department services and operations, team spirit, and morale
• Work both independently and as a member of a committee or team.
• Work harmoniously with others
• Aptitude to learn new methodologies, tools and technologies for requirement analysis and development
• Exhibit a high level of work ethics and professionalism within a business environment
• Perform duties to meet established policies, practices and standards
• NoSQL database sizing, provisioning and maintenance including AWS EC2 and serverless based. Specific experience with MongoDB, DynamoDB and Couchbase
• NoSQL data modeling and optimization including key-value and document databases
• Analytics and reporting tools such as Power BI and Tableau, including integration with RDBMS and NoSQL databases
• Development of ETL processes including between RDBMS and NoSQL
• Design, provisioning and maintenance of search engines such as Solr and Elastic Search
• SQL and SQL optimization; N1QL and DAX
• AWS cloud environment
• Analytical skills and experience with data analysis tools e.g. R, Python

Qualifications
• Bachelor’s Degree in computing science required from a recognized institution
• Additional and current Database Administration training or certifications
• Minimum 6 years of recent related experience in database development and administration
• Minimum of 3 years’ experience as the primary database administrator responsible for maintaining a large enterprise resource program
• An equivalent combination of education and experience may be considered.
• Comprehensive knowledge of database administration and design standards, practices and tools with Oracle, Microsoft SQL and MySQL environments
• Expert in writing SQL including complex JOINs, indexing and optimization
• Expert in database modeling and ER diagrams, covering conceptual, logical and physical designs
• Expert in performance profiling, tuning and query optimization using monitoring/troubleshooting tools
• Comprehensive knowledge of Operating systems including scripting in both Unix-based and Windows environments
• Candidates from medium to large organizations are preferred

Benefits

• Competitive salary
• Company that has sustainability as one of its core values
• Learning opportunities and innovative spirit
• Support for work-life balance including flexible schedule
• New, spacious and attractive office space conveniently located next to the New Westminster Sky Train station
• Pizza lunches every 2nd Friday as well as monthly personal pizza allowance!

Does this sound like you?
If so, we would really like to hear from you!
Please send your resume to it.careers@panago.com

Ready to be seen?

Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.

Company summary

Panago Pizza Inc. is an innovative and customer-focused delivery/takeout pizza franchise with 200 stores across Canada. Our goal is to provide remarkable customer experiences, offering a diverse menu of affordable meals using the highest quality ingredients.

Our mission
To compete aggressively in the national marketplace.

Our core values
• Respect – treating everyone with respect and fairness
• Balance – family and work
• Dedication – to world-class systems and standards
• Performance – personal and corporate performance is a priority
• Fun – this is the pizza business; we have fun and enjoy our work

Perks

· Competitive salary
· Company that has sustainability as one of its core values
· Learning opportunities and innovative spirit
· Support for work-life balance including flexible schedule
· New, spacious and attractive office space conveniently located next to the New Westminster Sky Train station
· Pizza lunches every 2nd Friday as well as monthly personal pizza allowance!

Tech Stack

• NoSQL database sizing, AWS EC2, MongoDB, DynamoDB and Couchbase
• Analytics and reporting tools such as Power BI and Tableau, including integration with RDBMS and NoSQL databases
• Search engines such as Solr and Elastic Search
• SQL and SQL optimization; N1QL and DAX
• AWS cloud environment
• Data analysis tools such as R, Python

Interview process

Our process takes 2-3 weeks
• Telephone screening - 15 minutes
• Telephone interview - 30 minutes
• Assignment provided - Email assignment
• Face-to-face interview - 1 hour
• Conducting reference checks
• Send offer

Be seen in a new Database Administrator job

Skip the search

Zero stress and one profile that can connect you directly to 1000s of companies.

Best-fit jobs—for you

We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.

Free Career Coaching

Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.

You get tech. We get you.

Join now and be seen.