Senior Database Administrator

Upgrade, Inc.; Canada; On-site; CAD 100,000 - 130,000; Full time

Job summary

A prominent fintech company is seeking a Senior Database Administrator to enhance its database infrastructure supporting core operations. The role involves managing SQL Server databases while collaborating across engineering teams to develop database solutions tailored to business growth. Ideal candidates will have extensive experience in high throughput database environments, particularly within AWS, alongside a passion for problem-solving and innovation in a fast-paced setting.

Benefits

Competitive salary and stock option plan

100% paid coverage of medical, dental, and vision insurance

Flexible PTO

Paid parental leave

Health & wellness initiatives

Qualifications

• 5+ years experience administering high throughput SQL Server databases.
• Experience in AWS environments.
• Advanced knowledge of SQL schema modeling.

Responsibilities

• Configure and maintain SQL Server databases for optimal performance.
• Participate in backup and recovery activities.
• Collaborate with engineering teams to develop and implement database best practices.

Skills

SQL query execution

Execution analysis

Optimization

Indexing strategies

Troubleshooting

Documentation

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server

AWS

PowerShell

Ansible

Job description

Upgrade is a fintech company that provides affordable and responsible credit, mobile banking, and payment products to everyday consumers. We were the fastest growing company in the Americas last year according to the Financial Times and Upgrade Card was the fastest growing credit card in America two years in a row. We have delivered over $33 billion in affordable and responsible credit to our 5.5M customers. The company is backed by some of the most prominent technology investors and was recently valued at $6.3B.

We have built an energizing, collaborative and inclusive culture where team members help each other, learn and innovate to move the company and its customers in the right direction, and own the outcome of their efforts.

Upgrade has been named a “Best Place to Work in the Bay Area” three years in a row, “Top Companies to work for in Arizona” and one of the "Best Engineering Department" awarded annually by Comparably. We've also received recognition for being a best company for Diversity, Women, Culture, and Veterans.

We are looking for new team members who get excited about designing and delivering new and better products to join a team of 1850 talented and dedicated professionals. Come work with us if you like to tackle big problems and make a meaningful difference in people's lives.

About the Role:

We’re looking for an experienced Senior Database Administrator to design, maintain, and build the database infrastructure that powers Upgrade’s core operations. This includes managing data storage, performance, and access. In addition, you’ll contribute to the development of new database solutions to scale with growing business needs.

What You’ll Do:

• Configure, monitor, maintain, and improve the performance and reliability of SQL Server databases and data stores
• Participate in all database related activities such as backup & recovery, upgrades, patching, and performance tuning
• Collaborate with different engineering teams to define and implement best practices for database operations to evolve and scale our SQL Server database architecture
• Develop standards and procedures to maximize DBMS performance, scalability, resilience, security, and data integrity for SQL Server
• Be on-call for supporting SQL Server clusters
• Provide production environment support in AWS and debug database issues as needed
• Identify areas to introduce and develop automation tooling to help improve efficiency in database administration

What We Look For:

• Previous DBA experience working with high throughput SQL Server databases in AWS environment
• 5+ years administering production, always-on, high throughput, OLTP RDBMS on Microsoft SQL Server
• Advanced knowledge of SQL query execution, execution analysis & optimization, indexing strategies, partitioning etc.
• Advanced knowledge of SQL schema modeling and evolution
• Proficiency in various RDBMS replication strategies
• Experience with geo-redundant database deployments (active/active, active/standby, etc.) is a plus
• Solid Windows fundamentals including kernel, filesystem and OS tuning, as they relate to DB performance and security.
• Excellent troubleshooting, documentation, and communication skills
• Knowledge on how MSSQL replication strategies work (log shipping, etc.) and Always On Availability Groups
• Knowledge on how MSSQL Change Tracking (CT) and MS-CDC works
• Good knowledge of PowerShell
• Highly motivated and self driven individual
• Interest in learning new technologies and applying that to solving problems
• Good collaborator and ability to work in small teams
• Technically strong and hands-on
• Excellent multitasker and ability to thrive in fast-paced environments
• Methodical, thorough, and solution oriented

Nice to Have:

• Proficiency with Ansible on Windows
• Experience supporting Linux-based MSSQL instances

What We Offer You:

• Competitive salary and stock option plan
• 100% paid coverage of medical, dental and vision insurance
• Flexible PTO
• Competitive 401(k) and RRSP program
• Opportunities for professional growth and development
• Paid parental leave
• Health & wellness initiatives

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Upgrade does not accept unsolicited resumes from staffing agencies, search firms, or any third parties. Any resume submitted to any employee of Upgrade without a prior written agreement in place will be considered the property of Upgrade, and Upgrade will not be obligated to pay any referral or placement fee. Agencies must obtain advance written approval from Upgrade's Talent Acquisition department to submit resumes and only in conjunction with a valid, fully executed agreement.

Create a Job Alert

Interested in building your career at Upgrade? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile

Website

Are you legally authorized to work in Canada? Select...

Will you now, or in the future, require sponsorship for employment visa status (e.g. H-1B visa status, work permit, etc.)? Select...

Demographic Questions & Categorizations

Upgrade is dedicated to building a diverse team and an inclusive culture. We believe that it’s crucial to Upgrade’s long-term success to create an environment where all employees feel like they belong and have an equal opportunity to succeed.

For this reason, we are asking candidates to voluntarily self-identify through a few demographic questions. Our purpose in collecting this information is to help us assess our outreach efforts and diversity representation goals. Your responses will not be linked to your identity or your application, and neither recruiters nor hiring managers can see this information at an individual level. Your responses are stored in the aggregate and will not play any role in our hiring decision. Your decision to participate or not participate in this survey will have no impact on your candidacy at Upgrade.

How you do you identify? (Gender identity) Select...