Database Engineer II

About Tekion:

Positively disrupting an industry that has not seen any innovation in over 50 years, Tekion has challenged the paradigm with the first and fastest cloud-native automotive platform that includes the revolutionary Automotive Retail Cloud (ARC) for retailers, Automotive Enterprise Cloud (AEC) for manufacturers and other large automotive enterprises and Automotive Partner Cloud (APC) for technology and industry partners. Tekion connects the entire spectrum of the automotive retail ecosystem through one seamless platform. The transformative platform uses cutting-edge technology, big data, machine learning, and AI to seamlessly bring together OEMs, retailers/dealers and consumers. With its highly configurable integration and greater customer engagement capabilities, Tekion is enabling the best automotive retail experiences ever. Tekion employs close to 3,000 people across North America, Asia and Europe.

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

Tekion is proud to be an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, victim of violence or having a family member who is a victim of violence, the intersectionality of two or more protected categories, or other applicable legally protected characteristics. 

For more information on our privacy practices, please refer to our Applicant Privacy Notice here.