Senior Database Engineer

Supply Wisdom: Senior Database Engineer 

• Position based in Bangalore, India 

Join a dynamic company that is growing at an explosive rate. Supply Wisdom’s patented solution is transforming the way supply chain, procurement and third-party risk leaders manage risks and operational resilience. Our market-leading risk intelligence solution leverages the latest advancements in AI, Machine Learning, and data science to deliver the real-time early-warning risk intelligence that enterprises critically need now to secure their supply chains, prevent disruptions, and ensure operational resiliency. The demand for our solution is stronger than ever, and our team must expand to keep up. 

In January 2022, we closed a significant institutional round led by Fulcrum Equity Partners to fund our growth and market expansion into new verticals and new geographies. Join us at this exciting growth stage as stock options may be awarded for this position upon board approval. 

Objective: Supply Wisdom is seeking a seasoned Senior Database Engineer with a passion for building and optimizing highly reliable and scalable data architectures. In this pivotal role, you'll be at the heart of defining and implementing our database strategy, focusing on enhancing reliability, throughput, scalability, and security across our backend systems. Working closely with our DevOps/SRE team, you will play a crucial role in administering, maintaining, and securing our data infrastructure, which includes S3, PostgreSQL, Redshift, and future data platforms. 

As the Senior Database Engineer, your responsibilities will include executing operational DBA duties such as installation, database upgrades, patching, and implementing comprehensive backup/recovery and monitoring procedures. You'll lead the charge in capacity planning, site failover/switchover operations, and participate in high availability and disaster recovery planning/drills. 

Responsibilities 

• Database Architecture: Design and implement database systems emphasizing reliability, throughput, scalability, and security. Collaborate with DevOps/SRE teams for data infrastructure planning across S3, PostgreSQL, Redshift, and new platforms.
• Operational Management: Perform DBA tasks such as installations, upgrades, patching, and backup/recovery procedures. Lead capacity planning, site failover/switchover operations, and high availability/disaster recovery planning.
• Performance Optimization: Analyze and tune queries to ensure optimal performance. Guide engineering teams on optimization techniques like query optimization, index tuning, and caching. Develop observability tools for preemptive issue detection.
• Change Management: Review engineering database change requests for compliance with design standards, impact on designs, data conversion processes, and documentation. Make recommendations for data storage and processing improvements.
• Data Engineering: Design and maintain data engineering pipelines. Develop data migration procedures and scripts. Automate schema management using tools such as Django.
• Architectural Support: Assist in integrating new database environments within AWS, supporting architectural changes and data infrastructure  
  evolution.

Requirements 

• 5+ years of cloud / AWS experience with at least 3+ years of that managing a cloud database instance (i.e. RDS, Aurora, or on EC2).

• 5+ years of PostgreSQL (or similar) database engineering and administration.

• Deep knowledge and experience designing and maintaining PostgreSQL and Redshift in AWS

• Experience with Linux administration and Linux scripting. Systems engineering experience, including Linux performance, memory management, I/O tuning, configuration, security, networking, etc.

• Experience building and maintaining sophisticated critically important production database systems

• Experience analyzing issues holistically, from the application tier through the database, down to the storage

• Working knowledge of relational database internals (locking, consistency, serialization, recovery paths)

• Proficient in Python programming, with experience using Django ORM for schema management and automation purposes.

• Exceptional analytical skills and meticulous attention to detail, coupled with strong organizational capabilities.

• Self-motivated, proactive individual who excels in both independent work and as part of a collaborative team. Ability to work both independently and collaboratively in a team environment.

• Excellent problem-solving skills and the ability to troubleshoot and debug software effectively.

• Effective time management, prioritization, and the ability to track and follow up on pending matters.

• Demonstrated ability to work with minimal supervision, showing initiative and a sense of urgency. A team player with a can-do attitude, promoting a positive company image and supporting manufacturing efforts. Strong written and verbal interpersonal skills for effective communication across different channels.

• Honest, trustworthy, and respectful, with the ability to maintain confidentiality.

Our Commitment to You:  

We offer a competitive salary and generous benefits. In addition, we offer a vibrant work environment, a global team filled with passionate and fun-loving people coming from diverse cultures and backgrounds. 

If you are looking to make an impact in delivering market-leading risk management solutions, empowering our clients, and making the world a better place, then Supply Wisdom is the place for you. 

You can learn more at supplywisdom.com and on LinkedIn.