Database Engineer

Job Description
Role Overview:
As a Database Engineer II, 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 Include
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 scripts processing 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
Work 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 (arrays, linked lists, trees, graphs, hashing, recursion, etc.).

Excellent analytical and debugging skills.

Experience with cloud platforms (AWS, Azure, GCP) and managed DB services like RDS or DynamoDB.

Familiarity with DevOps tools (Git, Jenkins, Terraform).

Good communication and collaboration skills.

Nice To Have
Experience with AI/ML integration for anomaly detection or predictive performance insights.

Experience with performance tuning, replication, or sharding.

Familiarity with monitoring tools (Grafana, Prometheus, Datadog).

Knowledge of infrastructure automation (Ansible, Chef, Terraform).

Exposure to distributed DB systems like MongoDB Atlas or Aurora.

What We're Looking For
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 SQL and NoSQL performance tuning.

Brings curiosity, ownership, and innovation, including openness to AI-driven database solutions.

Required Skills
['Python', 'MongoDB']

Additional Information

Education
Bachelor's or Master's degree in Computer Science, Engineering, or a related technical field.