Database Developer
UWorld, LLC, India

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 Database Developer who is passionate about creating an excellent user experience and enjoys taking on new challenges. The DB developer will be responsible for developing, testing, deploying, improving, and supporting our UWorld Applications, Databases, Data Analytics, and Data warehouse platform to help users retrieve data effectively.

• Develop analytics to understand product sales, marketing impact, and application usage for current and future UWorld products
• Designing and developing Database solutions, Reports, Backend services, schemas, Data pipelines, and stored procedures.
  
• Understand Data Services and Analytics needs across the organization and work on the Application back-end, 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
• Cleanse, prepare, and migrate data to various systems
• Generate ad-hoc reports and insights for on-demand needs
• Constantly review database performance for improvement and query optimizations
• Collaborate with technical architects, product leads, QA team, and customer care team to drive new enhancements or fix bugs in a timely manner
• Work in an agile environment such as Scrum

Requirements

• 5+ years of experience in developing reports, dashboards, database schemas, and stored procedures in SQL, MS SQL Server, SSIS Packages, and DBA tools. Experience with OLAP/Datawarehouse is a plus.
• 3+ years of experience with programming and scripting languages (Java/Python/C#, Unix/Linux Shell scripting), REST API, JSON, Build and Deployment pipelines (Git, Ansible), and Cloud environments (Azure, AWS)
• Deep understanding of Data management (permissions, recovery, security, and monitoring). Experience in optimizing and maintaining queries and stored procedures
• Hands-on experience with SQL queries, stored procedures, triggers, and cursors.
• Exposure to database design and performance tuning is desirable.

• Working proficiency and communication skills in verbal and written English
• Excellent attention to detail and organization skills and ability to articulate ideas clearly and concisely
• Ability to work effectively within a changing environment that is going through high growth
• Exceptional follow-through, personal drive, and ability to understand direction and feedback
• Positive attitude with a willingness to put aside ego for the sake of what is best for the team

Job Rewards and Benefits