Senior Database Administrator-Dynamo/Mysql
| Company | Rocket Companies |
|---|---|
| Location | Detroit, MI, USA, Remote in Canada |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior |
Requirements
- Bachelor’s degree in computer science or a related field or equivalent work experience
Responsibilities
- Work with our developers and business analysts to create and modify our database structure
- Proactively monitor and optimize the performance of the database servers
- 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
- Mentor and coach other team members
Preferred Qualifications
- Designing data models for both DynamoDB and Aurora based on application requirements, considering data access patterns and scalability need
- Implementing efficient partitioning strategies for large datasets in DynamoDB
- Selecting appropriate database configurations for Aurora depending on workload (e.g., MySQL, PostgreSQL)
- Monitoring database performance metrics for both DynamoDB and Aurora, identifying bottlenecks and implementing tuning strategies
- Optimizing query performance by analyzing access patterns and adjusting indexes in DynamoDB
- Tuning database parameters in Aurora to improve query execution and throughput
- Implementing robust backup and recovery strategies for both DynamoDB and Aurora, including point-in-time restores
- Managing data replication across availability zones for high availability
- Performing data migrations between different cloud DB technologies
- Enforcing strict security policies on both DynamoDB and Aurora, managing user permissions and access controls
- Implementing data encryption at rest and in transit for sensitive data
- Developing automation scripts using AWS tools to streamline database management tasks like provisioning, patching, and backups
- Leveraging Terraform to manage database infrastructure
- Troubleshooting database issues and providing technical support to application teams