Staff Database Administrator

  • Normal, IL
  • Posted 20 hours ago | Updated 9 hours ago

Overview

On Site
USD 140,600.00 - 175,800.00 per year
Full Time

Skills

Business Operations
Reporting
IT Operations
Microsoft SQL Server DBA
Migration
Computer Hardware
VMware ESXi
Virtual Machines
Version Control
Configuration Management
Change Management
ITIL
Redis
Scalability
Data Integrity
Storage
Database Security
Policies and Procedures
High Availability
Disaster Recovery
Optimization
Software Development
Productivity
Collaboration
Management
Amazon Web Services
Remote Desktop Services
Amazon RDS
Amazon DynamoDB
Computer Science
Information Technology
Database Administration
FOCUS
MongoDB
Apache Cassandra
Microsoft SQL Server
Backup
Recovery
Performance Tuning
Databricks
Transact-SQL
Scripting
Query Optimization
Graph Databases
Database
Clustering
Replication
SQL
NoSQL
Conflict Resolution
Problem Solving
Communication
Insurance
Military
Privacy
Data Security
Social Media
VMware Infrastructure
VI
Network
Information Security
Fraud
Law
Finance
Legal
Recruiting
Cloud Computing
Law Enforcement

Job Details

About Rivian

Rivian is on a mission to keep the world adventurous forever. This goes for the emissions-free Electric Adventure Vehicles we build, and the curious, courageous souls we seek to attract.

As a company, we constantly challenge what's possible, never simply accepting what has always been done. We reframe old problems, seek new solutions and operate comfortably in areas that are unknown. Our backgrounds are diverse, but our team shares a love of the outdoors and a desire to protect it for future generations.

Role Summary

As a Staff Database Administrator, you will be responsible for managing and optimizing both SQL Server and NoSQL databases and the underpinning infrastructure. You will ensure the integrity, performance, and security of our database systems, while collaborating with cross-functional teams to support business operations and deliver high-quality data solutions. This position will be located in Normal, IL and report to our Sr. Manager, Factory IT Operations

Responsibilities

  • SQL Server Management:
    • Manage, maintain, and optimize Microsoft SQL Server databases to ensure high availability, performance, and scalability.
    • Design and implement database backup and recovery strategies following industry best practices.
    • Monitor database performance and troubleshoot any issues related to SQL Server.
    • Perform database migrations, upgrades, and installations for SQL Server environments.
    • Optimize host hardware, including ESXi tuning and virtual machine-level configuration.
    • Suggest and implement improvements to the use of version control for configuration management of databases.
    • Suggest and implement improvements to change management processes to align with ITIL best practices.
    • Participate in on-call rotation.
  • NoSQL Database Management:
    • Manage, maintain, and optimize NoSQL databases (such as MongoDB, Cassandra, NATS and/or Redis) to support business-critical applications.
    • Design and implement NoSQL data models to ensure high performance, scalability, and data integrity.
    • Monitor NoSQL database performance and optimize queries and storage structures to meet application requirements.
    • Implement backup and recovery solutions for NoSQL databases.
    • Ensure proper security protocols are applied to NoSQL environments.
  • Database Security and High Availability:
    • Develop and enforce database security policies and procedures for both SQL Server and NoSQL environments.
    • Collaborate with teams to implement replication, high availability, and disaster recovery strategies.
    • Provide expertise on database resiliency and support the design of fault-tolerant database architectures.
  • Collaboration and Optimization:
    • Work closely with software development teams to design efficient and effective database schemas, queries, and indexes.
    • Automate routine database tasks using scripts and tools to enhance productivity.
    • Troubleshoot and resolve database-related issues in both SQL and NoSQL environments.
    • Make recommendations on how to improve database performance across both relational and non-relational platforms.
    • Collaborate with application teams on management of cloud/AWS databases such as RDS, DynamoDB, and DocumentDB.

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 7+ years of experience in database administration, with a strong focus on Microsoft SQL Server and NoSQL databases (MongoDB, Cassandra, etc.).
  • In-depth knowledge of SQL Server architecture, backup and recovery, performance tuning, and security.
  • Experience with Databricks integration is a plus.
  • Proficient in T-SQL, database scripting, and query optimization.
  • Strong understanding of NoSQL architecture, including document-based, key-value, columnar, and graph databases.
  • Experience in database clustering, sharding, and replication for both SQL and NoSQL environments.
  • Strong problem-solving skills and the ability to work independently and as part of a team.
  • Excellent communication skills, both written and verbal.

Pay Disclosure

Salary Range - Illinois Based Applicants: USD - $140,600 - $175,800 (actual compensation will be determined based on experience, location, and other factors permitted by law).

Benefits Summary: Rivian provides robust medical/Rx, dental and vision insurance packages for full-time and part-time employees, their spouse or domestic partner, and children up to age 26. Full Time Employee coverage is effective on the first day of employment. Part-Time employee coverage is effective the first of the month following 90 days of employment.

Equal Opportunity

Rivian is an equal opportunity employer and complies with all applicable federal, state, and local fair employment practices laws. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender, gender expression, gender identity, genetic information or characteristics, physical or mental disability, marital/domestic partner status, age, military/veteran status, medical condition, or any other characteristic protected by law.

Rivian is committed to ensuring that our hiring process is accessible for persons with disabilities. If you have a disability or limitation, such as those covered by the Americans with Disabilities Act, that requires accommodations to assist you in the search and application process, please email us at

Candidate Data Privacy

Rivian may collect, use and disclose your personal information or personal data (within the meaning of the applicable data protection laws) when you apply for employment and/or participate in our recruitment processes ("Candidate Personal Data"). This data includes contact, demographic, communications, educational, professional, employment, social media/website, network/device, recruiting system usage/interaction, security and preference information. Rivian may use your Candidate Personal Data for the purposes of (i) tracking interactions with our recruiting system; (ii) carrying out, analyzing and improving our application and recruitment process, including assessing you and your application and conducting employment, background and reference checks; (iii) establishing an employment relationship or entering into an employment contract with you; (iv) complying with our legal, regulatory and corporate governance obligations; (v) recordkeeping; (vi) ensuring network and information security and preventing fraud; and (vii) as otherwise required or permitted by applicable law.

Rivian may share your Candidate Personal Data with (i) internal personnel who have a need to know such information in order to perform their duties, including individuals on our People Team, Finance, Legal, and the team(s) with the position(s) for which you are applying; (ii) Rivian affiliates; and (iii) Rivian's service providers, including providers of background checks, staffing services, and cloud services.

Rivian may transfer or store internationally your Candidate Personal Data, including to or in the United States, Canada, the United Kingdom, and the European Union and in the cloud, and this data may be subject to the laws and accessible to the courts, law enforcement and national security authorities of such jurisdictions.

Please note that we are currently not accepting applications from third party application services.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.