Database Engineer II- (Python,SQL,Automation)

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 & Skills

Must Have :

Nice to Have :

Education

What We’re Looking For

We’re seeking a hands-on engineer who :