Database Engineer II

At Tekion, we're building the only cloud-native platform that is transforming the automotive retail industry, leapfrogging it into the future and providing unparalleled customer experience. We're creating seamlessly integrated, elegant, and intuitive solutions built with cutting edge technology and powered by Big Data, Machine Learning (ML)/ AI and Internet of Things (Connected vehicle to connected devices). We’re harnessing passion, entrepreneurial spirit, deep industry expertise and the latest technologies to create something very special. We're inventing new technology along the way to overcome barriers and solve big problems, all while having a blast doing it!

Roles and Responsibilities:

1. Database Proficiency:

• MongoDB and MySQL Administration: Demonstrate strong command over MongoDB and MySQL databases, specifically in a Linux environment. This includes installing, configuring, and maintaining these databases for optimal performance.

2. Data Modeling and Management:

• MongoDB Data Modeling: Develop efficient data models tailored for MongoDB, focusing on data integrity, scalability, and ease of access.
• Administration and Troubleshooting: Perform daily administration tasks like monitoring database health, troubleshooting issues, and ensuring data consistency. Proactively identify and resolve bottlenecks to maintain seamless database operations.

3. Performance Optimization:

• Query Tuning and Index Optimization: Tune MongoDB queries and optimize indexes to improve database performance, reduce latency, and handle large volumes of data effectively.
• Performance Optimization: Implement strategies for overall database performance improvement, including fine-tuning MongoDB’s configuration settings and system parameters.

4. Replication, Migration, and Upgradation:

• Replication: Set up and maintain MongoDB replica sets for high availability and data redundancy.
• Migration and Upgrades: Plan and execute database migrations, including schema upgrades, with minimal downtime. Ensure smooth transitions while migrating databases across environments or upgrading to new versions.

5. Backup and Recovery Strategy:

• Backup and Recovery Solutions: Design, test, and implement robust backup and recovery strategies. Regularly verify backups to ensure data integrity and reliability.
• Disaster Recovery: Develop and test disaster recovery plans to ensure data is protected and recoverable in case of a system failure.

6. Cloud Platform Familiarity:

• AWS and Azure: Maintain a basic understanding of cloud environments like AWS and Azure, focusing on deploying, managing, and scaling databases on these platforms.
• High-Availability Solutions: Leverage cloud-native solutions for high availability, including managed services, load balancing, and failover setups.

7. Database Configuration and Maintenance:

• Configuration Management: Install and configure databases according to best practices, and maintain database configurations for security, performance, and reliability.
• Upgrades: Perform regular database upgrades to ensure compatibility with newer features and security patches.

8. Scripting and Automation:

• Shell Scripting or Python: Use shell scripts or Python to automate routine database tasks, including backups, monitoring, and reporting. This enhances efficiency and reduces the need for manual intervention.

9. Adaptability and Task Management:

• Managing Multiple Priorities: Effectively manage multiple projects and tasks within a fast-paced environment, prioritizing based on urgency and impact.

Primary Skills:

• Database Experience: Over 5 years of hands-on experience in database management, specializing in MongoDB and MySQL administration.
• Cloud-Computing: Strong foundational knowledge of AWS and Azure, with experience leveraging these platforms for database hosting and scaling.
• Additional Database Knowledge: Familiarity with other NoSQL databases like Redis or Elasticsearch is beneficial, adding versatility in managing different data types and structures.
• PostgreSQL Basics: Basic knowledge of PostgreSQL (PSQL) is an advantage, as it demonstrates familiarity with relational database concepts beyond MySQL.

This role emphasizes a strong background in MongoDB and MySQL administration, performance tuning, backup and recovery strategy, and familiarity with cloud platforms. The candidate must be adaptable, have good time-management skills, and be capable of using scripting for automation.
Perks and Benefits
• Competitive compensation
• Generous stock options
• Medical Insurance coverage
• Work with some of the brightest minds from Silicon Valley’s most dominant and successful