Database Engineer II- (Python,SQL,Automation)

Job Description

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: 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 For We’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.