Offer summary

Qualifications:

5+ years of experience as a DBA with high throughput SQL Server databases in an AWS environment., Advanced knowledge of SQL query execution, optimization, and schema modeling., Proficiency in RDBMS replication strategies and troubleshooting skills., Solid understanding of Windows fundamentals related to database performance..

Key responsibilities:

Configure, monitor, and maintain SQL Server databases for performance and reliability.

Participate in backup, recovery, upgrades, and performance tuning activities.

Collaborate with engineering teams to implement best practices for database operations.

Provide production support in AWS and develop automation tools for database administration.

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

You Are:

Highly motivated and self driven
Enjoy learning new technologies and applying that to solving problems
Enjoy collaborating and working in small teams
Technically strong and hands-on
Good at multitasking and thrive in fast-paced environments
Methodical, thorough, and solution oriented

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

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

#BI-Remote #LI-Remote

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.

Required profile