Database Engineer II-

As a Database Engineer II at Tekion, you will design, automate, and optimize database operations across our cloud-native automotive retail platform connecting OEMs, dealerships, partners, and consumers.This role requires strong expertise in Python, SQL/PL-SQL, JavaScript (for MongoDB), and data structures & algorithms, with a deep focus on problem-solving and automation.Exposure to AI/ML technologies is a plus.Key Responsibilities- Python Automation (Primary Focus):- Develop reliable and reusable Python scripts to automate key database operations such as schema migrations, health checks, data validation, and performance optimization.- SQL & PL/SQL Development:- Write and optimize complex SQL queries, stored procedures, functions, and triggers for MySQL/PostgreSQL.- Develop and manage PL/SQL logic for data manipulation, validation, and reporting.- Perform schema design, indexing, and query plan optimization to enhance performance.- MongoDB Scripting:- Use JavaScript and Python for MongoDB scripting, aggregation, data cleanup, and performance improvement tasks.- Algorithmic Problem Solving (Core Skill):- Apply data structures and algorithms to solve real-world data and system challenges efficiently.- Design Python-based programs that automate or optimize database workflows using algorithmic thinking.- Example problem areas candidates should be comfortable with:- Finding duplicates or missing records in large datasets.- Comparing data consistency between source and target databases.- Implementing retry, queue, or scheduling logic using stacks/queues.- Detecting outliers or anomalies in performance metrics or logs.- Writing scripts to identify circular dependencies in database relationships.- Optimizing time complexity in Python scripts that process millions of records.- Designing scripts to summarize large log files or analyze trends.- Building mini utilities for automation — like config diff tools or schema comparison programs.- Monitoring & Troubleshooting:- Build monitoring automation to detect replication issues, latency spikes, or performance degradation and auto-trigger alerts or recovery actions.- DevOps & Cloud Integration:- Integrate with CI/CD pipelines and cloud services (AWS, Azure, GCP) to automate provisioning, deployment, and backups.- Performance Optimization:- Tune SQL queries, database configurations, and scripts for efficiency, scalability, and reliability.- Collaboration & Compliance:- Partner with DBAs, developers, and product teams to maintain operational standards, security, and compliance.Qualifications & SkillsMust Have:- Strong proficiency in Python for automation, scripting, and algorithmic problem solving.- Hands-on expertise in SQL and PL/SQL for MySQL/PostgreSQL.- Proficiency in JavaScript (for MongoDB) scripting and operations.- Strong understanding of Data Structures and Algorithms (DSA) — arrays, linked lists, trees, graphs, hashing, recursion, etc.- Excellent analytical and debugging skills with a logical mindset.- Experience with cloud platforms (AWS, Azure, or GCP) and managed database services like RDS or DynamoDB.- Familiarity with DevOps tools (Git, Jenkins, Terraform, etc.).- Good communication skills and ability to collaborate across teams.Nice to Have:- Experience with AI/ML integration, such as using models for anomaly detection or predictive performance insights.- Experience with database performance tuning, replication, or sharding.- Familiarity with monitoring and observability tools (Grafana, Prometheus, Datadog).- Knowledge of infrastructure automation (Ansible, Chef, Terraform).- Exposure to distributed database systems such as MongoDB Atlas or Aurora.Education- Bachelor's or Master's degree in Computer Science, Engineering, or a related technical field.What We're Looking ForWe're seeking a hands-on engineer who:- Codes efficiently in Python, SQL, PL/SQL, and JavaScript.- Thinks algorithmically and solves complex problems creatively.- Automates repetitive database tasks with precision and scalability.- Understands both SQL and NoSQL performance tuning.- Brings curiosity, ownership, and innovation — including openness to AI-driven solutions for database management.