Sr. Database Developer

UWorld is a worldwide leader in online test prep for college entrance, undergraduate, graduate, and professional licensing exams throughout the United States. Since 2003, over 2 million students have trusted us to help them prepare for high-stakes examinations.

We are seeking a Sr. Database Developer who is passionate about creating an excellent user experience and enjoys taking on new challenges. The primary responsibilities include reviewing and optimizing queries, ensuring high performance, availability, and scalability of the database, and managing overall applications and database health. The DB developer will develop, test, deploy, improve, and support our UWorld Databases, Applications, Data Analytics, and Data warehouse platform to help users retrieve data effectively.

• Designing and developing Database solutions, schemas, and stored procedures.
• Review, analyze, and fine-tune SQL queries, stored procedures, and indexes to ensure efficient performance across the system.
• Work closely with development teams to review SQL code and ensure adherence to best practices for optimal query performance.
• Identify and resolve database-related issues promptly, including deadlocks, performance bottlenecks, and connection issues.
• Understand Data Services and Analytics needs across the organization and work on the Data warehouse and Reporting infrastructure to empower them with accurate information for decision-making.
• Develop, modify, and test algorithms that can be used in scripts to store, locate, cleanse, verify, validate, and retrieve specific documents, data, and information.
• Develop analytics to understand product sales, marketing impact, and application usage for current and future UWorld products.
• Work with the Operations team to Monitor database performance, diagnose issues, and proactively recommend and implement solutions to optimize database efficiency.
• Cleanse, prepare, and migrate data to various systems.
• Generate ad-hoc reports for on-demand needs.
• Collaborate with technical architects, product leads, QA team, and customer care team to drive new enhancements or fix bugs on time.
• Work in an agile environment such as Scrum.