Senior Database Administrator

Pivotree - Kanata, ON (30+ days ago)

Apply Now

Role: Senior Database Administrator

Reporting to: Database Administration Manager

Pivotree architects, builds, hosts and manages a wide range of commerce experiences for well-known domestic and global brands. Customers turn to Pivotree as their trusted partner when they want to grow revenue, increase online and in-store traffic, improve customer experience, grow a loyal customer base, achieve operational efficiencies, and higher profits.

Pivotree is a privately-held and venture backed company with an aggressive growth objective including strategic acquisitions. 2018 was a transformational year for Pivotree with the combination of three existing businesses in this sector: Tenzing, ThinkWrap and Spark:Red. Our combined team is made up of a diverse blend of engineers, solution architects, programmers, UI developers, project managers and analysts who work together to create and manage next-generation commerce excellence. We hold ourselves to the very highest standards and our employees take great pride in our accomplishments.

Position Summary:
Pivotree’s IT team is searching for an accomplished Senior Database Administrator (DBA) who is highly motivated, collaborative with an entrepreneurial spirit. You will be a key member of our database team, providing input on technical decisions that will shape the company's future and most importantly, the service satisfaction of our customers. You will administer various aspects of our database administration services involving on-premise and new cloud platforms. You will join a skilled and motivated operational organization helping to build the future mode of data services for Pivotree. Remote work-from-home is available.

Roles & Responsibilities:
Maintain, monitor and support various databases across all environments
Advanced in-depth knowledge of Oracle, SQL Server, MySQL databases
Perform database backup/recovery procedures and disaster recovery planning
Provide typical DBA functional capabilities such as data import/export or similar data migration routines
Lead the installation, upgrading and patching of Relational Database Management System (RDBMS) systems
Capacity planning for all database environments through monitoring, tuning and optimization
Interact with application and system architects and subject matter experts to design the corresponding physical database structure with best practices to ensure standard control procedures are followed
Participate in overall delivery & support process across multiple initiatives to ensure sustainable DBA practice which includes automation, process documentation, production support, optimization & monitoring
Provide input of developing database standards and procedures
Establish research for evaluating alternate database products
Assist in the implementation/upgrades/enhancements and testing of technology solutions
Work with development teams in troubleshooting and stabilizing database production issues
Ensure consistent database back-up/recovery; perform root-cause analysis and resolution;
Maintain data integrity and environmental security to improve information privacy, data protection, and compliance with regulations, audits, and business requirements
Develop and evolve standard documentation or runbooks for system configuration support
Rotational on-call 24/7 support for database including after-hours and weekends

Minimum seven (7) years solid database administration experience with substantial RDBMS implementations supporting Oracle, SQL Server and MySQL
7+ years solid experience with UNIX, LINUX, Windows Operating systems on physical servers and virtual environments
In-depth knowledge of typical database installation, setup, configuration and maintenance
Familiarity with Oracle RAC, Data guard, and/or Goldengate
Demonstrated focus on proactive database performance issues that includes indexing, security controls, patching cycles, capacity planning, backup strategy and various system configuration improvements
Advanced tuning experience using such tools as Automatic Workload Repository (AWR), Statspack, Quest Spotlight/Toad, or others
Demonstrated experience of resiliency practices in multi-cluster or high-availability environments in large database installations
Excellent communication skills, critical thinking, problem solving and sound judgment
Ability to work in a fast-paced and demanding environment; multitask and prioritize
Must be a team player with strong attention to detail and able to work independently
Working knowledge of Scrum/Lean and Agile, Scrum practices is desired
DBA certifications in Oracle, SQL Server, MySQL or AWS RDS is an asset
University/College Degree in Computer Science, Engineering, Mathematics, or IT is an asset

A professionally adaptable attitude
A positive, people-oriented and energetic attitude
An analytical, creative, and innovative approaches to solving problems
An interest in working hard/being challenged in a fast-paced environment, and having fun while doing it