What are the responsibilities and job description for the Senior Database Administrator - PostgreSQL/MySQL/MSSQL position at Rocket Companies?
As a Sr. Database Administrator, you’ll ensure the databases that support our technology systems perform efficiently and are designed to be highly available.
About The Role
Minimum Qualifications:
Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We’ve got your back. Check out our full list of Benefits and Perks.
About Us
We’re a Detroit-based company made up of businesses that provide simple, fast and trusted digital solutions for complex transactions. The name comes from our flagship business, now known as Rocket Mortgage®, which was founded in 1985. Today, we’re a publicly traded company involved in many different industries, including mortgages, fintech, real estate and more. We’re insistently different in how we look at the world and are committed to an inclusive workplace where every voice is heard. Apply today to join a team that offers career growth, amazing benefits and the chance to work with leading industry professionals.
This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the Company at any time. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state or federal law. The Company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team at Careers@myrocketcareer.com.
Colorado, New York City, Jersey City, California, D.C and Washington Candidates only: the salary range for this position is ninety-three thousand five hundred dollars to two hundred nine thousand five hundred dollars. The position may also be eligible for an annual bonus and other employment-related benefits including, but not limited to, medical, dental, and vision benefits, 401K retirement plan, and paid-time off. More information regarding these benefits and others can be found here. The information regarding compensation and other benefits included in this paragraph is only an estimate and is subject to revision from time to time as the Company, in its sole and exclusive discretion, deems appropriate. The Company may determine during its review of the proposed compensation and benefits provided for this position, that the compensation and benefits for such position should be reduced. In no event will the Company reduce the compensation for the position to a level below the applicable jurisdictional minimum wage rate for the position.
Los Angeles County Candidates only: qualified applicants with arrest or conviction records will be considered for employment per the Fair Chance Ordinance and the California Fair Chance Act.
About The Role
- Work with our developers and business analysts to create and modify our database structure
- Monitor the performance of the database servers
- On-call support on a rotation basis
- Strong understanding and ability to configure and troubleshoot physical and logical replication in MySQL and/or PostgreSQL
- Strong understanding and ability to configure and troubleshoot log shipping and Always-on HA solutions in SQL Server
- Identify and resolve performance bottlenecks both in on-premises and cloud
- Familiarity with deploying and managing MySQL and/or PostgreSQL, SQL Server in cloud environments (e.g., AWS, Azure, GCP), preferably AWS
- Perform database maintenance tasks, including backups/restores, updating statistics, rebuilding indexes, etc.
- Work with our data engineers to help map data in our production databases to our data warehouse
- Maintain system security and data integrity
- Work with our systems engineers to ensure optimal hardware and storage subsystems
- Develop, manage, and maintain a strong disaster recovery and high availability plan
- Install, upgrade, and patch the database servers
- Participate in code and design reviews
- Participate in production code pushes
Minimum Qualifications:
- Bachelor’s degree in computer science or business information systems, a related degree or equivalent experience
- 5 years of relevant work experience
- 2 years of experience with prod workload in AWS ecosystem
- Experience with PostgreSQL 13 and/or MySQL 5.7 and above
- Experience with SQL Server 2016 and above
- Experience with maintaining AWS RDS and Aurora instances
- In-depth understanding of the database engine and strong performance tuning skills
- Troubleshooting experience with MySQL and/or PostgreSQL, SQL Server high availability solutions
- Strong experience working with Unix/Linux and Shell Scripting
- Strong communication skills
- Ability to work independently and with others in a team environment
- Ability to prioritize tasks
- Strong analytical and problem-solving skills
- Troubleshoot service outages as they occur, including after hours and weekends
- Strong sense of personal accountability for results
- Experience with Infrastructure as a code (IAC) such as terraform, or Cloud-formation is an added advantage
- Familiarity with database CICD process, concept, and tools
- Understanding of NoSQL databases is an added advantage
- 1 year of experience with SQL Server T-SQL coding
- 1 year of experience with SQL Server database administration
- 1 year of experience with SQL Server Integration Services
- 1 year of programming experience
- Proficiency in the Microsoft Office suite
- Proficiency in the Azure management platform
- Proficiency in Microsoft SQL Server
Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We’ve got your back. Check out our full list of Benefits and Perks.
About Us
We’re a Detroit-based company made up of businesses that provide simple, fast and trusted digital solutions for complex transactions. The name comes from our flagship business, now known as Rocket Mortgage®, which was founded in 1985. Today, we’re a publicly traded company involved in many different industries, including mortgages, fintech, real estate and more. We’re insistently different in how we look at the world and are committed to an inclusive workplace where every voice is heard. Apply today to join a team that offers career growth, amazing benefits and the chance to work with leading industry professionals.
This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the Company at any time. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state or federal law. The Company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team at Careers@myrocketcareer.com.
Colorado, New York City, Jersey City, California, D.C and Washington Candidates only: the salary range for this position is ninety-three thousand five hundred dollars to two hundred nine thousand five hundred dollars. The position may also be eligible for an annual bonus and other employment-related benefits including, but not limited to, medical, dental, and vision benefits, 401K retirement plan, and paid-time off. More information regarding these benefits and others can be found here. The information regarding compensation and other benefits included in this paragraph is only an estimate and is subject to revision from time to time as the Company, in its sole and exclusive discretion, deems appropriate. The Company may determine during its review of the proposed compensation and benefits provided for this position, that the compensation and benefits for such position should be reduced. In no event will the Company reduce the compensation for the position to a level below the applicable jurisdictional minimum wage rate for the position.
Los Angeles County Candidates only: qualified applicants with arrest or conviction records will be considered for employment per the Fair Chance Ordinance and the California Fair Chance Act.
