We’re hiring

Database Administrator (DBA)
LOCATION: DOWNTOWN MONTREAL

ABOUT SEKURE

Sekure Merchant Solutions is committed to helping business owners save money by finding the lowest credit card processing rates for their business. Our excellent service and customer loyalty have made us a trusted name in the payment processing industry. With over 400 employees and two Montreal offices, Sekure is growing at a rapid pace.

At Sekure, we believe that employee satisfaction is the key to success, which is why we take pride in offering a highly engaged, collaborative and fun work environment. As one of Canada’s top-rated employers, Sekure is a great place to take your career to new heights!

JOB SUMMARY

Sekure Merchants is looking for a database administrator with business intelligence and data warehouse experience. Are you passionate about data? The position requires hands-on experience with MySQL Server 5.6 or above. Direct experience with on-call troubleshooting for database related issues are essential. Additionally, you need experience with the management and implementation of database upgrades and migrations.

RESPONSIBILITIES

• Oversee Development of New Databases
• Debug Database Issues on Live Data
• Proactively Tune Database in Production
• Monitor and maintain system health and security
• Design backup processes for server and associated data
• Create accounts for all users and assign security levels
• Establish a disaster recovery protocol
• Provide end-to-end technical support and problem resolution
• Participate in capacity planning for storage, servers and network components as needed to ensure performance and service level agreements
• Stay current with database technology advances to enable production support and incident resolution
• Collaborate with analysts, developers, and end users to communicate and enforce standards and guidelines for data access and security
• Document databases in support of system development life cycle compliance
• Own and manage the DB/DW ticket queue for the development team
• Develop, maintain/enhance the database structures and troubleshoot the data load scripts, jobs and packages (ETL)
• Provide tech support and mentoring to IT and business report developers
• Look for and act on continuous improvement opportunities

QUALIFICATIONS

• BA of Science in Computer Science or equivalent
• 5+ years as MySQL production DBA
• Detail oriented with the ability to work well independently and as a team player
• Strong critical thinking and analytical skills required

Experience

• Design, implementation, backup and recovery, monitoring and performance tuning
• Database structure and theory (advanced)
• MySQL and MSSQL
• Relational databases, backup and restore operations, replication, locking, mirroring, clustering, DB logins/permissions, stored procedures, schema, triggers, database maintenance activity
• Wait statistics, index maintenance, query performance tuning (query plans), long running queries, configuring meaningful SQL alerts
• Writing SQL and T-SQL scripts (advanced)
• Running health-check scripts and executing process improvements based on results
• System development lifecycle methodologies, deliverables, controls
• Database monitoring tools (Quest Spotlight)
• Design and implementation of high-availability database features, utilizing various replication and disaster recovery methodologies
• Implementing database schema changes in live production environment requiring minimal downtime and zero performance impact
• Defining and implementing database management tools across the platform to maximize performance and stability
• Managing the full life-cycle of database schema design and implementation (script management from development to production)
• Scaling up and out (sharding based on specific keys) databases for increased storage and computing capacity
• Reporting tools (Tableau an asset)
• Business intelligence (data warehouse development an asset)

PERKS

heart

• Free breakfast
• Company events
• Employee lounge
• Group insurance

dollar sign

• Competitive salary
• EMPLOYEE RECOGNITION
• STM discount
• Free cellphone

grow

• PROFESSIONAL TRAINING
• Ongoing coaching
• Career growth
• Job promotions

Sekure’s Diversity Commitment

Sekure Merchant Solutions is proud to be an equal opportunity employer.

We value diversity and inclusiveness and provide equal opportunities to all employees and applicants without regard to race, colour, religion, sex, national origin, age, marital status, sexual orientation, gender identity or expression, physical or mental disability, or any other basis protected by law. We aspire to leverage the unique qualities that each person brings to the company and are committed to ensuring equal access and participation to all who seek to build their career at Sekure.