Senior Database Engineer - SQL

As a Senior Database Engineer at Tekion, your role involves designing, automating, and optimizing database operations across the cloud-native automotive retail platform. You will be connecting OEMs, dealerships, partners, and consumers through cutting-edge technology, big data, machine learning, and AI. To excel in this role, you are expected to have a strong understanding of different storage and replication internals, trade-offs across SQL/NoSQL technologies, distributed systems fundamentals, transaction interaction, and concurrency. Additionally, proficiency in Python fundamentals and Python scripting is essential for this position. Key Responsibilities: - Debug and prevent concurrency issues such as deadlocks, lock escalation, starvation, and long-running transactions. Advise teams on safe patterns like idempotency, retries, backoff, and fencing tokens. - Understand B-tree/LSM trade-offs, page layout, WiredTiger cache, journaling, WAL/redo/undo, checkpoints, compaction, and MVCC behavior. - Manage backups (Logical vs Physical vs Snapshots based), upgradation of database systems and versions, data migration, and Disaster Recovery implementation. - Implement monitoring and alerting for replication lag, lock contention, buffer/cache health, slow query patterns, storage growth, and failover events. - Develop and maintain robust Python tooling/services for online schema change orchestration, safe rollout/rollback workflows, and performance diagnostics automation. - Guide data modeling decisions across relational and document/Key-Value stores, including secondary index design, hot partition mitigation, and TTL policies. Qualifications Required: - At least 4+ years of experience in a relevant engineering role. - Strong foundation in distributed systems and database fundamentals. - Proficiency in Python for building automation and diagnostics tooling. - Hands-on experience operating and tuning production databases (MongoDB and at least one SQL system like MySQL, PostgreSQL, MariaDB). - Experience with multi-region data architectures, global tables, cross-region failover strategies, AWS, MongoDB Atlas, Kubernetes, and self-managed database systems. - Understanding of Networking concepts like VPC, subnets, security groups, CIDR, peering, etc. - Ability to reason from first principles about database behavior under failure and load, and operationalize best practices into repeatable, safe automation using Python. Tekion is committed to diversity and inclusion, and does not discriminate based on various legally protected characteristics. Join Tekion to make a positive impact on the automotive industry with innovative solutions and cutting-edge technology. As a Senior Database Engineer at Tekion, your role involves designing, automating, and optimizing database operations across the cloud-native automotive retail platform. You will be connecting OEMs, dealerships, partners, and consumers through cutting-edge technology, big data, machine learning, and AI. To excel in this role, you are expected to have a strong understanding of different storage and replication internals, trade-offs across SQL/NoSQL technologies, distributed systems fundamentals, transaction interaction, and concurrency. Additionally, proficiency in Python fundamentals and Python scripting is essential for this position. Key Responsibilities: - Debug and prevent concurrency issues such as deadlocks, lock escalation, starvation, and long-running transactions. Advise teams on safe patterns like idempotency, retries, backoff, and fencing tokens. - Understand B-tree/LSM trade-offs, page layout, WiredTiger cache, journaling, WAL/redo/undo, checkpoints, compaction, and MVCC behavior. - Manage backups (Logical vs Physical vs Snapshots based), upgradation of database systems and versions, data migration, and Disaster Recovery implementation. - Implement monitoring and alerting for replication lag, lock contention, buffer/cache health, slow query patterns, storage growth, and failover events. - Develop and maintain robust Python tooling/services for online schema change orchestration, safe rollout/rollback workflows, and performance diagnostics automation. - Guide data modeling decisions across relational and document/Key-Value stores, including secondary index design, hot partition mitigation, and TTL policies. Qualifications Required: - At least 4+ years of experience in a relevant engineering role. - Strong foundation in distributed systems and database fundamentals. - Proficiency in Python for building automation and diagnostics tooling. - Hands-on experience operating and tuning production databases (MongoDB and at least one SQL system like MySQL, PostgreSQL, MariaDB). - Experience with multi-region data architectures, global tables, cross-region failover strategies, AWS, MongoDB Atlas, Kubernetes, and self-managed database systems. - Understanding of Networking concepts like VPC, subnets, security groups, CIDR, peering, etc. - Ability to reason from